Inactive Users Email Reminders For 3.7.x

[Skyrider]

Awesome, trying this! :D

PS, why is "(COPPA) Users Awaiting Moderation" being automatic tagged when I selected not to use it under "Which usergroups do you want to monitor for inactivity?".

And when I attempt to send a test email, I get the following database error:

Database error in vBulletin 3.7.3:

Invalid SQL:
INSERT INTO mailqueue (dateline,toemail,fromemail,subject,message,header ) VALUES ('1226396466','Skyrider@esforces.com','Skyrider@es forces.com','We Miss You!!','<p>Dear Test User</p>

<p>We miss you. Our website is not the same without you. Come back and join in the fun?</p>

<p>Kindest Regards<br/>
The Team
<a href=\"xxxxxxxxx\">Earth\'s Special Forces :: Forums</a></p>','MIME-Version: 1.0
Content-type: text/html; charset=iso-8859-1
To: Test User <Skyrider@esforces.com>
From: Earth's Special Forces :: Forums Reminder Service <Skyrider@esforces.com>
Return-Path: Skyrider@esforces.com
X-Remindermail-BounceId: 0
X-Remindermail-BounceSalt: TST
');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Special Forces :: Forums Reminder Service <Skyrider@esforces.com>
Return-Path' at line 1
Error Number : 1064
Request Date : Tuesday, November 11th 2008 @ 03:41:06 AM
Error Date : Tuesday, November 11th 2008 @ 03:41:06 AM
Script : xxxxx/forum/admincp/remindermail.php?do=test
Referrer : xxxxxxx/forum/admincp/remindermail.php?do=sendtest
IP Address : xxxx
Username : FF|Skyrider
Classname : vxxx
MySQL Version : 5.0.51a-community

Another small problem. While it sends out the email correctly to inactive users, the name where the email comes from shows rather odd (Skyrider @ esforces.com <- how it shows), check the attachment. How do I solve this and or change the name?

[Skyrider]

Also, will this work if I use cpanel 11, but google domain mail for all my emails?

[Skyrider]

Any updates on this?

EDIT, I see the problem... The "Email From" in the settings is incorrect. It uses both email names and email as my attachment above.. if I change it to "ESF Forum" for example, the name and email will be the same. Which should be incorrect! Please fix this issue, as I love this plugin.

[RedTrinity]

I can't seem save the usergroups I want to send reminders out to. So, after I select which usergroups to send and click "save", it says "saved", then all the usergroups come up blank.

VB 3.7.4. It also didn't work with 3.7.3. TIA.

It still works, even though it appears to have not saved. I reported the same thing a while back and the developer assured me the groups were still saving, sure enough he was right :)

[Skyrider]

I'm sorry, but I waited for days so I'm not sure if the author of this plugin is busy or doesn't support it anymore. Even my private message has not been responded to yet. While this is a great plugin, it has a lot of issues. I can't even get the bounce to work, plus it has name issues as well.

[Sweeks]

