[Ajuda] PlayerInfo
#21

Quote:
Originally Posted by JoelNyiTz
View Post
Para guardar:

stock GuardarCuenta(playerid)

forward SaveAccount(playerid);
public SaveAccount(playerid)

Para carregar:

forward CargarUsers();
public CargarUsers()
Tб, ok. Poste as callbacks.
Reply
#22

Quote:
Originally Posted by ipsLuan
View Post
Tб, ok. Poste as callbacks.
Certo, desculpe kk

Guardar:

Code:
forward SaveAccount(playerid);
public SaveAccount(playerid)
{
    if(GetPlayerScore(playerid) == 0) return 1;
	if(JugadorLogeado[playerid] == 1)
	{
        if(GetPVarInt(playerid, "TempName") == 1) return 1;
		JugadorLogeado[playerid] = 0;
		new query[2700];
		new Float:x,Float:y,Float:z,Float:z_a,Float:VidaV;
		new Float:x2,Float:y2,Float:z2,Float:z_a2,Float:VidaV2;
		new Float:x3,Float:y3,Float:z3,Float:z_a3,Float:VidaV3;
		new Float:x4,Float:y4,Float:z4,Float:z_a4,Float:VidaV4;
		new inte,vw;
		new pName[32],day,month,year;
		getdate(day,month,year);
		if(autos[playerid] > 0)
		{
			GetVehicleDamageStatus(autos[playerid], PlayerInfo[playerid][VE1], PlayerInfo[playerid][VE2], PlayerInfo[playerid][VE3], PlayerInfo[playerid][VE4]);
			PlayerInfo[playerid][vGas] = VehicleFuel[autos[playerid]];
			GetVehicleHealth(autos[playerid], VidaV);
			inte = GetVehicleInterior(autos[playerid]); vw = GetVehicleVirtualWorld(autos[playerid]);
			PlayerInfo[playerid][vinterior] = inte;
			PlayerInfo[playerid][vvw] = vw;
			GetVehiclePos(autos[playerid], x,y,z);
			PlayerInfo[playerid][vX] = x;
			PlayerInfo[playerid][vY] = y;
			bloqueado[autos[playerid]] = 0;
			PlayerInfo[playerid][vZ] = z;
			GetVehicleZAngle(autos[playerid], z_a);
			PlayerInfo[playerid][vA] = z_a;
			PlayerInfo[playerid][pVidaV] = VidaV;
			Baul[autos[playerid]] = 0;
			EspacioBaul[autos[playerid]] = 0;
			EspacioBaul2[autos[playerid]] = 0;
			EspacioBaul3[autos[playerid]] = 0;
			EspacioBaul4[autos[playerid]] = 0;
			EspacioBaul5[autos[playerid]] = 0;
			EspacioBaul6[autos[playerid]] = 0;
			EspacioBaul7[autos[playerid]] = 0;
			EspacioBaul8[autos[playerid]] = 0;
			DestroyVehicle(autos[playerid]);
			OldPosx[autos[playerid]] = 0;
			OldPosy[autos[playerid]] = 0;
			OldPosz[autos[playerid]] = 0;
			autos[playerid] = 0;
		}
		if(autos2[playerid] > 0)
		{
			GetVehicleDamageStatus(autos2[playerid], PlayerInfo[playerid][V2E1], PlayerInfo[playerid][V2E2], PlayerInfo[playerid][V2E3], PlayerInfo[playerid][V2E4]);
			PlayerInfo[playerid][v2Gas] = VehicleFuel[autos2[playerid]];
			GetVehicleHealth(autos2[playerid], VidaV2);
			inte = GetVehicleInterior(autos2[playerid]); vw = GetVehicleVirtualWorld(autos2[playerid]);
			PlayerInfo[playerid][v2interior] = inte;
			PlayerInfo[playerid][v2vw] = vw;
			GetVehiclePos(autos2[playerid], x2,y2,z2);
			PlayerInfo[playerid][v2X] = x2;
			PlayerInfo[playerid][v2Y] = y2;
			PlayerInfo[playerid][v2Z] = z2;
			GetVehicleZAngle(autos2[playerid], z_a2);
			PlayerInfo[playerid][v2A] = z_a2;
			PlayerInfo[playerid][pVidaV2] = VidaV2;
			Baul[autos2[playerid]] = 0;
			EspacioBaul[autos2[playerid]] = 0;
			EspacioBaul2[autos2[playerid]] = 0;
			EspacioBaul3[autos2[playerid]] = 0;
			EspacioBaul4[autos2[playerid]] = 0;
			EspacioBaul5[autos2[playerid]] = 0;
			EspacioBaul6[autos2[playerid]] = 0;
			EspacioBaul7[autos2[playerid]] = 0;
			EspacioBaul8[autos2[playerid]] = 0;
			bloqueado[autos2[playerid]] = 0;
			DestroyVehicle(autos2[playerid]);
			OldPosx[autos2[playerid]] = 0;
			OldPosy[autos2[playerid]] = 0;
			OldPosz[autos2[playerid]] = 0;
			autos2[playerid] = 0;
		}
		if(autos3[playerid] > 0)
		{
			GetVehicleDamageStatus(autos3[playerid], PlayerInfo[playerid][V3E1], PlayerInfo[playerid][V3E2], PlayerInfo[playerid][V3E3], PlayerInfo[playerid][V3E4]);
			PlayerInfo[playerid][v3Gas] = VehicleFuel[autos3[playerid]];
			GetVehicleHealth(autos3[playerid], VidaV3);
			inte = GetVehicleInterior(autos3[playerid]); vw = GetVehicleVirtualWorld(autos3[playerid]);
			PlayerInfo[playerid][v3interior] = inte;
			PlayerInfo[playerid][v3vw] = vw;
			GetVehiclePos(autos3[playerid], x3,y3,z3);
			PlayerInfo[playerid][v3X] = x3;
			PlayerInfo[playerid][v3Y] = y3;
			PlayerInfo[playerid][v3Z] = z3;
			GetVehicleZAngle(autos3[playerid], z_a3);
			PlayerInfo[playerid][v3A] = z_a3;
			PlayerInfo[playerid][pVidaV3] = VidaV3;
			Baul[autos3[playerid]] = 0;
			EspacioBaul[autos3[playerid]] = 0;
			EspacioBaul2[autos3[playerid]] = 0;
			EspacioBaul3[autos3[playerid]] = 0;
			EspacioBaul4[autos3[playerid]] = 0;
			EspacioBaul5[autos3[playerid]] = 0;
			EspacioBaul6[autos3[playerid]] = 0;
			EspacioBaul7[autos3[playerid]] = 0;
			EspacioBaul8[autos3[playerid]] = 0;
			bloqueado[autos3[playerid]] = 0;
			DestroyVehicle(autos3[playerid]);
			OldPosx[autos3[playerid]] = 0;
			OldPosy[autos3[playerid]] = 0;
			OldPosz[autos3[playerid]] = 0;
			autos3[playerid] = 0;
		}
		if(autos4[playerid] > 0)
		{
			GetVehicleDamageStatus(autos4[playerid], PlayerInfo[playerid][V4E1], PlayerInfo[playerid][V4E2], PlayerInfo[playerid][V4E3], PlayerInfo[playerid][V4E4]);
			PlayerInfo[playerid][v4Gas] = VehicleFuel[autos4[playerid]];
			GetVehicleHealth(autos4[playerid], VidaV4);
			inte = GetVehicleInterior(autos4[playerid]); vw = GetVehicleVirtualWorld(autos4[playerid]);
			PlayerInfo[playerid][v4interior] = inte;
			PlayerInfo[playerid][v4vw] = vw;
			GetVehiclePos(autos4[playerid], x4,y4,z4);
			PlayerInfo[playerid][v4X] = x4;
			PlayerInfo[playerid][v4Y] = y4;
			PlayerInfo[playerid][v4Z] = z4;
			GetVehicleZAngle(autos4[playerid], z_a4);
			PlayerInfo[playerid][v4A] = z_a4;
			PlayerInfo[playerid][pVidaV4] = VidaV4;
			Baul[autos4[playerid]] = 0;
			EspacioBaul[autos4[playerid]] = 0;
			EspacioBaul2[autos4[playerid]] = 0;
			EspacioBaul3[autos4[playerid]] = 0;
			EspacioBaul4[autos4[playerid]] = 0;
			EspacioBaul5[autos4[playerid]] = 0;
			EspacioBaul6[autos4[playerid]] = 0;
			EspacioBaul7[autos4[playerid]] = 0;
			EspacioBaul8[autos4[playerid]] = 0;
			bloqueado[autos4[playerid]] = 0;
			DestroyVehicle(autos4[playerid]);
			OldPosx[autos4[playerid]] = 0;
			OldPosy[autos4[playerid]] = 0;
			OldPosz[autos4[playerid]] = 0;
			autos4[playerid] = 0;
		}
		if(PlayerInfo[playerid][jDinero] < 0) { PlayerInfo[playerid][jDinero] = 0; }
		if(PlayerInfo[playerid][pBanco] < 0) { PlayerInfo[playerid][pBanco] = 0; }
		PlayerInfo[playerid][pInterior] = GetPlayerInterior(playerid);
		PlayerInfo[playerid][pMundoVirtual] = GetPlayerVirtualWorld(playerid);
		GetPlayerPos(playerid, PlayerInfo[playerid][jPos_x], PlayerInfo[playerid][jPos_y], PlayerInfo[playerid][jPos_z]);
		GetPlayerName(playerid, pName, 32);
		GetPlayerHealth(playerid, PlayerInfo[playerid][jVida]);
		GetPlayerArmour(playerid, PlayerInfo[playerid][jArmadura]);

		new hour,minute,second;
		gettime(hour, minute, second);
		format(PlayerInfo[playerid][jConexion], 90, "%02d/%02d/%02d %02d:%02d:%02d", year,month,day,hour,minute,second);

		format(query, 2700, "UPDATE `usuarios` SET `Online`='0',`Vida`='%f', `Chaleco`='%f', `Admin`=%d, `Nivel`='%d', `Money`=%d,`GPS`='%d',`Radio`='%d',`X`='%f',`Y`='%f',`Z`='%f',`A`='%f',`X2`='%f',`Y2`='%f',`Z2`='%f',`A2`='%f',`Sexo`='%d',`Numero`='%d',`Interior`=%d,`MundoVirtual`=%d,`NivelArmero`='%d',`ExpArmero`='%d',`Materiales`=%d,`NivelCamionero`='%d',`NivelBasurero`='%d',`ExpBasurero`='%d',`NivelVoa`='%d'", PlayerInfo[playerid][jVida], PlayerInfo[playerid][jArmadura],PlayerInfo[playerid][jAdminNvl],PlayerInfo[playerid][jNivel],PlayerInfo[playerid][jDinero],PlayerInfo[playerid][pGPS],PlayerInfo[playerid][pRadio],PlayerInfo[playerid][vX],PlayerInfo[playerid][vY],PlayerInfo[playerid][vZ],PlayerInfo[playerid][vA],PlayerInfo[playerid][v2X],PlayerInfo[playerid][v2Y],PlayerInfo[playerid][v2Z],PlayerInfo[playerid][v2A],PlayerInfo[playerid][jSexo],PlayerInfo[playerid][pNumero],PlayerInfo[playerid][pInterior],PlayerInfo[playerid][pMundoVirtual],PlayerInfo[playerid][pNivelArmero],PlayerInfo[playerid][pExpArmero],PlayerInfo[playerid][pMateriales],PlayerInfo[playerid][pNivelCamionero],PlayerInfo[playerid][pNivelBasurero],PlayerInfo[playerid][pExpBasurero],PlayerInfo[playerid][pNivelVoa]);
		format(query, 2700, "%s, `Posx`='%f', `Posy`='%f', `Posz`='%f',`TiempoJail`='%d',`Agonizando`='%d',`Trabajo`=%d,`Faccion`='%d',`NivelTransportista`='%d',`NivelLadron`='%d',`NivelPiloto`='%d',`ExpPiloto`='%d',`NivelTransportista`='%d',`ExpTransportista`='%d',`TipoCarcel`='%d',`SocioHP`='%d',`Hambre`='%d',`Licencia`='%d',`Semillas`='%d'", query,PlayerInfo[playerid][jPos_x], PlayerInfo[playerid][jPos_y], PlayerInfo[playerid][jPos_z],PlayerInfo[playerid][pTiempoJailS]*1000,PlayerInfo[playerid][Agonizando],PlayerInfo[playerid][jJob],PlayerInfo[playerid][jMiembro],PlayerInfo[playerid][pNivelTransportista],PlayerInfo[playerid][pNivelLadron],PlayerInfo[playerid][pNivelPiloto],PlayerInfo[playerid][pExpPiloto],PlayerInfo[playerid][pNivelTransportista],PlayerInfo[playerid][pExpTransportista],PlayerInfo[playerid][pTipoCarcel],PlayerInfo[playerid][pSocioHP], PlayerInfo[playerid][pHambre], PlayerInfo[playerid][pLicencia], PlayerInfo[playerid][pSemillas]);
		format(query, 2700, "%s, `IP`='%s',`Banco`=%d,`VidaV`='%f',`VidaV2`='%f',`Moneda`=%d,`EnCasa`='%d',`EnRopero`='%d',`EnGarage`='%d',`vinterior`='%d',`vvw`='%d',`v2interior`='%d',`v2vw`='%d',`vGas`='%d',`v2Gas`='%d',`TiempoPD`='%d', `totems`=%d, `arrestado`=%d, `horasjugadas`=%d, `TieneEmisora`='%d', `NombreEmisora`='%s',`Russo`='%d',`Espanhol`='%d',`Alemao`='%d',`Japones`='%d',`Facul`='%d'", query,PlayerInfo[playerid][IP],PlayerInfo[playerid][pBanco],PlayerInfo[playerid][pVidaV],PlayerInfo[playerid][pVidaV2],PlayerInfo[playerid][Moneda],PlayerInfo[playerid][EnCasa],PlayerInfo[playerid][EnRopero],PlayerInfo[playerid][EnGarage],PlayerInfo[playerid][vinterior],	PlayerInfo[playerid][vvw],PlayerInfo[playerid][v2interior],PlayerInfo[playerid][v2vw],PlayerInfo[playerid][vGas],PlayerInfo[playerid][v2Gas],TiempoPD[playerid], PlayerInfo[playerid][Totems], PlayerInfo[playerid][arrestado], PlayerInfo[playerid][horasjugadas], Emisoras[playerid][TieneEmisora], Emisoras[playerid][NombreEmisora],PlayerInfo[playerid][pRusso],PlayerInfo[playerid][pEspanhol],PlayerInfo[playerid][pAlemao],PlayerInfo[playerid][pJapones],PlayerInfo[playerid][pFacul]);
		format(query, 2700, "%s, `Cargos`='%d',`SkinTrabajo`='%d',`Duty`='%d',`WP0`='%d',`WP1`='%d',`WP2`='%d',`WP3`='%d',`WP4`='%d',`WP5`='%d',`WP6`='%d',`WP7`='%d',`WP8`='%d',`WP9`='%d',`WP10`='%d',`WP11`='%d',`WP12`='%d',`Experiencia`='%d',`TiempoCarcelM`='%d',`TiempoCarcelS`='%d',`NivelMinero`='%d',`ExpMinero`='%d', `PuntosCarrera`='%d', `Swat`='%d', `Emp`='%d', `Mercadoria`='%d'", query, PlayerInfo[playerid][pCargos],PlayerInfo[playerid][pModelo],PlayerInfo[playerid][pDuty],PlayerInfo[playerid][pWP0],PlayerInfo[playerid][pWP1],PlayerInfo[playerid][pWP2],PlayerInfo[playerid][pWP3],PlayerInfo[playerid][pWP4],PlayerInfo[playerid][pWP5],PlayerInfo[playerid][pWP6],PlayerInfo[playerid][pWP7],PlayerInfo[playerid][pWP8],PlayerInfo[playerid][pWP9],PlayerInfo[playerid][pWP10],PlayerInfo[playerid][pWP11],PlayerInfo[playerid][pWP12],PlayerInfo[playerid][jExperiencia],PlayerInfo[playerid][pTiempoCarcelM],PlayerInfo[playerid][pTiempoCarcelS],PlayerInfo[playerid][pNivelMinero],PlayerInfo[playerid][pExpMinero],PlayerInfo[playerid][pPuntosCarrera],PlayerInfo[playerid][pSwat],PlayerInfo[playerid][pEmp],PlayerInfo[playerid][pMercadoria]);
		format(query, 2700, "%s, `Conexion`='%s',`1Patente`='%s',`2Patente`='%s',`Sed`='%d',`NivelPescador`='%d',`ExpPescador`='%d',`RopaBasu`='%d',`RopaMedi`='%d',`RopaMeca`='%d',`RopaMine`='%d',`Martillo`='%d',`Destornillador`='%d',`Barreta`='%d',`Balde`='%d', `Regalo`='%d', `Patines`='%d', `vTraba` = '%d', `v2Traba` = '%d', `v3Traba`='%d', `v4Traba`='%d'", query, PlayerInfo[playerid][jConexion],PlayerInfo[playerid][vpatente], PlayerInfo[playerid][v2patente], PlayerInfo[playerid][pSed], PlayerInfo[playerid][pNivelPescador], PlayerInfo[playerid][pExpPescador], RopaBasu[playerid], RopaMedi[playerid], RopaMeca[playerid], RopaMine[playerid], PlayerInfo[playerid][jMartillo], PlayerInfo[playerid][jDestornillador], PlayerInfo[playerid][jBarreta], PlayerInfo[playerid][jBalde], PlayerInfo[playerid][jRegalo], PlayerInfo[playerid][pPatines], PlayerInfo[playerid][vTraba], PlayerInfo[playerid][v2Traba], PlayerInfo[playerid][v3Traba], PlayerInfo[playerid][v4Traba]);
		format(query, 2700, "%s, `Segurov3`='%d',`Segurov4`='%d',`V3E1`='%d',`V3E2`='%d',`V3E3`='%d',`V3E4`='%d',`V4E1`='%d',`V4E2`='%d',`V4E3`='%d',`V4E4`='%d',`3Patente`='%s',`4Patente`='%s',`VidaV3`='%f',`VidaV4`='%f',`v3interior`='%d',`v3vw`='%d',`v4interior`='%d',`v4vw`='%d',`v3Gas`='%d',`v4Gas`='%d'", query, PlayerInfo[playerid][vSeguro3],PlayerInfo[playerid][vSeguro4],PlayerInfo[playerid][V3E1],PlayerInfo[playerid][V3E2],PlayerInfo[playerid][V3E3],PlayerInfo[playerid][V3E4],PlayerInfo[playerid][V4E1],PlayerInfo[playerid][V4E2],PlayerInfo[playerid][V4E3],PlayerInfo[playerid][V4E4],PlayerInfo[playerid][v3patente], PlayerInfo[playerid][v4patente], PlayerInfo[playerid][pVidaV3],PlayerInfo[playerid][pVidaV4],PlayerInfo[playerid][v3interior],PlayerInfo[playerid][v3vw],PlayerInfo[playerid][v4interior],PlayerInfo[playerid][v4vw],PlayerInfo[playerid][v3Gas],PlayerInfo[playerid][v4Gas]);
		format(query, 2700, "%s, `Segurov`='%d',`Segurov2`='%d',`ExpCamionero`='%d',`ExpVoa`='%d',`Agenda`='%d',`Crack`=%d,`Medicamentos`=%d,`Trabajo2`=%d,`VIP`=%d,`Rango`='%d',`Repuestos`='%d',`VE1`='%d',`VE2`='%d',`VE3`='%d',`VE4`='%d',`V2E1`='%d',`V2E2`='%d',`V2E3`='%d',`V2E4`='%d',`NMute`='%d' WHERE `Username`='%s'", query,PlayerInfo[playerid][vSeguro],PlayerInfo[playerid][vSeguro2],PlayerInfo[playerid][pExpCamionero],PlayerInfo[playerid][pExpVoa],PlayerInfo[playerid][pAgenda],PlayerInfo[playerid][pCrack],PlayerInfo[playerid][pMedicamentos],PlayerInfo[playerid][vipjob],PlayerInfo[playerid][vip],PlayerInfo[playerid][pRango],PlayerInfo[playerid][Repuestos],PlayerInfo[playerid][VE1],PlayerInfo[playerid][VE2],PlayerInfo[playerid][VE3],PlayerInfo[playerid][VE4],PlayerInfo[playerid][V2E1],PlayerInfo[playerid][V2E2],PlayerInfo[playerid][V2E3],PlayerInfo[playerid][V2E4],TiempoDuda[playerid],pName);

		mysql_function_query(Conecction, query, true, "OnQueryFinish", "ii", 0, playerid);
	}
	return 1;
}

Carrega: (Enganei, a OnQueryFinish, carrega o pEmp)


Code:
forward OnQueryFinish(resultid, extraid, ConnectionHandle);
public OnQueryFinish(resultid, extraid, ConnectionHandle)
{
	new Rows, Field, string[256];
	if(resultid != 0)
	{
		cache_get_data(Rows, Field);
	}
	switch(resultid)
	{
		case 1:
		{
			if(Rows == 1)
			{
				new content[29];
				cache_get_field_content(0, "TieneEmisora", content);		Emisoras[extraid][TieneEmisora] = strval(content);
				cache_get_field_content(0, "ID", content);					PlayerInfo[extraid][pID] = strval(content);
				cache_get_field_content(0, "Online", content);				PlayerInfo[extraid][pOnline] = strval(content);
				cache_get_field_content(0, "Patines", content);				PlayerInfo[extraid][pPatines] = strval(content);
				cache_get_field_content(0, "Baneado", content);				PlayerInfo[extraid][pBan] = strval(content);
				cache_get_field_content(0, "Sed", content);					PlayerInfo[extraid][pSed] = strval(content);
				cache_get_field_content(0, "Licencia", content);			PlayerInfo[extraid][pLicencia] = strval(content);
				cache_get_field_content(0, "Hambre", content);				PlayerInfo[extraid][pHambre] = strval(content);
				cache_get_field_content(0, "SocioHP", content);				PlayerInfo[extraid][pSocioHP] = strval(content);
				cache_get_field_content(0, "TipoCarcel", content);			PlayerInfo[extraid][pTipoCarcel] = strval(content);
				cache_get_field_content(0, "TiempoCarcelM", content);		PlayerInfo[extraid][pTiempoCarcelM] = strval(content);
				cache_get_field_content(0, "TiempoCarcelS", content);		PlayerInfo[extraid][pTiempoCarcelS] = strval(content);
				cache_get_field_content(0, "Numero", content);				PlayerInfo[extraid][pNumero] = strval(content);
				cache_get_field_content(0, "TiempoJail", content);			PlayerInfo[extraid][pTiempoJail] = strval(content);
				cache_get_field_content(0, "Cargos", content);				PlayerInfo[extraid][pCargos] = strval(content);
				cache_get_field_content(0, "Duty", content);				PlayerInfo[extraid][pDuty] = strval(content);
				cache_get_field_content(0, "Swat", content);				PlayerInfo[extraid][pSwat] = strval(content);
				cache_get_field_content(0, "SkinTrabajo", content);			PlayerInfo[extraid][pModelo] = strval(content);
				cache_get_field_content(0, "Agenda", content);				PlayerInfo[extraid][pAgenda] = strval(content);
				cache_get_field_content(0, "Stats", content);				PlayerInfo[extraid][pStats] = strval(content);
				cache_get_field_content(0, "NivelPiloto", content);			PlayerInfo[extraid][pNivelPiloto] = strval(content);
				cache_get_field_content(0, "ExpPiloto", content);			PlayerInfo[extraid][pExpPiloto] = strval(content);
				cache_get_field_content(0, "Russo", content);				PlayerInfo[extraid][pRusso] = strval(content);
				cache_get_field_content(0, "Japones", content);				PlayerInfo[extraid][pJapones] = strval(content);
				cache_get_field_content(0, "Espanhol", content);			PlayerInfo[extraid][pEspanhol] = strval(content);
				cache_get_field_content(0, "Alemao", content);				PlayerInfo[extraid][pAlemao] = strval(content);
				cache_get_field_content(0, "Facul", content);				PlayerInfo[extraid][pFacul] = strval(content);
				cache_get_field_content(0, "Emp", content);					PlayerInfo[extraid][pEmp] = strval(content);
				cache_get_field_content(0, "Mercadoria", content);			PlayerInfo[extraid][pMercadoria] = strval(content);
				cache_get_field_content(0, "EMS", content);					PlayerInfo[extraid][pEMS] = strval(content);
				cache_get_field_content(0, "Radio", content);				PlayerInfo[extraid][pRadio] = strval(content);
				cache_get_field_content(0, "GPS", content);					PlayerInfo[extraid][pGPS] = strval(content);
				cache_get_field_content(0, "Tutorial", content);			PlayerInfo[extraid][pTutorial] = strval(content);
				cache_get_field_content(0, "Rango", content);				PlayerInfo[extraid][pRango] = strval(content);
				cache_get_field_content(0, "Edad", content);				PlayerInfo[extraid][jEdad] = strval(content);
				cache_get_field_content(0, "Experiencia", content);			PlayerInfo[extraid][jExperiencia] = strval(content);
				cache_get_field_content(0, "Skin", content);				PlayerInfo[extraid][jRopa] = strval(content);
				cache_get_field_content(0, "Nivel", content);				PlayerInfo[extraid][jNivel] = strval(content);
				cache_get_field_content(0, "Sexo", content);				PlayerInfo[extraid][jSexo] = strval(content);
				cache_get_field_content(0, "Martillo", content);			PlayerInfo[extraid][jMartillo] = strval(content);
				cache_get_field_content(0, "Destornillador", content);		PlayerInfo[extraid][jDestornillador] = strval(content);
				cache_get_field_content(0, "Barreta", content);				PlayerInfo[extraid][jBarreta] = strval(content);
				cache_get_field_content(0, "Balde", content);				PlayerInfo[extraid][jBalde] = strval(content);
				cache_get_field_content(0, "Faccion", content);				PlayerInfo[extraid][jMiembro] = strval(content);
				cache_get_field_content(0, "hprecio", content);				PlayerInfo[extraid][hprecio] = strval(content);
				cache_get_field_content(0, "hmoneda", content);				PlayerInfo[extraid][hmoneda] = strval(content);
				cache_get_field_content(0, "h2precio", content);			PlayerInfo[extraid][h2precio] = strval(content);
				cache_get_field_content(0, "h2moneda", content);			PlayerInfo[extraid][h2moneda] = strval(content);
				cache_get_field_content(0, "Repuestos", content);			PlayerInfo[extraid][Repuestos] = strval(content);
				cache_get_field_content(0, "FinMes", content);				PlayerInfo[extraid][finmes] = strval(content);
				cache_get_field_content(0, "FinDia", content);				PlayerInfo[extraid][findia] = strval(content);
				cache_get_field_content(0, "FinAno", content);				PlayerInfo[extraid][finano] = strval(content);
				cache_get_field_content(0, "EnCasa", content);				PlayerInfo[extraid][EnCasa] = strval(content);
				cache_get_field_content(0, "EnRopero", content);			PlayerInfo[extraid][EnRopero] = strval(content);
				cache_get_field_content(0, "EnGarage", content);			PlayerInfo[extraid][EnGarage] = strval(content);
				cache_get_field_content(0, "CasaID", content);				PlayerInfo[extraid][CasaID] = strval(content);
				cache_get_field_content(0, "CasaID2", content);				PlayerInfo[extraid][CasaID2] = strval(content);
				cache_get_field_content(0, "Agonizando", content);			PlayerInfo[extraid][Agonizando] = strval(content);
				cache_get_field_content(0, "totems", content);				PlayerInfo[extraid][Totems] = strval(content);
				cache_get_field_content(0, "ent_totem", content);			PlayerInfo[extraid][Ent_Totem] = strval(content);
				cache_get_field_content(0, "VIP", content);					PlayerInfo[extraid][vip] = strval(content);
				cache_get_field_content(0, "Banco", content);				PlayerInfo[extraid][pBanco] = strval(content);
				cache_get_field_content(0, "Moneda", content);				PlayerInfo[extraid][Moneda] = strval(content);
				cache_get_field_content(0, "Money", content);				PlayerInfo[extraid][jDinero] = strval(content);
				cache_get_field_content(0, "Medicamentos", content);		PlayerInfo[extraid][pMedicamentos] = strval(content);
				cache_get_field_content(0, "Crack", content);				PlayerInfo[extraid][pCrack] = strval(content);
				cache_get_field_content(0, "Materiales", content);			PlayerInfo[extraid][pMateriales] = strval(content);
				cache_get_field_content(0, "Semillas", content);			PlayerInfo[extraid][pSemillas] = strval(content);
				cache_get_field_content(0, "Trabajo", content);				PlayerInfo[extraid][jJob] = strval(content);
				cache_get_field_content(0, "Trabajo2", content);			PlayerInfo[extraid][vipjob] = strval(content);
				cache_get_field_content(0, "Admin", content);				PlayerInfo[extraid][jAdminNvl] = strval(content);
				cache_get_field_content(0, "Regalo", content);              PlayerInfo[extraid][jRegalo] = strval(content);

				cache_get_field_content(0, "NMute", content);				TiempoDuda[extraid] = strval(content);
				cache_get_field_content(0, "TiempoPD", content);			TiempoPD[extraid] = strval(content);
				cache_get_field_content(0, "RopaBasu", content);			RopaBasu[extraid] = strval(content);
				cache_get_field_content(0, "RopaMedi", content);			RopaMedi[extraid] = strval(content);
				cache_get_field_content(0, "RopaMeca", content);			RopaMeca[extraid] = strval(content);
				cache_get_field_content(0, "RopaMine", content);			RopaMine[extraid] = strval(content);

				cache_get_field_content(0, "NombreEmisora", content);		strmid(Emisoras[extraid][NombreEmisora],  content, 0, strlen(content), 90);
                cache_get_field_content(0, "Conexion", content);			strmid(PlayerInfo[extraid][jConexion],  content, 0, strlen(content), 90);
                cache_get_field_content(0, "razon", content);				strmid(PlayerInfo[extraid][pRazon],  content, 0, strlen(content), 32);
				cache_get_field_content(0, "totem", content);				strmid(PlayerInfo[extraid][Totem],  content, 0, strlen(content), 32);

				cache_get_field_content(0, "Vida", content);				PlayerInfo[extraid][jVida] = 		floatstr(content);
				cache_get_field_content(0, "Chaleco", content);				PlayerInfo[extraid][jArmadura] = 	floatstr(content);
				cache_get_field_content(0, "posX", content);				PlayerInfo[extraid][jPos_x] = 		floatstr(content);
				cache_get_field_content(0, "posY", content);				PlayerInfo[extraid][jPos_y] = 		floatstr(content);
				cache_get_field_content(0, "posZ", content);				PlayerInfo[extraid][jPos_z] = 		floatstr(content);

				PlayerInfo[extraid][pInterior] 		= cache_get_field_content_int(0, "Interior");
				PlayerInfo[extraid][pMundoVirtual] 	= cache_get_field_content_int(0, "MundoVirtual");
				PlayerInfo[extraid][arrestado] 		= cache_get_field_content_int(0, "arrestado");
				PlayerInfo[extraid][horasjugadas] 	= cache_get_field_content_int(0, "horasjugadas");
				//PlayerInfo[extraid][pPuntosCarrera] = cache_get_field_content_int(0, "PuntosCarrera");

				cache_get_field_content(0, "PuntosCarrera", content);		PlayerInfo[extraid][pPuntosCarrera] = strval(content);

				// Armas
				cache_get_field_content(0, "WP0", content);					PlayerInfo[extraid][pWP0] = strval(content);
				cache_get_field_content(0, "WP1", content);					PlayerInfo[extraid][pWP1] = strval(content);
				cache_get_field_content(0, "WP2", content);					PlayerInfo[extraid][pWP2] = strval(content);
				cache_get_field_content(0, "WP3", content);					PlayerInfo[extraid][pWP3] = strval(content);
				cache_get_field_content(0, "WP4", content);					PlayerInfo[extraid][pWP4] = strval(content);
				cache_get_field_content(0, "WP5", content);					PlayerInfo[extraid][pWP5] = strval(content);
				cache_get_field_content(0, "WP6", content);					PlayerInfo[extraid][pWP6] = strval(content);
				cache_get_field_content(0, "WP7", content);					PlayerInfo[extraid][pWP7] = strval(content);
				cache_get_field_content(0, "WP8", content);					PlayerInfo[extraid][pWP8] = strval(content);
				cache_get_field_content(0, "WP9", content);					PlayerInfo[extraid][pWP9] = strval(content);
				cache_get_field_content(0, "WP10", content);				PlayerInfo[extraid][pWP10] = strval(content);
				cache_get_field_content(0, "WP11", content);				PlayerInfo[extraid][pWP11] = strval(content);
				cache_get_field_content(0, "WP12", content);				PlayerInfo[extraid][pWP12] = strval(content);
				// Habilidades y Niveles
				cache_get_field_content(0, "NivelArmero", content);			PlayerInfo[extraid][pNivelArmero] = strval(content);
				cache_get_field_content(0, "ExpArmero", content);			PlayerInfo[extraid][pExpArmero] = strval(content);
				cache_get_field_content(0, "NivelCamionero", content);		PlayerInfo[extraid][pNivelCamionero] = strval(content);
				cache_get_field_content(0, "ExpCamionero", content);		PlayerInfo[extraid][pExpCamionero] = strval(content);
				cache_get_field_content(0, "NivelBasurero", content);		PlayerInfo[extraid][pNivelBasurero] = strval(content);
				cache_get_field_content(0, "ExpLixeiro", content);			PlayerInfo[extraid][pExpBasurero] = strval(content);
				cache_get_field_content(0, "NivelLadron", content);			PlayerInfo[extraid][pNivelLadron] = strval(content);
				cache_get_field_content(0, "ExpLadron", content);			PlayerInfo[extraid][pExpLadron] = strval(content);
				cache_get_field_content(0, "NivelPescador", content);		PlayerInfo[extraid][pNivelPescador] = strval(content);
				cache_get_field_content(0, "ExpPescador", content);			PlayerInfo[extraid][pExpPescador] = strval(content);
				cache_get_field_content(0, "NivelMinero", content);			PlayerInfo[extraid][pNivelMinero] = strval(content);
				cache_get_field_content(0, "ExpMinero", content);			PlayerInfo[extraid][pExpMinero] = strval(content);
				cache_get_field_content(0, "NivelTransportista", content);	PlayerInfo[extraid][pNivelTransportista] = strval(content);
				cache_get_field_content(0, "ExpTransportista", content);	PlayerInfo[extraid][pExpTransportista] = strval(content);
				cache_get_field_content(0, "NivelVoa", content);			PlayerInfo[extraid][pNivelVoa] = strval(content);
				cache_get_field_content(0, "ExpVoa", content);				PlayerInfo[extraid][pExpVoa] = strval(content);
				// Auto 1
				cache_get_field_content(0, "vTraba", content);				PlayerInfo[extraid][vTraba] = strval(content);
				cache_get_field_content(0, "OX", content);					PlayerInfo[extraid][pOX] = floatstr(content);
				cache_get_field_content(0, "OY", content);					PlayerInfo[extraid][pOY] = floatstr(content);
				cache_get_field_content(0, "OZ", content);					PlayerInfo[extraid][pOZ] = floatstr(content);
				cache_get_field_content(0, "OA", content);					PlayerInfo[extraid][pOA] = floatstr(content);
				cache_get_field_content(0, "VE1", content);					PlayerInfo[extraid][VE1] = strval(content);
				cache_get_field_content(0, "VE2", content);					PlayerInfo[extraid][VE2] = strval(content);
				cache_get_field_content(0, "VE3", content);					PlayerInfo[extraid][VE3] = strval(content);
				cache_get_field_content(0, "VE4", content);					PlayerInfo[extraid][VE4] = strval(content);
				cache_get_field_content(0, "vMoneda", content);				PlayerInfo[extraid][vMonedaa] = strval(content);
				cache_get_field_content(0, "Modelo", content);				PlayerInfo[extraid][vModelo] = strval(content);
				cache_get_field_content(0, "vGas", content);				PlayerInfo[extraid][vGas] = strval(content);
				cache_get_field_content(0, "vinterior", content);			PlayerInfo[extraid][vinterior] = strval(content);
				cache_get_field_content(0, "vvw", content);					PlayerInfo[extraid][vvw] = strval(content);
				cache_get_field_content(0, "Color1", content);				PlayerInfo[extraid][vColor1] = strval(content);
				cache_get_field_content(0, "Color2", content);				PlayerInfo[extraid][vColor2] = strval(content);
				cache_get_field_content(0, "VidaV", content);				PlayerInfo[extraid][pVidaV] = floatstr(content);
				cache_get_field_content(0, "vBaul", content);				PlayerInfo[extraid][vBaul] = strval(content);
				cache_get_field_content(0, "vBaul2", content);				PlayerInfo[extraid][vBaul2] = strval(content);
				cache_get_field_content(0, "vBaul3", content);				PlayerInfo[extraid][vBaul3] = strval(content);
				cache_get_field_content(0, "vBaul4", content);				PlayerInfo[extraid][vBaul4] = strval(content);
				cache_get_field_content(0, "vBaul5", content);				PlayerInfo[extraid][vBaul5] = strval(content);
				cache_get_field_content(0, "vBaul6", content);				PlayerInfo[extraid][vBaul6] = strval(content);
				cache_get_field_content(0, "vBaul7", content);				PlayerInfo[extraid][vBaul7] = strval(content);
				cache_get_field_content(0, "vBaul8", content);				PlayerInfo[extraid][vBaul8] = strval(content);
				cache_get_field_content(0, "PaintJob", content);			PlayerInfo[extraid][vPJ] = strval(content);
				cache_get_field_content(0, "1Componentes0", content);		PlayerInfo[extraid][vComponentes0] = strval(content);
				cache_get_field_content(0, "1Componentes1", content);		PlayerInfo[extraid][vComponentes1] = strval(content);
				cache_get_field_content(0, "1Componentes2", content);		PlayerInfo[extraid][vComponentes2] = strval(content);
				cache_get_field_content(0, "1Componentes3", content);		PlayerInfo[extraid][vComponentes3] = strval(content);
				cache_get_field_content(0, "1Componentes4", content);		PlayerInfo[extraid][vComponentes4] = strval(content);
				cache_get_field_content(0, "1Componentes5", content);		PlayerInfo[extraid][vComponentes5] = strval(content);
				cache_get_field_content(0, "1Componentes6", content);		PlayerInfo[extraid][vComponentes6] = strval(content);
				cache_get_field_content(0, "1Componentes7", content);		PlayerInfo[extraid][vComponentes7] = strval(content);
				cache_get_field_content(0, "1Componentes8", content);		PlayerInfo[extraid][vComponentes8] = strval(content);
				cache_get_field_content(0, "1Componentes9", content);		PlayerInfo[extraid][vComponentes9] = strval(content);
				cache_get_field_content(0, "1Componentes10", content);		PlayerInfo[extraid][vComponentes10] = strval(content);
				cache_get_field_content(0, "1Componentes11", content);		PlayerInfo[extraid][vComponentes11] = strval(content);
				cache_get_field_content(0, "1Componentes12", content);		PlayerInfo[extraid][vComponentes12] = strval(content);
				cache_get_field_content(0, "1Componentes13", content);		PlayerInfo[extraid][vComponentes13] = strval(content);
				cache_get_field_content(0, "Precio", content);				PlayerInfo[extraid][vPrecio] = strval(content);
				cache_get_field_content(0, "X", content);					PlayerInfo[extraid][vX] = floatstr(content);
				cache_get_field_content(0, "Y", content);					PlayerInfo[extraid][vY] = floatstr(content);
				cache_get_field_content(0, "Z", content);					PlayerInfo[extraid][vZ] = floatstr(content);
				cache_get_field_content(0, "A", content);					PlayerInfo[extraid][vA] = floatstr(content);
				cache_get_field_content(0, "Ovw", content);					PlayerInfo[extraid][vOvw] = strval(content);
				cache_get_field_content(0, "Segurov", content);				PlayerInfo[extraid][vSeguro] = strval(content);
				cache_get_field_content(0, "Ointerior", content);			PlayerInfo[extraid][vOinterior] = strval(content);
				cache_get_field_content(0, "1Patente", content);			strmid(PlayerInfo[extraid][vpatente],  content, 0, strlen(content), 32);
				// Auto 2
				cache_get_field_content(0, "v2Traba", content);				PlayerInfo[extraid][v2Traba] = strval(content);
				cache_get_field_content(0, "V2E1", content);				PlayerInfo[extraid][V2E1] = strval(content);
				cache_get_field_content(0, "V2E2", content);				PlayerInfo[extraid][V2E2] = strval(content);
				cache_get_field_content(0, "V2E3", content);				PlayerInfo[extraid][V2E3] = strval(content);
				cache_get_field_content(0, "V2E4", content);				PlayerInfo[extraid][V2E4] = strval(content);
				cache_get_field_content(0, "v2Moneda", content);			PlayerInfo[extraid][v2Monedaa] = strval(content);
				cache_get_field_content(0, "Modelo2", content);				PlayerInfo[extraid][vModelo2] = strval(content);
				cache_get_field_content(0, "v2Gas", content);				PlayerInfo[extraid][v2Gas] = strval(content);
				cache_get_field_content(0, "v2interior", content);			PlayerInfo[extraid][v2interior] = strval(content);
				cache_get_field_content(0, "v2vw", content);				PlayerInfo[extraid][v2vw] = strval(content);
				cache_get_field_content(0, "2Color1", content);				PlayerInfo[extraid][v2Color1] = strval(content);
				cache_get_field_content(0, "2Color2", content);				PlayerInfo[extraid][v2Color2] = strval(content);
				cache_get_field_content(0, "v2Baul", content);				PlayerInfo[extraid][v2Baul] = strval(content);
				cache_get_field_content(0, "v2Baul2", content);				PlayerInfo[extraid][v2Baul2] = strval(content);
				cache_get_field_content(0, "v2Baul3", content);				PlayerInfo[extraid][v2Baul3] = strval(content);
				cache_get_field_content(0, "v2Baul4", content);				PlayerInfo[extraid][v2Baul4] = strval(content);
				cache_get_field_content(0, "v2Baul5", content);				PlayerInfo[extraid][v2Baul5] = strval(content);
				cache_get_field_content(0, "v2Baul6", content);				PlayerInfo[extraid][v2Baul6] = strval(content);
				cache_get_field_content(0, "v2Baul7", content);				PlayerInfo[extraid][v2Baul7] = strval(content);
				cache_get_field_content(0, "v2Baul8", content);				PlayerInfo[extraid][v2Baul8] = strval(content);
				cache_get_field_content(0, "PaintJob2", content);			PlayerInfo[extraid][vPJ2] = strval(content);
				cache_get_field_content(0, "2Componentes0", content);		PlayerInfo[extraid][v2Componentes0] = strval(content);
				cache_get_field_content(0, "2Componentes1", content);		PlayerInfo[extraid][v2Componentes1] = strval(content);
				cache_get_field_content(0, "2Componentes2", content);		PlayerInfo[extraid][v2Componentes2] = strval(content);
				cache_get_field_content(0, "2Componentes3", content);		PlayerInfo[extraid][v2Componentes3] = strval(content);
				cache_get_field_content(0, "2Componentes4", content);		PlayerInfo[extraid][v2Componentes4] = strval(content);
				cache_get_field_content(0, "2Componentes5", content);		PlayerInfo[extraid][v2Componentes5] = strval(content);
				cache_get_field_content(0, "2Componentes6", content);		PlayerInfo[extraid][v2Componentes6] = strval(content);
				cache_get_field_content(0, "2Componentes7", content);		PlayerInfo[extraid][v2Componentes7] = strval(content);
				cache_get_field_content(0, "2Componentes8", content);		PlayerInfo[extraid][v2Componentes8] = strval(content);
				cache_get_field_content(0, "2Componentes9", content);		PlayerInfo[extraid][v2Componentes9] = strval(content);
				cache_get_field_content(0, "2Componentes10", content);		PlayerInfo[extraid][v2Componentes10] = strval(content);
				cache_get_field_content(0, "2Componentes11", content);		PlayerInfo[extraid][v2Componentes11] = strval(content);
				cache_get_field_content(0, "2Componentes12", content);		PlayerInfo[extraid][v2Componentes12] = strval(content);
				cache_get_field_content(0, "2Componentes13", content);		PlayerInfo[extraid][v2Componentes13] = strval(content);
				cache_get_field_content(0, "Precio2", content);				PlayerInfo[extraid][v2Precio] = strval(content);
				cache_get_field_content(0, "Ovw2", content);				PlayerInfo[extraid][v2Ovw] = strval(content);
				cache_get_field_content(0, "Segurov2", content);			PlayerInfo[extraid][vSeguro2] = strval(content);
				cache_get_field_content(0, "Ointerior2", content);			PlayerInfo[extraid][v2Ointerior] = strval(content);
				cache_get_field_content(0, "OX2", content);					PlayerInfo[extraid][pOX2] = floatstr(content);
				cache_get_field_content(0, "OY2", content);					PlayerInfo[extraid][pOY2] = floatstr(content);
				cache_get_field_content(0, "OZ2", content);					PlayerInfo[extraid][pOZ2] = floatstr(content);
				cache_get_field_content(0, "OA2", content);					PlayerInfo[extraid][pOA2] = floatstr(content);
				cache_get_field_content(0, "VidaV2", content);				PlayerInfo[extraid][pVidaV2] = floatstr(content);
				cache_get_field_content(0, "X2", content);					PlayerInfo[extraid][v2X] = floatstr(content);
				cache_get_field_content(0, "Y2", content);					PlayerInfo[extraid][v2Y] = floatstr(content);
				cache_get_field_content(0, "Z2", content);					PlayerInfo[extraid][v2Z] = floatstr(content);
				cache_get_field_content(0, "A2", content);					PlayerInfo[extraid][v2A] = floatstr(content);
				cache_get_field_content(0, "2Patente", content);			strmid(PlayerInfo[extraid][v2patente], content, 0, strlen(content), 32);
				// Auto 3
				cache_get_field_content(0, "v3Traba", content);				PlayerInfo[extraid][v3Traba] = strval(content);
				cache_get_field_content(0, "V3E1", content);				PlayerInfo[extraid][V3E1] = strval(content);
				cache_get_field_content(0, "V3E2", content);				PlayerInfo[extraid][V3E2] = strval(content);
				cache_get_field_content(0, "V3E3", content);				PlayerInfo[extraid][V3E3] = strval(content);
				cache_get_field_content(0, "V3E4", content);				PlayerInfo[extraid][V3E4] = strval(content);
				cache_get_field_content(0, "v3Moneda", content);			PlayerInfo[extraid][v3Monedaa] = strval(content);
				cache_get_field_content(0, "Modelo3", content);				PlayerInfo[extraid][vModelo3] = strval(content);
				cache_get_field_content(0, "v3Gas", content);				PlayerInfo[extraid][v3Gas] = strval(content);
				cache_get_field_content(0, "v3interior", content);			PlayerInfo[extraid][v3interior] = strval(content);
				cache_get_field_content(0, "v3vw", content);				PlayerInfo[extraid][v3vw] = strval(content);
				cache_get_field_content(0, "3Color1", content);				PlayerInfo[extraid][v3Color1] = strval(content);
				cache_get_field_content(0, "3Color2", content);				PlayerInfo[extraid][v3Color2] = strval(content);
				cache_get_field_content(0, "v3Baul", content);				PlayerInfo[extraid][v3Baul] = strval(content);
				cache_get_field_content(0, "v3Baul2", content);				PlayerInfo[extraid][v3Baul2] = strval(content);
				cache_get_field_content(0, "v3Baul3", content);				PlayerInfo[extraid][v3Baul3] = strval(content);
				cache_get_field_content(0, "v3Baul4", content);				PlayerInfo[extraid][v3Baul4] = strval(content);
				cache_get_field_content(0, "v3Baul5", content);				PlayerInfo[extraid][v3Baul5] = strval(content);
				cache_get_field_content(0, "v3Baul6", content);				PlayerInfo[extraid][v3Baul6] = strval(content);
				cache_get_field_content(0, "v3Baul7", content);				PlayerInfo[extraid][v3Baul7] = strval(content);
				cache_get_field_content(0, "v3Baul8", content);				PlayerInfo[extraid][v3Baul8] = strval(content);
				cache_get_field_content(0, "PaintJob3", content);			PlayerInfo[extraid][vPJ3] = strval(content);
				cache_get_field_content(0, "3Componentes0", content);		PlayerInfo[extraid][v3Componentes0] = strval(content);
				cache_get_field_content(0, "3Componentes1", content);		PlayerInfo[extraid][v3Componentes1] = strval(content);
				cache_get_field_content(0, "3Componentes2", content);		PlayerInfo[extraid][v3Componentes2] = strval(content);
				cache_get_field_content(0, "3Componentes3", content);		PlayerInfo[extraid][v3Componentes3] = strval(content);
				cache_get_field_content(0, "3Componentes4", content);		PlayerInfo[extraid][v3Componentes4] = strval(content);
				cache_get_field_content(0, "3Componentes5", content);		PlayerInfo[extraid][v3Componentes5] = strval(content);
				cache_get_field_content(0, "3Componentes6", content);		PlayerInfo[extraid][v3Componentes6] = strval(content);
				cache_get_field_content(0, "3Componentes7", content);		PlayerInfo[extraid][v3Componentes7] = strval(content);
				cache_get_field_content(0, "3Componentes8", content);		PlayerInfo[extraid][v3Componentes8] = strval(content);
				cache_get_field_content(0, "3Componentes9", content);		PlayerInfo[extraid][v3Componentes9] = strval(content);
				cache_get_field_content(0, "3Componentes10", content);		PlayerInfo[extraid][v3Componentes10] = strval(content);
				cache_get_field_content(0, "3Componentes11", content);		PlayerInfo[extraid][v3Componentes11] = strval(content);
				cache_get_field_content(0, "3Componentes12", content);		PlayerInfo[extraid][v3Componentes12] = strval(content);
				cache_get_field_content(0, "3Componentes13", content);		PlayerInfo[extraid][v3Componentes13] = strval(content);
				cache_get_field_content(0, "Precio3", content);				PlayerInfo[extraid][v3Precio] = strval(content);
				cache_get_field_content(0, "Ovw3", content);				PlayerInfo[extraid][v3Ovw] = strval(content);
				cache_get_field_content(0, "Segurov3", content);			PlayerInfo[extraid][vSeguro3] = strval(content);
				cache_get_field_content(0, "Ointerior3", content);			PlayerInfo[extraid][v3Ointerior] = strval(content);
				cache_get_field_content(0, "OX3", content);					PlayerInfo[extraid][pOX3] = floatstr(content);
				cache_get_field_content(0, "OY3", content);					PlayerInfo[extraid][pOY3] = floatstr(content);
				cache_get_field_content(0, "OZ3", content);					PlayerInfo[extraid][pOZ3] = floatstr(content);
				cache_get_field_content(0, "OA3", content);					PlayerInfo[extraid][pOA3] = floatstr(content);
				cache_get_field_content(0, "VidaV3", content);				PlayerInfo[extraid][pVidaV3] = floatstr(content);
				cache_get_field_content(0, "X3", content);					PlayerInfo[extraid][v3X] = floatstr(content);
				cache_get_field_content(0, "Y3", content);					PlayerInfo[extraid][v3Y] = floatstr(content);
				cache_get_field_content(0, "Z3", content);					PlayerInfo[extraid][v3Z] = floatstr(content);
				cache_get_field_content(0, "A3", content);					PlayerInfo[extraid][v3A] = floatstr(content);
				cache_get_field_content(0, "3Patente", content);			strmid(PlayerInfo[extraid][v3patente], content, 0, strlen(content), 32);
				// Auto 4
				cache_get_field_content(0, "v4Traba", content);				PlayerInfo[extraid][v4Traba] = strval(content);
				cache_get_field_content(0, "V4E1", content);				PlayerInfo[extraid][V4E1] = strval(content);
				cache_get_field_content(0, "V4E2", content);				PlayerInfo[extraid][V4E2] = strval(content);
				cache_get_field_content(0, "V4E3", content);				PlayerInfo[extraid][V4E3] = strval(content);
				cache_get_field_content(0, "V4E4", content);				PlayerInfo[extraid][V4E4] = strval(content);
				cache_get_field_content(0, "v4Moneda", content);			PlayerInfo[extraid][v4Monedaa] = strval(content);
				cache_get_field_content(0, "Modelo4", content);				PlayerInfo[extraid][vModelo4] = strval(content);
				cache_get_field_content(0, "v4Gas", content);				PlayerInfo[extraid][v4Gas] = strval(content);
				cache_get_field_content(0, "v4interior", content);			PlayerInfo[extraid][v4interior] = strval(content);
				cache_get_field_content(0, "v4vw", content);				PlayerInfo[extraid][v4vw] = strval(content);
				cache_get_field_content(0, "4Color1", content);				PlayerInfo[extraid][v4Color1] = strval(content);
				cache_get_field_content(0, "4Color2", content);				PlayerInfo[extraid][v4Color2] = strval(content);
				cache_get_field_content(0, "v4Baul", content);				PlayerInfo[extraid][v4Baul] = strval(content);
				cache_get_field_content(0, "v4Baul2", content);				PlayerInfo[extraid][v4Baul2] = strval(content);
				cache_get_field_content(0, "v4Baul3", content);				PlayerInfo[extraid][v4Baul3] = strval(content);
				cache_get_field_content(0, "v4Baul4", content);				PlayerInfo[extraid][v4Baul4] = strval(content);
				cache_get_field_content(0, "v4Baul5", content);				PlayerInfo[extraid][v4Baul5] = strval(content);
				cache_get_field_content(0, "v4Baul6", content);				PlayerInfo[extraid][v4Baul6] = strval(content);
				cache_get_field_content(0, "v4Baul7", content);				PlayerInfo[extraid][v4Baul7] = strval(content);
				cache_get_field_content(0, "v4Baul8", content);				PlayerInfo[extraid][v4Baul8] = strval(content);
				cache_get_field_content(0, "PaintJob4", content);			PlayerInfo[extraid][vPJ4] = strval(content);
				cache_get_field_content(0, "4Componentes0", content);		PlayerInfo[extraid][v4Componentes0] = strval(content);
				cache_get_field_content(0, "4Componentes1", content);		PlayerInfo[extraid][v4Componentes1] = strval(content);
				cache_get_field_content(0, "4Componentes2", content);		PlayerInfo[extraid][v4Componentes2] = strval(content);
				cache_get_field_content(0, "4Componentes3", content);		PlayerInfo[extraid][v4Componentes3] = strval(content);
				cache_get_field_content(0, "4Componentes4", content);		PlayerInfo[extraid][v4Componentes4] = strval(content);
				cache_get_field_content(0, "4Componentes5", content);		PlayerInfo[extraid][v4Componentes5] = strval(content);
				cache_get_field_content(0, "4Componentes6", content);		PlayerInfo[extraid][v4Componentes6] = strval(content);
				cache_get_field_content(0, "4Componentes7", content);		PlayerInfo[extraid][v4Componentes7] = strval(content);
				cache_get_field_content(0, "4Componentes8", content);		PlayerInfo[extraid][v4Componentes8] = strval(content);
				cache_get_field_content(0, "4Componentes9", content);		PlayerInfo[extraid][v4Componentes9] = strval(content);
				cache_get_field_content(0, "4Componentes10", content);		PlayerInfo[extraid][v4Componentes10] = strval(content);
				cache_get_field_content(0, "4Componentes11", content);		PlayerInfo[extraid][v4Componentes11] = strval(content);
				cache_get_field_content(0, "4Componentes12", content);		PlayerInfo[extraid][v4Componentes12] = strval(content);
				cache_get_field_content(0, "4Componentes13", content);		PlayerInfo[extraid][v4Componentes13] = strval(content);
				cache_get_field_content(0, "Precio4", content);				PlayerInfo[extraid][v4Precio] = strval(content);
				cache_get_field_content(0, "Ovw4", content);				PlayerInfo[extraid][v4Ovw] = strval(content);
				cache_get_field_content(0, "Segurov4", content);			PlayerInfo[extraid][vSeguro4] = strval(content);
				cache_get_field_content(0, "Ointerior4", content);			PlayerInfo[extraid][v4Ointerior] = strval(content);
				cache_get_field_content(0, "OX4", content);					PlayerInfo[extraid][pOX4] = floatstr(content);
				cache_get_field_content(0, "OY4", content);					PlayerInfo[extraid][pOY4] = floatstr(content);
				cache_get_field_content(0, "OZ4", content);					PlayerInfo[extraid][pOZ4] = floatstr(content);
				cache_get_field_content(0, "OA4", content);					PlayerInfo[extraid][pOA4] = floatstr(content);
				cache_get_field_content(0, "VidaV4", content);				PlayerInfo[extraid][pVidaV4] = floatstr(content);
				cache_get_field_content(0, "X4", content);					PlayerInfo[extraid][v4X] = floatstr(content);
				cache_get_field_content(0, "Y4", content);					PlayerInfo[extraid][v4Y] = floatstr(content);
				cache_get_field_content(0, "Z4", content);					PlayerInfo[extraid][v4Z] = floatstr(content);
				cache_get_field_content(0, "A4", content);					PlayerInfo[extraid][v4A] = floatstr(content);
				cache_get_field_content(0, "4Patente", content);			strmid(PlayerInfo[extraid][v4patente], content, 0, strlen(content), 32);


				SetSpawnInfo(extraid,0,PlayerInfo[extraid][jRopa],PlayerInfo[extraid][jPos_x], PlayerInfo[extraid][jPos_y], PlayerInfo[extraid][jPos_z],5,0,0,0,0,0,0);
				SetPlayerScore(extraid,  PlayerInfo[extraid][jNivel]);
				EstablecerChaleco(extraid, PlayerInfo[extraid][jArmadura]);
				EstablecerVida(extraid, PlayerInfo[extraid][jVida]);


				if(PlayerInfo[extraid][pBan] == 1)
				{
           			new str[220];
    				format(str, sizeof(str), "Sua conta estб banida. Razгo: %s.", PlayerInfo[extraid][pRazon]);
    				SendClientMessage(extraid, COLOR_MUTE, str);
					Kick(extraid);
					return 1;
				}
				if(PlayerInfo[extraid][pTiempoJail] > 0)
				{
					PlayerInfo[extraid][pTiempoJailS] = PlayerInfo[extraid][pTiempoJail]/1000;
				}
				if(PlayerInfo[extraid][pCargos] > 0)
				{
					SetTimerEx("Encerrando2",2000,false,"d",extraid);
				}
				if(PlayerInfo[extraid][pEMS] == 0)
				{
					format(string,sizeof(string),"Use um e-mail vбlido para caso de perder sua senha.\n\nDigite seu e-mail:");
					ShowPlayerDialog(extraid, DEMAIL,DIALOG_STYLE_INPUT,"Coloque seu e-mail",string,"Proximo","");
				}
				else
				{
					SpawnPlayer(extraid);
				}
			}
			else if(!Rows)
			{
			    if(IsPlayerConnected(extraid))
	    		{
					IntentoDeLogear[extraid] += 2;
					if(IntentoDeLogear[extraid] == 3)
					{
					    SendClientMessage(extraid, -1, "Senha Incorreta, Tente novamente");
					    Kick(extraid);
				    	return 1;
					}
					new content[20], plrIP[16];
					cache_get_field_content(0, "Password", content);
					PlayerInfo[extraid][pPassword] = strval(content);
					ShowPlayerDialog(extraid, LOGIN, DIALOG_STYLE_INPUT,"Estб conta estб registrada","Senha Incorreta, Tente novamente","Entrar","Sair");
				    GetPlayerIp(extraid, plrIP, sizeof(plrIP));
					printf("O jogador %s errou a senha. (IP: %s)", NombreJugador(extraid), plrIP);
				}
			}
		}
		case 2:
		{
			if(Rows == 1)
			{
				LimpiarChat(extraid, 25, 1);
				new pName[50]; GetPlayerName(extraid, pName, 50);
				format(string, sizeof(string), "Digite sua senha:", pName);
				ShowPlayerDialog(extraid, LOGIN, DIALOG_STYLE_PASSWORD,"Estб conta estб registrada",string,"Entrar","Sair");
			}
			else if(!Rows)
			{
				LimpiarChat(extraid, 25, 1);
				new pName[50]; GetPlayerName(extraid, pName, 50);
				format(string, sizeof(string), "Digite sua senha:", pName);
				ShowPlayerDialog(extraid, REGISTRO, DIALOG_STYLE_PASSWORD,"Registrar uma nova conta",string,"Entrar","Sair");
			}
		}
		case 6:
		{
		    if(Rows >= 1)
		    {
				if(Rows > 50) Rows = 50;
				new type, queryString[180];
		        for(new i = 0; i < Rows ; i++)
		        {

					ActionQueue[i][qID] = cache_get_field_content_int(0, "ID");
					ActionQueue[i][qfaccj] = cache_get_field_content_int(0, "faccj");
					cache_get_field_content(0, "user_ses", ActionQueue[i][quser_ses], Conecction, 23);
					cache_get_field_content(0, "jugname", ActionQueue[i][qjugname], Conecction, 23);
					cache_get_field_content(0, "queue_params", ActionQueue[i][qparams], Conecction, 23);
					ActionQueue[i][qstatus] = cache_get_field_content_int(0, "status");
					type = cache_get_field_content_int(0, "type");

					if(ActionQueue[i][qstatus] == 0)
					{
					    new qString[128];
						switch(type)
						{
						    case 1: // Aceptar invitacion
						    {
     							ActionQueue[i][qstatus] = 1;
						        format(qString, 128, "jugadorinvitacion %d %s", ActionQueue[i][qfaccj], ActionQueue[i][quser_ses]);
						        CustomProc(qString);
						    }
						    case 2: // Cambiar de rango
						    {
						        if(!strcmp(ActionQueue[i][qparams], "nada", true))
						        {
						            ActionQueue[i][qstatus] = 2;
						        }
						        new gRank;
						        sscanf(ActionQueue[i][qparams], "p<|>d", gRank);
						    	format(qString, 128, "gMemberRank %d %d %s %s", ActionQueue[i][qfaccj], gRank, ActionQueue[i][quser_ses], ActionQueue[i][qjugname]);
						        CustomProc(qString);
						    }
						    case 3: // Expulsar
						    {
						        ActionQueue[i][qstatus] = 1;
						    	format(qString, 128, "expulsarmiembro %d %s %s", ActionQueue[i][qfaccj], ActionQueue[i][quser_ses], ActionQueue[i][qjugname]);
						        CustomProc(qString);
						    }
						    case 4: // Abandonar banda
						    {
						    	ActionQueue[i][qstatus] = 1;
						    	format(qString, 128, "abandonarbanda %d %s", ActionQueue[i][qfaccj], ActionQueue[i][quser_ses]);
						        CustomProc(qString);
						    }
						    case 5: // Cargar banda
						    {
						    	ActionQueue[i][qstatus] = 1;
						    	format(qString, 128, "recargarbandas");
						        CustomProc(qString);
						    }
						    case 6: // Cambiar nombre rango
						    {
						    	ActionQueue[i][qstatus] = 1;
						    	format(qString, 128, "gRankName %d %s %s %s", ActionQueue[i][qfaccj], ActionQueue[i][quser_ses], ActionQueue[i][qparams], ActionQueue[i][qjugname]);
						        CustomProc(qString);
                            }
						}
						mysql_format(Conecction, queryString, 128, "DELETE FROM `action_queue` WHERE `ID` = '%d'", ActionQueue[i][qID]);
						mysql_tquery(Conecction, queryString, "");
					}
		        }
		    }
		}
		//
        case 7:
		{
		    new playerid = extraid;
		    if(Rows < 1)
		    {
		            IntentoDeLogear[playerid] += 2;
					if(IntentoDeLogear[playerid] == 3)
					{
					    SendClientMessage(playerid, -1, "Senha Incorreta, Tente novamente");
					    Kick(playerid);
				    	return 1;
					}

		    		new Query[1024], pName[24], day, month, year;
					getdate(year,month,day);
					GetPlayerName(playerid,pName,24);

					new rplName[32];
					GetPlayerName(playerid, rplName, sizeof(rplName));
					for(new i = 0; i < strlen(rplName); i++)
					{
						if(rplName[i] == '_')
						{
						    rplName[i] = ' ';
						}
					}

					format(Query, sizeof(Query), "INSERT INTO `usuarios` (username, password,posX,posY,posZ,vida,money,banco,skin,Registro,Email,EMS,Edad) VALUES ('%s','%s','1715.5295','-1900.1307','13.5664','100','6000','10000','250','%02d/%02d/%02d','%s',1,%d)",pName,PlayerInfo[playerid][pPassword],day,month,year,PlayerInfo[playerid][pEmail],PlayerInfo[playerid][jEdad]);
					mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 0, playerid);

					format(Query, sizeof(Query), "INSERT INTO `logros` (nombre) VALUES ('%s');", pName);
					mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 0, playerid);

					format(Query, sizeof(Query), "INSERT INTO `smf_members` (member_name, passwd, real_name, date_registered, id_group, email_address) VALUES ('%s', SHA1(CONCAT(LOWER('%s'), '%s')),'%s',UNIX_TIMESTAMP(now()), 0, '%s')",pName,pName,PlayerInfo[playerid][pPassword],rplName,PlayerInfo[playerid][pEmail]);
					mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 0, playerid);

					switch(PlayerInfo[playerid][jSexo])
					{
					    case 2:
					    {
			   		 		format(Query, sizeof(Query), "UPDATE `smf_members` SET `avatar`='personajes/11.png'  WHERE `member_name`='%s'",pName);
							mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 0, playerid);

							format(Query, 200, "UPDATE `usuarios` SET `Skin`='11',`Sexo`='%d' WHERE `Username`='%s'",PlayerInfo[playerid][jSexo],pName);
							mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 0, playerid);
					    }
					    default:
					    {
					    	format(Query, sizeof(Query), "UPDATE `smf_members` SET `avatar`='personajes/250.png'  WHERE `member_name`='%s'",pName);
							mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 0, playerid);

							format(Query, 200, "UPDATE `usuarios` SET `Skin`='250',`Sexo`='%d' WHERE `Username`='%s'",PlayerInfo[playerid][jSexo],pName);
							mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 0, playerid);
					    }
					}

					new query[200];
					Usuarios[Cantidad]++;
     				format(query, 200, "UPDATE `registros` SET `Cantidad`='%d'",									Usuarios[Cantidad]);
					mysql_function_query(Conecction, query, true, "OnQueryFinish", "ii", 0, playerid);

					format(query, 200, "UPDATE `smf_settings` SET `Value`='%s' WHERE `Variable`='latestRealName'",	pName);
					mysql_function_query(Conecction, query, true, "OnQueryFinish", "ii", 0, playerid);

					format(query, 200, "UPDATE `smf_settings` SET `Value`='%d' WHERE `Variable`='totalMembers'",	Usuarios[Cantidad]);
					mysql_function_query(Conecction, query, true, "OnQueryFinish", "ii", 0, playerid);

					format(query, 200, "UPDATE `smf_settings` SET `Value`='%d' WHERE `Variable`='latestMember'",	Usuarios[Cantidad]);
					mysql_function_query(Conecction, query, true, "OnQueryFinish", "ii", 0, playerid);

					format(Query, sizeof(Query), "SELECT * FROM `usuarios` WHERE `Username` = '%s' AND `Password` = '%s'", pName, PlayerInfo[playerid][pPassword]);
					mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 1, playerid);
		    }
		    else
		    {
				SendClientMessage(playerid, COLOR_BLANCO, "O e-mail ultilizado jб esta em uso.");
		    	ShowPlayerDialog(playerid, DEMAIL,DIALOG_STYLE_INPUT,"Digite seu e-mail:","Use um e-mail vбlido para caso de perder sua senha.","Proximo","Sair");
		    }
		}
		//
	}
	return 1;
}
Reply
#23

