monthly VIP system - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: monthly VIP system (/showthread.php?tid=449981)

---

monthly VIP system - fuem1907 - 11.07.2013

Hi.
I got a VIP system.But I need a monthly check for vips.
I mean, basicly I will give you a VIP package for 90 days.

When 90 days finished, and... when you login to game, you will take this message. "your VIP time is up ! "

How can I do that?
I'm using mysql .
Thanks for helping dude.

---

Re: monthly VIP system - iJumbo - 11.07.2013

Search for DATE_ADD() Function

Just add 90 days from the given date .. then check if the current date is >= of the given date + 90 days

---

Re: monthly VIP system - fuem1907 - 11.07.2013

I don't hava Date_Add function.
Any idea ?

---

Re: monthly VIP system - iJumbo - 11.07.2013

if you have mysql. you have DATE_ADD function.. is a query function like "SELECT * FROM sometable WHERE NOW() >= DATE_ADD(GivenDate, INTERVAL 90 DAY)"

---