Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Email Reminder for inactive users Details »
Email Reminder for inactive users
Mod Version: 2.2.1, by TalkVirginia (Coder) TalkVirginia is offline
Developer Last Online: Mar 2013 I like it Show Printable Version Email this Page

vB Version: 4.x.x Rating: (100 votes - 4.75 average) Installs: 1207
Released: 05 Mar 2010 Last Update: 06 Jun 2011 Downloads: 5772
Not Supported DB Changes Uses Plugins Additional Files Re-usable Code Translations  

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

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	3-26-2010 8-40-15 AM.jpg
Views:	2462
Size:	57.5 KB
ID:	114735   Click image for larger version

Name:	3-26-2010 8-41-43 AM.jpg
Views:	2919
Size:	135.9 KB
ID:	114736   Click image for larger version

Name:	3-15-2010 8-23-36 AM.png
Views:	5176
Size:	22.8 KB
ID:	114738   Click image for larger version

Name:	3-15-2010 8-26-32 AM.png
Views:	4293
Size:	26.0 KB
ID:	114739  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Mini Mods Email reminder for inactive users 1.1.3 robertjandreu vBulletin 3.7 Add-ons 184 31 Jul 2012 16:45
Mini Mods Email reminder for inactive users technom8t vBulletin 3.6 Add-ons 27 07 May 2008 01:59

  #151  
Old 29 Mar 2010, 11:44
balkanboy balkanboy is offline
 
Join Date: Dec 2008
To stop receiving this email, visit this URL: /misc.php?do=unsub&u=16
When they recieve a email it doesnt show the full URL.... why is that?

the code is:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

it has not been modified....
__________________
Release yourself, Release the Scene - www.techabyte.com.au
Reply With Quote
  #152  
Old 29 Mar 2010, 12:54
TalkVirginia's Avatar
TalkVirginia TalkVirginia is offline
 
Join Date: Oct 2008
Real name: Jim
Originally Posted by balkanboy View Post
When they recieve a email it doesnt show the full URL.... why is that?

the code is:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

it has not been modified....
Change $bburl to $forumurl so that it points to your forum root folder.
__________________
Jim - Webadmin 3:33am Paranormal Research - History will always repeat itself but sometimes the past never leave
vb4.x Email Reminders for Inactive Users, Add Mass Child Forums for vb3.8.6 & vb4.1.2
Reply With Quote
  #153  
Old 29 Mar 2010, 15:28
shyguy82 shyguy82 is offline
 
Join Date: Feb 2010
Ah forgot to nominate this MOD, just nominated it, thank you TalkVirginia, I'll shoot you a PM soon with requirements for the custom mod. Thanks again.
Reply With Quote
  #154  
Old 29 Mar 2010, 15:37
TalkVirginia's Avatar
TalkVirginia TalkVirginia is offline
 
Join Date: Oct 2008
Real name: Jim
Originally Posted by shyguy82 View Post
Ah forgot to nominate this MOD, just nominated it, thank you TalkVirginia, I'll shoot you a PM soon with requirements for the custom mod. Thanks again.
Good Good!! Thank you very much!
__________________
Jim - Webadmin 3:33am Paranormal Research - History will always repeat itself but sometimes the past never leave
vb4.x Email Reminders for Inactive Users, Add Mass Child Forums for vb3.8.6 & vb4.1.2
Reply With Quote
  #155  
Old 30 Mar 2010, 13:28
badawidollah badawidollah is offline
 
Join Date: Nov 2008
this is another crazy mods i must install

thanks
Reply With Quote
  #156  
Old 30 Mar 2010, 22:35
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
thx for the update and already ominated
__________________
For You Who Like To Play CounterStrike Source, Check Our Website At:
FireWaLL Website
Reply With Quote
  #157  
Old 30 Mar 2010, 22:49
alawee.blawee's Avatar
alawee.blawee alawee.blawee is offline
 
Join Date: Oct 2006
Location: IraQ
Real name: Ali Hilli
can this be modified to send HTML emails to all the members? it looks easier than other products to use
__________________
The Biggest Software Bug I Ever See ---> Here
Reply With Quote
  #158  
Old 30 Mar 2010, 23:27
TalkVirginia's Avatar
TalkVirginia TalkVirginia is offline
 
Join Date: Oct 2008
Real name: Jim
Originally Posted by alawee.blawee View Post
can this be modified to send HTML emails to all the members? it looks easier than other products to use
actually I'm working on a mod similar to this that is based on the vBulletin Notification System where you can create multiple emails templates with rules assigned to each one. I just started playing with some ideas so it may be a while before I release it.
__________________
Jim - Webadmin 3:33am Paranormal Research - History will always repeat itself but sometimes the past never leave
vb4.x Email Reminders for Inactive Users, Add Mass Child Forums for vb3.8.6 & vb4.1.2
Reply With Quote
  #159  