I had some php warning to do with VBSeo in the admin cp after installing the product. It disappeared after disabling, then enabling it again. :S
________
Vaporizer Pipe (http://vaporizers.net/vapor-genie)

[Skyrider]

Found the issue. The name of the board was "Earth's Special Forces", the ' in it was breaking it giving mysql errors. Can you solve this issue if possible?

[joh]

can this work on 3.8

[Angel-Wings]

Can you solve this issue if possible?

Problem is that the MySQL commands aren't parsed correct so ' that "signs" the end of a value let MySQL think the entire Query ends here. Everything behind will produce an error.
Maybe - with weird some Email- / Board- or Username some injection can be possible.

About the sent mails - maybe a good idea to add an X-Mailer value as well that Antispam systems won't "jump" on the mail with a false-positive.

In "remindermail.php" something like:


$headers .= "Return-Path: " . $vbulletin->options['reminder_fromemail'] . "\r\n";
$headers .= "X-Mailer: Vbulletin Mailer\r\n";
$headers .= "X-Remindermail-BounceId: $userid\r\n";
$headers .= "X-Remindermail-BounceSalt: $salt\r\n";


Should do it.

[Skyrider]

Problem is that the MySQL commands aren't parsed correct so ' that "signs" the end of a value let MySQL think the entire Query ends here. Everything behind will produce an error.
Maybe - with weird some Email- / Board- or Username some injection can be possible.

About the sent mails - maybe a good idea to add an X-Mailer value as well that Antispam systems won't "jump" on the mail with a false-positive.

In "remindermail.php" something like:



Should do it.
Thanks, I'll try that :).

[Skyrider]

For some reasons, multiple people said it send them an email over 15x (of the same email). Any idea what might have caused that?

[snoopy5]

Hi

I would like to use this plugin. However I use already the "EZ bounce management" plugin. My questions is now:

Can I use this plugin nevertheless and just ignore the following install instruction step because I use already EZ bounce management?

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.

Would the inactive user reminder plugin then still work properly?

[snoopy5]

Hi

I would like to use this plugin. However I use already the "EZ bounce management" plugin. My questions is now:

Can I use this plugin nevertheless and just ignore the following install instruction step because I use already EZ bounce management?



Would the inactive user reminder plugin then still work properly?


Anybody?

[cassis2k]

Great, thanks a lot ^^

[ysbet]

hi,
my CP11 show the attach img, so I setup "pipe to a program" :
|/usr/local/lib/php /home/xxxxxx/public_html/forum/bounce.php

is it right?

king regards
ysbet

[Yosef Sh]

i get this error via mail

Database error in vBulletin 3.7.4:

Invalid SQL:
INSERT INTO mailqueue (dateline,toemail,fromemail,subject,message,header ) VALUES ('1229888870'.......

and the forum stop to work

[Fungsten]

It keeps checking usergroups that have been previously unchecked.

Disabled for now.

[TerryMason]

I've had to uninstall it until the VBseo stuff is sorted out.

[Vinyljunky]

For some reasons, multiple people said it send them an email over 15x (of the same email). Any idea what might have caused that?

My users have just started complaining that they are getting 100 or so of these messages

Ive recently upgraded from VB3.7 to VB3.8 and gone from SMTP to PHP Sendmail

Sadly I will have to disable this mod or my users will kill me :o

Can anybody help?

Thanks

VJ :confused:

[fattony69]

I have vbseo and this going. It works fine.

[psychotica]

This plugin is crashing my database, also is very server intesive i get very high server load i need to uninstall.

[kevbentz]

Where is the setting that determines when this runs?

I don't see anything in the scheduled task manager for it, is there supposed to be an entry there?

[gopherhockey]

I had to remove this mod. For some reason people complain about getting dozens of emails when this thing is on. I'm going to try see if the older version is available - never had that problem before.

[relaxiha]

hello
does not work on 3.8.x ?

[dirtycrow]

hello
does not work on 3.8.x ?
wondering the same.

[Leo Brazil]

Despite of people complaining a lot about this mod such as sending lots of reminders to same users at the time.

I've been using the lastest version here on 3.8.0 without any problems at all.

[eh69]

Where i must set this:
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.?

[vitrag24]

i suggest you to associate this mod with vbexperience mod in next updates.
thx.

[MikesSite]

I am using this perfectly fine w/ 3.8.2. Thanks

[Sworm]

There's some knowed incompatibility with Cron based Email sending?
https://vborg.vbsupport.ru/showthread.php?t=201318

[dfc005]

Pity mods such as this with high potential are left to rot.

[Brandon Sheley]

I think the setting is off on my site, it set to send a notice if the user doesn't visit for 3 months, but I get some every now and than saying they visit every day and get the notice

I may have to disable this one again :(

[shervin_dvb]

Hi Dear Thank's For This Mod (Inactive-User-Reminder-Emails-1.2.8.zip)
Don't Support HTML AutoMatic Send EMail to user
But Manuelly Send Test Email It's Ok
I'm Use uft-8 Encoding For Send Email .

Please Answer Too Me the solved This Problem

For example :
سابدارا? ا?را? ?+ض?ر ?داشت?د ? ?…ا ا?+ساس د? ت?گ? برا? ش?…ا کرد? ا??…

? ت??… ?…د?ر?ت? سا?ت ? د?گر د?ستا? کا?…?ا ?…شتا? د?دار ش?…ا در سا?ت ?ست?د

اگر ش?…ا ک??…? ر?…ز خ?د را از ?اد برد? ا?د ?…? ت?ا??د با ?…راجع? ب? ???ک ز?ر ک??…? ر?…ز جد?د? را درخ?است ??…ا??د

Im Useing 3.8.2 VB

[jejuarez8]

anyone know why I am getting this message when an email is trying to be sent to a user?

We tried to email the following users, but their email address was invalid

It happens every time, even my own emails.

[imported_silkroad]

Hello!

We upgraded from 1.1.1 to 1.2.7 and wish we didn't. I am going to remove 1.2.7 because there is no vB crontab function and we can't control when the messages go out anymore!!!

Ahhhhhh!

[imported_silkroad]

This plugin is crashing my database, also is very server intesive i get very high server load i need to uninstall.

Agreed.

We make a big mistake and upgraded from 1.1.1 to 1.2.7. I wish I didn't upgrade now!!!

I had to disable 1.2.7 because upgrading crashed our busy board!!!!

BEWARE!!

[marshal_ramdev]

thanks for this

[Crystal Shards]

Can you make this so we can check the version in ACP?

[Elenna]

I have a quick question about this mod. Are the notification emails sent AFTER the Inactiviy Period setting, or BEFORE? In my emails, I'd like to give someone a time frame (i.e. "You have 3 weeks..."), but I want it to make sense. :)

[M.C.]

Agreed.

We make a big mistake and upgraded from 1.1.1 to 1.2.7. I wish I didn't upgrade now!!!

I had to disable 1.2.7 because upgrading crashed our busy board!!!!

BEWARE!!

any changes since?

[Elenna]

Is there anyone that still uses this? I would like to know how to set my settings to time things like this:

- After 6 weeks (42 days) of inactivity, send the first email.
- After 8 weeks (56 days) of inactivity, send the second email.
- After 9 weeks (63 days) of inactivity, we will consider them inactive.

[dkobia]

I have about 60,000 users. This plugin has been killing my server by running heavy queries every few seconds. Not sure what the problem is - any advice? I've turned it off now, because the server had literally been brought to its knees.

[Mr.kakO]

to activate the plugins gives me database error will be the new version of vBulletin 3.8.4?

[SVTCobraLTD]

Installed on 3.6.11. Other system I had installed sent email to everyone, every month.

[RedHacker]

http://img44.imageshack.us/img44/4237/81795927.jpg

What are 30...? Why display nothing in first line....?

[Elenna]

Sorry, Red, I'm not sure! My first line is blank, as well. :(


Can anyone take a look at my question (quoted below) and see if they might be able to help?

Is there anyone that still uses this? I would like to know how to set my settings to time things like this:

- After 6 weeks (42 days) of inactivity, send the first email.
- After 8 weeks (56 days) of inactivity, send the second email.
- After 9 weeks (63 days) of inactivity, we will consider them inactive.

[SVTCobraLTD]

This working on 3.8.4?

[MarceloS]

It is expected to be at the bottom - as a little credit to myself. i would prefer it on the site, but i wont make a fuss about it being removed. if you disable the (if i remember correctly as i dont have access to the plugin at this moment in time) the "Required" plugin, that should disable the link.

Uninstalled. :down:

You should make this clear on your product description. Putting up a linkback on all pages without warning is spam practice imo. The fact that it only appears when user is logged out, and in the bottom of the website, is even worse because it shows your intention to pass undetected to admins. :erm:

If you had asked for it or warned about it you would get one linkback as I usually do, but as you tried to pass undetected it shows your bad intentions.

And users beware: google does not like links outside context of the website theme, and can punish you if it suspects paid links.

A shame. :down:

[djbaxter]

Uninstalled. :down:

You should make this clear on your product description. Putting up a linkback on all pages without warning is spam practice imo. The fact that it only appears when user is logged out, and in the bottom of the website, is even worse because it shows your intention to pass undetected to admins. :erm:

If you had asked for it or warned about it you would get one linkback as I usually do, but as you tried to pass undetected it shows your bad intentions.

And users beware: google does not like links outside context of the website theme, and can punish you if it suspects paid links.

A shame. :down:

1. You reeally are an ungrateful moron.

2. How is this in anyone's wildest imagination a paid link? How much did you pay for the product you installed that created the link?

[Haqa]

1. You reeally are an ungrateful moron.

2. How is this in anyone's wildest imagination a paid link? How much did you pay for the product you installed that created the link?

While I agree with you that you are due credit for your efforts (And having written a couple of vB products myself I know how hard it is), I still think you should have mentioned the link...

As for the "paid link" comment, I think google's criteria for promoting or demoting sites are largely "what they feel like on the day" coupled with "what you've paid them". Any link on a site, inside or outside of the main content, could be a "paid link", I don't think it's up to them to start determining what we put on our sites, nor do I care if they do...

Just my opinion. Still nice mod, appears to work well, thanks.

H.

[yahsuah]

Thanks for mod. It is working fine on vb3.7.3

[Akyeame Kwame]

Hello,

How do I change the email address that these emails are sent from?

[SVTCobraLTD]

How do i remove the copy write it adds to the bottom of the index page. I do not mind giving credit where it is due but to just add something to the bottom, I do not like that.

[M4r5h4ll]

cant we have a update of this mod for V4 ???

[Gene Steinberg]

cant we have a update of this mod for V4 ???

It's probably not worth the effort. It never worked properly for 3.7 or 3.8.

Peace,
Gene

[commoncents]

does this have an opt-out function? if so i can't find it

[Elenna]

I do not believe this version has an Opt-Out option.

[Silencer Groans]

Is it works with 3.8?

[mgurain]

Hi,
Does this work on 3.8.5 ? Is it server load safe ?

Thank,,

[TalkVirginia]

I'm currently working on a 3.8.x version of this.

[FreshFroot]

I'm currently working on a 3.8.x version of this.
any updates? Looks like something many 3.8 users could use without having to upgrade to vB4 :)

[TalkVirginia]

any updates? Looks like something many 3.8 users could use without having to upgrade to vB4 :)

my plan is to continue working on the 3.8 version soon as I finish the current 4.x version. You're right. I have vb users asking about this on 3.8 and 4.x quite a bit. :)

It's that pesky day job that gets in the way. ;-)

[TalkVirginia]

I've started working on a 3.8.6 update for this addon. I should have a release next week.

[FreshFroot]

I've started working on a 3.8.6 update for this addon. I should have a release next week.
Wow sounds great :D

Keep us updated :)

[MrAd]

Thanks Jim, looking forward to it

[Panzer Max]

Same here, keep up the good work. :up:

[enivid2008]

The plugin seems to be working but I get an empty first line with a zero on the stats page. I use 1.2.8 with vBulletin 3.8.7 PL2.