06.01.2016, 23:48
This is my saveplayer.
Whenever someone disconnects from the server their data should save, but I get this error in the mysq log.
I have no idea what I did wrong..
Код:
stock SavePlayer(playerid) { new query[1024], aName[MAX_PLAYER_NAME]; GetPlayerName(playerid, aName, sizeof(aName)); mysql_format(mysql, query, sizeof(query), "UPDATE accounts SET AdminLevel = '%d', Skin = '%d', Money = '%d', Level = '%d', Job = '%d', Materials = '%d', Drugs ='%d', Lic1 = '%d', Warns ='%d', Mute = '%d', Group = '%d', GroupRank = '%d', Spawn = '%d' WHERE ID = '%d'", pInfo[playerid][pAdminLevel], GetPlayerSkin(playerid), GetPlayerMoney(playerid), GetPlayerScore(playerid), pInfo[playerid][pJob], pInfo[playerid][pMaterials], pInfo[playerid][pDrugs], pInfo[playerid][pLic1], pInfo[playerid][pWarns], pInfo[playerid][pMute], pInfo[playerid][pGroup], pInfo[playerid][pGroupRank], pInfo[playerid][pSpawn], pInfo[playerid][pID]); mysql_tquery(mysql, query); printf("Player ID %d (%s) has been saved", playerid, GetName(playerid)); }
Код:
[01:44:33] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE accounts SET AdminLevel = '%d', Skin = '%d', Money = '%d', Level = '%d', Job = '%d', Materials = '%d', Drugs ='%d', Lic1 ..." [01:44:33] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts SET AdminLevel = '3', Skin = '217', Money = '749", callback: "(null)", format: "(null)" [01:44:33] [DEBUG] CMySQLQuery::Execute[] - starting query execution [01:44:33] [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 'Group = '0', GroupRank = '0', Spawn = '0' WHERE ID = '35'' at line 1 [01:44:33] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError