Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement