local obiekt = {}

function getVehicleLicense(plr, type)
    if getElementData(plr,"player:license:pj"..type.."") ~= 1 then
        outputChatBox("✘#ffffff Nie posiadasz prawa jazdy kategorii "..type.."", plr, 255, 0, 0, true)
        return true
    end

    local result = exports["pystories-db"]:dbGet("SELECT * FROM pystories_punish WHERE serial=? AND type=? AND active=1 AND time>NOW()", getPlayerSerial(plr), tostring(type))
    if result and #result > 0 then
            v = result[1]
            outputChatBox("✘#ffffff Posiadasz zawieszone prawo jazdy do "..v.time.." za "..v.reason, plr, 255, 0, 0, true)
        return true
    else
            exports["pystories-db"]:dbSet("DELETE FROM pystories_punish WHERE serial=? AND type=? AND active=1 AND time<NOW()", getPlayerSerial(plr), tostring(type))
        return false
    end
end

function convertNumber ( number )  
    local formatted = number  
    while true do      
        formatted, k = string.gsub(formatted, "^(-?%d+)(%d%d%d)", '%1,%2')    
        if ( k==0 ) then      
            break   
        end  
    end  
    return formatted
end

addEvent("givePlayerMoney", true)
addEventHandler("givePlayerMoney", root, function(value,value2,isjob)
    if not tonumber(value) then return end
    if not getElementData(source,"player:sid") then return end
    if not isjob then isjob = false end
    local give = givePlayerMoney(source,value)
    if give or isjob == true then
        if not getElementData(source, "player:job") then return end
            if value2 > 0 then
                local actualSRP = getElementData(source, "player:srp") or 0
                outputChatBox("#0BFF00&#10003; "..convertNumber(value).." PLN#ffffff zosta?o dodane na twoje konto (#0BFF00+"..convertNumber(value2).."#ffffff SRP).", source, 0, 255, 0, true)
                setElementData(source, "player:srp", actualSRP+value2)
            else
                outputChatBox("#0BFF00&#10003; "..convertNumber(value).." PLN#ffffff zosta?o dodane na twoje konto.", source, 0, 255, 0, true)
            end
    end
end)

addEvent("givePlayerBankMoney", true)
addEventHandler("givePlayerBankMoney", root, function(value,value2,isjob)
    if not tonumber(value) then return end
    if not isjob then isjob = false end
    local player_sid = getElementData(source, "player:sid")
    if player_sid then
    local give = exports["DB2"]:zapytanie("UPDATE pystories_users SET bank_money=bank_money+"..(tonumber(value) or 0).." WHERE id="..tonumber(player_sid).." LIMIT 1")
        if give or isjob == true then
            if not getElementData(source, "player:job") then return end
                if value2 > 0 then
                    local actualSRP = getElementData(source, "player:srp") or 0
                    outputChatBox("#0BFF00&#10003; "..convertNumber(value).." PLN#ffffff zosta?o dodane na twoje konto (#0BFF00+"..convertNumber(value2).."#ffffff SRP).", source, 0, 255, 0, true)
                    setElementData(source, "player:srp", actualSRP+value2)
                else
                    outputChatBox("#0BFF00&#10003; "..convertNumber(value).." PLN#ffffff zosta?o dodane na twoje konto.", source, 0, 255, 0, true)
                end
            end
    end
end)

addEvent("takePlayerBankMoney", true)
addEventHandler("takePlayerBankMoney", root, function(value,value2)
    if not tonumber(value) then return end
    local player_sid = getElementData(source, "player:sid")
    if player_sid then
    local give = exports["DB2"]:zapytanie("UPDATE pystories_users SET bank_money=bank_money-"..(tonumber(value) or 0).." WHERE id="..tonumber(player_sid).." LIMIT 1")
        if give then
        end
    end
end)

addEvent("takePlayerMoney", true)
addEventHandler("takePlayerMoney", root, function(how)
    if not getElementData(source,"player:sid") then return end
    if not tonumber(how) then return end
    print( getPlayerMoney(source) );
    local take = takePlayerMoney(source,how);
    if take then
    end
end)

addEvent("destroyVehicle", true)
addEventHandler("destroyVehicle", root, function(veh)
    if not veh then return end

    if isElement(veh) then
        destroyElement(veh)
    end
    if obiekt[veh] then 
        destroyElement(obiekt[veh])
    end
end)

addEvent("removeObject", true)
addEventHandler("removeObject", root, function(veh,code)
    if obiekt[veh] then
        destroyElement(obiekt[veh])
    end
end)

addEvent("addObject", true)
addEventHandler("addObject", root, function(veh,code)
    if code == "kamieniolom" then
        obiekt[veh]=createObject(3929, 0, 0, 0)
        setObjectScale(obiekt[veh], 3.5)
        attachElements(obiekt[veh], veh, 0, -2, 1, 90)
    end
end)

addEventHandler ( "onPlayerVehicleEnter", root, function(v,s,j)
if getElementData(v,"vehicle:fuel") == false then
setElementData(v,"vehicle:fuel",100)
end
end)