Code:
for(new i = 0; i < MAX_PLAYERS; i++)
{
	if(!strcmp(PlayerName(i), PropInfo[c][pFunc]))
	{
		PlayerInfo[i][pEmp] = 0;
		break;
	}
}
Bom... A forma mais fбcil de fazer isso, eu acho
Reply
#24

Quote:
Originally Posted by MrEdu
View Post
Code:
for(new i = 0; i < MAX_PLAYERS; i++)
{
	if(!strcmp(PlayerName(i), PropInfo[c][pFunc]))
	{
		PlayerInfo[i][pEmp] = 0;
		break;
	}
}
Bom... A forma mais fбcil de fazer isso, eu acho
Coloquei e nгo funcionou, ainda nгo seta o pEmp a 0, infelizmente

Code:
CMD:demitirvaga1(playerid,params[])
{
    new string[1100], Query[130];
    for(new c = 0; c < MAX_PROPIEDADES; c++)
    for(new i = 0; i < MAX_PLAYERS; i++)
    {
		if(IsPlayerInRangeOfPoint(playerid,2.5,PropInfo[c][pPosX],PropInfo[c][pPosY],PropInfo[c][pPosZ]))
		{
 			if(!strcmp(PropInfo[c][pPropietario], NombreJugador(playerid), true))
			{
				if(strcmp(PropInfo[c][pFunc], NombreJugador(playerid), true) || strcmp(PropInfo[c][pFunc1], NombreJugador(playerid), true) || strcmp(PropInfo[c][pFunc2], NombreJugador(playerid), true) || strcmp(PropInfo[c][pFunc3], NombreJugador(playerid), true))
				{
   					if(!strcmp(NombreJugador(i), PropInfo[c][pFunc]))
					{
						PlayerInfo[i][pEmp] = 0;
					}
					format(string, 128,"Vocк {ff0000}demitiu{FFFFFF} da empresa {0066ff}%s{FFFFFF} que vocк trabalhava na produзгo {0066ff}1{FFFFFF}.", PropInfo[c][pFunc]);
					SendClientMessage(playerid, -1, string);
	    			        CargarPropiedad©;
					format(Query,sizeof(Query),"UPDATE `propiedades` SET `Func`='Ninguem' WHERE `ID`=%d",PropInfo[c][pID]);
					mysql_function_query(Conecction,Query,true,"","");
					format(PropInfo[c][pFunc], 24, "Ninguem");
					break;
				}
	 			else return SendClientMessage(playerid, COLOR_ROJO, "Nгo а ninguem ocupando a vaga 1!");
                        }
			else return SendClientMessage(playerid, COLOR_ROJO, "Vocк nгo й o dono dessa empresa.");
                }
	}
	return 1;
}
Reply
#25

Quote:
Originally Posted by ipsLuan
View Post
Tб, ok. Poste as callbacks.
@Update

Encontrei este erro no mysql.log, o que poderб ser?

Code:
[ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'NyiTz' in 'where clause' (Query: "UPDATE `usuarios` SET `Emp`='0' WHERE `Username`=NyiTz")
Reply
#26

Formate o nome do jogador como '%e' e tente novamente.
Reply
#27

se tem /demitirvaga1 deve ter /demitirvaga2 /demitirvaga3 nгo sei.

Mas se tiver faзa por sscanf

/DemitirVaga [Vaga 1-3]

@Agora resolvendo seu problema:

Tente converter o nome para id talvez de certo!
Tambйm da certo usando strcmp sem usar TEmp = 0 ou TEmp = 1
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)