--s-side
local vehicles = {}
SQL = exports.ak_database
function restartPlayerCars(player, typec)
    local UID = getElementData(player, "player:uid")
    local q1 = SQL:query("SELECT * FROM ak_vehicles WHERE Owner=?", UID)
    for i,v in pairs(q1) do
        vehicles[i] = {v.VID, v.Model}
    end
    if typec == true then
        triggerClientEvent("giveAkinaCars", root, vehicles)
    elseif typec == false then
        triggerClientEvent("onRestartPlayerCars", root, vehicles)
    end
end

addEvent("getAkinaCars", true)
addEventHandler("getAkinaCars", root, function()
    restartPlayerCars(client, true)
end)
addEvent("onGarageSellCar", true)
addEventHandler("onGarageSellCar", root, function(vid)
    local UID = getElementData(client, "player:uid")
    local q1 = SQL:query("SELECT * FROM ak_vehicles WHERE Owner=?", UID)
    if #q1 > 1 then
        SQL:query("DELETE FROM `ak_vehicles` WHERE VID=?", vid)
        restartPlayerCars(client, false)
    else
        outputChatBox("To jest twoje jedyne auto!")
    end
end)

addEvent("exitGarage", true)
addEventHandler("exitGarage", root, function()
    setElementPosition(client, -1824.88696, 104.85914, 15.11719)
    setCameraTarget(client)
end)
addEvent("spawnPlayerWithCar", true)
addEventHandler("spawnPlayerWithCar", root, function(vid)
    local q1 = SQL:query("SELECT * FROM ak_vehicles WHERE VID=?", vid)
    local car = createVehicle(q1[1]["Model"], -1824.88696, 104.85914, 15.11719)
    warpPedIntoVehicle(client, car)
    setCameraTarget(client)
    setElementData(car, "vehicle:vid", vid)
end)
addCommandHandler("garage", function(player)
    restartPlayerCars(player, false)
    triggerClientEvent("onCommandGarage", root, vehicles)
end)

--c side
local cvehicles = {}
local carName = "CAR_NAME"
local number = 1
local selectm = true
local screenW, screenH = guiGetScreenSize()
DGS = exports.ak_gui

function cvehicles.dxdraw()
    dxDrawText(carName, screenW * 0.4354, screenW * 0.4917, screenW * 0.5344, screenH * 0.5481, tocolor(255, 255, 255, 255), 5.00, "default", "left", "top", false, false, false, false, false)
end
function cvehicles.gui()
    cvehicles.window = DGS:dgsCreateWindow(0.6880, 0.2852, 0.1854, 0.3472, "", true, 0xFFFFFFFF, 0, nil, tocolor(12,12,12,255), nil, tocolor(12,12,12,255), 5, true)
    cvehicles.button1 = DGS:dgsCreateButton(0, 0, 1, 0.25, "Weź auto", true, cvehicles.window)
    cvehicles.button2 = DGS:dgsCreateButton(0, 0.249, 1, 0.25, "Tuning", true, cvehicles.window)
    cvehicles.button3 = DGS:dgsCreateButton(0, 0.497, 1, 0.25, "Sprzedaj", true, cvehicles.window)
    cvehicles.button4 = DGS:dgsCreateButton(0, 0.745, 1, 0.25, "Wyjdz z garazu", true, cvehicles.window)
end
addEvent("onAkinaPlayerLogin", true)
addEventHandler("onAkinaPlayerLogin", root, function()
    triggerServerEvent("getAkinaCars", localPlayer)
end)
function spawnPlayerCars(vehicles)
    for i,v in pairs(vehicles) do
        cvehicles[i] = {vehicles[i][1], vehicles[i][2]}
    end
end

addEvent("giveAkinaCars", true)
addEventHandler("giveAkinaCars", root, function(vehicles)
    addEventHandler("onClientRender", root, cvehicles.dxdraw)
    car = createVehicle(vehicles[1][2],  -1231.15283, 456.97937, 7.18750, 0,0,90)
    carName = getVehicleNameFromModel(vehicles[1][2])
    setCameraMatrix(-1231.15283-10, 456.97937, 7.18750)
    ped = createPed(getElementModel(localPlayer), -1231.15283, 454.97937, 7.18750, 90)
    cvehicles.gui()
    showCursor(true)
    setPedAnimation(ped, "DANCING", "dnce_m_b")
    spawnPlayerCars(vehicles)
end)
bindKey("arrow_l", "down", function()
    if selectm == true then
        destroyElement(car)
        number = number - 1
        if number < 1 then
            number = #cvehicles
        end
        car = createVehicle(cvehicles[number][2], -1231.15283, 456.97937, 7.18750, 0,0,90)
        carName = getVehicleNameFromModel(cvehicles[number][2])
    end
end)
bindKey("arrow_r", "down", function()
    if selectm == true then
        destroyElement(car)
        number = number + 1
        if number > #cvehicles then
            number = 1
        end
        car = createVehicle(cvehicles[number][2], -1231.15283, 456.97937, 7.18750, 0,0,90)
        carName = getVehicleNameFromModel(cvehicles[number][2])
    end
end)

addEventHandler("onDgsMouseClick", root, function()
    if source == cvehicles.button1 then
        destroyElement(car)
        destroyElement(ped)
        selectm = false
        DGS:dgsSetVisible(cvehicles.window, false)
        removeEventHandler("onClientRender", root, cvehicles.dxdraw)
        showCursor(false)
        local vid = cvehicles[number][1]
        triggerServerEvent("spawnPlayerWithCar", localPlayer, vid)
    elseif source == cvehicles.button3 then
        local vid = cvehicles[number][1]
        triggerServerEvent("onGarageSellCar", localPlayer, vid)
    elseif source == cvehicles.button4 then
        destroyElement(car)
        destroyElement(ped)
        selectm = false
        DGS:dgsSetVisible(cvehicles.window, false)
        removeEventHandler("onClientRender", root, cvehicles.dxdraw)
        showCursor(false)
        triggerServerEvent("exitGarage", localPlayer)
    end
end)

addEvent("onRestartPlayerCars", true)
addEventHandler("onRestartPlayerCars", root, function(vehicles)
    spawnPlayerCars(vehicles)
    destroyElement(car)
end)

addEvent("onCommandGarage", true)
addEventHandler("onCommandGarage", root, function(vehicles)
    destroyElement(car)
    destroyElement(ped)
    addEventHandler("onClientRender", root, cvehicles.dxdraw)
    DGS:dgsSetVisible(cvehicles.window, false)
    car = createVehicle(vehicles[1][2],  -1231.15283, 456.97937, 7.18750, 0,0,90)
    carName = getVehicleNameFromModel(vehicles[1][2])
    setCameraMatrix(-1231.15283-10, 456.97937, 7.18750)
    ped = createPed(getElementModel(localPlayer), -1231.15283, 454.97937, 7.18750, 90)
    cvehicles.gui()
    showCursor(true)
    setPedAnimation(ped, "DANCING", "dnce_m_b")
    spawnPlayerCars(vehicles)
end)