Mini Mods - Email Reminder for inactive users

Like others before me, I've been using this mod quite a while on previous versions of vBulletin. Since updates and support for older versions had stopped, I figured I would make my own modifications and help others that have enjoyed it as well. I want to add back in some of the previous functionality that has been left out as well as add some new functionality. This mod for the most part picks up where the 3.7.x version leaves off.

What does it do?
=====================================
This mod will send out reminder emails to inactive members to encourage them to come back to your site. This is now only based on member's last activity date.

*** 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 AND DON'T FORGET TO NOMINATE MOTM!!
THANK YOU!!

Features
The following features are updatable through the AdminCP.
=====================================
* Turn Product on/off.

* Set the number of days a user can be inactive (grace period) before email is sent.
Example: Inactivity Graceperiod is set for 60 days. On day 61, member Bob will begin receiving reminder emails.

* Send Email Once.
If this is set, when members become inactive they will receive one reminder only.

* Set how often an reminder email is sent after an inactive member has received their first reminder.
Example: Inactivity Grace period is set for 60 days, and Reminder Email frequency is set for 30 days. On day 61, member Bob will receive his first reminder email letting him know he has been inactive for over 60 days asking him to come back to see your new content. If Bob, continues to be inactive, Bob will receive reminder emails based on the number of days you have the email frequency set to. If set to 30 days, members will receive reminders every 30 days after their first reminder.

* Set reminder email format - TEXT or HTML.

* Set the reminder email subject. (phrased)

* Set the reminder email body. (phrased)

* Set the usergroups to be sent a reminder email.

* Set Userids to exclude.

* Edit number of emails send totally (Max Reminders)
Example: If the Send Once option is set to false, and this option is set to 50. Inactive members will only receive 50 reminders.

* 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)

Install Instructions
--------------------------
1. Upload file in the upload folder to the forums folder on your server.

2. In your AdminCP:

a. Go to Plugs & Products -> Product Manager -> Add New Product.
c. Import the product xml from the zip file. (make sure to use overwrite)

3. The mod is disabled by default on install so you will need to enable it. Go to Vbulletin "Settings" -> Options -> Inactivity Reminder Emails.

4. Settings and the inactivity log viewer are also available on the left menu just above the users settings group.

5 Mark as Installed

6 Please Nominate for MOTM

=======================================
Update 2.1.5 - Initial Release for VB 3.8.x

Credits & Previous Updates
======================================
Updates and fixes that have been carried over from version 1.1.3 can be found at the link below.
https://vborg.vbsupport.ru/showthread.php?t=180025&highlight=email+reminder

I also want to give full credit and thanks to the developers of the previous versions 1.0.6 to 1.1.3 from which this was derived:

C Braithwaite
robertjandreu

PLEASE DON'T FORGET TO CLICK THE INSTALLED LINK.

[adwade]

Two brief questions:

Originally Posted by TalkVirginia

You can find the email templates by going to the addon settings. There is a link there to modify the subject and the email body. Your forum must be in DEBUG mode in order to modify the base version. You can only translate them when in non-debug mode.
Jim

1)I don't quite understand this reasoning about revising the subject/body of the email. I've always just used the Copy Default Text button(i.e. Translations Feature) to 're-word' things as needed. Is there any reason, why that would not work with this add-on?(i.e. Why would one use DEBUG mode to revise your original text, when the translate feature is available?)

Originally Posted by tandy

Is it a good idea to wait for a new revision?

2)With the consequences being so great, is this add-on ready for prime-time use? I don't want to install it and have lots of angry/inactive users, if something can still go amiss right now using the existing code we can D/L at present.(i.e. Is it safe?)

[realmr]

any updates Jim ?

[Artes_Marciales]

Amazing, thanks! : D

[SamirDarji]

Reminder for me to look into this. I can't believe I didn't see it before!

[busybeeburns]

Hi,

thanks for the mod.

1) Does it work for secondary usergroups or primary only? I have various smaller secondary groups within registered members but doesn't seem to be sending any emails out to those alone.

2) Could this mod essestially be used as a mailout on a cronjob basis, with the phrase template altered each time and inactive time ~0.1?

[YankForum]

talkvirginia this is super greate , i miss confused other plugins with this one , but of course this is the best one among them , i dont know why it never won MOTH which it deserves to win.

how come there is no author link ? it's totally free ?

[tehPARADOX]

Doesn't seem as effective anymore.

[ennio]

It would be nice if it had a feature to send the reminder to an user manually. So, after you search a user on the results page you could select send reminder to user.

[waynne]

I have a fix and hack for this to be applied to functions_remindermail.php

This fixes the lack of userid in the unsubscribe email link and log files...
Find

$sql = "SELECT username, email, ".
           "usergroupid, ".

Replace with

$sql = "SELECT username, email, userid, ".
           "usergroupid, ".

The following restricts reminder emails to members who have been active in the last year. This is helpful to reduce the risk of spamming old defunct addresses.

Find (3 instances)

 "AND options & 16 ".  
           "AND rmoptout = 0 ";

Replace with

 "AND options & 16 ". 
		   "AND TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) <= '365'". 
           "AND rmoptout = 0 ";

(Caution :- You must add this code in all 3 places or you'll end up repeatedly emailing the same user.)