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.

[wolfe]

ok will test it out but will back up user table first lol

[wolfe]

why don't you intergrate this page into the AdminCP before it is a Full Release

[amykhar]

Because it is designed to run as a cron script and adding more code just adds more opportunities for installers to screw up.

If you really don't know how to do that on your own, I will post the code here as an addon.

Amy

[TheEDIGuy]

I have it cron'ed and it works perfectly. One of the best hacks I've got installed.

Thanks again, Amy!

[amykhar]

No problem Glad you like it.

Amy

[hypedave]

Hey Amy,
I have a couple of users on my forum, that will be going on a vacation and will be gone for a uncertain amount of time, so I was wondering if possible is there a way to have to hack exclude user certain user groups, like if a member is going a vacation I can drop her of her im a different user group, or put in an option where this hackl will exclude user id's ?

Thanks

[amykhar]

Hmmm, what about installing the "away" hack and then changing the query in manageInactive.php to

$userArray=$DB_site->query("SELECT username,userid,email,adminemail,emailDate FROM user WHERE lastactivity<$cutoffdate and emailDate<$dateCut and away==0 ORDER BY username");

This would exclude anybody who set themself as away.

[Yuber]

Great hack thanks.

[SmartGnome]

Hi Amy,

Great hack and it takes a lot of work out of my hands.

Djr didn't ask yet for a mod so I will do that.
We have a lot of leechers in the board (0-posters) so it should be nice to take them in the same sesion to warn them and delete or move them to a banned group. (I prefer the last).

Again thanks for the good work and install is clicked :banana:

Greetzz

[iggy123]

is there anyway of setting this hack up so that it does include people in a certain usergroup ie admins / moderators