Email reminder for inactive users

[C Braithwaite]

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]

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

Can someone make it easy to install...please

[lolo?]

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

[Robru]

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

[JsnakeJ]

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

Installed.

[C Braithwaite]

Updated it into a product now.

[Robru]

Thank you very much for the fast services :)

[Snake]

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?]

great thanks for update

[Robru]

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

$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]

What do you mean?

[Robru]

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

[C Braithwaite]

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

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

to

$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]

Thanks for this solution :)

[PinkDaisy]

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

[C Braithwaite]

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]

/me clicks install

[puertoblack2003]

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

[PinkDaisy]

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

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

[Ahsin1]

I tried to send emails its sending blank emails

Subject is there but there is nothing in body

please help

Ahsin

[buileminh]

$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]

where do you change the email body?

[lolo?]

where do you change the email body?

In the email template

[C Braithwaite]

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]

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?]

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

[C Braithwaite]

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]

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:


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

and replace with:


$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]

good work over here...

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

[Zia]

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]

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:


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

and replace with:


$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]

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

[C Braithwaite]

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

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

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]

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

[WEBDosser]

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

[Robru]

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

[WEBDosser]

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]

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]

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

Edit: nevermind.

[WEBDosser]

mind clicking "install" then? ;) lol

but glad to see it's effective!

oops..:o clicked now. :)

[djbaxter]

In the product XML file, what is this:

<phrase name="setting_frequency_desc" date="1171120632" username="Chris" version="1.0.0"><![CDATA[How often to send a reminder email once a member has become inactive.]]></phrase>

Who is "Chris"?

[C Braithwaite]

In the product XML file, what is this:



Who is "Chris"?

That would be me.

[Chadi]

I just installed, manually ran scheduled task "emailreminders" and for some reason it only sent to about 20 people. I have 7,300 members and many have not logged in for a long time. How can this be?

[rezapci]

thanks for hack, but dude, how this ting works? I just installed it, what should I do next?

I cant find any Option on vbOption!

[carpefile]

Thanks a ton! Works a charm! *Installs

[Chadi]

This makes no sense. It even emails banned users. Please fix that. Thank you.

[djbaxter]

It even emails banned users.

Yeah, that would not be good.

"We miss you. Please come back."

"Oops! You're banned. Just joking! :D"

[rezapci]

Yeah, that would not be good.

"We miss you. Please come back."

"Oops! You're banned. Just joking! :D"

hahahahah , what A JOKE :D

But how can I fix the YOURSITE? how can I edite the msg?

[rezapci]

god, someone tell how to fix this, it keep sending this to all memmbers as:

We've noticed that you've not been active on mished for quite some time now, and we miss you!
Could we not tempt you back?
If you don't remember your password, you can request it here: http://www.mished.co.uk/forum/login.php?do=lostpw
We hope to see you soon

Kindest Regards
YOURSITE


What a unprofessional Hack Installations Directions

what the world you don't explain right to all user step by step what the heck we should do man.!

crab

[sdphotoforum]

Anyway to send a test e-mail to myself? Just to make sure everything is working right?

[sdphotoforum]

god, someone tell how to fix this, it keep sending this to all memmbers as:

We've noticed that you've not been active on mished for quite some time now, and we miss you!
Could we not tempt you back?
If you don't remember your password, you can request it here: http://www.mished.co.uk/forum/login.php?do=lostpw
We hope to see you soon

Kindest Regards
YOURSITE


What a unprofessional Hack Installations Directions

what the world you don't explain right to all user step by step what the heck we should do man.!

crab

Go to the Admin CP, Vbulletin Options, Inactive User Reminder E-Mails. You can edit it in there.

[djbaxter]

This makes no sense. It even emails banned users. Please fix that. Thank you.

Would this do it?

Find:

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

Change to:

$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND . TABLE_PREFIX . "usergroup != 20 AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND . TABLE_PREFIX . "usergroup != 20 AND emailDate < '$datetime[lastemail]' LIMIT $quantity");

[rezapci]

Yeah, that would not be good.

"We miss you. Please come back."

"Oops! You're banned. Just joking! :D"

Go to the Admin CP, Vbulletin Options, Inactive User Reminder E-Mails. You can edit it in there.

Thank you , he supossed to explain it in first place which is he didn't!:down: :down: :down:

[djbaxter]

What a unprofessional Hack Installations Directions

what the world you don't explain right to all user step by step what the heck we should do man.!

That's why I said earlier "not ready for prime time".

I think this addon has possibilities but it is just not ready for a live forum yet.

[C Braithwaite]

I just installed, manually ran scheduled task "emailreminders" and for some reason it only sent to about 20 people. I have 7,300 members and many have not logged in for a long time. How can this be?

it send emails out in small batches which can be amended in the options

thanks for hack, but dude, how this ting works? I just installed it, what should I do next?

I cant find any Option on vbOption!

it's there.

god, someone tell how to fix this, it keep sending this to all memmbers as:

We've noticed that you've not been active on mished for quite some time now, and we miss you!
Could we not tempt you back?
If you don't remember your password, you can request it here: http://www.mished.co.uk/forum/login.php?do=lostpw
We hope to see you soon

Kindest Regards
YOURSITE


What a unprofessional Hack Installations Directions

what the world you don't explain right to all user step by step what the heck we should do man.!

crab

I've given what i thought are ample instructions. upload, import, edit options. tell ya what - write you're own then eh?

Would this do it?

Find:

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

Change to:

$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND . TABLE_PREFIX . "usergroup != 20 AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND . TABLE_PREFIX . "usergroup != 20 AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
that is something i never thought of - i will update that in the php later today. cheers

[C Braithwaite]

Thank you , he supossed to explain it in first place which is he didn't!:down: :down: :down:

if you read the first post:



Ive updated the mod so all the settings are editable in the AdminCP


it's a simple plugin, not rocket science!

i designed it for my own forum, and it does the job i wanted it to do and i thought it may be useful for other people (which i might add, has beenk) so if anyone doesn't like it then just lump it.

[WEBDosser]

there are still some settings to change in product-remindermail.xml

Lines 61,64 & 68 need attention before uploading..

[Masiello]

Good idea, *clicked install*

[Masiello]

Hey, anobody can confirm please if this mod works too on a vB version 3.5.3?

[djbaxter]

that is something i never thought of - i will update that in the php later today. cheers

At the risk of telling you something you already know, I don't believe there is a "Banned" group by default in vBulletin - mine is ID=20 but it may be different for others so you'll need to make that a variable.

[Chadi]

I only want to email to usergroup ID 2 and 3. How can I set this up?

[carpefile]

At the risk of telling you something you already know, I don't believe there is a "Banned" group by default in vBulletin - mine is ID=20 but it may be different for others so you'll need to make that a variable.
I also got a parsing error when making that change. I only edited the usergroup to match my board's banned id.

