MySQL Saving and Variables
#4

You mean something like

Код:
			format(string, sizeof(string), "UPDATE players SET `Cash`=%d,`Account`=%d,`AdminLevel`=%d,`Level`=%d,`Respect`=%d,`UpgradePoints`=%d,`Kills`=%d,`Gun1`=%d,`Gun2`=%d,`Gun3`=%d,`Gun4`=%d,`Gun5`=%d,`Gun6`=%d,`Ammo1`=%d,`Ammo2`=%d,`Ammo3`=%d,`Ammo4`=%d,`Ammo5`=%d,`Ammo6`=%d,`pSHealth`=%f,`Health`=%f,`Pos_x`=%f,`Pos_y`=%f,`Pos_z`=%f,`Int`=%d,`Local`=%d,`Team`=%d,`Char`=%d,`PhoneNr`=%d,`pHouseKey`=%d,`Bizz`=%d WHERE `Name` = '%s'",
			PlayerInfo[playerid][pCash],
			PlayerInfo[playerid][pAccount],
			PlayerInfo[playerid][pAdmin],
			PlayerInfo[playerid][pLevel],
			PlayerInfo[playerid][pExp],
			PlayerInfo[playerid][gPupgrade],
			PlayerInfo[playerid][pKills],
			PlayerInfo[playerid][pGun1],
	        PlayerInfo[playerid][pGun2],
	        PlayerInfo[playerid][pGun3],
	        PlayerInfo[playerid][pGun4],
	        PlayerInfo[playerid][pGun5],
	        PlayerInfo[playerid][pGun6],
	        PlayerInfo[playerid][pAmmo1],
	        PlayerInfo[playerid][pAmmo2],
	        PlayerInfo[playerid][pAmmo3],
	        PlayerInfo[playerid][pAmmo4],
	        PlayerInfo[playerid][pAmmo5],
	        PlayerInfo[playerid][pAmmo6],
	        PlayerInfo[playerid][pSHealth],
	        PlayerInfo[playerid][pHealth],
	        PlayerInfo[playerid][pPos_x],
	        PlayerInfo[playerid][pPos_y],
	        PlayerInfo[playerid][pPos_z],
	        PlayerInfo[playerid][pInt],
	        PlayerInfo[playerid][pLocal],
	        PlayerInfo[playerid][pTeam],
	        PlayerInfo[playerid][pModel],
	        PlayerInfo[playerid][pPnumber],
	        PlayerInfo[playerid][pHousekey],
	        PlayerInfo[playerid][pPbiskey],
			PlayerName(playerid));
			mysql_query_ex(string);
Just make a public with it like OnPlayerUpdate(playerid) eith those variables in it and set the time to the public
Reply


Messages In This Thread
MySQL Saving and Variables - by NeroX98 - 13.09.2013, 15:58
Respuesta: MySQL Saving and Variables - by PabloDiCostanzo - 13.09.2013, 16:12
Re: MySQL Saving and Variables - by NeroX98 - 13.09.2013, 16:39
Re: MySQL Saving and Variables - by devil shill - 13.09.2013, 17:39

Forum Jump:


Users browsing this thread: 1 Guest(s)