Всем доброго время суток!
Проблемы с сохранением MySQL аккаунта. Из лога:
PHP код:
[23:53:26] [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 '`Sex` = '0' WHERE `player_name` = 'Lars_Keller'' at line 1
Код:
PHP код:
stock SaveAccount(playerid)
{
new query_string[(21)+(20+MAX_PLAYER_NAME)+(19+MAX_PLAYER_NAME)+(16+30) + (40)] = "UPDATE `accounts` SET";
format(query_string, sizeof(query_string), "%s `player_name` = '%s',", query_string, pInfo[playerid][pName]);
format(query_string, sizeof(query_string), "%s `password` = '%s'", query_string, pInfo[playerid][pPassword]);
format(query_string, sizeof(query_string), "%s `Sex` = '%d'", query_string, pInfo[playerid][pSex]);
format(query_string, sizeof(query_string), "%s WHERE `player_name` = '%s'", query_string, pInfo[playerid][pName]);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
return 1;
}