[MySQL] All players saving the same stats.
#1

OK. So I'm trying to save some weapon packages here, but somehow all players on my database get's the same weapon packages whenever I disconnect from the server. Whenever I buy new packages, sell them, or delete them. Everyone get's the same stats as I had when I log out.


pawn Code:
public SavePackages(playerid)
{
        if(playerid != INVALID_PLAYER_ID && PlayerIsOn(playerid) && PlayerLogged(playerid))
        {
        new packages[128], ammo[128];
        format(packages, sizeof(packages), "%d|%d|%d|%d|%d|%d|%d|%d|%d|%d", PlayerInfo[playerid][pGunPackages][0], PlayerInfo[playerid][pGunPackages][1], PlayerInfo[playerid][pGunPackages][2], PlayerInfo[playerid][pGunPackages][3], PlayerInfo[playerid][pGunPackages][4], PlayerInfo[playerid][pGunPackages][5], PlayerInfo[playerid][pGunPackages][6], PlayerInfo[playerid][pGunPackages][7], PlayerInfo[playerid][pGunPackages][8], PlayerInfo[playerid][pGunPackages][9]);
        format(ammo, sizeof(ammo), "%d|%d|%d|%d|%d|%d|%d|%d|%d|%d", PlayerInfo[playerid][pPackageAmmo][0], PlayerInfo[playerid][pPackageAmmo][1], PlayerInfo[playerid][pPackageAmmo][2], PlayerInfo[playerid][pPackageAmmo][3], PlayerInfo[playerid][pPackageAmmo][4], PlayerInfo[playerid][pPackageAmmo][5], PlayerInfo[playerid][pPackageAmmo][6], PlayerInfo[playerid][pPackageAmmo][7], PlayerInfo[playerid][pPackageAmmo][8], PlayerInfo[playerid][pPackageAmmo][9]);
        format(query, sizeof(query), "UPDATE `users` SET `gunpackages` = '%s', `packageammo` = '%s'",packages,ammo);
        GetName(playerid);
        mysql_function_query(dbHandle, query, false, "", "");
        }
        ret
Reply


Messages In This Thread
[MySQL] All players saving the same stats. - by ounce - 30.07.2015, 16:57
Re: [MySQL] All players saving the same stats. - by ]Rafaellos[ - 30.07.2015, 17:04
Re: [MySQL] All players saving the same stats. - by gurmani11 - 30.07.2015, 17:05
Re: [MySQL] All players saving the same stats. - by dominik523 - 30.07.2015, 17:06
Re: [MySQL] All players saving the same stats. - by ounce - 30.07.2015, 17:08
Re: [MySQL] All players saving the same stats. - by ounce - 30.07.2015, 17:37
Re: [MySQL] All players saving the same stats. - by Jacket - 30.07.2015, 17:45
Re: [MySQL] All players saving the same stats. - by ounce - 30.07.2015, 17:54

Forum Jump:


Users browsing this thread: 2 Guest(s)