[SQL] Help me please.
#1

[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.
Reply
#2

Use IF + gettime()
Reply
#3

Do you have code samples.
Reply
#4

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

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)