Problème sauvegarde MYSQL

[Vestax]

Bonjour ,

J'ai un souci avec le mysql de mon serveur .

Tout les comptes ce créer parfaitement , cependant rien ne ce sauvegarde lors de la déconnexion du joueur ...

Un exemple si je met un statut à un joueur et que celui ci déco bah dans la DB sa reste à GROVE=0 idem pour les points de score rien ne ce sauvegarde .

Voici mon OnPlayerDisconnect :

Code: [Sélectionner]

public OnPlayerDisconnect(playerid, reason)
{
if(IsPlayerNPC(playerid))
{
    IsSpawned[playerid] =0;
    return 1;
}
    if(afktag[playerid] == 1)
{
new pname[16];
GetPlayerName(playerid,pname,16);
strdel(pname, strlen(pname)-5, strlen(pname));
afktag[playerid] =0;
SetPlayerName(playerid,pname);
}
    new string[128];
new pname[24];
GetPlayerName(playerid,pname,sizeof(pname));

//Save Wanted Level && Jailtime
SavedWantedLevel[playerid] =GetPlayerWantedLevel(playerid);
SavedJailTime[playerid] =JailTime[playerid];

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 = 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[200];
new nom[50];
        GetPlayerName(playerid, nom, 50);
        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, nom);
        mysql_query(query);
    }

//Do things to the playerid
ResetVariables(playerid);
TextDrawHideForPlayer(playerid,VersionTD);
TextDrawHideForPlayer(playerid,WebsiteTD);
TextDrawDestroy(MessageTD[playerid]);
TextDrawDestroy(JailTimer[playerid]);
TextDrawDestroy(LocationTD[playerid]);

if (PlayerInfo[playerid][pRoadblock] != 0)
{
RemoveRoadblock(playerid);
}
for(new i = 0; i < sizeof(Objects); i++) ////Xobj
{
if(Player[playerid][view][i])
{
Player[playerid][view][i] = false;
DestroyPlayerObject(playerid,Player[playerid][objid][i]);
}
}
format(string,sizeof(string),"%s vient de quitter {LSOFC} Flics & Criminels. (%s)",pname,aDisconnectNames[reason]);
SendClientMessageToAll(COLOR_DEADCONNECT,string);
format(string,sizeof(string),"1%s Has just left the server! (%s)",pname,aDisconnectNames[reason]);
IRC_Say(gGroupID,IRC_CHANNEL,string);
return 1;
}
MERCI !