(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 ?!
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.
How WOULD you do it anyway? I am intrigued, enlighten me, Arsench :)
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 1002592000seconds=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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.