@C Braithwaite- I'm not sure the cron job is running, it doesn't show in the log even though logging is enabled. It runs manually when you push the run button, but nothing in the log indicates it ran. I set it to run every ten minutes for 1 hour every night 100 mails per (just till it catches up with the 1500 or so inactive members, then will set it to run once weekly).

Also noticed there is no title, description, or log phrase listed in the scheduled task.

It may be running without making any log entries, I don't know.

Thanx again, once the bugs are ironed out, this will be extremely useful to a ton of peeps.

[djbaxter]

I also got a parsing error when making that change. I only edited the usergroup to match my board's banned id.

OK. Good to know. I haven't actually yet tried my suggested modification yet - my first attempt at installing the addon (original version) crashed my email server - my fault for setting the number of emails too high but I'm now waiting for some of these bugs to be fixed before I reinstall.

Can you tell me what the parsing error was? What did it object to?

once the bugs are ironed out, this will be extremely useful

It will indeed.

[carpefile]

unexpected t string error in line 19.

[C Braithwaite]

what i hope to do is create a list of usergroups and let you select which you send to.

i hope to iron out all bug, and ill look into the cron to see if it is running.

[bazzup]

installed tody and already got one lost member back good job

[djbaxter]

unexpected t string error in line 19.

Of course. Sorry - left out a quotation mark. Try this (my example excludes two member groups for my forums) and uses lastactivity instead of lastpost:

$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND ". TABLE_PREFIX . "usergroup != 20 AND ". TABLE_PREFIX . "usergroup != 23 AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND ". TABLE_PREFIX . "usergroup != 20 AND ". TABLE_PREFIX . "usergroup != 23 AND emailDate
< '$datetime[lastemail]' LIMIT $quantity");

Edit: Sorry - that SQL syntax is also incorrect.

My head hurts - any SQL gurus here?

[WEBDosser]

cool.. uninstalled and re-installed the new version, looks a lot better :)

[projectego]

Thanks for the update. :)

[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

[C Braithwaite]

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]

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]

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]

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

I was using 1,2,3,4

[djbaxter]

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]

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.

[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/plugin.php?do=productimport
Referrer : http://www.alshiatalk.com/vb/admincp/plugin.php?do=productadd
IP Address : 70.252.137.29
Username : alghadeer
Classname : vb_database

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

[C Braithwaite]

"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.

[C Braithwaite]

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

ive removed the onoff setting - i was attempting to make it so you could switch the plugin on or off. ill add that later.

[djbaxter]

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

I'll retry in a moment - got an error saying I couldn't access the download here.

By the way, I have the EZ Bounce add-on installed for other forum emails. For some reason, it didn't work with the bounced emails generated by your add-on. I made it work via the following edits to remindermail.php:

Find:

$headers .= "To: $username <$email>" . "\r\n";
$headers .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n";


Add after:

$bounceurl = $vbulletin->options['ezb_admincpurl'] . "/ezbounce.php?u=" . $userid;
$bouncestring = "<a href=\"$bounceurl\" target=\"_blank\">$bounceurl</a>";
$headers .= 'X-EZbouncer: ' . $bouncestring . $delimiter;


NOTE: This will fail unless you have the EZ Bounce add-on installed. It's a quick way to automatically uncheck "Receive emails from admin" for invalid email addresses, which you are invariably going to get eventually using this inactive users add-on.

[rezapci]

ive removed the onoff setting - i was attempting to make it so you could switch the plugin on or off. ill add that later.

I cant, I cant reinstall it I cant update it, it give me DB error

[PinkDaisy]

If we are updating this, do we re-install it entirely even if it seems to be working okay ??

[jordanjj]

If we are updating this, do we re-install it entirely even if it seems to be working okay ??

I was wondering the same thing. Best thing is to probably uninstall everything.. Make sure you remember all your information like the text in the email, then install the new one. Ill give it a shot.

[PinkDaisy]

I was wondering the same thing. Best thing is to probably uninstall everything.. Make sure you remember all your information like the text in the email, then install the new one. Ill give it a shot.

lol let me know then if that works for you!! I'll let you be the guinea pig on it!! haha

[jordanjj]

lol let me know then if that works for you!! I'll let you be the guinea pig on it!! haha


Yep, Installed it again. Seems to be working fine, ofcourse i wont know.. because im not receiving the emails. Don't see why it wouldn't work.

Seems Good :up: Love The Mod.. Already Getting Member's Back! :cool:

[projectego]

Thanks for the patch. :)

[C Braithwaite]

there is no update option (i dont know how to do that yet - im just learning vbulletin products!)

It would prrobably be best to uninstall/reinstall but remember your settings and male a copy of your email if you have changed it.

as soon as i figure out how to make an upgrade, then ill make it upgradable.

sorry about any inconvinience.

[rezapci]

there is no update option (i dont know how to do that yet - im just learning vbulletin products!)

It would prrobably be best to uninstall/reinstall but remember your settings and male a copy of your email if you have changed it.

as soon as i figure out how to make an upgrade, then ill make it upgradable.

sorry about any inconvinience.

good job, keep up your good work;)

[C Braithwaite]

Already Getting Member's Back! :cool:

Im so happy to know that it's actually working :D

I'd like to see how it affects a big board actually.... so if anyone has one and uses this, please let me know

[carpefile]

@C Braithwaite--Please add your updates to the original post. It gets confusing trying to figure out what I need to update and when.
It would also be helpful to know if I have to reupload the php or just overwrite the xml.
Cheers

[C Braithwaite]

@C Braithwaite--Please add your updates to the original post. It gets confusing trying to figure out what I need to update and when.
It would also be helpful to know if I have to reupload the php or just overwrite the xml.
Cheers

just let me know the format you want it in.

[carpefile]

Using this as an example;
History:
1.0.0
Initial Version for vBulletin 3.5

1.1.0
Added Rule(s) from URL
Fixed typo in Phrase

1.1.1
Fixed bug with new registration
-> to upgrade, import product-rulesagreement.xml and set Allow Overwrite to yes

1.1.2
Fixed bug with Reseting Rules every 12 hours
-> to upgrade, import product-rulesagreement.xml and set Allow Overwrite to yes

1.1.3
Fixed bug with with TABLE_PREFIX missing
-> to upgrade, import product-rulesagreement.xml and set Allow Overwrite to yes

Adding something along these lines would eliminate a lot of confusion and allow those wary of bugs posted in comments to see when they are resolved.

[s0lidgr0und]

How do I go about removing the link that this mod added to the footer of my board without permission or without notification in the description of the modification?

[C Braithwaite]

How do I go about removing the link that this mod added to the footer of my board without permission or without notification in the description of the modification?

uninstall the mod

AdminCP -> Manage Products -> Uninstall

[WEBDosser]

hmm.. i use a skin for my forum and it don't show that link, is that ok or do i have to have the link there?..

[C Braithwaite]

I'm not going to make a big deal about it if it doesn't show for whatever reason so dont worry about it, WEBDosser.
hmm.. i use a skin for my forum and it don't show that link, is that ok or do i have to have the link there?..



