ошибки mysql

jeselonger

Ученик

1 Мар 2021

в чём проблема?

C++:

stock UpdatePlayerDataInt(const playerid, const field[], data) mysql_queryf(dbHandle, "UPDATE `users` SET `%s` = '%d' WHERE `ID` = '%i' LIMIT 1", false, field, data, PI[playerid][pID]);

C++:

[03:10:48] [ERROR] error #1064 while executing query "UPDATE `users` SET WHERE `ID` = '0' `Name` = 'Jese_Long', `Password` = '' `Money` = '231213123'": 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' `Name` = 'Jese_Long', `Password` = '' `Money` = '231213123'' at line 1 (C:\Users\user\OneDrive\Рабочий стол\мод  с 0\gamemodes\new.pwn:600 -> C:\Users\user\OneDrive\Рабочий стол\мод  с 0\gamemodes\new.pwn:212 -> C:\Users\user\OneDrive\Рабочий стол\мод  с 0\pawno\include\sscanf2.inc:266 -> C:\Users\user\OneDrive\Рабочий стол\мод  с 0\pawno\include\foreach.inc:938)

КОД где вызывается функция

C++:

stock SetPlayerMoney(playerid, money)
{
    ResetPlayerMoney(playerid);
    GivePlayerMoney(playerid, money);
    PI[playerid][pMoney] = money;
    UpdatePlayerDataInt(playerid, "Money", PI[playerid][pMoney]);
    return true;
}

mysql R41-4