12.02.2012, 15:46
Hello ,
When a player disconnects, statistics does not back up, why? ( My gm is in MYSQL )
When a player disconnects, statistics does not back up, why? ( My gm is in MYSQL )
Код:
//==============================================================================
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)
{
//If the player disconnects before registering,
//we want to make sure it doesn't try update
//so we check if the player is logged in.
new score = GetPlayerScore(playerid); //Gets players score
new money = GetPlayerMoney(playerid); //Gets players money
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);
}
//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;
}
//==============================================================================
