MySQL FraktionsCarRespawn

local vcolor = {}
vcolor[1] = {}
vcolor[1][1] = 0
vcolor[1][2] = 1
vcolor[1][3] = 0
vcolor[1][4] = 0

vcolor[2] = {}
vcolor[2][1] = 3
vcolor[2][2] = 1
vcolor[2][3] = 3
vcolor[2][4] = 1

vcolor[3] = {}
vcolor[3][1] = 6
vcolor[3][2] = 6
vcolor[3][3] = 6
vcolor[3][4] = 6

vcolor[4] = {}
vcolor[4][1] = 102
vcolor[4][2] = 102
vcolor[4][3] = 102
vcolor[4][4] = 102

vcolor[5] = {}
vcolor[5][1] = 123
vcolor[5][2] = 123
vcolor[5][3] = 123
vcolor[5][4] = 123

vcolor[6] = {}
vcolor[6][1] = 93
vcolor[6][2] = 93
vcolor[6][3] = 93
vcolor[6][4] = 93

local owner = {
    [1] = "Polizei",
    [2] = "Sanitäter",
    [3] = "San News",
    [4] = "Bundeswehr",
    [5] = "La Cosa Nostra",
    [6] = "Yakuza"
}

local sowner = {
    [1] = 1,
    [2] = 2,
    [3] = 3,
    [4] = 4,
    [5] = 5,
    [6] = 6
}

function respawnFraktCars(thePlayer, cmd)
    local frak   = getElementData(thePlayer, "Fraktion")
    local rang   = getElementData(thePlayer, "Rang")
    local FraktOwner = tostring(owner[frak])
    local fowner     = tonumber(sowner[frak])
    if rang >= 4 then
        for i, vehicle in pairs (getElementsByType("vehicle")) do
            local facid = tonumber(getElementData(vehicle,"faccarid"))
            if facid == fowner then
                if isVehicleOccupied(vehicle) == false then
                    destroyElement(vehicle)
                end
            end
        end
        local result = mysql_query(sqlcon, "SELECT * FROM fraktauto_data WHERE `Besitzer` = '"..FraktOwner.."' AND `faccarid` = '"..fowner.."'");
        if( not result) then
            outputDebugString("Error executing the query: (" .. mysql_errno(sqlcon) .. ") " .. mysql_error(sqlcon))
        else
            if(mysql_num_rows(result) > 0) then
                carTable = mysql_fetch_assoc(result)
                while carTable do
                    local Besitzer = carTable["Besitzer"]
                    local Modell = carTable["VehID"]
                    local Spawn_X = carTable["X"]
                    local Spawn_Y = carTable["Y"]
                    local Spawn_Z = carTable["Z"]
                    local Spawn_RX = carTable["RX"]
                    local Spawn_RY = carTable["RY"]
                    local Spawn_RZ = carTable["RZ"]
                    local Upgrade0 = carTable["Upgrade0"]
                    local Upgrade1 = carTable["Upgrade1"]
                    local Upgrade2 = carTable["Upgrade2"]
                    local Upgrade3 = carTable["Upgrade3"]
                    local Upgrade4 = carTable["Upgrade4"]
                    local Upgrade5 = carTable["Upgrade5"]
                    local Upgrade6 = carTable["Upgrade6"]
                    local Upgrade7 = carTable["Upgrade7"]
                    local Upgrade8 = carTable["Upgrade8"]
                    local Upgrade9 = carTable["Upgrade9"]
                    local Upgrade10 = carTable["Upgrade10"]
                    local Upgrade11 = carTable["Upgrade11"]
                    local Upgrade12 = carTable["Upgrade12"]
                    local Upgrade13 = carTable["Upgrade13"]
                    local Upgrade14 = carTable["Upgrade14"]
                    local Upgrade15 = carTable["Upgrade15"]
                    local Upgrade16 = carTable["Upgrade16"]
                    local Besch = carTable["Beschlagnahmt"]
                    local Paintjob = carTable["Paintjob"]
                    local color1 = carTable["color1"]
                    local color2 = carTable["color2"]
                    local color3 = carTable["color3"]
                    local color4 = carTable["color4"]
                    local tank = carTable["Tank"]
                    local dist = carTable["Distanz"]
                    local health = carTable["Leben"]
                    local lc1 = carTable["lc1"]
                    local lc2 = carTable["lc2"]
                    local lc3 = carTable["lc3"]
                    local slot = carTable["faccarid"]
                    _G["Fraktionsauto"..Besitzer..slot] = createVehicle(Modell, Spawn_X, Spawn_Y, Spawn_Z, Spawn_RX, Spawn_RY, Spawn_RZ, Besitzer)
                    local veh = _G["Fraktionsauto"..Besitzer..slot]
                    setVehicleRotation ( veh, Spawn_RX, Spawn_RY, Spawn_RZ )
                    setVehicleColor(veh, color1, color2, color3, color4)
                    setVehicleHeadLightColor(veh, lc1, lc2, lc3)
                    setVehiclePaintjob(veh, Paintjob)
                    setElementHealth(veh, health)
                    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, "Tank", tank)
                    setElementData(veh, "Distanz", dist)
                    setElementData(veh, "Besitzer", Besitzer)
                    setElementData(veh, "faccarid", slot)
                    setElementData(veh, "ID", carTable["ID"])
                    carTable = mysql_fetch_assoc(result)
                end
            end
            mysql_free_result(result)
        end
        for i, players in pairs(getElementsByType("player")) do
            if getElementData(players, "Fraktion") == frak then
                outputChatBox("Fraktionsfahrzeuge wurden vom Leader respawnt.", players, 255, 155, 0)
            end
        end
    else
        outputChatBox("Dein Rang ist zu niedrig!", thePlayer,255,0,0)
    end
end
addCommandHandler("frsp", respawnFraktCars)
addEvent("respawnFraktCars", true)
addEventHandler("respawnFraktCars", getRootElement(), respawnFraktCars)