Delete cars ingame problem.
#8

Here you go, and thanks for helping me.

Quote:
Код:
public LoadSQLCars()
{
	new sql[64], fields[55][MAX_PLAYER_NAME], row[320];
	new Float:park_x, Float:park_y, Float:park_z, Float:park_a;

	format(sql, sizeof(sql), "SELECT COUNT(*) FROM srp_players_cars");
	MySQLCheckConnection();
	mysql_query(sql);
	mysql_store_result();
	mysql_fetch_row(row);
	totalcars = strval(row);
	mysql_free_result();
	for (new i=1; i<=totalcars; i++)
	{
		format(sql, sizeof(sql), "SELECT * FROM srp_players_cars WHERE id=%d", i);
		MySQLCheckConnection();
		mysql_query(sql);
		mysql_store_result();
		mysql_fetch_row(row);
		split(row, fields, '|');
		CarInfo[i][cModel] = strval(fields[1]);
		CarInfo[i][cLocationx] = floatstr(fields[2]);
		CarInfo[i][cLocationy] = floatstr(fields[3]);
		CarInfo[i][cLocationz] = floatstr(fields[4]);
		CarInfo[i][cAngle]     = floatstr(fields[5]);
		park_x = floatstr(fields[6]);
		park_y = floatstr(fields[7]);
		park_z = floatstr(fields[8]);
		park_a = floatstr(fields[9]);
		if (park_x != 0 && park_y != 0 && park_z != 0)
	    {
	    	CarInfo[i][cLocationx] = park_x;
			CarInfo[i][cLocationy] = park_y;
			CarInfo[i][cLocationz] = park_z;
			CarInfo[i][cAngle] = park_a;
	    }
		CarInfo[i][cColorOne] = strval(fields[10]);
		CarInfo[i][cColorTwo] = strval(fields[11]);
		CarInfo[i][cOwned] = strval(fields[12]);
		memcpy(CarInfo[i][cOwner], fields[13], 0, MAX_PLAYER_NAME*4, MAX_PLAYER_NAME*4);
		memcpy(CarInfo[i][cOldOwner], fields[14], 0, MAX_PLAYER_NAME*4, MAX_PLAYER_NAME*4);
        CarInfo[i][cFaction] = strval(fields[15]);
  		CarInfo[i][cFamily] =  strval(fields[16]);
		CarInfo[i][cType] = strval(fields[17]);
		memcpy(CarInfo[i][cDescription], fields[18], 0, 32*4, 32*4);
		CarInfo[i][cValue] = strval(fields[19]);
		CarInfo[i][cStatus] = strval(fields[20]);
		if(CarInfo[i][cStatus]==3) // Cela ne sauvegarde pas la position du garage, donc, on remet а defaut
		    {CarInfo[i][cStatus]=1;}
		CarInfo[i][cRespawnTime] = 3600;
		CarInfo[i][cWindow] = 0;
		CarInfo[i][cLock] = strval(fields[21]);
	    CarInfo[i][cHouse] = strval(fields[23]);
		CarInfo[i][cArme1] = strval(fields[24]);
		CarInfo[i][cArme2] = strval(fields[25]);
		CarInfo[i][cArme3] = strval(fields[26]);
		CarInfo[i][cArme4] = strval(fields[27]);
		CarInfo[i][cArme5] = strval(fields[28]);
		CarInfo[i][cAmo1] = strval(fields[29]);
		CarInfo[i][cAmo2] = strval(fields[30]);
		CarInfo[i][cAmo3] = strval(fields[31]);
		CarInfo[i][cAmo4] = strval(fields[32]);
		CarInfo[i][cAmo5] = strval(fields[33]);
		CarInfo[i][cDrugs] = strval(fields[34]);
		CarInfo[i][cHero] = strval(fields[35]);
		CarInfo[i][cMatos] = strval(fields[36]);
		CarInfo[i][cJob] = strval(fields[37]);
		CarInfo[i][tPaintJob] = strval(fields[38]);
		CarInfo[i][tExhausts] = strval(fields[39]);
		CarInfo[i][tFrontBumper] = strval(fields[40]);
		CarInfo[i][tRearBumper] = strval(fields[41]);
		CarInfo[i][tRoof] = strval(fields[42]);
		CarInfo[i][tSpoilers] = strval(fields[43]);
		CarInfo[i][tSideBumper] = strval(fields[44]);
		CarInfo[i][tWheels] = strval(fields[45]);
		CarInfo[i][tHydraulics] = strval(fields[46]);
		CarInfo[i][tNitro] = strval(fields[47]);
		CarInfo[i][tSideBumper2] = strval(fields[48]);
		CarInfo[i][tNeon] = strval(fields[49]);
		memcpy(CarInfo[i][cPlaque], fields[50], 0,32*4,32*4);
		CarInfo[i][cRank] = strval(fields[51]);
		CarInfo[i][cStelled] = strval(fields[52]);
		CarInfo[i][cHuile] = strval(fields[53]);
		CarInfo[i][cVignette] = strval(fields[54]);
		CarInfo[i][cPlaqueAfficher] = 1;
        mysql_free_result();

		if (carsreloaded==0)
		{
			AddStaticVehicleEx(CarInfo[i][cModel], CarInfo[i][cLocationx], CarInfo[i][cLocationy], CarInfo[i][cLocationz], CarInfo[i][cAngle], CarInfo[i][cColorOne], CarInfo[i][cColorTwo], -1);
			tuning_resetFacture(i);
		    tuning_applyDbTuning(i);
		    car_isrenting[i] = -1;
		    if(IsABike(i))
		    {
		        engineOn[i] = true;
				car_Engine(i);
		    }
		}
		else
			{car_respawn(i,false);}
        CreateVehicleLabel(i,-1);

        CreatePlate(i,1);
	}
	print("Fin Boucle 292");
	carsreloaded++;
}
Reply


Messages In This Thread
Delete cars ingame problem. - by Kethrios - 15.11.2012, 11:51
Re : Delete cars ingame problem. - by Kethrios - 15.11.2012, 11:58
Re: Delete cars ingame problem. - by Abreezy - 15.11.2012, 12:03
Re : Delete cars ingame problem. - by Kethrios - 15.11.2012, 12:30
Re: Delete cars ingame problem. - by Abreezy - 15.11.2012, 12:36
Re : Delete cars ingame problem. - by Kethrios - 15.11.2012, 12:39
Re: Delete cars ingame problem. - by Abreezy - 15.11.2012, 12:42
Re : Delete cars ingame problem. - by Kethrios - 15.11.2012, 12:46
Re: Delete cars ingame problem. - by Abreezy - 15.11.2012, 12:50
Re : Delete cars ingame problem. - by Kethrios - 15.11.2012, 13:01

Forum Jump:


Users browsing this thread: 1 Guest(s)