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: 5774
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:	2464
Size:	57.5 KB
ID:	114735   Click image for larger version

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

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

Name:	3-15-2010 8-26-32 AM.png
Views:	4295
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 17:45
Mini Mods Email reminder for inactive users technom8t vBulletin 3.6 Add-ons 27 07 May 2008 02:59

  #676  
Old 15 Oct 2013, 15:16
rhody401's Avatar
rhody401 rhody401 is offline
 
Join Date: Feb 2012
The one from the author works great with 4.2.1 and youll have no trouble with the instructions.
Reply With Quote
  #677  
Old 20 Oct 2013, 18:00
DemOnstar's Avatar
DemOnstar DemOnstar is offline
 
Join Date: Dec 2012
This one seems to work! 4.2.1.

Reply With Quote
  #678  
Old 09 Nov 2013, 21:42
honda208 honda208 is offline
 
Join Date: Nov 2013
Is this still a working add-on? I have 4.2.2, thanks.
Reply With Quote
  #679  
Old 02 Feb 2014, 22:02
thernus thernus is offline
 
Join Date: Jul 2007
Error after install in 4.2.2

After I install the hack I get this error message via mail:

Invalid SQL:
SELECT userid, username, email, usergroupid, FROM_UNIXTIME(lastvisit) lastvisit, FROM_UNIXTIME(lastactivity) lastactivity, CASE WHEN lastpost = 0 THEN '' ELSE FROM_UNIXTIME(lastpost) END AS lastpost, CASE WHEN rmEmailDate = 0 THEN '' ELSE FROM_UNIXTIME(rmEmailDate) END AS lastreminder, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastvisit, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastactivity, CASE WHEN lastpost = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastpost), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastpost, CASE WHEN rmEmailDate = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastemail, rmoptout FROM vb3_user WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND usergroupid IN ('3','18','22','23','21') AND rmEmailCount = 0 AND options & 16 AND rmoptout = 0 LIMIT 0, 50;;

MySQL-Fehler : 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 '(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_last' at line 1
Fehler-Nr. : 1064
Is there a way to fix it?


THX
th
Reply With Quote
  #680  
Old 08 Mar 2014, 09:31
M.C.'s Avatar
M.C. M.C. is offline
 
Join Date: Jan 2002
It's working but gives me error in AdminCP -> Settings:
Warning: trim() expects parameter 1 to be string, array given in [path]/includes/adminfunctions_options.php on line 1032
__________________
WBR`s
M.C.
Reply With Quote
  #681  
Old 18 Mar 2014, 21:43
buffaloscooby buffaloscooby is offline
 
Join Date: Feb 2014
Is it possible at all to have 2 different setups? One message to go to one group on one schedule, but then a second instance to send a different message to another group at a different interval?
Reply With Quote
  #682  
Old 23 Mar 2014, 08:26
krimznheidiz krimznheidiz is offline
 
Join Date: May 2013
Anybody can confirm is it work with 4.2.2?
Reply With Quote
  #683  
Old 23 Mar 2014, 10:14
ikorolis's Avatar
ikorolis ikorolis is offline
 
Join Date: Sep 2006
Real name: Ilias
is worked to me.
__________________
The Internet World
http://www.theinternetworld.org
Reply With Quote
  #684  
Old 23 Mar 2014, 17:29
mradlin's Avatar
mradlin mradlin is offline
 
Join Date: Nov 2008
Is working for me on 4.2.2 also.
Reply With Quote
  #685  
Old 24 Mar 2014, 21:30
rhody401's Avatar
rhody401 rhody401 is offline
 
Join Date: Feb 2012
It works fine. I get 2 emails each morning from it. One for the 30 day folks, and one for the rest.
Reply With Quote
  #686  
Old 19 Apr 2014, 01:39
bosanci28's Avatar
bosanci28 bosanci28 is offline
 
Join Date: Feb 2008
How to edit , the info that was sent out?

I got a email,and the links back to the forum they don't match up.

Thanks
Reply With Quote
  #687  
Old 19 Apr 2014, 07:21
K!nG K!nG is offline
 
Join Date: Dec 2010
Originally Posted by bosanci28 View Post
How to edit , the info that was sent out?

I got a email,and the links back to the forum they don't match up.

Thanks
Hi,
I believe you asking where to edit the email which goes out to inactive users. If that's what you want.. Go to Admincp and on left side menu click on Inactive Reminders and scroll down a bit till you see Email format. In Email format click on Email body make changes you need and save it.

Here is screenshot. (sorry if this is not what you were looking for, but that was the best guess i could make.)

Reply With Quote
  #688  
Old 29 May 2014, 21:12
gageb gageb is offline
 
Join Date: May 2013
excellent mod
__________________
www.tunisia-land.com
Reply With Quote
  #689  
Old 12 Feb 2015, 09:51
vwdforum vwdforum is offline
 
Join Date: Jun 2006
Anybody else received a warning from google about "passing personally identifiable information (PII) to Google through your use of one or more of Google's advertising products -- DFP, AdSense, and/or DoubleClick AdExchange."

According the the url sent, the problem is with my vbulletin standard template showing google ads, on this page ***Forum url ***/optout-reminders.php?u=36844

Any way to prevent ads from showing on optout-reminders.php pages?
__________________
www.vwdforum.com
residual income
Reply With Quote
  #690  
Old 25 Feb 2015, 22:09
Alibass's Avatar
Alibass Alibass is offline
 
Join Date: Mar 2007
Originally Posted by vwdforum View Post
Anybody else received a warning from google about "passing personally identifiable information (PII) to Google through your use of one or more of Google's advertising products -- DFP, AdSense, and/or DoubleClick AdExchange."

According the the url sent, the problem is with my vbulletin standard template showing google ads, on this page ***Forum url ***/optout-reminders.php?u=36844

Any way to prevent ads from showing on optout-reminders.php pages?
In the phrase manager email body are you using html and if so have you used and google links there?
__________________
Alibass
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:44.

Layout Options | Width: Wide Color: