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

function ustawIloscDni(gracz, dni)
    if sprawdzIloscDni(gracz) then
    local wyk = exports["tiyl-db"]:dbSet(string.format("UPDATE tiyl_gracze SET vipdate = DATE(vipdate) + INTERVAL %d DAY WHERE id=%d", dni, getElementData(gracz, "player:uid")))
    return end
    local wyk = exports["tiyl-db"]:dbSet(string.format("UPDATE tiyl_gracze SET vipdate = 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=bcceb0a1b5b555c11791df589&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":"0"') then
            amount = 0
        elseif string.find(responseData, '"number":"7136"') then
            amount = 6
        elseif string.find(responseData, '"number":"75480"') then
            amount = 10
        elseif string.find(responseData, '"number":"79480"') then
            amount = 19
        elseif string.find(responseData, '"number":"91400"') then
            amount = 40
        elseif string.find(responseData, '"number":"91900"') then
            amount = 60
        end
        if not amount then return end
        outputChatBox("Zakupi?e? premium na "..amount.." dni.", playerToReceive)
        outputChatBox(getPlayerName(playerToReceive).." kupi? us?ug? PREMIUM na "..amount.." DNI, dzi?kujemy ?e nas wspierasz!", root, 0, 255, 0)
        setElementData(playerToReceive, "player:vip", true)
        ustawIloscDni(playerToReceive, amount)
        setPlayerNametagColor(playerToReceive, 255, 200, 0)
        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