0

(I want to make free subscription area where members' info is deleted from mysql when 30 days old)

I already have have a members login script.... but i have to manually delete users.....what i really need is to know how to make member expire after so many days with a php script. (free or very cheap) :eek:

6
Contributors
6
Replies
7
Views
12 Years
Discussion Span
Last Post by almostbob
Featured Replies
  • 1

    If you're going to get technical, it's actually 5.20833 years old which makes hashinclude's number more accurate. Either way, there was no need to reply. Considering the OP only posted 5 times within less than a month of joining, they probably have completely forgotten about this post/thread. Read More

  • on login update lastlogin with sql now() the timestamp of now [code=mysql]delete low_priority from table where last_login < (now() - 2592000 ) order by last_login limit 100[/code]2592000seconds=30 days limit 100 to make sure no timeout and because a limit is usefull where there may be 10000000 members low priority to … Read More

-4

(I want to make free subscription area where members' info is deleted from mysql when 30 days old)

I already have have a members login script.... but i have to manually delete users.....what i really need is to know how to make member expire after so many days with a php script. (free or very cheap) :eek:

Hello, I can do it for you or if you are PHP programmer can explain how to do :)

Regards

1

Arsench, you do realize this thread is 5 years old don't you ?!

Edited by hashinclude: n/a

-2

Arsench, you do realize this thread is 5 years old don't you ?!

No, 5.5 years old and you ?

1

If you're going to get technical, it's actually 5.20833 years old which makes hashinclude's number more accurate.

Either way, there was no need to reply. Considering the OP only posted 5 times within less than a month of joining, they probably have completely forgotten about this post/thread.

Edited by Fbody: n/a

1

on login update lastlogin with sql now() the timestamp of now

delete low_priority from table where last_login < (now() - 2592000 ) order by last_login limit 100

2592000seconds=30 days
limit 100 to make sure no timeout and because a limit is usefull where there may be 10000000 members
low priority to ensure the login page the code is embedded in presents without delay

Edited by almostbob: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.