(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:

(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

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

Edited 6 Years Ago by hashinclude: n/a

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

No, 5.5 years old and you ?

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 6 Years Ago by Fbody: n/a

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 6 Years Ago by almostbob: n/a

This article has been dead for over six months. Start a new discussion instead.