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.

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

Configuring the Options is easy:

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

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

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

great hack !! thx

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?

heh great, a hack i've always wanted

/me licks install

Does it use some kind of cron?