Mini Mods - Email reminder for inactive users

Inactive reminder emails. This mod was designed to send out a reminder to inactive members to try and win them back.

***1.2.7 Update***
This update includes built in support for bouncing emails. The script will automatically detect the bounced mail, mark it as bounced so the user is not to be contacted again so as to avoid spam, and then move that user into a seperate usergroup. This plugin is still in it's testing stages, but I have addressed the bugs mentioned previously regarding the emailing side of things.

This is important so keep reading
To install this plugin and take advantage of the bounced email features you are going to need to follow these instructions very carefully. I can not gaurentee that they will work to the letter as this will be based on each persons individual hosting settings.

Step 1: Pre Install
Before you touch this product you need to do the following

• Create an "inactive" usergroup
• Set up a "bounce to" email address
  Pick an email address that you want to use as your bounced email address. Im using "bounce@icora.co.uk". feel free to use whatever you wish.
• Add a email message filter
  This is the hard part. You need to set up a filter that will 'pipe' an email sent to the above email address.
  I am using Cpanel 11 and this is how i have mine set up:
  Rules: 'To' 'Equals' 'bounce@icora.co.uk'
  Actions: 'Pipe to program' with the setting: |/usr/local/bin/php /home/icora/public_html/forum/bounce.php
  This will depend entirely on your settings and structure so you may have to do a little research. It would be very helfull if people who have to use diferent configurations would post them on here.
• Go into vBulletin options, and find the options for 'Emails'. there is a setting asking you if you want to use '-f'. set this to yes.
• While still inn the email options set the 'Bounce Email Address' to your above address.

Step 2: Install
Remove all previous trace of this modification, and upload all the files in the "upload" folder to your base directory of the server.
Go into your product management section and add a new product. upload the XML file with overwrite selected.
Refresh your admin CP to load the new menu items. Just under the "users" group you will find an "Inactive Reminders" group. open that up and click on settings.
Play with these settings and options to suit for the most part. when you come down to the bounce settings you MUST use the same email address as the one you created above.
Set to active and save.

I must re-iterate that this version has not been widely tested, but the simulations i have ran have worked. I look forward to your feedback!

Features:

• Select the period of time before a user is considered inactive.
• Select how many emails to send to each inactive user per inactivity period
• Choose weather inactivity is based on members "Last Post" or their "Last Visit"
• Specify how often followup emails are sent
• Specify alternative emails to send to reduce repetition
• Keep a log of all inactive users contacted

Planned Updates:

• More detail in reports
• ...such as
• Which useres returned
• Effectivness stats
• Email validity

**1.2.1 Update***
Added more detail to the reports section. You can now see the email address, and quickly indicate which emails were invalid. You can link directly to that user to edit as you wish.
I have fixed some errors which have been crashing people's database. Please post any problems if you can.

**1.2.3 Update***
Fixed several problems with escaping strings
Stopped database errors locking up site
***

**1.2.4 Update***
Added a "From Email" so you can specify your own email address to send the reminders from.
Fixed potential bug for people who do not use the mail queue.

Anyone having problems with sending emails out too fast, and multiple emails being sent need to consider changing their email settings in vbulletin options.
People with emails going out too fast - edit Number of Emails to Send Per Batch to a lower amount
People with multiple emails sending - edit Use Mailqueue System to "Yes, with locking"
***

**1.2.5 Update***
Added more stats in the reports page, also added a "Send test email" option so users can test the functionality of the mod
***

[C Braithwaite]

Originally Posted by BobbyBig

I took a look at your code - now I uninstalled this Mod. The frequency which can be set in the admincp is a lie.

Frequenzy just inceases the Time when the Email will be send again. It doesnt mean for "1" that it only will be send 1 time, but thats how you wrote it...

That means Inactive Users will receive the email every X days of not posting when Y days are over.

Also you ever thought about one thing: 15 Days Inactivity, Frequenzy 1, Emails Send: 50.
15*50 = 750

That means in this Period only 750 Inactive Users get the email, after this OTHER inactive users are not effected by this rule, instead the Users which allready received emails will receive email AGAIN.

You should work on the logic for that.

regards

i have no idea what you are talking about. there is a setting to set the inactivity period, how frequent the emails are sent once the inactivity period is entered, and how many emails to send at once.

for example, set the inactivity period to 7 days, then frequency to 3 days, once a person becomes inactive they will be sent an email every 3 days.

