14.05.2014, 15:40
hy. its working for a long time, but i am start the server today, and its not working..
why?
PHP код:
mysql_format(sqldb, query, sizeof(query), "UPDATE users SET death ='0', dx ='0', dy ='0', dz ='0', di ='0', WHERE nev ='%e'", GetName(playerb));
mysql_query(sqldb, query);
PHP код:
[17:55:04] [DEBUG] mysql_format - connection: 1, len: 1000, format: "UPDATE users SET death ='0', dx ='0', dy ='0', dz ='0', di ='0', WHERE nev ='%e'"
[17:55:04] [DEBUG] mysql_query - connection: 1, query: "UPDATE users SET death ='0', dx ='0', dy ='0', dz ='0', di ='0',", use_cache: true
[17:55:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[17:55:04] [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 nev ='Thommas_Cook'' at line 1