Find, Optionally Email and Optionally Delete Inactive Members

This hack is designed to allow you to:

a) Find users who have not logged in to your board in X days. X is configurable by you in the control panel.

b) Email the inactive users. When the email is set, the date is recorded so that you will not email them again within X days

c) Delete the inactive users. This can happen in two ways:
1) If you don't have email users set, it will simply delete users who have not logged in to your forums in the past X days.
2) If you have emails turned on, it will delete users who have not logged in during the past X days AND who were sent the warning email more than 15 days before.

The email is a template configurable by you.

Here is how this hack will behave:

If you have email on and delete off, it will email inactive users every X days.

If you have email on and delete on, it will email a warning then delete 15 days later.

If you have emails off and delete on, it will delete users who have been incactive for X days.

If you have email off and delete off, it will list the inactive users for you in a very crude plain text list.

This is not a hack for newbies. If you don't know how to run Queries, don't touch this hack. It is still In Beta. If I get bored and ambitious, I will write an install script and make it idiot-proof.

Screen Shots to Follow

I will Support this hack for users with some hacking experience. I will fix bugs. I will not teach hacking basics though.

!Important - After You Install the hack, go to your Control Panel and Set the Options! Otherwise it will NOT work.

[amykhar]

No prob djr. I shall get right on it and be back with a fix.

Amy

[amykhar]

updated the zip. All you need to do is upload the php file again.

I recommend renaming this script to something else on your server for security reasons. I haven't been able to find a way to pass in the username and password for a cron job to be able to run this in the admin folder yet.

[djr]

Hi amy,

The hack gets better and better! Thank you VERY MUCH for implementing all my feat reqs.
I have (what's new) another one Because most of the forum-admins will run this script as cronjob, it's probably nicer to have the output how many users (and optionally which usernames) are deleted emailed to the admin. If there's no pruning done, have the script e-mail that, so we know it's up and running and doin' its (very good) job!

If somebody can be of help to Amy for dealing with potentially security risks, please don't hesitate! In the meantime i've renamed the script to something insignificant

Thanks again!
- djr

[amykhar]

The email is a good idea. I will do it tomorrow cause I'm working on somebody else's hack right now.

Amy

[amykhar]

OK. I just updated the zip file. The program now emails the webmaster email with information about members who were emailed or deleted.

To update: You will need to add the two new templates and reupload the zip file.

Within the templates, you have access to counts telling how many inactive members there are, how many were emailed, how many were deleted, and list the emailed or deleted members.

Amy

[djr]

Hi Amy,

I forgot to say thank you for all that you've added to the hack. Major thumbs up for making this an excellent hack for the very hard needed forum maintenance a.k.a spring cleaning

I love everything about this hack. The fact it's fully automated via cron, the fact it keeps us webmasters notified of its duty and the fact that I feel assured that no redundant user info is left behind in the db!

This is definitely in my Top 10 list of favourite hacks!

- djr

[amykhar]

Thank you, djr

Amy

[hypedave]

So bascially, If I set it to 30 Days, then it will look users that havent been active in 30 Days send them an email warning, then in 15 days if that person hasn't logged on then their account will be automatically deleted.

[amykhar]

Yes Dave - if you have both email and delete turned on, that's how it will work.

Amy

[hypedave]

Is there a way to exempt posters with XX amount of posts?

Some users may have like 100 post, and get real busy with school and can't log on for like 2 months.

That would be a nice add-on