Dankesehr. Habe es ein wenig verändert, aber immerhin wird jetzt nicht angezeigt, dass er keine Datensätze findet.
Ich habe den Debugger mal angeschmissen und das entsteht, wenn er die Query versucht auszuführen:
Code
[14:41:43] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM missionsystem WHERE missionname='%s'"
[14:41:43] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM missionsystem WHERE missionname='Lieferungsmission", callback: "DeleteMission", format: "us"
[14:41:43] [DEBUG] CMySQLQuery::Execute[DeleteMission] - starting query execution
[14:41:43] [DEBUG] CMySQLQuery::Execute[DeleteMission] - query was successfully executed within 0.797 milliseconds
[14:41:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[14:41:43] [DEBUG] Calling callback "DeleteMission"..
[14:41:43] [DEBUG] cache_get_data - connection: 1
[14:41:43] [DEBUG] mysql_format - connection: 1, len: 128, format: "DELETE * FROM missionsystem WHERE missionname='%s'"
[14:41:43] [DEBUG] mysql_pquery - connection: 1, query: "DELETE * FROM missionsystem WHERE missionname='Lieferungsmission", callback: "(null)", format: "(null)"
[14:41:43] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:41:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[14:41:43] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* FROM missionsystem WHERE missionname='Lieferungsmission'' at line 1
[14:41:43] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Alles anzeigen
Das ist die Line die gemeint wird:
Code
mysql_format(handle,delquery,sizeof(delquery), "DELETE * FROM missionsystem WHERE missionname='%s'",mdelname);
So sieht der Code bei mir jetzt aus:
Code
ocmd:deletemission(playerid, params[])
{
new mdelname[100], query[256];
if(sscanf(params,"s",mdelname)) return SendClientMessage(playerid, -1, "{FF3200}[SYNTAX:] {BEBEBE}/deletemission <Name der Mission");
mysql_format(handle,query,sizeof(query),"SELECT * FROM missionsystem WHERE missionname='%s'", mdelname);
mysql_pquery(handle, query, "DeleteMission", "us", playerid,mdelname);
return 1;
}
forward DeleteMission(playerid, const mdelname[]);
public DeleteMission(playerid, const mdelname[])
{
new zeilen,felder, delquery[128];
//cache_get_data(zeilen,felder);
if(cache_get_data(zeilen,felder) == 0)
{
SendClientMessage(playerid, -1, "{FF3200}[FEHLER:] {BEBEBE}Ein solcher Eintrag existiert nicht.");
}
else
{
mysql_format(handle,delquery,sizeof(delquery), "DELETE * FROM missionsystem WHERE missionname='%s'",mdelname);
mysql_pquery(handle, delquery);
}
return 1;
}
Alles anzeigen