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.

[blackberry]

it shows userid 0 for all users??

[TalkVirginia]

Originally Posted by blackberry

it shows userid 0 for all users??

Yes, it's only in the inactivity log. I will fix that tonight.

[tandy]

Originally Posted by TalkVirginia

Yes, it's only in the inactivity log. I will fix that tonight.

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

[waynne]

Would it be possible to add a "consider user 'Dead' option at..." So when they haven't logged in for 365 days we stop sending them reminder emails.

Also I have 2 questions.

1) If I install this I presume it will then email all my inactive users, some of these are over 5 years old and inactive and this will certainly get me flagged up as a spammer as there email addresses are probably inactive. Can I exclude users that have not been recently active ie in the last year or two? Is there a MYSQL statement I can run for example to set them to "not receive reminder emails".

2) If I set the reminder emails to 10 - does this mean that the user will only get 10 reminder emails ever or does the counter reset when they become active again?

Ideally I'd like to email a reminder out at 30, 90, 120 and 365 days each time someone goes inactive, can this be done? After this period I don't think the user is coming back to me.

I look forward to the bounce handling option.

[microbob]

Jim,

I'm s-t-i-l-l trying to get your hack installed on V3.8.5 (although planning on upgrade to 3.8.7 soon for security purposes). Everything is up in the Admin CP with the exception of the drop down menu on the left illustrated here:

https://vborg.vbsupport.ru/attachmen...6&d=1308509227

Note: /includes/xml/cpnav_remindermail.xml is as instructed but when I refresh, there is no dropdown menu showing up.

I'm not sure about the sequence of activities (regarding DEBUG MODE) to get this wrapped up and actually working. I have the following questions:


-I have a file sitting in my cPanel public FTP root: optout-reminders.php. Where does this belong?
-When should the the missing menu appear in the AdminCP?
-After I modify the subject and body of the e-mail template?
-Is this [below] the sequence of events to do that?
-Can I get all (3) things done in one shot?

1) Add the following line to config.php located in /includes to enter into DEBUG mode:

$config['Misc']['debug'] = 1;

2) Change the subject and body of the e-mail template to my individualized message

3) Save the Subject and Body

4) Go back into the config.php located in /includes and remove $config['Misc']['debug'] = 1;

5) Click on "Yes" on "Enable Product?":

6) Save

Is that all that's required?confused:

Please help.

Bob

[TalkVirginia]

Originally Posted by waynne

Would it be possible to add a "consider user 'Dead' option at..." So when they haven't logged in for 365 days we stop sending them reminder emails.

Also I have 2 questions.

1) If I install this I presume it will then email all my inactive users, some of these are over 5 years old and inactive and this will certainly get me flagged up as a spammer as there email addresses are probably inactive. Can I exclude users that have not been recently active ie in the last year or two? Is there a MYSQL statement I can run for example to set them to "not receive reminder emails".

2) If I set the reminder emails to 10 - does this mean that the user will only get 10 reminder emails ever or does the counter reset when they become active again?

Ideally I'd like to email a reminder out at 30, 90, 120 and 365 days each time someone goes inactive, can this be done? After this period I don't think the user is coming back to me.

I look forward to the bounce handling option.

I am working on resolving these issues.. I've just been limited on time to go around. Some of this I've already resolved in the 4.0 version I just need to add it to the 3.8.x version.

[TalkVirginia]

Originally Posted by microbob

Jim,

I'm s-t-i-l-l trying to get your hack installed on V3.8.5 (although planning on upgrade to 3.8.7 soon for security purposes). Everything is up in the Admin CP with the exception of the drop down menu on the left illustrated here:

https://vborg.vbsupport.ru/attachmen...6&d=1308509227

Note: /includes/xml/cpnav_remindermail.xml is as instructed but when I refresh, there is no dropdown menu showing up.

I'm not sure about the sequence of activities (regarding DEBUG MODE) to get this wrapped up and actually working. I have the following questions:


-I have a file sitting in my cPanel public FTP root: optout-reminders.php. Where does this belong?
-When should the the missing menu appear in the AdminCP?
-After I modify the subject and body of the e-mail template?
-Is this [below] the sequence of events to do that?
-Can I get all (3) things done in one shot?

1) Add the following line to config.php located in /includes to enter into DEBUG mode:

$config['Misc']['debug'] = 1;

2) Change the subject and body of the e-mail template to my individualized message

3) Save the Subject and Body

4) Go back into the config.php located in /includes and remove $config['Misc']['debug'] = 1;

5) Click on "Yes" on "Enable Product?":

6) Save

Is that all that's required?confused:

Please help.

Bob

Sorry Bob, that sequence of events doesn't apply to the left side menu. It sounds like you may have 2 separate versions competing with each other possibly. Please make sure you don't have an old cpnav_remindermail file by chance. Compare with the one in the zip file. If it's in there it should work.

[microbob]

Please attach the updated file here so I can download and overwrite the one that in there now.

Also, where does this file go? optout-reminders.php

It's sitting in my FTP folder and I know that's not where it belongs. Maybe that's the cause?

Please advise.
Bob

[TalkVirginia]

Originally Posted by microbob

Please attach the updated file here so I can download and overwrite the one that in there now.

Also, where does this file go? optout-reminders.php

It's sitting in my FTP folder and I know that's not where it belongs. Maybe that's the cause?

Please advise.
Bob

I haven't updated anything yet.

The optout-reminders.php file goes in your forum root folder.

[microbob]

OK Jim...I seem to have gotten everything straightened out with the help of my web host. Got the drop down menu installed after reloading the product install file and moving "optout-reminders.php" as recommended.

Now, I would like to test this out on my board which currently has about 875 registered members and a lot of inactive users. How do I get it to send out the reminder e-mail NOW, and then reset it afterward, so I can see the inactivity log? What settings do I apply to have it send the message out tomorrow [Friday]?

Thanks again.
Bob