Не могу найти ошибку, помогите :blum3:
PHP код:
stock SaveAccount(playerid)
{
new query_string[1000] = "UPDATE `accounts` SET";
format(query_string, sizeof(query_string), "%s `name` = '%s',", query_string, pInfo[playerid][pName]);
mysql_function_query(dbHandle, query_string, false, "", "");
format(query_string, sizeof(query_string), "%s `password` = '%s',", query_string, pInfo[playerid][pPassword]);
mysql_function_query(dbHandle, query_string, false, "", "");
format(query_string, sizeof(query_string), "%s `kills` = '%d',", query_string, pInfo[playerid][pKills]);
mysql_function_query(dbHandle, query_string, false, "", "");
format(query_string, sizeof(query_string), "%s `deaths` = '%d',", query_string, pInfo[playerid][pDeaths]);
mysql_function_query(dbHandle, query_string, false, "", "");
format(query_string, sizeof(query_string), "%s `admin` = '%d',", query_string, pInfo[playerid][pAdmin]);
mysql_function_query(dbHandle, query_string, false, "", "");
format(query_string, sizeof(query_string), "%s `ban` = '%d',", query_string, pInfo[playerid][pBan]);
mysql_function_query(dbHandle, query_string, false, "", "");
format(query_string, sizeof(query_string), "%s `mute` = '%d',", query_string, pInfo[playerid][pMute]);
mysql_function_query(dbHandle, query_string, false, "", "");
format(query_string, sizeof(query_string), "%s `jail` = '%d',", query_string, pInfo[playerid][pJail]);
mysql_function_query(dbHandle, query_string, false, "", "");
format(query_string, sizeof(query_string), "%s `cash` = '%d'", query_string, pInfo[playerid][pCash]);
mysql_function_query(dbHandle, query_string, false, "", "");
format(query_string, sizeof(query_string), "%s WHERE `id` = '%d'", query_string, pInfo[playerid][pID]);
mysql_function_query(dbHandle, query_string, false, "", "");
return true;
}
Код HTML:
[18:07:27] [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 '' at line 1
[18:07:27] [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 '' at line 1
[18:07:27] [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 '' at line 1
[18:07:27] [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 '' at line 1
[18:07:27] [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 '' at line 1
[18:07:27] [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 '' at line 1
[18:07:27] [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 '' at line 1
[18:07:27] [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 '' at line 1