or you can set the inactivity period to 1 month, and set the reminder email to 90 days, and thus would send the reminder email every 90 days once a member had entered the inactivity period.

there is no lie. the plugin does exactly what it is supposed to do. the plugin description for frequency says "How often to send a reminder email once a member has become inactive."

"how often" being the operative words here, not "how many".

if you wish to send the email less than once a day set it to higher than 1.

idiot.

[djbaxter]

If you specify more than one usergroup ID, it sends out nothing.

[C Braithwaite]

Originally Posted by djbaxter

If you specify more than one usergroup ID, it sends out nothing.

how are you writing the usergroups? 1,2,3,4 or 1, 2, 3, 4 etc?

[C Braithwaite]

Originally Posted by djbaxter

If you specify more than one usergroup ID, it sends out nothing.

try it now, make sure it's x,y,z etc not z, y, x etc

[HOST-KSA.COM]

Hi,, I've a questuion..

If I have more than 20 thousands of members are inactive .. will this reminder affect my server ?

[djbaxter]

Originally Posted by C Braithwaite

how are you writing the usergroups? 1,2,3,4 or 1, 2, 3, 4 etc?

I was using 1,2,3,4

[djbaxter]

Originally Posted by C Braithwaite

try it now, make sure it's x,y,z etc not z, y, x etc

"Try it now" meaning you've updated the add-on? If so, what or which file has changed?

[C Braithwaite]

Originally Posted by HOST-KSA.COM

Hi,, I've a questuion..

If I have more than 20 thousands of members are inactive .. will this reminder affect my server ?

I have designed it so you can limit the ammount of emails sent. 1, 5, 10, 100 - whatever you want.

It uses the mail function.

[C Braithwaite]

Originally Posted by djbaxter

"Try it now" meaning you've updated the add-on? If so, what or which file has changed?

reupload the php file - it was a bug in the coding.

[rezapci]

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'onoff',
'remindermail',
'1',
'no',
'free',
'yesno',
1,
0,
1,
'',
0,
'remindermail'
),
(
'inactivity',
'remindermail',
'7',
'7',
'number',
'',
1,
0,
1,
'',
0,
'remindermail'
),
(
'frequency',
'remindermail',
'3',
'3',
'number',
'',
2,
0,
1,
'',
0,
'remindermail'
),
(
'quantity',
'remindermail',
'3',
'3',
'number',
'',
12,
0,
1,
'',
0,
'remindermail'
),
(
'subject',
'remindermail',
'$username! We miss you!',
'$username! We miss you!',
'free',
'',
22,
0,
1,
'',
0,
'remindermail'
),
(
'message',
'remindermail',
'<p>Hello, $username!</p>\r\n<p>We\'ve noticed that you\'ve not been active on $bbtitle for quite some time now, \r\n and we miss you!</p>\r\n<p>Could we not tempt you back?</p>\r\n<p>If you don\'t remember your password, you can request it here: <a href=\"$forumurl/login.php?do=lostpw\">$forumurl/login.php?do=lostpw</a></p>\r\n<p>We hope to see you soon</p>\r\n<p>&nbsp;</p>\r\n<p>Kindest Regards</p>\r\n$bbtitle\r\n<p><a href=\"$homeurl\">$homeurl</a></p>',
'<p>Hello, $username!</p>\r\n<p>We\'ve noticed that you\'ve not been active on $bbtitle for quite some time now, \r\n and we miss you!</p>\r\n<p>Could we not tempt you back?</p>\r\n<p>If you don\'t remember your password, you can request it here: <a href=\"$forumurl/login.php?do=lostpw\">$forumurl/login.php?do=lostpw</a></p>\r\n<p>We hope to see you soon</p>\r\n<p>&nbsp;</p>\r\n<p>Kindest Regards</p>\r\n$bbtitle\r\n<p><a href=\"$homeurl\">$homeurl</a></p>',
'free',
'textarea',
32,
0,
1,
'',
0,
'remindermail'
),
(
'usergroups',
'remindermail',
'2',
'2',
'free',
'',
42,
0,
1,
'',
0,
'remindermail'
);

MySQL Error : Duplicate entry 'onoff' for key 1
Error Number : 1062
Date : Monday, February 12th 2007 @ 09:01:01 PM
Script : http://www.alshiatalk.com/vb/admincp...=productimport
Referrer : http://www.alshiatalk.com/vb/admincp...?do=productadd
IP Address : 70.252.137.29
Username : alghadeer
Classname : vb_database

whats wrong with this!? why cant I update or reinstall it?