It annoys me however when people will download my code for their forum and then make demands of me, complain or wish not to give credit where credit is due.

[WEBDosser]

credit is given by clicking install.. however, i will edit the code for the emails sent out to include your link.. if that is ok with you?.

just IMO the footer is not a good place to force a link on someone website.

[djbaxter]

credit is given by clicking install.. however, i will edit the code for the emails sent out to include your link.. if that is ok with you?.

just IMO the footer is not a good place to force a link on someone website.

I don't see anything added in my footer but I agree with this. If an add-on affects the entire forum sitewide (e.g., Zoints SEO), I can see a footer link. But in general, I don't think it's appropriate.

I think the suggestion of adding a line or two at the bottom of sent emails is more appropriate.

[djbaxter]

How do I go about removing the link that this mod added to the footer of my board without permission or without notification in the description of the modification?

You don't seem to have the vBulletin copyright notice in the footer of your forum either.

[s0lidgr0und]

You don't seem to have the vBulletin copyright notice in the footer of your forum either.I never noticed it wasn't there. I simply had the font color and the background color set to the same color. I updated it - thank you.

I'm not going to make a big deal about it if it doesn't show for whatever reason so dont worry about it, WEBDosser.

It annoys me however when people will download my code for their forum and then make demands of me, complain or wish not to give credit where credit is due.It annoys me when people hide advertisements for their own site in a simple modification that my regular members will never even see due to the very nature of the modification.

uninstall the mod

AdminCP -> Manage Products -> UninstallI'll just edit it out, I found where it's been added. I don't think it would kill you to simply stick a sentence in the description of the mod stating that you'll be advertising for free on the site of whoever downloads and installs it. Seems like a slight lack of integrity.

[C Braithwaite]

an install doesn't benefit me, but a link on a site does as google will spider it and boost my pr

I can't stop people from editing it out.

but I coded it, I coded it my way, and if people choose to use my code then they can either accept the link or edit it out themselves.

as for putting a link in the emails that is not needed. a nice little discrete link at the bottom of the page will be sufficient.

now I will not discuss this further.

any suggestions or bugs feel free to comment

[djbaxter]

It annoys me when people hide advertisements for their own site in a simple modification that my regular members will never even see due to the very nature of the modification.

I'll just edit it out, I found where it's been added. I don't think it would kill you to simply stick a sentence in the description of the mod stating that you'll be advertising for free on the site of whoever downloads and installs it. Seems like a slight lack of integrity.

That seems a little harsh to me.

an install doesn't benefit me, but a link on a site does as google will spider it and boost my pr

I can't stop people from editing it out.

but I coded it, I coded it my way, and if people choose to use my code then they can either accept the link or edit it out themselves.

Your choice, I suppose, and you're correct - those who object can edit it out. You might want to know, though, that it doesn't seem to be working - I don't see a link even in the vBulletin default theme and I haven't edited anything like that out of your add-on.

[s0lidgr0und]

I wasn't being harsh, I was being honest. I've only been doing this for two years but I've never known any of the other mods I've downloaded to chimp in a plug for themselves, especially without notifying the installer that they'd be doing so. I edited it out because I think it looked terrible. The modifications I have to my board aren't any of my members' concern nor will I allow it to be used as spider food to boost his site.

Dj, the link shows up way at the bottom near the JelSoft information.

[djbaxter]

Dj, the link shows up way at the bottom near the JelSoft information.

No it doesn't - not on my forum. have a look for yourself: http://forum.psychlinks.ca

[C Braithwaite]

No it doesn't - not on my forum. have a look for yourself: http://forum.psychlinks.ca

dont worry yourself about it - honestly - it's not important.

[airborneCAL]

Do the groups specified have to be primary groups or can they be additional groups? Also, what if a user that would receive an email is a member of more than one group you specify in the admin panel - would they get more than one email?

[s0lidgr0und]

No it doesn't - not on my forum. have a look for yourself: http://forum.psychlinks.caLucky you.

[C Braithwaite]

Do the groups specified have to be primary groups or can they be additional groups? Also, what if a user that would receive an email is a member of more than one group you specify in the admin panel - would they get more than one email?

each member will only receive 1 email despite being a member of multiple. it will send out to them if they are secondary members of your specified usergroups.

does this cause a problem?

[airborneCAL]

each member will only receive 1 email despite being a member of multiple. it will send out to them if they are secondary members of your specified usergroups.

does this cause a problem?
I don't think so - my main concern was preventing duplication of emails based on multiple group memberships.

[SCRIPT3R]

unadvertised hotlinking/self-promotion is SPAM IMO... as much as i hate it, it's done rather often with hacks released here. i always just remove the occurance if i decide to use the hacks... AND rate negatively appropriately.

[djbaxter]

All this seems like a gross overreaction to me.

I think this is a useful add-on, bugs and all (which the author seems to be gradually working out). Between this and the EZ Bounce add-on, it has made the job of bringing back old members and deleting defunct members a whole lot easier. For that, the author should be commended.

I don't get the carping - if you don't like it, don't use it. Or create your own as a competitor. Or do as the author said and edit out the link if it shows up.

[C Braithwaite]

All this seems like a gross overreaction to me.

I think this is a useful add-on, bugs and all (which the author seems to be gradually working out). Between this and the EZ Bounce add-on, it has made the job of bringing back old members and deleting defunct members a whole lot easier. For that, the author should be commended.

I don't get the carping - if you don't like it, don't use it. Or create your own as a competitor. Or do as the author said and edit out the link if it shows up.

I like you.
Right attitude.

[Snake]

Haha I can tell you that he's an idiot. :D

Anyway, thanks for the update, C. Seems to work just fine for me.

[carpefile]

I kinda resent the "carping" reference:p

Seriously, this is one of the most useful hacks I've ever installed. I mean its no IbProArcade or VBA, but it has shown to be very effective in doing its job. In the last few days, my lately very slow board has had tons of renewed activity.
I credit this hack for it, and don't mind a little link at the bottom that for the most part only search engines ever even see. I mean if your users are constantly scrolling to the footer of your pages to see what copyright links and what not are there, your board has bigger issues to deal with (like perhaps a lack of more engaging content).
Thanks Chris, I give this a MOTM nomination.:up:

[WEBDosser]

hehe.. this is great

[C Braithwaite]

I kinda resent the "carping" reference:p

Seriously, this is one of the most useful hacks I've ever installed. I mean its no IbProArcade or VBA, but it has shown to be very effective in doing its job. In the last few days, my lately very slow board has had tons of renewed activity.
I credit this hack for it, and don't mind a little link at the bottom that for the most part only search engines ever even see. I mean if your users are constantly scrolling to the footer of your pages to see what copyright links and what not are there, your board has bigger issues to deal with (like perhaps a lack of more engaging content).
Thanks Chris, I give this a MOTM nomination.:up:


Thankyou. :D

[PinkDaisy]

I've had TONS of members come back because of this!! I love it and it really shows the community that you really do miss them around the boards - at least on my board members do!

[C Braithwaite]

