[SQL] Help me please. - 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: [SQL] Help me please. (/showthread.php?tid=606880)

---

[SQL] Help me please. - Nicholas999 - 10.05.2016

[SQL] The account is inactive. More than 30 days. I want to remove it.
- Example Accounts (A),(B),©,(D) Lastonline since 10/4/2016 to present 11/5/2016.
- I want to delete this accounts (A),(B),©,(D) automatically.
- Or other accounts that are inactive for more than 30 days.
[SQL] The account is inactive. More than 3 days. I want to set it.
- Example Accounts (A) = PlayerInfo[playerid][pLeader] == 1; (Inactive more than 3 Day)
- To change Accounts (A) = PlayerInfo[playerid][pLeader] == 0;

----------------------------------------------
I am a native of Thailand. Not proficient in English.
Sorry if do not print correctly.

---

Re: [SQL] Help me please. - F1N4L - 10.05.2016

Use IF + gettime()

---

Re: [SQL] Help me please. - Nicholas999 - 10.05.2016

Do you have code samples.

---

Re: [SQL] Help me please. - Konstantinos - 10.05.2016

If you use mysql, the best way to go is: https://sampforum.blast.hk/showthread.php?tid=546630

---

Re: [SQL] Help me please. - F1N4L - 10.05.2016

Creates a column where you insert an integer value, in this case: GetTime.
Every time the player LOGIN to your account automatically sets this column to:
30 * 24 * 60 * 60 + gettime()

Correct me if I'm wrong, I think so be 30 days.

---