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]

You can either run it manually or set up a cron job. I recommend cron but explaining how to set that part up is beyond the scope of this hack because it is different on different web hosts.

Amy

[amykhar]

BTW, if you run it manually, make SURE you install the new templates on the style that you typically use to browse. Otherwise, you will send out blank emails.

[diettalk]

When the user gets deleted.. the posts are removed too?

[amykhar]

Originally posted by diettalk
When the user gets deleted.. the posts are removed too?

No. They are not.

Amy

[tkeil69575]

hi amy,
thank you for this great hack

i have a couple of questions. the variable $daysInactive in the inactiveEmailMessage template doesnt seem to be working. its not including the number of days inactive in the email.

Is it correct the in the colum emailDate in the user table all values are "127" ? and that they dont change when users are emailed? I have a feeling there should be a unix timestamp in there? or is that the 15 days value?

thanks for your help
tina

[amykhar]

Originally posted by tkeil69575
hi amy,
thank you for this great hack

i have a couple of questions. the variable $daysInactive in the inactiveEmailMessage template doesnt seem to be working. its not including the number of days inactive in the email.

Is it correct the in the colum emailDate in the user table all values are "127" ? and that they dont change when users are emailed? I have a feeling there should be a unix timestamp in there? or is that the 15 days value?

thanks for your help
tina

You caught a glitch in the install instructions. Change the emailDate to Int instead of TinyInt and it should fix that problem.

Regarding the $daysInactive, it worked for me. I will look into it.

I have updated the zip file reflecting the query change.

[tkeil69575]

great stuff - thanks amy

[amykhar]

Found the problem. In the message template, change daysInactive to inactiveDays. That should do it.

[tkeil69575]

yep that did it - working great now - thanks

[amykhar]

No prob. Thanks for helping to test it.

Amy