vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Mini Mods - Email reminder for inactive users (https://vborg.vbsupport.ru/showthread.php?t=138946)

C Braithwaite 02-08-2007 10:00 PM

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

AKapadia 02-09-2007 03:19 PM

really good idea i was looking for something like that.. Click Install

Can someone make it easy to install...please

lolo? 02-09-2007 03:53 PM

very good mod i hope some one can do it easy to install ;)

Robru 02-09-2007 04:43 PM

Who can help him to make a product.xml or like this :)

JsnakeJ 02-09-2007 05:16 PM

Ahh I'll wait on one of them mods to help you out with this then I'll use it.

Installed.

C Braithwaite 02-09-2007 05:28 PM

Updated it into a product now.

Robru 02-09-2007 05:48 PM

Thank you very much for the fast services :)

Snake 02-09-2007 06:01 PM

Oh my god. I was just about to request this hack but it seems that you've created it already. :D

Thanks a lot!

lolo? 02-09-2007 06:09 PM

great thanks for update

Robru 02-09-2007 06:12 PM

Who can tell me how to read the counters...

Quote:

$datetime[lastpost] = $now - (60 * 60 * 24 * 7); //Last post was how long ago?
$datetime[lastemail] = $now - (60 * 60 * 24 * 3); //Last email was how long ago?

Snake 02-09-2007 06:17 PM

What do you mean?

Robru 02-09-2007 06:21 PM

For example: I want to sent the reminder email after three months, what must I set there?

C Braithwaite 02-09-2007 06:38 PM

Quote:

Originally Posted by Robru (Post 1178598)
For example: I want to sent the reminder email after three months, what must I set there?

i've updated it so it's easier to modify the settings.

just change
PHP Code:

$inactivity 7//How many days must elapse without posting 

to
PHP Code:

$inactivity 90//How many days must elapse without posting 

if anyone can help me convert the settings in the file so they can be easily changed in the admincp i would really appreciate it

Robru 02-09-2007 06:53 PM

Thanks for this solution :)

PinkDaisy 02-09-2007 08:19 PM

I just did this and don't see any settings to change anything ??

C Braithwaite 02-09-2007 08:28 PM

Quote:

Originally Posted by PinkDaisy (Post 1178667)
I just did this and don't see any settings to change anything ??

i have just updated it with settings in the vbulliten->options

projectego 02-09-2007 09:26 PM

/me clicks install

puertoblack2003 02-09-2007 10:05 PM

i'm lookin for the emailreminder template can someone direct me to it .thanks

PinkDaisy 02-09-2007 11:44 PM

Quote:

Originally Posted by C Braithwaite (Post 1178671)
i have just updated it with settings in the vbulliten->options

So do I reinstall it or is there an update ???

Ahsin1 02-10-2007 02:51 AM

I tried to send emails its sending blank emails

Subject is there but there is nothing in body

please help

Ahsin

buileminh 02-10-2007 03:40 AM

Quote:

$username <$email@---.---server.com>
Why is there $username and $email in my email header? I guess they must be replaced by something else, right?

enhanced 02-10-2007 05:34 AM

where do you change the email body?

lolo? 02-10-2007 06:43 AM

Quote:

Originally Posted by enhanced (Post 1178927)
where do you change the email body?

In the email template

C Braithwaite 02-10-2007 07:28 AM

Quote:

Originally Posted by PinkDaisy (Post 1178802)
So do I reinstall it or is there an update ???

just reinstall

im going to modify it so the email body and subject etc are editable in the settings soon.

Snake 02-10-2007 10:01 AM

Thanks for the update. And yeah it'll be much better if we can edit the email content and settings in the vB Options page of the ACP. :)

lolo? 02-10-2007 10:39 AM

do you tinhk it's possible to add when user is not conected for a long time and no on post acount ?

C Braithwaite 02-10-2007 01:01 PM

Quote:

Originally Posted by lolo? (Post 1179053)
do you tinhk it's possible to add when user is not conected for a long time and no on post acount ?

ill add it all in eventually.

C Braithwaite 02-10-2007 01:49 PM

Updated it so you can edit the message text/html via the options panel.
uninstall then re-import should delete the unused templates.

if you wish it to only send on visit inactivity as opposed to posting inactivity find:

PHP Code:

$result $vbulletin->db->query_read("SELECT * FROM " TABLE_PREFIX "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity"); 

and replace with:

PHP Code:

$result $vbulletin->db->query_read("SELECT * FROM " TABLE_PREFIX "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity"); 

in remindermail.php


I will update this so you can select via admincp also, in due course.

JawadIT 02-10-2007 02:35 PM

good work over here...

but shall i update every single style (emailreminder template) in my forum to edit the messege?

Zia 02-10-2007 02:42 PM

thats good idea...

why not adding the featuer to add images like sites banner or etc
also add "activation link" for "awaiting email confirmation" user group(hence this user gorup also inactive)

thnx in advance.

Clicks Install.

Snake 02-10-2007 02:51 PM

Quote:

Originally Posted by C Braithwaite (Post 1179131)
Updated it so you can edit the message text/html via the options panel.
uninstall then re-import should delete the unused templates.

if you wish it to only send on visit inactivity as opposed to posting inactivity find:

PHP Code:

$result $vbulletin->db->query_read("SELECT * FROM " TABLE_PREFIX "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity"); 

and replace with:

PHP Code:

$result $vbulletin->db->query_read("SELECT * FROM " TABLE_PREFIX "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity"); 

in remindermail.php


I will update this so you can select via admincp also, in due course.

Thanks for the update but I'm trying to send the mail every once a week. How do I do that? :D

djbaxter 02-10-2007 03:33 PM

Nice idea but not ready for prime time... too many errors to be debugged at present.

C Braithwaite 02-10-2007 03:35 PM

Quote:

Originally Posted by JawadIT (Post 1179153)
good work over here...

but shall i update every single style (emailreminder template) in my forum to edit the messege?

No, no need to do that now. ive removed the need for templates, and now you can edit the email in the admincp options

Quote:

Originally Posted by Zia (Post 1179158)
thats good idea...

why not adding the featuer to add images like sites banner or etc
also add "activation link" for "awaiting email confirmation" user group(hence this user gorup also inactive)

thnx in advance.

Clicks Install.

sounds like i need to update this into something much more than just a simple inactivity reminder..

Quote:

Originally Posted by Snake (Post 1179163)
Thanks for the update but I'm trying to send the mail every once a week. How do I do that? :D


In the options you set the frequency to 7 days.

Robru 02-10-2007 03:44 PM

The recieved email only shows the Email subject out of the ACP (Inactive User Reminder Emails) but not the Email message!

WEBDosser 02-10-2007 04:02 PM

it shows the message in the email for me?..

Robru 02-10-2007 04:31 PM

I installed the product again wth 'overwrite' , it lets show now the message too :)

WEBDosser 02-10-2007 04:37 PM

hmm.. i just followed the install and it worked first time.. the email was sent to a user that has not posted for a while and they came and posted.. in the email it just said..

"$username! We miss you!"..

C Braithwaite 02-10-2007 04:41 PM

Quote:

Originally Posted by WEBDosser (Post 1179236)
hmm.. i just followed the install and it worked first time.. the email was sent to a user that has not posted for a while and they came and posted.. in the email it just said..

"$username! We miss you!"..

mind clicking "install" then? ;) lol

but glad to see it's effective!

projectego 02-10-2007 05:22 PM

I'm trying to download the update but all see is "No files uploaded." :(

Edit: nevermind.

WEBDosser 02-10-2007 05:44 PM

Quote:

Originally Posted by C Braithwaite (Post 1179239)
mind clicking "install" then? ;) lol

but glad to see it's effective!

oops..:o clicked now. :)


All times are GMT. The time now is 06:28 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03272 seconds
  • Memory Usage 1,844KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_php_printable
  • (14)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete