[Youice]

Код:

Error (0): Failed to exeute query. 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 ''15.374' at line 1.

What do that code mean?

code I assume you need to know:

pawn Код:

stock SavePlayerData(playerid)
{
    new query[128], pname[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pname, MAX_PLAYER_NAME);
    PlayerInfo[playerid][pMoney] = GetPlayerMoney(playerid);
    GetPlayerPos(playerid, PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z]);
    format(query, sizeof(query), "UPDATE accounts SET Name = '%s', Password = '%s', Money = '%d', PlayerX = '%f', PlayerY = '%f', PlayerZ = '%f' WHERE Name = '%s'",
                                                                                PlayerInfo[playerid][pName],
                                                                                PlayerInfo[playerid][pPw],
                                                                                PlayerInfo[playerid][pMoney],
                                                                                PlayerInfo[playerid][pPos_x],
                                                                                PlayerInfo[playerid][pPos_y],
                                                                                PlayerInfo[playerid][pPos_z],
                                                                                pname
                                                                                );
    mysql_query(query);
}