[Ajuda] Nгo ta salvando mysql
#1

Gente to mt tempo sem mexer com SAMP, peguei meu GM, ta dando um monte de problema que antes de eu parar nгo dava (PS: FUI EU Q FIZ ESSE GM )

MYSQL nгo ta carregando... pq sr!?

stock que salva as variaveis do player (chamad ongamemodexit e onplayerdisconnect)
Код:
stock OnPlayerSave(playerid) {
	new query[1024], ip[25];
	GetPlayerIp(playerid, ip, sizeof(ip));
	money[playerid] = GetPlayerMoneyEx(playerid);

	format(query, sizeof(query), "UPDATE accounts SET Username = '%s', IP = '%s', scorelevel = %d, maconha = %d, sementes = %d, BPsize = %d, lastlogin = %d, wanted = %d, moneybag = %d, COPskills = %d, CRIMINALskills = %d, PARAMEDICskills = %d, admin = %d, money = %d, bank = %d, kills = %d, deaths = %d, ",
		GetName(playerid), ip, scorelevel[playerid], maconha[playerid], sementes[playerid], BPsize[playerid], lastlogin[playerid], wanted[playerid], moneybag[playerid], COPskills[playerid], CRIMINALskills[playerid], PARAMEDICskills[playerid], admin[playerid], money[playerid], bank[playerid], kills[playerid], deaths[playerid]);
		
	format(query, sizeof(query), "%seagleSPAWN = %d, shotgunSPAWN = %d, spazSPAWN = %d, mp5SPAWN = %d, akSPAWN = %d, m4SPAWN = %d, rifleSPAWN = %d, sniperSPAWN = %d, meleeSPAWN[ = %d, ",
		GetName(playerid), EagleSPAWN[playerid], shotgunSPAWN[playerid], spazSPAWN[playerid], mp5SPAWN[playerid], akSPAWN[playerid], m4SPAWN[playerid], rifleSPAWN[playerid], sniperSPAWN[playerid], meleeSPAWN[playerid]);
		
	format(query, sizeof(query), "%sDP = %d, VIP = %d, fmembro = %d, fcargo = %d, preso = %d, presotime = %d, startVIPdia = %d, startVIPmes = %d, startVIPano = %d, carid = %d, carpos0 = %f, carpos1 = %f, carpos2 = %f, carpos3 = %f, spawnpoint = %d, housekey = %d, idiom = %d, tutorial = %d, banned = %d, leftBANdia = %d, leftBANmes = %d, leftBANano = %d WHERE Username = '%s'",
		query, DP[playerid], VIP[playerid], fmembro[playerid], fcargo[playerid], preso[playerid], presotime[playerid], startVIPdia[playerid], startVIPmes[playerid], startVIPano[playerid], carid[playerid], carpos[playerid][0], carpos[playerid][1], carpos[playerid][2], carpos[playerid][3], spawnpoint[playerid], housekey[playerid], idiom[playerid], tutorial[playerid], banned[playerid], leftBANdia[playerid], leftBANmes[playerid], leftBANano[playerid] , GetName(playerid) );
	mysql_pquery(ConnectMYSQL, query);
}
Reply


Messages In This Thread
Nгo ta salvando mysql - by maikons - 20.08.2015, 18:29
Re: Nгo ta salvando mysql - by HaRdiiZin - 20.08.2015, 18:34
Re: Nгo ta salvando mysql - by maikons - 20.08.2015, 18:55
Re: Nгo ta salvando mysql - by [BOPE]Seu._.Madruga - 20.08.2015, 19:04
Re: Nгo ta salvando mysql - by maikons - 20.08.2015, 19:17
Re: Nгo ta salvando mysql - by [BOPE]Seu._.Madruga - 20.08.2015, 19:46
Re: Nгo ta salvando mysql - by n0minal - 20.08.2015, 20:26
Re: Nгo ta salvando mysql - by maikons - 20.08.2015, 20:38
Re: Nгo ta salvando mysql - by n0minal - 20.08.2015, 21:10
Re: Nгo ta salvando mysql - by maikons - 21.08.2015, 20:59

Forum Jump:


Users browsing this thread: 1 Guest(s)