GTAONLINE.PL :: premka czasowa

function setPremiumDay(plr,days) if getPremiumDate(plr) then local queryA=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(premiumdate) + INTERVAL %d DAY WHERE id=%d",days,getElementData(plr,"player:sid"))) return end local queryA=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(curdate()) + INTERVAL %d DAY WHERE id=%d",days,getElementData(plr,"player:sid"))) end function getPremiumDate(plr) local queryA=exports['pystories-db']:dbGet("SELECT * FROM pystories_users WHERE id=? AND premiumdate>NOW() LIMIT 1", getElementData(plr,"player:sid")) if (queryA and #queryA > 0) then return queryA[1].premiumdate end return false end

"serigorro" napisał/a:

"killercycDDS" napisał/a:

Witam g?owie si? i g?owie jak zrobi? by premka by?a czasowa to znaczy chodzi mi o to ?e jak kto? w danej chwili kupi czyli 25.08.2019 10:12 to ma preme na tyle ile kupi? i do tego odpowiednia godzina w strukturze db zmieni?em typ z date na timestamp i gdy np kupi? premk? nadaje wszystko ?adnie lecz nie ma odpowiedniej godziny
kod


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

function getPremiumDate(plr)
    local queryA=exports['pystories-db']:dbGet("SELECT * FROM pystories_users WHERE id=? AND premiumdate>NOW() LIMIT 1", getElementData(plr,"player:sid"))
    if (queryA and #queryA > 0) then
        return queryA[1].premiumdate
    end
    return false    
end

U?yj datetime.

nic to nie da bo w kodzie kt?ry poda?em nie jest to zdefiniowane i nie mam pomys?u jak zdefiniowa?

[ Dodano: 2019-08-26, 14:36 ]
obecnie zrobi?em co? takiego


function setPremiumDay(plr,days,hours,minutes)
    if getPremiumDate(plr) then
    local queryA=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(premiumdate) + INTERVAL %d DAY WHERE id=%d",days,getElementData(plr,"player:sid")))
    local queryB=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(premiumdate) + INTERVAL %d HOUR WHERE id=%d",hours,getElementData(plr,"player:sid")))
    local queryC=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(premiumdate) + INTERVAL %d MINUTE WHERE id=%d",minutes,getElementData(plr,"player:sid")))
    return end
    local queryA=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(curdate()) + INTERVAL %d DAY WHERE id=%d",days,getElementData(plr,"player:sid")))
    local queryB=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(curtime()) + INTERVAL %d HOUR WHERE id=%d",hours,getElementData(plr,"player:sid")))     
    local queryC=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(curtime()) + INTERVAL %d MINUTE WHERE id=%d",minutes,getElementData(plr,"player:sid"))) 
end

function getPremiumDate(plr)
    local queryA=exports['pystories-db']:dbGet("SELECT * FROM pystories_users WHERE id=? AND premiumdate>NOW() LIMIT 1", getElementData(plr,"player:sid"))
    if (queryA and #queryA > 0) then
        return queryA[1].premiumdate
    end
    local queryB=exports['pystories-db']:dbGet("SELECT * FROM pystories_users WHERE id=? AND premiumdate>NOW() LIMIT 2", getElementData(plr,"player:sid"))
    if (queryB and #queryB > 0) then
        return queryB[1].premiumdate
    end
    local queryC=exports['pystories-db']:dbGet("SELECT * FROM pystories_users WHERE id=? AND premiumdate>NOW() LIMIT 3", getElementData(plr,"player:sid"))
    if (queryC and #queryC > 0) then
        return queryC[1].premiumdate
    end
    return false    
end

local queryB=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(premiumdate) + INTERVAL %d HOUR WHERE id=%d",hours,getElementData(plr,"player:sid")))

local queryB=exports['pystories-db']:dbSet(string.format("UPDATE pystories_users SET premiumdate = DATE(premiumdate) + INTERVAL %d HOUR WHERE id=%d",tonumber(hours),getElementData(plr,"player:sid"))