15.09.2014, 14:20
If I use /setlevel my Level change in Game but not in my database is there a mistake in this line ?
MYSQL_LOG.TXT
PHP код:
format(query,sizeof(query),"UPDATE user SET Score='%i',money='%i',AdminLevel='%i', WHERE ID='%i'",sInfo[playerid][Score],GetPlayerMoney(playerid),sInfo[playerid][AdminLevel],sInfo[playerid][ID]);
PHP код:
[16:13:40] [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 'WHERE ID='1'' at line 1