I've had TONS of members come back because of this!! I love it and it really shows the community that you really do miss them around the boards - at least on my board members do!

I'm over the moon that people are not only using it, but finding it useful.

[djbaxter]

Great update, Chris.

One point: The add-on is set to "Active = No" by default. I almost missed this... I would suggest that the default should be "yes".

[s0lidgr0und]

unadvertised hotlinking/self-promotion is SPAM IMO... as much as i hate it, it's done rather often with hacks released here. i always just remove the occurance if i decide to use the hacks... AND rate negatively appropriately.Agreed. I'd be more apt to allow the link to stay there if there was an obvious link to every member's board that uses his hack. Only seems fair to me.

I did forget to mention in my rantings that I do think this is a good hack. I'm not sure if it works yet because I have no way to really test it out, but emailing these members is something I've always done manually and it'll save me the time it took to do that. Thank you.

[lolo?]

thanks for your update great evolution :)

[GCC LLC]

Hi, I have this installed and it's seemingly working correctly with the exception that I'm not receiving any emails. I set it to send out only to the Admin usergroup (group 7 in my case) based on last activity. I went into the AdminCP for another administrator I set up and set it's last activity to June of last year. Then I run the cron job and I don't receive the emails. Any ideas? I want to test it on myself before I add all of the regular usergroups. Thanks!

[JoeWho]

I installed your e-mail reminder and it works great. I have received several think use from people who have just forgot to check back in. :)

I do have a question: I have also received an e-mail from somebody who just joined saying they have received the notice also, how does this determine who will receive the notice and who won't?

I only signed up not more than a week ago! And this is the second email of this kind that I have received...
dg


I have it set:
Days of Inactivity: 30
Email Frequency: 15

Has anybody else had a problem with this? Or is my settings incorrect and causing the problem?

Thanks.

[ehsanix]

thank u very much

[C Braithwaite]

Great update, Chris.

One point: The add-on is set to "Active = No" by default. I almost missed this... I would suggest that the default should be "yes".

my reasoning was that i didnt want emails to be sent out before people had updated the template.

[C Braithwaite]

I installed your e-mail reminder and it works great. I have received several think use from people who have just forgot to check back in. :)

I do have a question: I have also received an e-mail from somebody who just joined saying they have received the notice also, how does this determine who will receive the notice and who won't?




I have it set:
Days of Inactivity: 30
Email Frequency: 15

Has anybody else had a problem with this? Or is my settings incorrect and causing the problem?

Thanks.


that is one thing that i thought might be a problem, and was my next update - sending emails to new users. ill fix that asap.

[GCC LLC]

I should add the following to my post above. Even though I have a user in my Admin group who has not logged onto the board since 2006, I get the following results when I run the cron job manually:

Inactive User Reminder Emails

Done

Looking at the php code, it appears that it should say:

Inactive User Reminder Emails

mailing test@test.com (done)

Done

but I don't see anything in between the lines even though clearly this test user i set up does qualify for a mail according to the parameters I set up..

[C Braithwaite]

Hi, I have this installed and it's seemingly working correctly with the exception that I'm not receiving any emails. I set it to send out only to the Admin usergroup (group 7 in my case) based on last activity. I went into the AdminCP for another administrator I set up and set it's last activity to June of last year. Then I run the cron job and I don't receive the emails. Any ideas? I want to test it on myself before I add all of the regular usergroups. Thanks!

you mean you are logging on as a diferent admin, setting your other account's lastactivity to june, and while on the second admin account running the cron resulting in no emails?

what is output when you run the cron manually - it should say who is being emaild?

[C Braithwaite]

I should add the following to my post above. Even though I have a user in my Admin group who has not logged onto the board since 2006, I get the following results when I run the cron job manually:

Inactive User Reminder Emails

Done

Looking at the php code, it appears that it should say:

Inactive User Reminder Emails

mailing test@test.com (done)

Done

but I don't see anything in between the lines even though clearly this test user i set up does qualify for a mail according to the parameters I set up..


i will have a look at it to see if i have missed anything.

[GCC LLC]

you mean you are logging on as a diferent admin, setting your other account's lastactivity to june, and while on the second admin account running the cron resulting in no emails?

That is correct. I basically set up a pseudo-administrator to test this out. Really, I just want to see what the email looks like and tweak it before it gets sent out to the 7,000 or so users that it's going to go to.

what is output when you run the cron manually - it should say who is being emaild?

See above post... There's nothing in between the lines... no one being emailed even though this userid qualifies for an email. Even tested it out on a non-administrator that i put into a "test group" and it still doesn't go out.

[C Braithwaite]

That is correct. I basically set up a pseudo-administrator to test this out. Really, I just want to see what the email looks like and tweak it before it gets sent out to the 7,000 or so users that it's going to go to.



See above post... There's nothing in between the lines... no one being emailed even though this userid qualifies for an email. Even tested it out on a non-administrator that i put into a "test group" and it still doesn't go out.

i am having the same problem - im just putting some debug info in there to test - ill get back to you.

[GCC LLC]

I just downloaded this hack about 2 hours ago if that helps you any.. Not sure when you put it up but whatever changed from the last version to this one seems to have broken something. :) Can't wait to try it out... Looks great, thanks for your effort!

[djbaxter]

my reasoning was that i didnt want emails to be sent out before people had updated the template.

Good point. I had forgotten but that is exactly what happened to me when I installed your first version.

[C Braithwaite]

Figured it out - when you install the plugin, it sets the last email sent by default to == the users lastpost date, not it's last activity. so even if you set the last activity and last post to sometime in the last month/year/whatever, it wont email the user until the frequency period elapses.

I will update the install query and release an update later tonight.

[obmob]

Great idea, hope it works on my site :)

Oh i shall wait for an update! :D

[morrow]

if you read the first post:



it's a simple plugin, not rocket science!

i designed it for my own forum, and it does the job i wanted it to do and i thought it may be useful for other people (which i might add, has beenk) so if anyone doesn't like it then just lump it.Frankly, I don't know why you're giving this guy the time of day. I haven't installed this hack yet but I'm getting ready to. If it works, Great! If not, then I ask questions and possibly get it to work. This guy has been nothing but RUDE, and I agree with you... If you don't like the mod, go build your own; but certainly don't come on here and bash a guy who has already gone out of his way with just building this hack. You should try asking questions and possibly learn something along the way instead of bashing him.

Constructive critisism is always healthy...

[GCC LLC]

Yeah, agreed. I can do my fair share of coding (and usually it's just enough to get me by...) and when I see people bashing a programmer it gets under my skin. If you don't like the results of a free hack, go pay for one. You shouldn't expect things for free in life. You should be grateful if something useful comes along for free.

[simalert]

After setting up I ran it manually from the vBulletin scheduled task manager and got the following error
Inactive User Reminder Emails

Warning: include_once(/home/simalert/public_html/forum/./includes/cron/remindermail.php) [function.include-once]: failed to open stream: No such file or directory in /admincp/cronadmin.php on line 108

Warning: include_once() [function.include]: Failed opening '/home/simalert/public_html/forum/./includes/cron/remindermail.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /admincp/cronadmin.php on line 108

DoneI thought it meant I hadn't uploaded the remindermail.php file to the right place, but I checked and it's definitely in forum root.

Any ideas please?

Thanks

[simalert]

Just re-read instructions and realised that file shouldn't be in the root directory of my forum!

Sorry, carry on............. :)

