Mysql saving stats problem
#1

Hello guys , i have an error on my mysql and i try to search about how to fix that but i can't find

Mysql logs!
Код:
[Fri Dec 06 22:35:49 2013] [Sat Dec 07 00:26:47 2013] Function: mysql_query executed: "UPDATE `playerdata` SET `admin` = '0', `score` = '0', `money` = '0' ,`kills` = '0','deaths' = '0',`skin` = '0',`muted` = '0','banned' = '0','Online' ='0 h 1 m 45 s','Vip' = '0' WHERE `id` = '3' LIMIT 1" with result: "1".
[Sat Dec 07 00:26:47 2013] 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 ''deaths' = '0',`skin` = '0',`muted` = '0','banned' = '0','Online' ='0 h 1 m 45 s' at line 1.
My Script
pawn Код:
SavePlayer(playerid)
{
    if(PlayerInfo[playerid][Logged] == 1)
    {
        new Query[700],hh, mm, ss;
        GetPlayerOnlineTime(playerid, hh, mm, ss);
        format(Query, 500, "UPDATE `playerdata` SET `admin` = '%d', `score` = '%d', `money` = '%d' ,`kills` = '%d','deaths' = '%d',`skin` = '%d',`muted` = '%d','banned' = '%d','Online' ='%i h %i m %i s','Vip' = '%d' WHERE `id` = '%d' LIMIT 1",
        PlayerInfo[playerid][pAdminLevel],
        PlayerInfo[playerid][pScore],
        PlayerInfo[playerid][pMoney],
        PlayerInfo[playerid][pKills],
        PlayerInfo[playerid][pDeaths],
        PlayerInfo[playerid][pSkin],
        PlayerInfo[playerid][pMuted],
        PlayerInfo[playerid][pBanned],
        hh,
        mm,
        ss,
        PlayerInfo[playerid][pVip],
        PlayerInfo[playerid][ID]);
        mysql_query(Query);
    }
}
Reply


Messages In This Thread
Mysql saving stats problem - by SilentSoul - 07.12.2013, 05:48
Re: Mysql saving stats problem - by Tayab - 07.12.2013, 06:48
Re: Mysql saving stats problem - by SilentSoul - 07.12.2013, 06:58
Re: Mysql saving stats problem - by Konstantinos - 07.12.2013, 11:03

Forum Jump:


Users browsing this thread: 1 Guest(s)