local vehicles = {}

function loadOneVehicle(data)
    local id = data.id

    vehicles[id] = {}
    vehicles[id].SpawnX = data.x
    vehicles[id].SpawnY = data.y
    vehicles[id].SpawnZ = data.z
    vehicles[id].Rotation = data.rot
    vehicles[id].Veh = CreateVehicle(data.vehID, data.x, data.y, data.z, 360, data.color1, data.color2, false, 0)
end

function OnGameModeInit()
    local connected = ConnectToMySQL("localhost", "root", "1234");
    if connected then
        SendQueryToMySQL("USE database");
        local data = SendQueryToMySQL("SELECT * FROM vehicles WHERE faction = 1");

        for k, v in pairs(data) do
            loadOneVehicle(v)
        end
    end
    return 1
end