Mini Mods - Email Reminder for inactive users

AS OF MARCH 16TH 2013 - THIS ADDON IS NO LONGER BEING UPDATED DUE TO INSUFFICIENT TIME AVAILABLE. THANK YOU ALL FOR USING THIS ADDON AND FOR YOUR SUPPORT. IF YOU OR YOU KNOW OF ANYONE THAT WOULD BE ABLE TO PICK UP WHERE I LEFT OFF ON THIS ADDON, PLEASE DO SO. I'M RELEASING THIS ADDON TO THE VBULLETIN COMMUNITY TO UPDATE AS NEEDED.
================================================== =======

What does it do?
=====================================
This mod will send out reminder emails to inactive members to encourage them to come back to your site.

I also want to give full credit and thanks to the developers of the previous versions from which this was derived:
technom8t (Email reminder for inactive users 1.0.0)
C Braithwaite and djbaxter (Email reminder for inactive users v1.2.7)
robertjandreu (Email reminder for inactive users 1.1.3)

*** See Updates section below for new feature list per release. ***

IF YOU HAVE QUESTIONS OR PROBLEMS WITH THE ADDON, PLEASE LET ME KNOW.

PLEASE DON'T FORGET TO CLICK THE INSTALLED LINK!! THANK YOU!!

Features
=====================================
* Turn product on/off.
* Set the number of days a user can be away from your site before being considered inactive. (Default: 30 days)
* Send reminder emails once and once only during any inactive period. (Default: Off)
* Edit maximum number of reminder emails sent totally.
* Set how often an reminder email is sent during an inactive period .
* Set reminder email format - TEXT or HTML.
* Set the reminder email subject. (phrased) (site must be placed in debug mode currently to edit, not translate)
* Set the reminder email body. (phrased) (site must be placed in debug mode currently to edit, not translate)
* Set the usergroups to be sent a reminder email.
* Set userids to exclude.
* Log inactive users that have been sent a reminder.

Install Instructions
--------------------------
This was written specifically for VB4. The VB3.8.x version is here.

IMPORTANT BEFORE YOU INSTALL, IF YOU HAVE A PREVIOUS VERSION INSTALLED I STRONGLY RECOMMEND THAT YOU BACK UP YOUR
CUSTOM REMINDER MESSAGE SUBJECT AND MESSAGE BODY THIS MOD WILL OVER WRITE THEM. ALSO, IN VERSION 2.x, REMINDER
MESSAGE CONTENTS HAS BEEN MOVED TO USING VBPHRASES. LOOK IN THE INSTALL.TXT FILE WITH THIS UPLOAD FOR A LIST OF
PHRASES USED IN THIS MOD.

1. Back up Custom Reminder Email Phrases that you have made.
2. Upload file in the upload folder to the forums folder on your server.
3. In your AdminCP:
a. If you've installed an older version of this mod prior to 1.1.4 you must uninstall it first as well as remove the files that came with it. I can not stress this enough.
b. Go to Plugs & Products -> Product Manager -> Add New Product.
c. Import the product xml from the zip file. (make sure to use overwrite)
4. The mod is disabled by default on install so you will need to enable it. Go to Vbulletin "Settings" -> Options -> Inactivity Reminder Emails.
5. Settings and the inactivity log viewer are also available on the left menu just above the users settings group.

History Log
=======================================
Update 2.2.1
* NEW : New plugin resets inactive members when they return to site.
* FIX : UserID field in inactivity log was showing 0, and UserID was not being added to the optout url.

UpDate 2.2.0
* CHANGE : Inactivity is now based on members Last Activity Date.
* ADD : Exporting the following additional values which can be used in reminder email templates. Check readme.txt in zip file for list of place holders.

Update 2.1.5
* CHANGE : Mod no longer has the option of adding a footer credit to the end of your website.
* CHANGE : Mod no longer has the option of adding a footer credit to outgoing emails.
* CHANGE : New Reminder Optout: Currently this is only accessable from emails being sent out.

Note: Please let members know that they may receive one more email at which time they can choose to optout/unsubscribe by clicking on the embedded link or copying/paste it into
their browser.

* FIX : Reminders were still being sent out incorrectly. I believe this is now fixed finally.
* FIX : Issues when emails were sent out had the incorrect "From" address and listed the host domain name. This should be resolved now.
* FIX : Issue regarding special characters in the usernames being added to the database has been resolve.
* NEW: New data fields have been implimented for keeping track of when reminders are sent out and how many a member has received. If you have a had this mod installed since version 1.1.4, it will look for those fields and rename them so you do not loose previous data in those fields, otherwise new fields will be added.
* NEW: I've added the ability to turn off the admin report. In this version, if it is enabled, you may receive 2 reports. One report for members that have never received a reminder and one for members who haven't received a reminder since the last reminder based on the frequencey setting in the mod settings screen.
* NEW: Reminder's sender and email address are correctly determined now. Should now reflect site name with the webmasteremail address as the reply to.
* CHANGE :Translations for 2.1.1 may not work for versions after since some templates and phrases have been removed.

Update 2.1.1 (6/24/2010) - German Translation - (Thanks Semmi)
Thanks to Semmi for translating the Admin menu, Phrases and Reminder Phrase Templates to German.

Update 2.1.1 (3/30/2010) - Bug Fix
* FIX - Removed extra where clause in query where scheduled task script was performing an update when inactive reminders where based on last post count.
* FIX - Email Phrase Templates - Changed $bburl variable to $forumurl to correct a broken unsubscribe link.
* NEW - Includes tool to reset the date and count of reminder emails that were previously sent to users. This tool is mainly for testing purposes.

Update 2.1.0 (3/26/2010) - Bug Fixs and some new features
* Edit number of emails send totally
* Choose whether inactivity is based on members "Last Post" or their "Last Activity"
* Keep a log of all inactive users contacted
* Opt-Out Feature for members - Include an opt-out link in reminder email. (Thanks to Gene Steinberg)
* Added a link to the bottom of the default email template phrases that members can use to unsubscribe from reminder emails.

Update 2.0.1 (03/15/2010 9:00pm) - Bug Fix
* FIX - Issue related to processing users in a batch configuration. Mod was checking for a field length greater than zero instead of a numeric value greater than zero.

Update 2.0.0 (03/15/2010) - Complete rewrite of mod
* NEW - Can specify number of users to process during nightly scheduled task.
* NEW - Send reminder emails in either text or html format.
* NEW - Email subject and message body uses vb phrase templates. I've included sample content in email phrase templates so all you need to is customize as desired.

Update 1.1.4 (03/05/2010) - Initial release for vBulletin 4.x
* FIX - Would continue to send out email more often than specified intervals due to incorrect setting in cron job.
* NEW - Exclude userids from processing.


IF YOU HAVE QUESTIONS OR PROBLEMS WITH THE ADDON, PLEASE LET ME KNOW. THOSE THAT HAVE NOT INDICATED THE MOD IS INSTALLED WILL BE A LOWER PRIORITY.

PLEASE DON'T FORGET TO CLICK THE INSTALLED LINK!! THANK YOU!!

PLEASE DON'T FORGET TO NOMINATE.

If you like this mod and it has helped your site, and would like to see more features added, please consider donating.
Your support is very much appreciated! Thank you - Thank you

[CharlieDelta]

Originally Posted by TalkVirginia

You are correct. That being said, is there anyone basing inactivity on lastpost date? Would anyone like to see more criteria added similar to the notices? ... or would anyone like me to take lastpost date out all together.

Yes. I would like to see more criteria. We would make great use out of both at our forums.

[Stefan118]

Originally Posted by TalkVirginia

What year?

Member since december 18 2010 at 21:45
Last activety march 27 2011 at 00:51
last post: december 18 2010 at 22:01

And the other one:
Member since march 4 2011 at 18:45
last activety april 8 2011 at 18:40
last post april 8 2011 at 18:39

This is the setting I have:
Inactivity Grace Period
How many days before a user is considered inactive?
Default: 30 --> manualy set to 60

[TalkVirginia]

Originally Posted by Stefan118

Member since december 18 2010 at 21:45
Last activety march 27 2011 at 00:51
last post: december 18 2010 at 22:01

And the other one:
Member since march 4 2011 at 18:45
last activety april 8 2011 at 18:40
last post april 8 2011 at 18:39

This is the setting I have:
Inactivity Grace Period
How many days before a user is considered inactive?
Default: 30 --> manualy set to 60

Is your inactivity grace period based on Last Post or Last Visit?
According to those dates:
If Last Activity is around the same date as Last Post it's been 409 days roughly.
otherwise it's been 56 days.

[Stefan118]

My setting is based on last activity, because my opinion is that you might bother members too often if you set it by last post.

march 27 to may 21 = 55 days
april 8 to may 21 = 43 days

[TalkVirginia]

Originally Posted by Stefan118

My setting is based on last activity, because my opinion is that you might bother members too often if you set it by last post.

march 27 to may 21 = 55 days
april 8 to may 21 = 43 days

Agreed. Either Last Visit or Last Activity. Yeah, with 55 days and 43 days, reminders should not be going out that soon. Are you sure you don't have your mod set to be based on Last Post? That's the only way that they would be going out so soon. Make sure you save your mod settings at least once before actually using it. I've noticed that after it's first installed, it will used whatever is in memory at the time it was installed. So I recommend setting it how you want it to operate then click the submit button.

[cbiweb]

My apologies if this issue has already been addressed in this thread, but after reading 10 pages of replies my eyes were glazing over, lol.

I can't tell if it's working because none of my test accounts has received any reminders. They do have valid email addresses. I did receive the following email early this morning:

Members who have become inactive based on their last visit date and never received a reminder email:Emails sent to:
Nixon11,the_mask_lover,hithit,drvenom,MrsWrite,

I also ran the cron job manually a few minutes ago, and got this:

Inactive User Reminder Emails
Looking for members who have become inactive (based on their last visit date) and never received a reminder email...

5 inactive members(s) found!
Sent To: ManilaGurL
Sent To: meerulfx
Sent To: Kailash
Sent To: surfville
Sent To: whitemusk

Looking for members who have become inactive (based on their last visit date) and
haven't received a reminder email in the last 45 days...

No inactive member(s) found based on last visit date!

Done

Which also generated another email to me that said this:

Members who have become inactive based on their last visit date and never received a reminder email:Emails sent to:
ManilaGurL,meerulfx,Kailash,surfville,whitemusk,

None of the above user names are test accounts, and shouldn't those be mentioned as well? How can tell if inactive users themselves are actually getting the reminders?

[Stefan118]

I have set the settings AGAIN to last visit date, and guess what...
last night it send another 4 SPAM mails.
SPAM, because it does not follow the settings i have given it.

This member has got a reminder mail last night!

Member since: march 29, 2010 at 9:01
Last visit: may 16, 2011 at 12:04
Last post: may 16, 2011 at 12:04

I am not crazy, my settings are based on last activety, inactive for 60 days.
I did pressed save again after your last post, just to be sure.
Now i'ts sending mail after 9 days!!!

1 more mistake of this program and i uninstall it.
This is spamming my members!

[TalkVirginia]

Originally Posted by Stefan118

I have set the settings AGAIN to last visit date, and guess what...
last night it send another 4 SPAM mails.
SPAM, because it does not follow the settings i have given it.

This member has got a reminder mail last night!

Member since: march 29, 2010 at 9:01
Last visit: may 16, 2011 at 12:04
Last post: may 16, 2011 at 12:04

I am not crazy, my settings are based on last activety, inactive for 60 days.
I did pressed save again after your last post, just to be sure.
Now i'ts sending mail after 9 days!!!

1 more mistake of this program and i uninstall it.
This is spamming my members!

Sounds to me like you've already made up your mind. Sorry I couldn't be of further assistance.

[MrAd]

Great Mod, thanks again Jim, quick question will there be a 3.8.x fo this mod ?

[TalkVirginia]

Originally Posted by MrAd

Great Mod, thanks again Jim, quick question will there be a 3.8.x fo this mod ?

3.8.x release? Yes, I am planning to release one for 3.8.x. As for when, soon. I was hoping to release something this week. :erm: