Не сохраняет акк (MySQL r39-3)

AnToXa23 · 31 Июл 2015

В общем, суть вопроса ясна, кто может помогите, в MySQL сильно не шарю, надеюсь на вашу помощь, +иком отблагадарю.

Код:

PHP:

stock SaveAccount(playerid)
{
    new query_string[1000] = "UPDATE `accounts` SET";
    
    format(query_string, sizeof(query_string), "%s `player_name` = '%s',", query_string, PlayerInfo[playerid][pName]);
	format(query_string, sizeof(query_string), "%s `password` = '%s',", query_string, PlayerInfo[playerid][pPass]);
	format(query_string, sizeof(query_string), "%s `online` = '%d',", query_string, PlayerInfo[playerid][pOnline]);

    format(query_string, sizeof(query_string), "%s WHERE `player_name` = '%s'", query_string, PlayerInfo[playerid][pName]);
    mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    return true;
}

Log MySQL:

PHP:

[19:15:38] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Test', `password` = '1234", callback: "(null)", format: "(null)"
[19:15:38] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:15:38] [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 `player_name` = 'Test'' at line 1
[19:15:38] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Переход в группу "Пользователь"

Не сохраняет акк (MySQL r39-3)

AnToXa23

Умник