--[[
 Code write by Yolos. Permissions to use only by agree from Yolos.
]]
function getPremiumDate(plr)
    local queryA=exports['ogrpg-db']:dbGet("SELECT * FROM ogrpg_users WHERE id=? AND premiumdate>NOW() LIMIT 1", getElementData(plr,"player:uid"))
    if (queryA and #queryA > 0) then
        return queryA[1].premiumdate
    end
    return false    
end


function setPremiumDay(plr,days)
    if getPremiumDate(plr) then
    local queryA=exports['ogrpg-db']:dbSet(string.format("UPDATE ogrpg_users SET premiumdate = DATE(premiumdate) + INTERVAL %d DAY WHERE id=%d",days,getElementData(plr,"player:uid")))
    return end
    local queryA=exports['ogrpg-db']:dbSet(string.format("UPDATE ogrpg_users SET premiumdate = DATE(curdate()) + INTERVAL %d DAY WHERE id=%d",days,getElementData(plr,"player:uid")))
end


addEvent("premiumActive", true)
addEventHandler("premiumActive", root, function(code,amount)
    outputDebugString(code..":"..amount)
    local query=string.format("XXXXXXXXXXXXX", tostring(amount),code,string.format("UID:"..getElementData(client,"player:uid")))
    fetchRemote( query, result,"",false, client,amount)
end)

function result(responseData, errno, playerToReceive,amount)
    if errno == 0 then
    if string.find(responseData,"ok") then
        if tonumber(amount) == 9 then amount = 12 else amount = 30 end
        setPremiumDay(playerToReceive,amount)
        outputChatBox("Kupiono konto premium na "..amount.." dni!", playerToReceive)
        setElementData(playerToReceive,"player:premium", true)
        triggerEvent("save:player",root,playerToReceive)
        triggerEvent("load:player",root,playerToReceive)
    else
        outputChatBox("B??dny Kod ("..responseData..")", playerToReceive)
--        outputChatBox("*B??dny Kod", client)
    end
    end
end



addCommandHandler("dajvipa",function(plr,cmd,cel,dni) 
    if exports['dutyadmin']:getAdmin(plr,3) then
    if not cel then outputChatBox("/dajvipa [gracz] [dni]",plr) return end
    if not dni then outputChatBox("/dajvipa [gracz] [dni]",plr) return end
    if not tonumber(dni) then outputChatBox("/dajvipa [gracz] [dni]",plr) return end
        local target=exports["ogrpg-core"]:findPlayer(plr,cel)
        if not target then
            outputChatBox("* Nie znaleziono podanego gracza.", plr, 255, 0, 0)
            return
        end
        setPremiumDay(target,dni)
        outputChatBox("Nadano konto premium na "..dni.." dni!", plr, 255, 128, 64)
        outputChatBox("Otrzymales konto premium na "..dni.." dni!", target, 255, 128, 64)
        triggerEvent("save:player",root,target)
        triggerEvent("load:player",root,target)
    end
end)

if tonumber(amount) == 9 then amount = 12 else amount = 30 end