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]

This shows that this hack is configured under the Options Section of your Control Panel.

[amykhar]

Configuring the Options is easy:

[Koutaru]

Great hack! I know a lot of people who are looking for this-- I'll check it out

[afterlab]

Nice. A great use for us over at FFR. Thanks greatly.

[amykhar]

Let me know how it works, OK? The email message template needs work. You should probably include the url to your board and maybe a link to the reset password form.

Amy

[empreur76]

great hack !! thx

[Tim Wheatley]

Yeah it works, needed to make some small mods etc, but it certainly works fine. Superb work.

One problem I had was with running the query to enter 68,Inactivememberoptions,68 into the settinggroupid table. I did it manually - not sure if there's a problem with your query?

[ULTIMATESSJ]

heh great, a hack i've always wanted

/me licks install

[JulianD]

Does it use some kind of cron?