KostyanMaker
Новичок
У меня ошибка
Вот код сохранения
Помогите пожалуйста!
---------- Сообщение добавлено в 17:50 ---------- Предыдущее сообщение добавлено в 17:50 ----------
mysql r39-6
Код:
[19:42:34 10/12/18] [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 '`admin` = '0' `admin_password` = '0' `level` = '1' `vip` = '0' `h' at line 1 (Query: "UPDATE `users` SET `nickname` = 'Ivan_Ivanov', `password` = 'zzz321zzz' `admin` = '0' `admin_password` = '0' `level` = '1' `vip` = '0' `h")
[19:44:11 10/12/18] [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 '`admin` = '0' `admin_password` = '' `level` = '1' `vip` = '0' `ho' at line 1 (Query: "UPDATE `users` SET `nickname` = 'Ivan_Ivanov', `password` = 'zzz321zzz' `admin` = '0' `admin_password` = '' `level` = '1' `vip` = '0' `ho")
[19:44:47 10/12/18] [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 '`admin` = '0' `admin_password` = '' `level` = '1' `vip` = '0' `ho' at line 1 (Query: "UPDATE `users` SET `nickname` = 'Ivan_Ivanov', `password` = 'zzz321zzz' `admin` = '0' `admin_password` = '' `level` = '1' `vip` = '0' `ho")
[19:45:23 10/12/18] [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 '`admin` = '0' `admin_password` = '' `level` = '0' `vip` = '0' `ho' at line 1 (Query: "UPDATE `users` SET `nickname` = 'Ivan_Ivanov', `password` = 'zzz321zzz' `admin` = '0' `admin_password` = '' `level` = '0' `vip` = '0' `ho")
Код:
stock SaveAccount(playerid)
{
new query_string[(21)+(16+11)+(20+MAX_PLAYER_NAME)+(16+30)] = "UPDATE `users` SET";
format(query_string, sizeof(query_string), "%s `nickname` = '%s',", query_string, pInfo[playerid][Nickname]);
format(query_string, sizeof(query_string), "%s `password` = '%s'", query_string, pInfo[playerid][password]);
format(query_string, sizeof(query_string), "%s `admin` = '%d'", query_string, pInfo[playerid][admin]);
format(query_string, sizeof(query_string), "%s `admin_password` = '%s'", query_string, pInfo[playerid][admin_password]);
format(query_string, sizeof(query_string), "%s `level` = '%d'", query_string, pInfo[playerid][level]);
format(query_string, sizeof(query_string), "%s `vip` = '%d'", query_string, pInfo[playerid][vip]);
format(query_string, sizeof(query_string), "%s `house` = '%d'", query_string, pInfo[playerid][house]);
format(query_string, sizeof(query_string), "%s `biz` = '%d'", query_string, pInfo[playerid][biz]);
format(query_string, sizeof(query_string), "%s `leader` = '%d'", query_string, pInfo[playerid][leader]);
format(query_string, sizeof(query_string), "%s `member` = '%d'", query_string, pInfo[playerid][member]);
format(query_string, sizeof(query_string), "%s `fraction_rang` = '%d'", query_string, pInfo[playerid][fraction_rang]);
format(query_string, sizeof(query_string), "%s `bank_money` = '%d'", query_string, pInfo[playerid][bank_money]);
format(query_string, sizeof(query_string), "%s `money` = '%d'", query_string, pInfo[playerid][money]);
format(query_string, sizeof(query_string), "%s `warns` = '%d'", query_string, pInfo[playerid][warns]);
format(query_string, sizeof(query_string), "%s `skin` = '%d'", query_string, pInfo[playerid][skin]);
format(query_string, sizeof(query_string), "%s `sex` = '%d'", query_string, pInfo[playerid][sex]);
format(query_string, sizeof(query_string), "%s WHERE `id` = '%d'", query_string, pInfo[playerid][ID]);
mysql_function_query(links_sql, query_string, false, "", "");
return 1;
}
---------- Сообщение добавлено в 17:50 ---------- Предыдущее сообщение добавлено в 17:50 ----------
mysql r39-6
