[Alex_T]

Код:

SaveAccounts(playerid)
{
	new query[400];
	format(query, sizeof(query), "UPDATE `accounts` SET `adminlevel` = %d, `vip` = %d, WHERE `id` = %d", pInfo[playerid][Admin], pInfo[playerid][VIP], pInfo[playerid][ID]);
	mysql_tquery(mysql, query, "EmptyCallback", "");
	return 1;
}

Код:

[14:43:36] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `adminlevel` = 9999, `vip` = 0, WHERE `id`", callback: "EmptyCallback", format: "(null)"
[14:43:36] [DEBUG] CMySQLQuery::Execute[EmptyCallback] - starting query execution
[14:43:36] [ERROR] CMySQLQuery::Execute[EmptyCallback] - (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 'WHERE `id` = 0' at line 1
[14:43:36] [DEBUG] CMySQLQuery::Execute[EmptyCallback] - error will be triggered in OnQueryError
[14:43:36] [DEBUG] Calling callback "OnQueryError"..

[CmZxC]

Код:

`vip` = %d,

unnecessary comma at the end

[Alex_T]

Quote:

Originally Posted by CmZxC Код: `vip` = %d, unnecessary comma at the end

Thank you. Another set of eyes is always better