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.

[hypedave]

Today at 01:35 PM iggy123 said this in Post #80
is there anyway of setting this hack up so that it does include people in a certain usergroup ie admins / moderators

Yeah that will be like a nice add on, I have users that take vacations, so it would be nice to place them in a temporary vacation group, and have that group id be un touch by this hack, what ya think Amy?

[amykhar]

it would be cake for you to adjust the query. Just change the "WHERE lastactivity<$cutoffdate and emailDate<$dateCut" to "WHERE lastactivity<$cutoffdate and emailDate<$dateCut and usergroupid != X"

With X being the usergroup you want to exclude.

Amy

[iggy123]

Today at 07:49 PM amykhar said this in Post #82
it would be cake for you to adjust the query. Just change the "WHERE lastactivity<$cutoffdate and emailDate<$dateCut" to "WHERE lastactivity<$cutoffdate and emailDate<$dateCut and usergroupid != X"

With X being the usergroup you want to exclude.

Amy

if i were to alter it too

"WHERE lastactivity<$cutoffdate and emailDate<$dateCut and usergroupid != X and usergroupid! = Y"
would it include both the groups?

[iggy123]

$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. [/B]

shouldnt that be

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

Sorry if i am wrong but i don't know much php etc and it just looked incorrect.

[amykhar]

Yes, iggy. You caught a typo. Thanks.

Amy

[hypedave]

also would there be away to get a report of what user accounts are in the process of being deleted if they dont log back on after the notification email?

[amykhar]

I thought this one emailed the admins? Don't remember and am too lazy to scroll back up. If it doesn't find the hack that deletes members who never click the validation link and grab the email code from that.

Amy

[iggy123]

yea it does mail the admin well i got one anyhow LOL

[GaleForce]

This hack looks cool, I'm going to probably install it later. Its so tedious doing a find users by last post date, since you need to format the date in a weird way and email them individually

[Cyricx]

NM, problem fixed. User Error

Question, can we make this hack run only on a specific usergroup?

For example, registered members (usergroupid 2).