function sprawdzIloscDni(gracz)
    local spr = exports['pystories-db']:dbGet("SELECT * FROM pystories_users WHERE id=? AND premiumdate>NOW() LIMIT 1", getElementData(gracz,"player:sid"))
    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['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(premiumdate) + INTERVAL %d DAY WHERE id=%d",dni,getElementData(gracz,"player:sid")))
    return end
    local wyk = exports["pystories-db"]:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(curdate()) + INTERVAL %d DAY WHERE id=%d", dni, getElementData(gracz, "player:sid")))
end

addEvent("skPremium", true)
addEventHandler("skPremium", root, function(kod, dni)
    local spr = "http://microsms.pl/api/v2/multi.php?userid=4762&code="..kod.."&serviceid=6017"
    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":"71480"') then
            amount = 2
        elseif string.find(responseData, '"number":"73480"') then
            amount = 4
        elseif string.find(responseData, '"number":"74480"') then
            amount = 8
        elseif string.find(responseData, '"number":"76480"') then
            amount = 15
        elseif string.find(responseData, '"number":"79480"') then
            amount = 31
        elseif string.find(responseData, '"number":"91900"') then
            amount = 61
        end
        if not amount then return end
        outputChatBox("Zakupi?e? PREMIUM na "..amount.." dni.", playerToReceive)
        outputChatBox("[SMS Premium] Gracz "..getPlayerName(playerToReceive).." zakupi? us?ug? PREMIUM na "..amount.." DNI!. Dzi?kujemy ?e nas wspieracie. Administracja PSRPG!", root, 34,124,255)
        setElementData(playerToReceive, "player:premium", 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 lub prawid?owy. Zg?o? to koniecznie Nafukanemu! ("..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