[projectego]

Thanks for the new update. It works like a charm. Thanks! ;)

[djbaxter]

The latest version of this add-on (just installed this morning after receiving an update notice) is sending out emails to members with "receive admin emails" already set to off.

[deegan]

Haven't installed yet, but plan to...

Question : There are a couple of people that, although they are still members and can come back if they wish, I'd rather NOT have an email sent to them as if I'm inviting them back.

Although creating a new usergoup and placing them in there, then having the email stopped for that usergroup would probably work, is there a way (or could an option be created) that would allow me to imput members' names that I do NOT wish to have the email sent?

[cashpath]

Does this show up in the CRON logs when it is run? I have run it manually from the scheduled task manager and it seems to work fine, but I've had it installed now for over 24 hours and it is not showing anywhere in the CRON logs.

[GCC LLC]

works great now, thanks!

[djbaxter]

Does this show up in the CRON logs when it is run? I have run it manually from the scheduled task manager and it seems to work fine, but I've had it installed now for over 24 hours and it is not showing anywhere in the CRON logs.

I don't see any logs either.

The sending to members who have specifically unchecked "Receive Admin Emails" (see above) is potentially a significant issue. I don't want to run afoul of some spam blacklist.

[C Braithwaite]

I will fix the sending to opted out thingy in the morning

re: cron logs - it runs but doesn't log don't know why sorry.

re: excluding users - like you said about setting up another usergroup is prob the best way for now. I will look into setting up some sort of individual user setting.

ill put this all down to inexperience with vbulletin =P

[djbaxter]

Thanks, Chris.

[Gazer]

Just installed thanks chris

Regards Gazer

[aj8690]

Thank you!!! I really like this! :D

[Morrus]

Nice idea! I've installed it, but get the following error (same as someone above, but the file *is* in the right place; the /includes/cron/ directory). Any ideas?

Warning: main(/www/circvsmaximvs.com/production/htdocs/./includes/cron/remindermail.php) [function.main]: failed to open stream: No such file or directory in /admincp/cronadmin.php on line 108

Warning: main() [function.include]: Failed opening '/www/circvsmaximvs.com/production/htdocs/./includes/cron/remindermail.php' for inclusion (include_path='.:/usr/local/lib/php') in /admincp/cronadmin.php on line 108

[cashpath]

My scheduled tasks stopped running do to this.....

I have no idea how to figure out what it was that caused them to stop running but I know disabling this allows them to work and enabling it breaks the scheduled tasks.

I'de like to use this hack but need my scheduled tasks to work..

[Greek76]

How do you know if actually send out the emails? Im kind of naive with it Ill admit. I installed it, fixed the options to my liking. Then I went to schedule task manager and clicked to run the reminder inactive users now. So is that suppose to send out the emails immediately if so I dont see anything happening? Thanks

[djbaxter]

How do you know if actually send out the emails? Im kind of naive with it Ill admit. I installed it, fixed the options to my liking. Then I went to schedule task manager and clicked to run the reminder inactive users now. So is that suppose to send out the emails immediately if so I dont see anything happening? Thanks

Running the cronjob manually, you will see a list of any emails sent out (i.e., for members who meet your criteria for inactive) followed by the word "Done". If no members meet the criteria, you should just see the word "Done".

[bada_bing]

I would like to install this mod on my 3.5.3 site,, Will this 3.6.x version work?

[bada_bing]

Another question what does this feature do "Email Frequency" can someone tell me in more details what this does exactly?

[djbaxter]

Enter the number of days you want to elapse before any subsequent reminder emails are sent out.

For example, on my forum I have it set to identify someone as inactive after 90 days of no activity. After that, it will send out a reminder email every 30 days - so I entered 30 in that box.

[djbaxter]

The latest version of this add-on (just installed this morning after receiving an update notice) is sending out emails to members with "receive admin emails" already set to off.

I will fix the sending to opted out thingy in the morning

Any update for this issue yet, Chris?

[C Braithwaite]

Any update for this issue yet, Chris?

sorry i cant find where the setting is stored...

as soon as i find it ill update it.

[DeMagH]

Pretty easy to install:
To install, upload remindermail.php to your ./includes/cron/ dir, and import the product xml
Options are in admincp options menu, where you should edit the settings.

that's what is mentioned in the text file i downloaded with the hack, doesn't seem as complicated as the marks above indicated. Just a simple one file upload and no template changes done by users at all, should clarify this in the first post.

just an advice for ppl out there, i was doing this manually for inactive users and i got some responses in new threads stating that "we trusted your website with our email addresses, you shouldn't be threatening us with your emails and some other users reported it as spam "which will cause huge forums to collapse ASAP as most hosting service providers don't allow spam, so they may stop your hosting plans for the violation of one of their policies" i myself got a warning before i stopped sending emails to inactive users"

Requesting a feature in this hack:
-To have a link within the email msg stating if you don't want to receive this email again please "click here", to unsubscribe the user from such mailing list if he desires, will protect us all from being reported as spammers.
-To have the ability to allow/disallow forum users from setting pre-reminder time.

Finally:
thanks for the hack, pretty good idea to have this managed automatically.

[djbaxter]

just an advice for ppl out there, i was doing this manually for inactive users and i got some responses in new threads stating that "we trusted your website with our email addresses, you shouldn't be threatening us with your emails and some other users reported it as spam "which will cause huge forums to collapse ASAP as most hosting service providers don't allow spam, so they may stop your hosting plans for the violation of one of their policies" i myself got a warning before i stopped sending emails to inactive users"

Requesting a feature in this hack:
-To have a link within the email msg stating if you don't want to receive this email again please "click here", to unsubscribe the user from such mailing list if he desires, will protect us all from being reported as spammers.

That's quite easy to add in the Admin options in the existing mod. Just create your email content to include the link. Mine provides specific details:

<p>Hello, $username!</p>
<p>It's been some time since your last visit to $bbtitle.</p>
<p>You might be interested in having another look. We have added several features and enhancements to the forums, as well as many new members and new topics added every day.</p>
<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>
<p>You can now keep up to date with new topics at $bbtitle by subscribing to the Psychlinks Forum Newsletter. Click on your <a href="http://forum.psychlinks.ca/usercp.php"User CP</a> link in the top navigation bar of any forum page and select < href="http://forum.psychlinks.ca/profile.php?do=editoptions">Edit Options</a>. Then scroll down to the Messaging & Notification section and check the box next to Subscribe to Psychlinks Forum Newsletter.</p>
<p>We hope to see you back soon.</p>
<p>&nbsp;</p>
<p>If you do not wish to receive further emails of this nature, please log into your UserCP at <a href="http://forum.psychlinks.ca/profile.php?do=editoptions">http://forum.psychlinks.ca/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>
<p>&nbsp;</p>
<p>Administrator</p>
$bbtitle
<p><a href="$homeurl">$homeurl</a></p>

