Hallo, nachdem ich Perso und Pkw abgespeichert hab speichert er mein Account nicht mehr.
ERROR:
[ERROR] CMySQLQuery::Execute[] - (error #1064) 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 'Alter='0',Perso='0',Pkw='1' WHERE id='1'' at line 1
CODE:
new query[1000];
if(pInfo[playerid][Eingeloggt] != 1)return 1;
format(query,sizeof(query),"UPDATE accounts SET Geld='%i',Level='%i',Admin='%i',Fraktion='%i',Rank='%i',Wanteds='%i',Job='%i',Skin='%i',Alter='%i',Perso='%i',Pkw='%i' WHERE id='%i'",
GetPlayerMoney(playerid),pInfo[playerid][Level],pInfo[playerid][Admin],pInfo[playerid][Fraktion],pInfo[playerid][Rank],pInfo[playerid][Wanteds],pInfo[playerid][pJob],pInfo[playerid][Skin],pInfo[playerid][Alter],pInfo[playerid][Perso],pInfo[playerid][Pkw],pInfo[playerid][db_id]);
mysql_function_query(Handle,query,false,"","");
return 1;