//==============================================================================

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;
}

//==============================================================================

 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);

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);