-- Od?wie?anie tabeli
function refreshingb(client)
    -- Pobieramy UID gracza
    local uid=getElementData(client,"player:uid")
    if not uid then return end

end

local categoryL={592,553,577,488,511,497,548,563,512,476,593,447,425,519,520,460,417,469,487,513}

-- Kod s?u??cy od sprawdzania prawa jazdy
function getVehicleLicense(plr,type)
local qr = exports['ogrpg-db']:dbGet("SELECT * FROM ogrpg_users WHERE id AND pjL=?", id, "0")
if #qr == 1 then outputChatBox("Nie Posiadasz Licencji na Drony!", source, 255, 255, 255) return end
        query=string.format("SELECT * FROM ogrpg_punish WHERE type=%q AND active=1 AND serial=%q AND time>NOW() LIMIT 1","L", getPlayerSerial(target))
        local result=exports["ogrpg-db"]:pobierzWyniki(query)
        if (result) then
            cancelEvent()
            outputChatBox("* Posiadasz zawieszon? Licencje do "..result["time"]..", za: "..result["reason"], plr, 255, 0, 0)
        else
            exports["ogrpg-db"]:dbSet("DELETE FROM ogrpg_punish WHERE type=? AND active=1 AND serial=?", "L", getPlayerSerial(plr))
        end
    end

     if getElementData(plr,"player:license:pjL") ~= 1 then
        outputChatBox("* Aby tu pracowa? musisz mie? licencj? na Drony!!", plr, 255, 0, 0)
        return

local marker2=createMarker(-2050.29,-106.16,35.24,"corona",2,170,200,0)

addEventHandler("onMarkerHit", marker2, function(el,md)
 setElementPosition(el,-2044.69,-94.57,35.17 )
end) 

addEvent("license:do",true)
addEventHandler("license:do", resourceRoot, function(cost,selected)
    if tonumber(cost) <= getPlayerMoney(client) then
        takePlayerMoney(client,cost)
    end

    local veh=nil
    if selected == "A" then veh=createVehicle(586, 160.04, -168.15, 1.24, 359.5, 360.0, 87.3)
    elseif selected == "B" then veh=createVehicle(436,160.04, -168.15, 1.24, 359.5, 360.0, 87.3 )
    elseif selected == "C" then veh=createVehicle(482, 160.04, -168.15, 1.24, 359.5, 360.0, 87.3) 
    elseif selected == "Dron" then veh=createVehicle(511, 428.86, 2495.59, 17.10, 3.1, 359.8, 80.3) end
    if not veh then return end
    if selected == "Dron" then
    setElementData(veh,"vehicle:desc","Egzamin Licencji Lotniczej\nKategoria "..selected)
    else
    setElementData(veh,"vehicle:desc","Egzamin prawa jazdy\nKategoria "..selected)
    end
    setElementData(veh,"vehicle:mileage",16442)
    setElementData(veh,"vehicle:fuel",100)
    setElementData(veh,"vehicle:lic",true)

    setElementDimension(client,0)
    setElementInterior(client,0)
    warpPedIntoVehicle(client,veh)
    triggerClientEvent(client, "license:start", resourceRoot, selected, veh)

    outputChatBox("", root, 255, 0, 0)
end)

addEvent("license:vehdel", true)
addEventHandler("license:vehdel", resourceRoot, function(veh)
    destroyElement(veh)
end)

addEventHandler("onPlayerQuit", root, function()
    local veh=getPedOccupiedVehicle(source)
    if not veh then return end
    if getVehicleController(veh) ~= source then return end
    if not getElementData(veh,"vehicle:lic") then return end
    destroyElement(veh)
end)

addEventHandler("onVehicleDamage", resourceRoot, function(loss)
    local kierowca=getVehicleController(source)
    if not kierowca then return end
    if not getElementData(source,"vehicle:lic") then return end
    destroyElement(source)
    outputChatBox("* Uszkodzi?e?(a?) pojazd, nie zdajesz egzaminu! :c", kierowca, 255, 0, 0)
    triggerClientEvent(kierowca, "license:finish", resourceRoot, true)
end)

addEventHandler("onVehicleStartExit", resourceRoot, function()
    cancelEvent()
end)

    if licenseTarget < #categoryPositions[licenseCategory] then