not saving
#1

Someone knows why this query doesn't save stats when someone quits?

OnPlayerDisconnect:

pawn Код:
if(Logged[playerid] == 1)
    {
    new score = GetPlayerScore(playerid);
    new money = GetPlayerMoney(playerid);
    new query[500], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "UPDATE `playerdata` SET Scores='%d', Cash='%d', Admin='%d', Deaths='%d', Nopm='%d', Muted='%d', Vip='%d', Warn='%d', RegisterDate='%d', Jailed='%d', AdminActions='%d', Cookies='%d', Rank='%d', VipTime='%d', Class='%d', PrototypesStolen='%d', Exp='%d', Duty='%d', KillAsUsaTeam='%d', KillAsGermanyTeam='%d', KillAsItalyTeam='%d', KillAsJapanTeam='%d', KillAsMercTeam='%d', KillAsMexicoTeam='%d' WHERE user='%s'",
    score,
    money,
    PlayerInfo[playerid][Admin],
    PlayerInfo[playerid][Deaths],
    PlayerInfo[playerid][Nopm],
    PlayerInfo[playerid][Muted],
    PlayerInfo[playerid][Vip],
    PlayerInfo[playerid][Warn],
    PlayerInfo[playerid][RegisterDate],
    PlayerInfo[playerid][Jailed],
    PlayerInfo[playerid][AdminActions],
    PlayerInfo[playerid][Cookies],
    PlayerInfo[playerid][Rank],
    PlayerInfo[playerid][VipTime],
    PlayerInfo[playerid][Class],
    PlayerInfo[playerid][PrototypesStolen],
    PlayerInfo[playerid][Exp],
    PlayerInfo[playerid][Duty],
    PlayerInfo[playerid][KillAsUsaTeam],
    PlayerInfo[playerid][KillAsGermanyTeam],
    PlayerInfo[playerid][KillAsItalyTeam],
    PlayerInfo[playerid][KillAsJapanTeam],
    PlayerInfo[playerid][KillAsMercTeam],
    PlayerInfo[playerid][KillAsMexicoTeam],
    pname
    );
    mysql_query(query);
    }
The tables are created and everything is ok. The only thing that doesnt save is the score and the money.
Reply


Messages In This Thread
not saving - by Face9000 - 03.01.2014, 11:57
Re: not saving - by iJumbo - 03.01.2014, 12:21
Re: not saving - by Face9000 - 03.01.2014, 12:33
Re: not saving - by newbienoob - 03.01.2014, 12:42
Re: not saving - by Face9000 - 03.01.2014, 12:54
Re: not saving - by Face9000 - 03.01.2014, 18:29

Forum Jump:


Users browsing this thread: 2 Guest(s)