Ich hab folgendes Problem.
Und zwar wird mir Angezeigt das in einen Syntax Fehler hätte
Hier mal der Error:
[02/03/19 14:33:05] [ERROR] error #1064 while executing query "UPDATE `users` SET `level` = '0', `money` = '0', `kills` = '0', `deaths` = '0', `ban` = '3', `admin` = '0', WHERE `id` = '31'": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id` = '31'' at line 1
Hier der Code:
mysql_format(handle, query, sizeof(query), "UPDATE `users` SET `level` = '%d', `money` = '%d', `kills` = '%d', `deaths` = '%d', WHERE `id` = '%d', `ban` = '%d', `admin` = '%d'",PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][p_id], PlayerInfo[playerid][pBan], PlayerInfo[playerid][pAdmin]);
Desweiteren werden die Daten nicht richtig Gespeichert z.b beim Befehl /setadmin:
CMD:setadmin(playerid,params[]){new string[128];if(PlayerInfo[playerid][pAdmin] >= 1){if(sscanf(params,"ui",p_id ,pAdmin))return SendClientMessage(playerid,0x00FF00,"[Info] /setadmin [playerid][adminlevel]");PlayerInfo[p_id][pAdmin] = pAdmin;mysql_format(handle, string, sizeof(string), "UPDATE `users` SET `admin` = '1' WHERE `id` = %d;", PlayerInfo[playerid][pAdmin]);mysql_pquery(handle, string);SendClientMessage(playerid,0x00FF00,"Du hast den Adminrang geändert");}else{SendClientMessage(playerid,0x00FF00, "[ ! ] Du besitzt keine Rechte um diesen Befehl auszuführen!"); // Keine Rechte}return 1;}
Hier mein SaveUserStats:
stock SaveUserStats(playerid){//Wenn der Spieler nicht eingeloggt ist, dann speichere seine Statistiken nichtif(!PlayerInfo[playerid][pLoggedIn]) return 1;//Ansonsten speichere sienew query[1024];mysql_format(handle, query, sizeof(query), "UPDATE `users` SET `level` = '%d', `money` = '%d', `kills` = '%d', `deaths` = '%d', WHERE `id` = '%d', `ban` = '%d', `admin` = '%d'",PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][p_id], PlayerInfo[playerid][pBan], PlayerInfo[playerid][pAdmin]);//Das Query wird abgesendetmysql_pquery(handle, query);return 1;}
Wo Liegt der Fehler?