Beiträge von deutschedaddelbude

public LoadJobCars()
{
	print("Lade Job Cars1");
	new string[256];
	format(string, (sizeof string), "SELECT * From `jobfahrzeuge`");
	mysql_query(string);
	mysql_store_result();
	new fahrzeuganzahl = mysql_num_rows();
	new Float:SpawnAutoX, Float:SpawnAutoY, Float:SpawnAutoZ, Float:SpawnAutoRota, Float:DerztigePosX, Float:DerztigePosY, Float:DerztigePosZ, Float:DerztigePosRota;
	mysql_free_result();
	//
	if(fahrzeuganzahl != 0)
	{
		print("Lade Job Cars2");
		new choosetheidopfer;

		while(choosetheidopfer > fahrzeuganzahl)
		{
			print("Lade Job Cars3");

		    format(string, (sizeof string), "SELECT ID From `jobfahrzeuge` WHERE ID = '%d'", choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			JobCar[choosetheidopfer][ID] = mysql_fetch_int();
			mysql_free_result();

			format(string, (sizeof string), "SELECT JobID From `jobfahrzeuge` WHERE ID = '%d'", choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			JobCar[choosetheidopfer][JobID] = mysql_fetch_int();
			mysql_free_result();


			format(string, (sizeof string), "SELECT Modell From `jobfahrzeuge` WHERE ID = '%d'", choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			JobCar[choosetheidopfer][Modell] = mysql_fetch_int();
			mysql_free_result();


			format(string, (sizeof string), "SELECT SpawnX From `jobfahrzeuge` WHERE ID = '%d'",choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			mysql_fetch_float(Float:SpawnAutoX);
			JobCar[choosetheidopfer][SpawnCarX] = Float:SpawnAutoX;
			mysql_free_result();

			format(string, (sizeof string), "SELECT SpawnY From `jobfahrzeuge` WHERE ID = '%d'",choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			mysql_fetch_float(Float:SpawnAutoY);
			JobCar[choosetheidopfer][SpawnCarY] = Float:SpawnAutoY;
			mysql_free_result();


			format(string, (sizeof string), "SELECT SpawnZ From `jobfahrzeuge` WHERE ID = '%d'",choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			mysql_fetch_float(Float:SpawnAutoZ);
			JobCar[choosetheidopfer][SpawnCarZ] = Float:SpawnAutoZ;
			mysql_free_result();


			format(string, (sizeof string), "SELECT SpawnRota From `jobfahrzeuge` WHERE ID = '%d'",choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			mysql_fetch_float(Float:SpawnAutoRota);
			JobCar[choosetheidopfer][SpawnCarRota] = Float:SpawnAutoRota;
			mysql_free_result();


			format(string, (sizeof string), "SELECT DerzeitigerStandortX From `jobfahrzeuge` WHERE ID = '%d'",choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			mysql_fetch_float(Float:DerztigePosX);
			JobCar[choosetheidopfer][DerzeitigePosX] = Float:DerztigePosX;
			mysql_free_result();


			format(string, (sizeof string), "SELECT DerzeitigerStandortY From `jobfahrzeuge` WHERE ID = '%d'",choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			mysql_fetch_float(Float:DerztigePosY);
			JobCar[choosetheidopfer][DerzeitigePosY] = Float:DerztigePosY;
			mysql_free_result();


			format(string, (sizeof string), "SELECT DerzeitigerStandortZ From `jobfahrzeuge` WHERE ID = '%d'",choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			mysql_fetch_float(Float:DerztigePosZ);
			JobCar[choosetheidopfer][DerzeitigePosZ] = Float:DerztigePosZ;
			mysql_free_result();


			format(string, (sizeof string), "SELECT DerzeitigerStandortRota From `jobfahrzeuge` WHERE ID = '%d'",choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			mysql_fetch_float(Float:DerztigePosRota);
			JobCar[choosetheidopfer][DerzeitigePosRota] = Float:DerztigePosRota;
			mysql_free_result();


			format(string, (sizeof string), "SELECT Farbe1 From `jobfahrzeuge` WHERE ID = '%d'", choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			JobCar[choosetheidopfer][Farbe1] = mysql_fetch_int();
			mysql_free_result();

			format(string, (sizeof string), "SELECT Farbe2 From `jobfahrzeuge` WHERE ID = '%d'", choosetheidopfer+1);
			mysql_query(string);
			mysql_store_result();
			JobCar[choosetheidopfer][Farbe2] = mysql_fetch_int();
			mysql_free_result();


			AddStaticVehicle(JobCar[choosetheidopfer][Modell], JobCar[choosetheidopfer][DerzeitigePosX], JobCar[choosetheidopfer][DerzeitigePosY], JobCar[choosetheidopfer][DerzeitigePosZ], JobCar[choosetheidopfer][DerzeitigePosRota], JobCar[choosetheidopfer][Farbe1], JobCar[choosetheidopfer][Farbe2]);
		}
		print("Lade Job Cars4");
		choosetheidopfer++;
	}
	else
	{
	    print("* Es konnten keine Job Fahrzeuge geladen werden. Evtl. ist die Datenbank falsch konfiguriert oder es sind keine Fahrzeuge verfügbar!");
	}
	return 1;
}