[SymonClash]

Mysql log says i've an error in this syntax to save stats:

pawn Code:

mysql_format(g_SQL, query,sizeof(query), "UPDATE `players` SET `Kills` = %d, `Deaths` = %d, `Score` = %i, `Money` = %i, `LastLoginDate` = %s, `LastLoginIP` = %s, `AdminLevel` = %d WHERE `ID` = %d LIMIT 1",
    Player[p][Kills], Player[p][Deaths], GetPlayerScore(p), GetPlayerMoney(p), ReturnDate(), ReturnPlayerIp(p), Player[p][AdminLevel], Player[p][ID]);
    mysql_query(g_SQL, query);

And effectively, stats aren't saved. What i did wrong?

[Kane]

Well what's the error?

[SymonClash]

You've an error in your SQL syntax, near line [...] (error line is in mysql_format.

[Calisthenics]

Replace %s with '%s'

If `ID` is primary key (which it should be), the LIMIT clause is not needed.

[SymonClash]

What a stupid, lol. Thanks!

Yes, ID is primary key. Cheers