-To have the ability to allow/disallow forum users from setting pre-reminder time.

Try the solution above. I think this option is superfluous and probably self-defeating. If it were included, I'd disable it. Just use a reasonable repeat interval, not shorter than once per month. And include the "unsubscribe" instructions in every email your forum sends out.

[DeMagH]

@djbaxter
thanks for the reply. Though, I don't want the user to disable receiving emails from admins because of the reminder. There are account deletion notices, banning notices and finally warning notices i am sending to the whole usergroup whenever a user of the usergroup violates the forums rules. I don't want a bunch of users to disable receiving emails from admins just because of the reminder, i kinda want it to be separate, i don't know if this is clear enough or not.

About the 2nd point, you misunderstood me as i wasn't clear enough, I want the user to have the option of setting the time to a week/2 weeks/1 month/2 months/3 months/6 months from his profile, not totally disabling the reminder, some users though won't be able to set this time so the emails sent to them will take the default period set in the hack options.

the 2nd point is not that important but i think my forums might benefit from such a feature.

[criscokid]

I would like to install this mod on my 3.5.3 site,, Will this 3.6.x version work?
Will this mod work on 3.5.x?

[C Braithwaite]

Will this mod work on 3.5.x?

dont see why not - try it?

[Tom_S]

Quick question.
After installing it worked perfect. I then re-ran it manually again a bit later after chaning the time frame from 7 days and it now is showing this:

Inactive User Reminder Emails

mailing example@yahoo.com (failed)
mailing example2@sbcglobal.net (failed)
mailing example3@centene.com (failed)

Done

Those are examples of course of email addresses.

Does this check for validity of email address and this could cause it or am I looking at a host problem?

Thanks

[C Braithwaite]

Quick question.
After installing it worked perfect. I then re-ran it manually again a bit later after chaning the time frame from 7 days and it now is showing this:

Inactive User Reminder Emails

mailing example@yahoo.com (failed)
mailing example2@sbcglobal.net (failed)
mailing example3@centene.com (failed)

Done

Those are examples of course of email addresses.

Does this check for validity of email address and this could cause it or am I looking at a host problem?

Thanks


you will get a failed if for whatever reason the php mail command fails.

i really couldn't speculate as to why

[Tom_S]

So it isn't checking for the email account being valid then so it has to be my hosting messing with sendmail again.

Okay...thanks :)

[Jafo232]

Ideally, it would be nice if this hack also allowed an option to delete a user after X notifications and no activity (or posts).

Edit: or at least move them to another usergroup..

[cashpath]

Edit: or at least move them to another usergroup..

That would be a great addition..

[Tom_S]

Absolutely! :)

[djbaxter]

Ideally, it would be nice if this hack also allowed an option to delete a user after X notifications and no activity (or posts).

Edit: or at least move them to another usergroup..

That would be a great addition..

Absolutely! :)


Use this add-on in combination with the EZ Bounced Email Management add-on by Antivirus (https://vborg.vbsupport.ru/showthread.php?t=138884) and you'll have exactly what you request. That's the setup I'm using now... :)

[Jafo232]

Use this add-on in combination with the EZ Bounced Email Management add-on by Antivirus (https://vborg.vbsupport.ru/showthread.php?t=138884) and you'll have exactly what you request. That's the setup I'm using now... :)

Not really, because you are just relying on bounced emails to actually mean something..

[ktp101]

installed, will see how this goes, in the first hour of having it on 3 members i havent seen for a long time appeared back.

so i'd say a successful addition.

[djbaxter]

Ideally, it would be nice if this hack also allowed an option to delete a user after X notifications and no activity (or posts).

Edit: or at least move them to another usergroup..

Use this add-on in combination with the EZ Bounced Email Management add-on by Antivirus (https://vborg.vbsupport.ru/showthread.php?t=138884) and you'll have exactly what you request. That's the setup I'm using now... :)

Not really, because you are just relying on bounced emails to actually mean something..

:confused:

Bounced emails usually do mean something, although it may not necessarily mean the address is invalid. What EZBounce does is:

1. allows you to inspect the reason the email was returned before taking action, so if no action is necessary (e.g., mailbox full) you do nothing

2. places a link in the bounced email that when clicked can move the user into a special user group (I set up one called "Inactive"), which is what you requested - then if you wish you can periodically prune members of that group

3. sets "Receive emails from Admins" to "off" so that you can at least exclude that group from mailings of newsletters, etc.

[djbaxter]

Chris:

The following string sets "Receive Admin email" to "ON":

UPDATE " . TABLE_PREFIX . "user SET options = options + 16 WHERE NOT (options & 16)"

You should be able to query the database using that to determine whether to send out the reminder email.

[Ignicoccus]

Looks like a great mod for bigger boards !
Is it possible to send a reminder to moderators or admins so they know who has been reminded ?

[Hemanth]

Hi,

Thanks for this great hack.. But the emails sent by this hack is not sending HTML emails. HOw to make the mail HTML. Now it's just showing the HTML code.

Also please add an option to set the Sender email ID.

[criscokid]

But the emails sent by this hack is not sending HTML emails. HOw to make the mail HTML. Now it's just showing the HTML code.
Please can you do a screenshot of how the email looks.

[criscokid]

I don't see this mod in the 'scheduled task manager' - what triggers the script?

[djbaxter]

Hard refresh your Admin CP and look again.

It should be there under "Inactive User Reminder Emails".

If it isn't, it's not installed correctly.

[criscokid]

It should be there under "Inactive User Reminder Emails". If it isn't, it's not installed correctly.
It's not there... which means my question (does this work on vb3.5.x?) has been answered...

No it doesn't work on vb3.5.x :(

[ThorstenA]

Will this product not send mails out to users who do not want to receive mails from administrator?

[djbaxter]

Will this product not send mails out to users who do not want to receive mails from administrator?

At the moment, it does not check to see whether the user has Admin emails unchecked. I believe Chris is working on that.

It's the last major drawback to an otherwise great add-on, in my opinion.

[ThorstenA]

At the moment, it does not check to see whether the user has Admin emails unchecked. I believe Chris is working on that.

It's the last major drawback to an otherwise great add-on, in my opinion.

After this is integrated, I am considering installing this product. If users vote for "no" in meaning of getting no mails from me, I should not send mails to them.

[newbe_haselina]

Thanks for this mod :) It's a real good one.

I had no problems installing it and it seems to work perfectly on my side.

[Hemanth]

Please can you do a screenshot of how the email looks.

It just looks like the HTML code. I used your default message for testing. It shows all the HTML code as text in emails & not in HTML form. So i am using a text only custom message now, but it'll be great if i could send real HTML mails.

[akulion]

he nice stuff :D thanks

[perfphysio]

This mod is great but the admin insttructions are a bit vague, e.g.

How often does this run? Is it once a day?, once every few hours?
Does it keep running in bunches of emails as set in the admin "Email Quantity" until all are sent?
Once it has sent this to someone how long will it wait until it sends it to them again if they do not revisit. I would like it to send it again for them but how long does it wait in between sends to the same person? This might be part of the email frequency setting. is this number a number of days between resends to the same user?

Overall a few more instructions in the admin would be a real help. I am getting a few people email me back annoyed that they have received the email a few times in the first week and I am not exactly sure what the settings are doing entirely.

Thanks again for a great hack, just a bit more prompting would be great.

[djbaxter]

Check your Scheduled Tasks console and set up the frequencies there.The defaukts are way too frequent and should be adjusted ionce it's working. I have mine sent to 90 / 60 - remind after 90 days, don't remind again for another 60 days.

[carpefile]

Really need to get the cron log working with this hack. It makes it impossible to really know who this hack is sending mail to and when

[djbaxter]

We need to get the "don't send emails to members who have deselected 'Receive emails from Admins'" issue fixed first, unless you relish getting on a whole lot of antispam blacklists.

[newbe_haselina]

Check your Scheduled Tasks console and set up the frequencies there.The defaukts are way too frequent and should be adjusted ionce it's working. I have mine sent to 90 / 60 - remind after 90 days, don't remind again for another 60 days.

I'm sorry for asking mayby silly questions, but how can I adjust the frequency like this in the scheduled tasks? It's the first time I do something with scheduled tasks and as I can see, I only can adjust the day of the month, the weekday and the time (h/m/s) ... my wish would be remind after 60 days, don't remind again for another 30 days ... can anybody help?

Thanks in advance,
sabine

[Dihnjo]

thanks u so much! hope the instal goes perfect :)

[djbaxter]

I'm sorry for asking mayby silly questions, but how can I adjust the frequency like this in the scheduled tasks? It's the first time I do something with scheduled tasks and as I can see, I only can adjust the day of the month, the weekday and the time (h/m/s) ... my wish would be remind after 60 days, don't remind again for another 30 days ... can anybody help?

Thanks in advance,
sabine

First, go to Admin CP | vBulletin options | Inactive Users Reminder Emails

and set Days of Inactivity (mine is 90) and Email Frequency (mine is currently 30, i.e., every 30 days).

Then go to Admin CP | Scheduled Tasks | Scheduled Task Manager

and click on "Edit - Go" for Inactive User Reminder Emails.

Scroll down to where you see

Day of the Month *

Hour *

Minute * * * * * *

and decide how often you want this to run - note that "*" means EVERY day, hour, minute... and that is way too often.

I left day and hour set to * and changed minute to:

Minute 18 48 - - - -

where "-" means none, so this setting checks for inactive users every half hour at hh:18 and hh:48.

[newbe_haselina]

Thanks djbaxter ... that's what I was looking for :up:

I almost got it, the only thing I didn't understand was the email frequency ... it say "how often" and I thought it might be the amount of emails which will be sent. But now I got there 30 days ... and I changed the scheduled task as you proposed ... that makes sense to me :)

Thanks for helping ...

BTW ... since I installed the hack (6 days) I got 7 members "back" ;) ... we are a pretty tiny community and 6 members out of 136 inaktive users are alot :-). In total we have about 460 ... that's the reason why I like this hack ...

