Mysql no save
#1

Hello ,

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

//==============================================================================
Reply


Messages In This Thread
Mysql no save - by Baba_oweo - 12.02.2012, 15:46
Re : Mysql no save - by Baba_oweo - 14.02.2012, 10:40
Re : Mysql no save - by Vestax - 14.02.2012, 18:54
Re: Mysql no save - by lorigio - 14.02.2012, 19:05
Re: Mysql no save - by [MG]Dimi - 14.02.2012, 19:34

Forum Jump:


Users browsing this thread: 1 Guest(s)