[TomyZ]

Hello,

I could put my GamePlay, in MySQL, but a pity that when the player disconnected trase no backup in my database (DB), here is the code so that you can help me.

Thank you in advance.

pawn Code:

if(Logged[playerid] == 1)
    {
        new score = GetPlayerScore(playerid);
        new money = GetPlayerMoney(playerid); 
        new CompteBanque = BankCash[playerid];
        new AdmLevel = AdminLevel[playerid];
        new Army = CanUseArmy[playerid];
        new CIA = CanUseCIA[playerid];
        new Lgroove = CanUseLeaderGroove[playerid];
        new groove = CanUseGroove[playerid];
        new Lballas = CanUseLeaderBallas[playerid];
        new ballas = CanUseBallas[playerid];
        new Regular = ("RegularPlayer",IsRegularPlayer[playerid]);
        new Drug = DrugHouseOwner[playerid];
        new Otto = OttoOwner[playerid];
        new Skill = TerroristSkill[playerid];
        new RSkill = RobSkill[playerid];
        new C4 = HasPackC4[playerid];
        new Rope = HasPackRope[playerid];
        new Pmoney = HasPackMoney[playerid];
        new Wanted = SavedWantedLevel[playerid];
        new Jail = SavedJailTime[playerid];
        new query[718]; //Creates the variables
        GetPlayerName(playerid, pname, 24); //Gets the players name.
        format(query, sizeof(query), "UPDATE oweo_compte SET Level=%d, Bankcash=%d, Cash=%d, Adminlevel=%d, Army=%d, CIA=%d, LeaderGroove=%d, Groove=%d, LeaderBallas=%d, Ballas=%d, RegularPlayer=%d, DrugHouseOwner=%d, OttoOwner=%d, TSkill=%d, RobSkill=%d, HasPackC4=%d, HasPackRope=%d, SavedWantedLevel=%d, SavedJailTime=%d WHERE compte='%s'",
        score, CompteBanque, money, AdmLevel, Army, CIA, Lgroove, groove, Lballas, ballas, Regular, Drug, Otto, Skill, RSkill, C4, Rope, Pmoney, Wanted, Jail, pname);
        mysql_query(query);
    }

ps: I apologize for my English, I am French.

Sincerely, TomyZ