Advertisement
Guest User

Untitled

a guest
Oct 16th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. function getPremiumDate(plr)
  2. local queryA=exports['ogrpg-db']:dbGet("SELECT * FROM ogrpg_users WHERE id=? AND premiumdate>NOW() LIMIT 1", getElementData(plr,"player:uid"))
  3. if (queryA and #queryA > 0) then
  4. return queryA[1].premiumdate
  5. end
  6. return false
  7. end
  8.  
  9. function setPremiumDay(plr,days)
  10. if getPremiumDate(plr) then
  11. 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")))
  12. return end
  13. 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")))
  14. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement