[Keyhead]

I get an error in my MySQL log when it tries to update a players data. Anyone know why?

pawn Код:

stock UpdatePlayerData(playerid)
{
    if(Player[playerid][IsLoggedIn] == false)
        return 0;

    new query[256];
    mysql_format(SQL, query, sizeof(query), "UPDATE `players` SET `money` = '%d' `level` = '%d' `deaths` = '%d' `admin` = '%d' WHERE `id` = '%d' LIMIT 1", Player[playerid][Money], Player[playerid][Level],Player[playerid][Deaths],Player[playerid][Admin], Player[playerid][ID]);
    mysql_tquery(SQL, query, "", "");
    return 1;
}

[iJumbo]

You missed some comma

Код:

UPDATE `players` SET `money` = '%d', `level` = '%d', `deaths` = '%d', `admin` = '%d' WHERE `id` = '%d' LIMIT 1

[Keyhead]

I have no idea how I could be so stupid. I'm ashamed. Thanks. I'll REP you.

[iJumbo]

Also the MySql error will help you fix this things. Take a look at that before post here