[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;
} 


---

То ли я такая Ванга, то ли ответ когда-то давно был дан, ибо я туплю :D

Код:

---

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;
}

---

щяс так
[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 'WHERE `Name` = 'Andr_Silva'' 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, "", "");
    } 


---

Вот точно должно сейчас работать :)

Цитата:

---

Сообщение от Untonyst

Код:

---

format(query, sizeof(query), "%s `Cash` = '%d,'", query, GetPlayerMoney(playerid));

---

Вот точно должно сейчас работать :)

---

Не думаю.

Цитата:

---

Сообщение от Londlem

Не думаю.

---

А теперь передумывай.

Цитата:

---

Сообщение от Untonyst

А теперь передумывай.

---

SQL Injection хотите словить... Дело Ваше.