- Регистрация
- 9 Авг 2018
- Сообщения
- 35
- Лучшие ответы
- 0
- Репутация
- 0
Не сохраняет значения.
Сам код:
Логи говорят, что допустил ошибку, может запятая где-то не там, прошу помочь найти:
Сам код:
PHP:
stock SaveAccount(playerid)
{
new query_string[244] = "UPDATE `accounts` SET";
format(query_string, sizeof(query_string), "%s `player_name` = '%s'", query_string, p_info[playerid][p_name]);
format(query_string, sizeof(query_string), "%s `password` = '%s'", query_string, p_info[playerid][p_password]);
format(query_string, sizeof(query_string), "%s `mail` = '%s'", query_string, p_info[playerid][p_mail]);
format(query_string, sizeof(query_string), "%s `skin` = '%d'", query_string, p_info[playerid][p_skin]);
format(query_string, sizeof(query_string), "%s `sex` = '%d'", query_string, p_info[playerid][p_sex]);
format(query_string, sizeof(query_string), "%s `money` = '%d'", query_string, p_info[playerid][p_money]);
format(query_string, sizeof(query_string), "%s `admin` = '%d'", query_string, p_info[playerid][p_admin]);
format(query_string, sizeof(query_string), "%s `score` = '%d'", query_string, p_info[playerid][p_score]);
format(query_string, sizeof(query_string), "%s WHERE `id` = '%d'", query_string, p_info[playerid][p_ID]);
mysql_function_query(mysql_connect_id, query_string, false, "", "");
return true;
}
[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 '`mail` = 'sdsds.sdsd@mail.ru' `skin` = '35' `sex` = '1' `money` = '150' `admin` ' at line 1 (Query: "UPDATE `accounts` SET `player_name` = 'XXXX', `password` = '2281337' `mail` = 'sdsds.sdsd@mail.ru' `skin` = '35' `sex` = '1' `money` = '150' `admin` = '1' `score` = '10' WHERE `id` = '6'")