fraktcarrespawn

function isVehicleOccupied(vehicle)
	local occupants = getVehicleOccupants(vehicle)
	local seats = getVehicleMaxPassengers(vehicle)
	for seat = 0, seats do
		if occupants[seat] then
			return true
		end
	end
	return false
end

function fraktrespawn(thePlayer, command)
	if (getElementData(thePlayer, "Fraktion") == 1) then
		fowner = 1
		FraktOwner = "Polizei"
	elseif (getElementData(thePlayer, "Fraktion") == 2) then
		fowner = 2
		FraktOwner = "Sanitäter"
	elseif (getElementData(thePlayer, "Fraktion") == 3) then
		fowner = 3
		FraktOwner = "San News"
	elseif (getElementData(thePlayer, "Fraktion") == 4) then
		fowner = 4
		FraktOwner = "Bundeswehr"
	elseif (getElementData(thePlayer, "Fraktion") == 5) then
		fowner = 5
		FraktOwner = "La Cosa Nostra"
	elseif (getElementData(thePlayer, "Fraktion") == 6) then
		fowner = 6
		FraktOwner = "Yakuza"
	end
	local Owner = tostring(FraktOwner)
	local slot  = tonumber(fowner)
	if getElementData(thePlayer, "Rang") >= 4 then
		if (_G["Fraktionsauto"..Owner..slot]) then
			if not isVehicleOccupied then
				destroyElement(_G["Fraktionsauto"..Owner..slot])
				_G["Fraktionsauto"..Owner..slot] = nil
				local tabler = mysql_query(sqlcon, "SELECT * FROM fraktauto_data WHERE `Besitzer`='"..Owner.."' AND `faccarid` = '"..slot.."'");
				if (tabler) then
					if(mysql_num_rows(tabler) > 0) then
						newTable = mysql_fetch_assoc(tabler)
						local Besitzer = newTable["Owner"]
						local Modell = newTable["VehID"]
						local Spawn_X = tonumber(newTable["X"])
						local Spawn_Y = tonumber(newTable["Y"])
						local Spawn_Z = tonumber(newTable["Z"])
						local Spawn_RX = tonumber(newTable["RX"])
						local Spawn_RY = tonumber(newTable["RY"])
						local Spawn_RZ = tonumber(newTable["RZ"])
						local Upgrade0 = newTable["Upgrade0"]
						local Upgrade1 = newTable["Upgrade1"]
						local Upgrade2 = newTable["Upgrade2"]
						local Upgrade3 = newTable["Upgrade3"]
						local Upgrade4 = newTable["Upgrade4"]
						local Upgrade5 = newTable["Upgrade5"]
						local Upgrade6 = newTable["Upgrade6"]
						local Upgrade7 = newTable["Upgrade7"]
						local Upgrade8 = newTable["Upgrade8"]
						local Upgrade9 = newTable["Upgrade9"]
						local Upgrade10 = newTable["Upgrade10"]
						local Upgrade11 = newTable["Upgrade11"]
						local Upgrade12 = newTable["Upgrade12"]
						local Upgrade13 = newTable["Upgrade13"]
						local Upgrade14 = newTable["Upgrade14"]
						local Upgrade15 = newTable["Upgrade15"]
						local Upgrade16 = newTable["Upgrade16"]
						local Besch = newTable["Beschlagnahmt"]
						local Paintjob = newTable["Paintjob"]
						local color1 = newTable["color1"]
						local color2 = newTable["color2"]
						local color3 = newTable["color3"]
						local color4 = newTable["color4"]
						local drugs = tonumber(newTable["Drogen"])
						local mats = tonumber(newTable["Material"])
						local tank = newTable["Tank"]
						local dist = newTable["Distanz"]
						local health = newTable["Leben"]
						local lc1 = newTable["lc1"]
						local lc2 = newTable["lc2"]
						local lc3 = newTable["lc3"]
						local OwnerSlot = newTable["faccarid"]
						_G["Fraktionsauto"..Besitzer..OwnerSlot] = createVehicle( Modell, Spawn_X, Spawn_Y, Spawn_Z,Spawn_RX, Spawn_RY, Spawn_RZ, Besitzer )
						local veh = _G["Fraktionsauto"..Besitzer..OwnerSlot]
						setVehicleRotation ( veh, Spawn_RX, Spawn_RY, Spawn_RZ )
						setVehicleColor ( veh, color1, color2, color3, color4)
						setVehicleHeadLightColor(veh, lc1, lc2, lc3)
						setVehiclePaintjob(veh, Paintjob)
						addVehicleUpgrade(veh, Upgrade0)
						addVehicleUpgrade(veh, Upgrade1)
						addVehicleUpgrade(veh, Upgrade2)
						addVehicleUpgrade(veh, Upgrade3)
						addVehicleUpgrade(veh, Upgrade4)
						addVehicleUpgrade(veh, Upgrade5)
						addVehicleUpgrade(veh, Upgrade6)
						addVehicleUpgrade(veh, Upgrade7)
						addVehicleUpgrade(veh, Upgrade8)
						addVehicleUpgrade(veh, Upgrade9)
						addVehicleUpgrade(veh, Upgrade10)
						addVehicleUpgrade(veh, Upgrade11)
						addVehicleUpgrade(veh, Upgrade12)
						addVehicleUpgrade(veh, Upgrade13)
						addVehicleUpgrade(veh, Upgrade14)
						addVehicleUpgrade(veh, Upgrade15)
						addVehicleUpgrade(veh, Upgrade16)
						setElementData(veh, "Drogen", drugs)
						setElementData(veh, "Material", mats)
						setElementData(veh, "Tank", tank)
						setElementData(veh, "Distanz", dist)
						setElementData(veh, "Leben", getElementHealth(veh))
						setElementData(veh, "Owner", Besitzer)
						setElementData(veh, "faccarid", OwnerSlot)
						setElementData(veh, "FraktCar", true)
					end
					mysql_free_result(tabler)
					outputChatBox("Fraktionsfahrzeuge erfolgreich respawnt!", thePlayer,0,255,0)
				end
			end
		end
	else
		outputChatBox("Du bist im Rang zu niedrig!", thePlayer,0,255,0)
	end
end
addCommandHandler("frsp", fraktrespawn)