[ERROR] CMySQLQuery::Execute[] - (error #1064)
[23:45:59] [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 '`Sex` = '1' `Cash` = '270970' `Level` = '1' `Email` = '@mqil.ru', `HouseKey` = '' at line 1
в чем проблема
PHP код:
stock SavePlayer(playerid)
{
if(GetPVarInt(playerid,"Logged") > 0)
{
new query[800] = "UPDATE `Accounts` SET ";
format(query, sizeof(query), "%s `Skin` = '%d'", query, PlayerInfo[playerid][pSkin]);
format(query, sizeof(query), "%s `Sex` = '%d'", query, PlayerInfo[playerid][pSex]);
format(query, sizeof(query), "%s `Cash` = '%d'", query, GetPlayerMoney(playerid));
format(query, sizeof(query), "%s `Level` = '%d'", query, PlayerInfo[playerid][pLevel]);
format(query, sizeof(query), "%s `Email` = '%s',", query, PlayerInfo[playerid][pEmail]);
format(query, sizeof(query), "%s `HouseKey` = '%d',", query, PlayerInfo[playerid][pHouseKey]);
format(query, sizeof(query), "%s `SaleHouse` = '%d',", query, PlayerInfo[playerid][pSaleHouse]);
format(query, sizeof(query), "%s `Car` = '%d',", query, PlayerInfo[playerid][pCar]);
format(query, sizeof(query), "%s WHERE `Name` = '%s'", query, GN(playerid));
mysql_function_query(mysql_variable, query, false, "", "");
}
return true;
}