database duplicating accounts
#1

It duplicates the previous stats from a previous user all the way to "playerrobs", moneybags stay at "0" ..
I cant find any mistake i've made ..
pawn Код:
stock SaveAccount(playerid)
{
        new score = GetPlayerScore(playerid);
        new money = GetPlayerMoney(playerid);
        new
                query[300],
                Float:pos[4],
                Float:health,
                Float:armour;

        GetPlayerPos(playerid, posArr{pos});
        GetPlayerFacingAngle(playerid, pos[3]);
        GetPlayerHealth(playerid, health);
        GetPlayerArmour(playerid, armour);
        format(query, sizeof(query), "UPDATE `users` SET score = %d, money = %d, health = %.1f, armour = %.1f, X = %.2f, Y = %.2f, Z = %.2f, A = %.2f, interior = %d, vw = %d, skin = %d, wantedlevel = %d, admin = %d, tut = %d, muted = %d, kills = %d, deaths = %d, jailed = %d, frozen = %d, bankrobs = %d, storerobs = %d, playerrobs = %d, moneybags = %d, crimes = %d WHERE `id` = %d",
                score,
                money,
                health,
                armour,
                posArrEx{pos},
                GetPlayerInterior(playerid),
                GetPlayerVirtualWorld(playerid),
                GetPlayerSkin(playerid),
                GetPlayerWantedLevel(playerid),
                g_PlayerInfo[playerid][pAdmin],
                g_PlayerInfo[playerid][pTut],
                g_PlayerInfo[playerid][pMuted],
                g_PlayerInfo[playerid][pKills],
                g_PlayerInfo[playerid][pDeaths],
                g_PlayerInfo[playerid][pJailed],
                g_PlayerInfo[playerid][pFrozen],
                g_PlayerInfo[playerid][pBankrobs],
                g_PlayerInfo[playerid][pStorerobs],
                g_PlayerInfo[playerid][pPlayerrobs],
                g_PlayerInfo[playerid][pMoneybags],
                g_PlayerInfo[playerid][pCrimes],
                g_PlayerInfo[playerid][pSQLid]
        );

        mysql_function_query(g_Handle, query, false, "SendQuery", "");
        return 1;
}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)