1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Linear Mode
OnPlayerUpdateEx (MySQL)
TuTh
Big Clucker
***
Posts: 99
Threads: 19
Joined: Apr 2012
Reputation: 0
#1

20.12.2012, 16:34
i transformed the login/register from gf in mysql, and onplayerupdateex is not working, the informations is not saving

what is wrong ?

Код:
public OnPlayerUpdateEx(playerid)
{
	if(IsPlayerConnected(playerid))
	{
		if(gPlayerLogged[playerid])
		{
        	new var[32];
        	new Pname[24];
    		GetPlayerName(playerid, Pname, 24);
        	new escname[24];
            mysql_real_escape_string(Pname, escname);
            format(var, 32, "UPDATE `users` SET Key = %s WHERE `Nickname` = %s", PlayerInfo[playerid][pKey],escname);
      	    PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
            format(var, 32, "UPDATE `users` SET Level = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pLevel],escname);
            format(var, 32, "UPDATE `users` SET AdminLevel = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pAdmin],escname);
            format(var, 32, "UPDATE `users` SET DonateRank = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pDonateRank],escname);
            format(var, 32, "UPDATE `users` SET UpgradePoints = %d WHERE `Nickname` = %s",PlayerInfo[playerid][gPupgrade],escname);
            format(var, 32, "UPDATE `users` SET ConnectedTime = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pConnectTime],escname);
            format(var, 32, "UPDATE `users` SET Registered = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pReg],escname);
            format(var, 32, "UPDATE `users` SET Sex = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pSex],escname);
            format(var, 32, "UPDATE `users` SET Age = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pAge],escname);
            format(var, 32, "UPDATE `users` SET Origin = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pOrigin],escname);
            format(var, 32, "UPDATE `users` SET CK = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pCK],escname);
            format(var, 32, "UPDATE `users` SET Muted = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pMuted],escname);
            format(var, 32, "UPDATE `users` SET Respect = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pExp],escname);
            format(var, 32, "UPDATE `users` SET Money = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pCash],escname);
            format(var, 32, "UPDATE `users` SET Bank = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pAccount],escname);
            format(var, 32, "UPDATE `users` SET Crimes = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pCrimes],escname);
            format(var, 32, "UPDATE `users` SET Kills = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pKills],escname);
            format(var, 32, "UPDATE `users` SET Deaths = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pDeaths],escname);
            format(var, 32, "UPDATE `users` SET Arrested = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pArrested],escname);
            format(var, 32, "UPDATE `users` SET WantedDeaths = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pWantedDeaths],escname);
            format(var, 32, "UPDATE `users` SET Phonebook = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pPhoneBook],escname);
            format(var, 32, "UPDATE `users` SET LottoNr = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pLottoNr],escname);
            format(var, 32, "UPDATE `users` SET Fishes = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pFishes],escname);
            format(var, 32, "UPDATE `users` SET BiggestFish = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pBiggestFish],escname);
            format(var, 32, "UPDATE `users` SET Job = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pJob],escname);
            format(var, 32, "UPDATE `users` SET Paycheck = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pPayCheck],escname);
            format(var, 32, "UPDATE `users` SET HeadValue = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pHeadValue],escname);
            format(var, 32, "UPDATE `users` SET Jailed = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pJailed],escname);
            format(var, 32, "UPDATE `users` SET JailTime = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pJailTime],escname);
            format(var, 32, "UPDATE `users` SET Materials = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pMats],escname);
            format(var, 32, "UPDATE `users` SET Drugs = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pDrugs],escname);
            format(var, 32, "UPDATE `users` SET Leader = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pLeader],escname);
            format(var, 32, "UPDATE `users` SET Member = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pMember],escname);
            format(var, 32, "UPDATE `users` SET FMember = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pFMember],escname);
            format(var, 32, "UPDATE `users` SET Rank = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pRank],escname);
            format(var, 32, "UPDATE `users` SET Char = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pChar],escname);
            format(var, 32, "UPDATE `users` SET ContractTime = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pContractTime],escname);
            format(var, 32, "UPDATE `users` SET DetSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pDetSkill],escname);
            format(var, 32, "UPDATE `users` SET SexSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pSexSkill],escname);
            format(var, 32, "UPDATE `users` SET BoxSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pBoxSkill],escname);
            format(var, 32, "UPDATE `users` SET LawSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pLawSkill],escname);
            format(var, 32, "UPDATE `users` SET MechSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pMechSkill],escname);
            format(var, 32, "UPDATE `users` SET JackSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pJackSkill],escname);
            format(var, 32, "UPDATE `users` SET CarSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pCarSkill],escname);
            format(var, 32, "UPDATE `users` SET NewsSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pNewsSkill],escname);
            format(var, 32, "UPDATE `users` SET DrugsSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pDrugsSkill],escname);
            format(var, 32, "UPDATE `users` SET CookSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pCookSkill],escname);
            format(var, 32, "UPDATE `users` SET FishSkill = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pFishSkill],escname);
            format(var, 32, "UPDATE `users` SET pSHealth=%.1f WHERE `Nickname` = %s",PlayerInfo[playerid][pSHealth],escname);
   		    GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
            format(var, 32, "UPDATE `users` SET pHealth=%.1f WHERE `Nickname` = %s",PlayerInfo[playerid][pHealth],escname);
            format(var, 32, "UPDATE `users` SET Int = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pInt],escname);
            format(var, 32, "UPDATE `users` SET Local = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pLocal],escname);
            format(var, 32, "UPDATE `users` SET Team = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pTeam],escname);
            format(var, 32, "UPDATE `users` SET Model = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pModel],escname);
            format(var, 32, "UPDATE `users` SET PhoneNr = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pPnumber],escname);
            format(var, 32, "UPDATE `users` SET House = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pPhousekey],escname);
            format(var, 32, "UPDATE `users` SET Bizz = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pPbiskey],escname);
			if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
 			{
				PlayerInfo[playerid][pPos_x] = 1684.9;
				PlayerInfo[playerid][pPos_y] = -2244.5;
				PlayerInfo[playerid][pPos_z] = 13.5;
			}
			if(Spectate[playerid] != 255)
			{
				PlayerInfo[playerid][pPos_x] = Unspec[playerid][sPx];
				PlayerInfo[playerid][pPos_y] = Unspec[playerid][sPy];
				PlayerInfo[playerid][pPos_z] = Unspec[playerid][sPz];
       		    PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
	    		PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
            }
            format(var, 32, "UPDATE `users` SET Pos_x = %.1f WHERE `Nickname` = %s",PlayerInfo[playerid][pPos_x],escname);
            format(var, 32, "UPDATE `users` SET Pos_y = %.1f WHERE `Nickname` = %s",PlayerInfo[playerid][pPos_y],escname);
            format(var, 32, "UPDATE `users` SET Pos_z = %.1f WHERE `Nickname` = %s",PlayerInfo[playerid][pPos_z],escname);
            format(var, 32, "UPDATE `users` SET CarLic = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pCarLic],escname);
            format(var, 32, "UPDATE `users` SET FlyLic = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pFlyLic],escname);
            format(var, 32, "UPDATE `users` SET BoatLic = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pBoatLic],escname);
            format(var, 32, "UPDATE `users` SET FishLic = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pFishLic],escname);
            format(var, 32, "UPDATE `users` SET GunLic = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pGunLic],escname);
            format(var, 32, "UPDATE `users` SET Gun1 = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pGun1],escname);
            format(var, 32, "UPDATE `users` SET Gun2 = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pGun2],escname);
            format(var, 32, "UPDATE `users` SET Gun3 = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pGun3],escname);
            format(var, 32, "UPDATE `users` SET Gun4 = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pGun4],escname);
            format(var, 32, "UPDATE `users` SET Ammo1 = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pAmmo1],escname);
            format(var, 32, "UPDATE `users` SET Ammo2 = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pAmmo2],escname);
            format(var, 32, "UPDATE `users` SET Ammo3 = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pAmmo3],escname);
            format(var, 32, "UPDATE `users` SET Ammo4 = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pAmmo4],escname);
            format(var, 32, "UPDATE `users` SET CarTime = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pCarTime],escname);
            format(var, 32, "UPDATE `users` SET PayDay = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pPayDay],escname);
            format(var, 32, "UPDATE `users` SET PayDayHad = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pPayDayHad],escname);
            format(var, 32, "UPDATE `users` SET CDPlayer = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pCDPlayer],escname);
            format(var, 32, "UPDATE `users` SET Wins = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pWins],escname);
            format(var, 32, "UPDATE `users` SET Loses = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pLoses],escname);
            format(var, 32, "UPDATE `users` SET AlcoholPerk = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pAlcoholPerk],escname);
            format(var, 32, "UPDATE `users` SET DrugPerk = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pDrugPerk],escname);
            format(var, 32, "UPDATE `users` SET MiserPerk = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pMiserPerk],escname);
            format(var, 32, "UPDATE `users` SET PainPerk = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pPainPerk],escname);
            format(var, 32, "UPDATE `users` SET TraderPerk = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pTraderPerk],escname);
            format(var, 32, "UPDATE `users` SET Tutorial = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pTut],escname);
            format(var, 32, "UPDATE `users` SET Mission = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pMissionNr],escname);
            format(var, 32, "UPDATE `users` SET Warnings = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pWarns],escname);
            format(var, 32, "UPDATE `users` SET Adjustable = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pAdjustable],escname);
            if(PlayerInfo[playerid][pDonateRank] < 1) { PlayerInfo[playerid][pFuel] = 0; }
            format(var, 32, "UPDATE `users` SET Fuel = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pFuel],escname);
            format(var, 32, "UPDATE `users` SET Married = %d WHERE `Nickname` = %s",PlayerInfo[playerid][pMarried],escname);
            format(var, 32, "UPDATE `users` SET MarriedTo = %s WHERE `Nickname` = %s",PlayerInfo[playerid][pMarriedTo],escname);
		    mysql_function_query(mysqlh, var, false, "SendQuery", "");
		}
	}
	return 1;
Find
Reply
« Next Oldest | Next Newest »


Messages In This Thread
OnPlayerUpdateEx (MySQL) - by TuTh - 20.12.2012, 16:34
Re: OnPlayerUpdateEx (MySQL) - by Alexander_Petrov - 20.12.2012, 16:44
Re : OnPlayerUpdateEx (MySQL) - by TuTh - 20.12.2012, 16:59
Re: OnPlayerUpdateEx (MySQL) - by ikkentim - 20.12.2012, 18:58
Re: OnPlayerUpdateEx (MySQL) - by Alexander_Petrov - 20.12.2012, 19:00
Re: OnPlayerUpdateEx (MySQL) - by Vince - 20.12.2012, 19:28
Re : OnPlayerUpdateEx (MySQL) - by TuTh - 21.12.2012, 09:15
Re : Re: OnPlayerUpdateEx (MySQL) - by lelemaster - 21.12.2012, 11:15

Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help