[simalert]

Just one thing, I had a couple of bounced emails come back which is fine as the accounts now seem closed. However one or two of the user names cropped up twice. It seems to suggest that this is sending out more than one email or looping round the list continuosly which would be classed as spamming or mail bombing people if that was the case.

Is this possible?

[djbaxter]

Just one thing, I had a couple of bounced emails come back which is fine as the accounts now seem closed. However one or two of the user names cropped up twice. It seems to suggest that this is sending out more than one email or looping round the list continuosly which would be classed as spamming or mail bombing people if that was the case.

Is this possible?

1. check your settings (see my post above)

2. check the content of the "duplicate" emails - they may not be duplicates at all but a second email sent by anoither part of the system or another add-on (are you using the EZ Bounced Emails add-on, for example?)

[ssvp]

This may have been asked already. But maybe the possibly of adding the following features:
Usergroups
Indicate which usergroups will be using this feature

Spam Removal (YES/NO)
Setting this to "Yes", allows the users to click a "REMOVE ME" link that will prevent future mailings.

Spam Removal Group:
Enter a Usergroup to move users to a inactive group

[SuperGLS]

I did not like the footer addition and therefore would like you donate some money instead. How can I do that? Let me know. Thanks, great hack.

[wildo69]

Great mod... *installed*

just a suggestion (as i didn't find it when searching this thread)
maybe add a button to the admincp options that can be used to send a "test" message to the admin/current admin so we can check the formating and appearance of the message before it gets sent to thousands of our members.. :)

thanks again

[Hemanth]

Hi,

1. Can you please add an option to set the sender email address as it's giving a hell lot of server info out.

eg.

Content-type: text/html; charset=iso-8859-1

To: Xtra <useremailq@gmail.com>
From: MyForum.com@web2.myhost.com, Community@web2.myhost.com,
-@web2.myhost.com, Technology@web2.myhost.com,
Computers@web2.myhost.com,
&amp@web2.myhost.com;Internet!Reminder Service
<admin@mysite.com>
Message-Id: <20070305201724.BBFD347056@web2.myhost.com>
Date: Mon, 5 Mar 2007 14:17:24 -0600 (CST)

2. Do i need to add any HTML email sending hacks to make this work as all the html code i'm putting is mail as itself. No formatting done. Is there any settings i need to change in vB?

Please respond.

[djbaxter]

I'm not the author of this add-on. I'm just a user.

[Hemanth]

I'm not the author of this add-on. I'm just a user.
Sorry my friend. It was a mistake. :)

[Battle_Ring]

I installed this but all the emails come back as unrouteable mail domain

[Chadi]

A good feature needed is ability to exclude members from receiving further notification. The only method now is to close their account.

[fifko]

Seems like C. was las active on 25. Feb 2007...

Hopefully he is just on some holiday :D


Great hack btw... once all the issues described in the last few pages are fixed, I will definitely go for this ;) .

Thanks

[djbaxter]

A good feature needed is ability to exclude members from receiving further notification. The only method now is to close their account.

Yes. That is the major remaining bug.

If Chris doesn't come back soon, I'll try to find a fix for this myself.

[Smoothie]

I have this clicked as installed, but I haven't yet. I hope the fix to "respect users email options from the site" comes soon.

[mollila]

Does this mod check that the user has given permission to receive emails from Administrators?

And does it provide a link to the website where user can change that preference?

[criscokid]

Really need to get the cron log working with this hack. It makes it impossible to really know who this hack is sending mail to and when

I'm not seeing any entries in the 'Scheduled Task Log Viewer' even though the mod is set as active - how can I be sure this mod is working?