Old 01 Apr 2010, 08:16
badawidollah badawidollah is offline
 
Join Date: Nov 2008
installed
but dont know its running or not

??
Reply With Quote
  #160  
Old 01 Apr 2010, 12:46
TalkVirginia's Avatar
TalkVirginia TalkVirginia is offline
 
Join Date: Oct 2008
Real name: Jim
Originally Posted by badawidollah View Post
installed
but dont know its running or not

??
1. Go into Inactive Reminders -> Settings or vBulletin Settings -> Inactive User Reminder Emails and make sure the product is enabled. It is disabled on install.

2. Go to Scheduled Tasks Manager and you should have a task "Inactive User Reminder Emails". The task is set to run at 1:30am. How many members do you have? If you're not sure, you can set the mod to process users in a batch. Set the value for anywhere from 1-5 adjusting the other settings as desired. (Check out the detailed description of each feature in my first post). Then run the task manually by clicking the "Run Now" button.

3. You can also check the Inactive User Logviewer. It shows any members which have been processed. The webmaster account or the email address specified as the webmaster will receive an email notification when the process has run indicating the member names that were sent reminders as well as any members it couldn't send to.

Hopefully this will get you going... Please let me know if you need further assistance.
__________________
Jim - Webadmin 3:33am Paranormal Research - History will always repeat itself but sometimes the past never leave
vb4.x Email Reminders for Inactive Users, Add Mass Child Forums for vb3.8.6 & vb4.1.2
Reply With Quote
  #161  
Old 01 Apr 2010, 15:47
badawidollah badawidollah is offline
 
Join Date: Nov 2008
thanks

working
it will help my users come back to my forum
Reply With Quote
  #162  
Old 05 Apr 2010, 18:10
TalkVirginia's Avatar
TalkVirginia TalkVirginia is offline
 
Join Date: Oct 2008
Real name: Jim
Can anyone tell me what type of mail services or servers you are using? I'm working on a script to automate processing bounced mail. So far I've got information on IMAP and a little on the POP protocols... Any others would be nice. Anyone interested in helping with beta testing please shoot me a PM. I'd like to have a few that would be using each protocol.

Thanks!
__________________
Jim - Webadmin 3:33am Paranormal Research - History will always repeat itself but sometimes the past never leave
vb4.x Email Reminders for Inactive Users, Add Mass Child Forums for vb3.8.6 & vb4.1.2
Reply With Quote
  #163  
Old 06 Apr 2010, 16:49
lazerguy_82 lazerguy_82 is offline
 
Join Date: Mar 2010
Occasionally I get errors. Is it maybe caused by user names that include the '@' sign?

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('Bill 'C'','8323','1270189848','1','someemail@sky.com');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'C'','8323','1270189848','1','someemail@sky.com')' at line 2
Error Number : 1064
Request Date : Friday, April 2nd 2010 @ 02:30:48 AM
Error Date : Friday, April 2nd 2010 @ 02:30:48 AM
Script : http://www.
Referrer : http://www.
Username : Unregistered
Classname : vB_Database
Reply With Quote
  #164  
Old 06 Apr 2010, 17:37
TalkVirginia's Avatar
TalkVirginia TalkVirginia is offline
 
Join Date: Oct 2008
Real name: Jim
Originally Posted by lazerguy_82 View Post
Occasionally I get errors. Is it maybe caused by user names that include the '@' sign?

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('Bill 'C'','8323','1270189848','1','someemail@sky.com');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'C'','8323','1270189848','1','someemail@sky.com')' at line 2
Error Number : 1064
Request Date : Friday, April 2nd 2010 @ 02:30:48 AM
Error Date : Friday, April 2nd 2010 @ 02:30:48 AM
Script : http://www.
Referrer : http://www.
Username : Unregistered
Classname : vB_Database
Looks like the extra quotes in the username are causing it. There are 2 places to change that should fix it. To fix this manually, do the following:

1. Open the reminderemail.php file in the {forumroot}/includes/cron folder
2. Scroll down and insert the following code after 361, just before the line where $sql = "INSERT INTO " is getting set:

$username = addslashes($username);

3. Save and close the file.

4. Open the inactivitylog.php file in your admincp folder
5. Scroll down to line 133 and replace it with the following line of code.

$username = stripslashes($log['username']);


That should do it. I'll upload a new zip with this fix this weekend.
__________________
Jim - Webadmin 3:33am Paranormal Research - History will always repeat itself but sometimes the past never leave
vb4.x Email Reminders for Inactive Users, Add Mass Child Forums for vb3.8.6 & vb4.1.2
Reply With Quote
  #165  
Old 06 Apr 2010, 23:30
lazerguy_82 lazerguy_82 is offline
 
Join Date: Mar 2010
Ok thanks! Will that also fix the error if an apostrophe is in the username like this:
Norman O'Neill

That username generated an error as well.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 07:22.

Layout Options | Width: Wide Color: