PDA

Просмотр полной версии : [Вопрос] Проблема с сохранение аккаунта MySQL



Mr_LemoneZ
03.01.2017, 23:04
[ERROR] error #1064 while eo=xecuting query "UPDATE `accounts` SET `player_name` = 'Nickname' `password` = 'password' `sex` = '1' `nationality` = '1' `age` = '16' WHERE `id` = '2'": 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 '`password` = 'password' `sex` = '1' `nationality` = '1' `age` = '16' WHERE `id` ' at line 1
Вот, собственно, сам stock с сохранением аккаунта:

stock SaveAccount(playerid)
{
if(!authorized[playerid]) return 1;
new query_string[21 + (-4 + 24 + MAX_PLAYER_NAME) + (-4 + 20 + 30) + (-4 + 15 + 1) + (-4 + 16 + 1) + (-4 + 11 + 3) + (-4 + 20 + 11)] = "UPDATE `accounts` SET";

format(query_string, sizeof(query_string), "%s `player_name` = '%s'", query_string, player_info[playerid][pName]);
format(query_string, sizeof(query_string), "%s `password` = '%s'", query_string, player_info[playerid][pPassword]);
format(query_string, sizeof(query_string), "%s `sex` = '%b'", query_string, player_info[playerid][pSex]);
format(query_string, sizeof(query_string), "%s `nationality` = '%d'", query_string, player_info[playerid][pNationality]);
format(query_string, sizeof(query_string), "%s `age` = '%d'", query_string, player_info[playerid][pAge]);

format(query_string, sizeof(query_string), "%s WHERE `id` = '%d'", query_string, player_info[playerid][pID]);
mysql_tquery(mysql_connect_ID, query_string, "", "");
return 1;
}
Никак не врубаюсь, в чём же проблема...

ziggi
03.01.2017, 23:20
В запятых, посмотри на примеры правильных UPDATE запросов.

Mr_LemoneZ
04.01.2017, 16:24
Всё заработало, спасибо!