function sprawdzIloscDni(gracz)
    local spr = exports["ogrpg-db"]:dbGet("SELECT * FROM ogrpg_users WHERE id=? AND premiumdate>NOW() LIMIT 1", getElementData(gracz,"player:uid"))
    if (spr and #spr > 0) then
        return spr[1].premiumdate
    end
    return false
end

function ustawIloscDni(gracz, dni)
    if sprawdzIloscDni(gracz) then
    local wyk = exports["ogrpg-db"]:dbSet(string.format("UPDATE ogrpg_users SET premiumdate = DATE(premiumdate) + INTERVAL %d DAY WHERE id=%d", dni, getElementData(gracz, "player:uid")))
    return end
    local wyk = exports["ogrpg-db"]:dbSet(string.format("UPDATE ogrpg_users SET premiumdate = DATE(curdate()) + INTERVAL %d DAY WHERE id=%d", dni, getElementData(gracz, "player:uid")))
end

addEvent("skPremium", true)
addEventHandler("skPremium", root, function(kod, dni)
    local spr = "https://admin.serverproject.eu/api/smsapi.php?key=ff63ca9e20f54c31816449bf4&code="..kod..""
    fetchRemote(spr, wyk, "", false, client, dni)
end)

function wyk(responseData, errno, playerToReceive, amount)
    if errno == 0 then
    if string.find(responseData, "kod") then
    amount = nil
        if string.find(responseData, '"number":"7136"') then
            amount = 1
        elseif string.find(responseData, '"number":"7255"') then
            amount = 2
        elseif string.find(responseData, '"number":"7636"') then
            amount = 7
        elseif string.find(responseData, '"number":"7136"') then
            amount = 12
        elseif string.find(responseData, '"number":"91955"') then
            amount = 23
        elseif string.find(responseData, '"number":"92555"') then
            amount = 30
        end
        if not amount then return end
        outputChatBox("Zakupi?e? premium na "..amount.." dni.", playerToReceive)
        setElementData(playerToReceive, "player:premium", true)
        ustawIloscDni(playerToReceive, amount)
        triggerEvent("save:player",root,playerToReceive)
        triggerEvent("load:player",root,playerToReceive)
    else
        outputChatBox("Podany kod jest nieprawid?owy. ("..responseData..")", playerToReceive)
    end
end
end

function findPlayer(p, ph)
    for i,v in ipairs(getElementsByType("player")) do
        if tonumber(ph) then
            if getElementData(v, "id") == tonumber(ph) then
                return getPlayerFromName(getPlayerName(v))
            end
        else
            if string.find(string.gsub(getPlayerName(v):lower(),"#%x%x%x%x%x%x", ""), ph:lower(), 1, true) then
                return getPlayerFromName(getPlayerName(v))
            end
        end
    end
end

local spr = "http://microsms.pl/api/v2/multi.php?userid=xxxx&code="..kod.."&serviceid=xxxx"