[djbaxter]

Does this mod check that the user has given permission to receive emails from Administrators?

If you had read the thread, you would already know that the answer is "no, not yet".

And does it provide a link to the website where user can change that preference?

You can add such a link yourself by editing preference. At the bottom of the email text box, add something like the following:

<p>If you do not wish to receive further emails of this nature, please log into your UserCP at <a href="http://www.yourforum.com/profile.php?do=editoptions">http://www.yourforum.com/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>

The problem is that, until the script is fixed to abide by the "admin email" setting, clicking on such a link won't actually work.

I'm not seeing any entries in the 'Scheduled Task Log Viewer' even though the mod is set as active - how can I be sure this mod is working?

1. see comment above to mollila - the cron job does not create or write to a log file in the present version of this add-on

2. run the cron job manually - it will either give you a list of emails sent or just say "Done."

[Smoothie]

I know for a fact if I were to use this now in it's present state, members who had selected to not receive emails would be pretty PO'ed.

[criscokid]

run the cron job manually - it will either give you a list of emails sent or just say "Done."
I get a list that contains each user's email address:
mailing emailaddress@domain.com (failed)

What would be causing the 'failure'? What is it that's failed? caused 'failed' to be thrown up?

[djbaxter]

I know for a fact if I were to use this now in it's present state, members who had selected to not receive emails would be pretty PO'ed.

I agree. I was hoping Chris would return to update this but he hasn't apparently been back for a while. I'll see if I can figure it out when I get a moment.

[djbaxter]

I get a list that contains each user's email address:
mailing emailaddress@domain.com (failed)

What would be causing the 'failure'? What is it that's failed? caused 'failed' to be thrown up?

I'm not certain, to be honest. My first guess would be that there's something wrong with your email setup. Check with your host.

Alternatively, are those emails bouncing back to your admin address (or whatever address you use as the forum email address)?

What happens if you select one of those "failed" addresses and try to send a note directly from your email client?

[Smoothie]

When you get a bounced emails and I'm sure you will, is there a report that is generated to show you these failed addresses?

[djbaxter]

Generally, what you'll get is the original email returned to you, if the email is sent by your server. If not, you'll generally get at least a message from the destination indicating that your message could not be delivered.

[itsblack]

I get this error also:
mailing emailaddress@domain.com (failed)
But in fact, my email setup is correct, because the new member can receive the activation email.
My forum is set logging all of the mails, but for these "error" emails, they left even no mail-logs.
So there must be something wrong with this cron script, I think.

[ben_erhan]

I want to ask a question.

I have tried this lots of time but I could not get the e-mail.

I opened a new usergroup and I have send the e-mail to this group using scheduled task maneger ( Run Now), but I did not get any e-mail.

If it works or not how can we understand?

[djbaxter]

Can someone with a test forum (I know... I really need to set one up) try this:

Find in /includes/cron/remindermail.php:

if($vbulletin->options['reminder_posts']){
$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
} else {
$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");


Change to:

if($vbulletin->options['reminder_posts']){
// $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16 LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
} else {
// $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16 LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");

I believe this will send emails ONLY to members who have NOT set "Receive admin emails" to OFF.

[MPDesignZ]

Is there a way to single out members who do not want this mail sent to them? I have a client I installed this for who has members who have requested they be taken off this automatic list.

Thanks
MP

[C Braithwaite]

Hello all - sorry i've not been on here or done anything recently - i've been very busy.

Ill crack on with admin emails = no option.

cheers to djbaxter for assuming support of this mod while ive been away :)

[djbaxter]

Good to see you back, Chris! :)

Have a look at the attached - I think it works with "Admin emails" set to off but it needs further testing.

Edit: Never mind - I see you've already done this. :)

Attachment removed.

[C Braithwaite]

Good to see you back, Chris! :)

Have a look at the attached - I think it works with "Admin emails" set to off but it needs further testing.

hi - yeh, i read your post with the modification to the code, works fine except it needs to be on the update query also, or it will be updating the wrong members which would result in multiple emails being sent.

I've released an update anyway, and thanks' for the help with that.

[projectego]

Thanks for the 1.07 update! ;)

[MPDesignZ]

Thanks.

MP

[Smoothie]

Ok, so who has this running without any issues?

[Fungsten]

When I received the email it did show who the sender was. :confused:

[djbaxter]

Ok, so who has this running without any issues?

I do. What issues are you having?

When I received the email it did show who the sender was. :confused:

Why wouldn't it? The sender is the forum and whatever email address is listed as the official forum email address. If it didn't disclose the sender, the email would be blocked by most spam filters.

[Smoothie]

Check your logs for me please. According to the cron, it is suppose to log entries. I just sent out a test email batch, got the email, but the log says 'no matches found".

[Fungsten]

But not from this one.

I do. What issues are you having?



Why wouldn't it? The sender is the forum and whatever email address is listed as the official forum email address. If it didn't disclose the sender, the email would be blocked by most spam filters.

[Smoothie]

My test email shows who it is from.

[Fungsten]

I checked the settings in my live forum and it doesn't show up. :confused:

My test email shows who it is from.

[Smoothie]

I checked the settings in my live forum and it doesn't show up. :confused:In your email client, it does not show who this is from?

[djbaxter]

Check your logs for me please. According to the cron, it is suppose to log entries. I just sent out a test email batch, got the email, but the log says 'no matches found".

Oh yeah, sorry - you're correct - that part isn't working (yet).

[Fungsten]

It's only for my live forum though. From the test forum it is ok.

In your email client, it does not show who this is from?

[Smoothie]

Fungsten,

Not sure. I just sent out a test email on my live forum and when it arrived, it showed the "To:" and "From:" fields correctly filled in.

[Smoothie]

Oh yeah, sorry - you're correct - that part isn't working (yet).Would be nice to get these logs working so we can see what's happening with this cron job.

[Smoothie]

Requesting a small addition. The ability to send a test email message, to the email address of the website. Possible?

[Luky]

Please add an option for the admin e-mail thing..

[Smoothie]

Ok, I'm editing this post because I've been doing some testing and I seem to have a problem. The email isn't always getting sent. I've narrowed it down to the cron not running. If I click run now, it seems to send the email. If I let it run by itself, it's not sending. I have the dron set to run every 30 minutes.

[thincom2000]

This hack brings back at least 1 member PER cron run. ^_^

However, these email reminders are being bounced when sent to users with AOL email addresses. You may need to work on the headers to get past AOL's bouncer, because I have not had issues sending my newsletters to these same addresses.

[Smoothie]

Update: Seems to sending fine now.

[C Braithwaite]

I'm really not sure about the cron logs - way out of my depth on that one. maybe it's something small i have missed out?

[C Braithwaite]

fixed

[kingvillain]

Thanks for the update :)

[Smoothie]

Woo-Hoo!

[Luky]

Blonx Lol R U Teh Spammar?!?!1

[djbaxter]

Blonx Lol R U Teh Spammar?!?!1

:confused:

Huh?