Guten Tag Community,
ich habe ein ERROR beim speichern des Spielers....
stock SaveSpieler(playerid)
{
if(sInfo[playerid][pEingeloggt] == 0)return 1;
new query[400];
format(query,sizeof(query),"UPDATE spieler SET Level='%d',Geld='%d',Geschlecht='%d',Cars='%d',Fraktion='%d',Leader='%d',Member='%i',Rang='%i',Alter='%i' WHERE id='%i'",sInfo[playerid][pLevel],GetPlayerMoney(playerid),sInfo[playerid][pGeschlecht],sInfo[playerid][pCars],sInfo[playerid][pFraktion],sInfo[playerid][pLeader],sInfo[playerid][pMember],sInfo[playerid][pRang],sInfo[playerid][pAlter],sInfo[playerid][pDb_id]);
mysql_function_query(mysqlconnect,query,false,"","");
return 1;
}
[18:42:37] [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='15' WHERE id='5'' at line 1