SA-MP Forums Archive
saving system mysql(not mysql problem) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: saving system mysql(not mysql problem) (/showthread.php?tid=460684)



saving system mysql(not mysql problem) - martoivanov - 29.08.2013

Before everything I want to add that I think the problem is not in the SQL
I made a login/register system with MySQL. When someone enters the server for the first time everything is saved after he/she lefts BUT when the same person enter for 2nd, 3rd ... time his data is not saved after quiting. I don't know where is the problem but here is the code
pawn Code:
SavePlayer(playerid)
{
    {
        new Query[700];
        mysql_real_escape_string(pInfo[playerid][Username], pInfo[playerid][Username]);
        GetPlayerIp(playerid, pInfo[playerid][IP], 16);
        pInfo[playerid][Money] = GetPlayerMoney(playerid);
        pInfo[playerid][Scores] = GetPlayerScore(playerid);
        GetPlayerWeaponData(playerid, 0, pInfo[playerid][Weapon0], pInfo[playerid][Ammo0]);
        GetPlayerWeaponData(playerid, 1, pInfo[playerid][Weapon1], pInfo[playerid][Ammo1]);
        GetPlayerWeaponData(playerid, 2, pInfo[playerid][Weapon2], pInfo[playerid][Ammo2]);
        GetPlayerWeaponData(playerid, 3, pInfo[playerid][Weapon3], pInfo[playerid][Ammo3]);
        GetPlayerWeaponData(playerid, 4, pInfo[playerid][Weapon4], pInfo[playerid][Ammo4]);
        GetPlayerWeaponData(playerid, 5, pInfo[playerid][Weapon5], pInfo[playerid][Ammo5]);
        GetPlayerWeaponData(playerid, 6, pInfo[playerid][Weapon6], pInfo[playerid][Ammo6]);
        GetPlayerWeaponData(playerid, 7, pInfo[playerid][Weapon7], pInfo[playerid][Ammo7]);
        GetPlayerWeaponData(playerid, 8, pInfo[playerid][Weapon8], pInfo[playerid][Ammo8]);
        GetPlayerWeaponData(playerid, 9, pInfo[playerid][Weapon9], pInfo[playerid][Ammo9]);
        GetPlayerWeaponData(playerid, 10, pInfo[playerid][Weapon10], pInfo[playerid][Ammo10]);
        GetPlayerWeaponData(playerid, 11, pInfo[playerid][Weapon11], pInfo[playerid][Ammo11]);
        GetPlayerWeaponData(playerid, 12, pInfo[playerid][Weapon12], pInfo[playerid][Ammo12]);
        format(Query,sizeof Query,"UPDATE general SET Money = %d,Adminlevel = %d, VIPlevel = %d,Scores = %d, Kills = %d, Deaths = %d, Skin = %d,Warnings = %d,Banned = %d,Muted = %d,tMuted = %d,Jail = %d,JailTime = %d,BizID = %d,IP = '%s' WHERE Username = '%s'",
        pInfo[playerid][Money],
        pInfo[playerid][Adminlevel],
        pInfo[playerid][VIPlevel],
        pInfo[playerid][Scores],
        pInfo[playerid][Kills],
        pInfo[playerid][Deaths],
        pInfo[playerid][Skin],
        pInfo[playerid][Warnings],
        pInfo[playerid][Banned],
        pInfo[playerid][Muted],
        pInfo[playerid][tMuted],
        pInfo[playerid][Jail],
        pInfo[playerid][JailTime],
        pInfo[playerid][BizID],
        pInfo[playerid][IP],
        pInfo[playerid][Username]
        );
        mysql_query(Query);
        format(Query,sizeof Query,"UPDATE `general` SET `Ammo0` = '%d',`Ammo1` = '%d',`Ammo2` = '%d',`Ammo3` = '%d',`Ammo4` = '%d',`Ammo5` = '%d',`Ammo6` = '%d',`Ammo7` = '%d',`Ammo8` = '%d',`Ammo9` = '%d',`Ammo10` = '%d',`Ammo11` = '%d',`Ammo12` = '%d', `Weapon0` = '%d',`Weapon1` = '%d',`Weapon2` = '%d',`Weapon3` = '%d',`Weapon4` = '%d',`Weapon5` = '%d',`Weapon6` = '%d',`Weapon7` = '%d',`Weapon8` = '%d',`Weapon9` = '%d',`Weapon10` = '%d',`Weapon11` = '%d',`Weapon12` = '%d' WHERE `Username` = '%s'",
        pInfo[playerid][Ammo0],
        pInfo[playerid][Ammo1],
        pInfo[playerid][Ammo2],
        pInfo[playerid][Ammo3],
        pInfo[playerid][Ammo4],
        pInfo[playerid][Ammo5],
        pInfo[playerid][Ammo6],
        pInfo[playerid][Ammo7],
        pInfo[playerid][Ammo8],
        pInfo[playerid][Ammo9],
        pInfo[playerid][Ammo10],
        pInfo[playerid][Ammo11],
        pInfo[playerid][Ammo12],
        pInfo[playerid][Weapon0],
        pInfo[playerid][Weapon1],
        pInfo[playerid][Weapon2],
        pInfo[playerid][Weapon3],
        pInfo[playerid][Weapon4],
        pInfo[playerid][Weapon5],
        pInfo[playerid][Weapon6],
        pInfo[playerid][Weapon7],
        pInfo[playerid][Weapon8],
        pInfo[playerid][Weapon9],
        pInfo[playerid][Weapon10],
        pInfo[playerid][Weapon11],
        pInfo[playerid][Weapon12],
        pInfo[playerid][Username]
        );
        mysql_query(Query);
    }
}