vb.org Archive - Mini Mods - Inactive Users Email Reminders For 3.7.x

Page 7 of 8

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Mini Mods - Inactive Users Email Reminders For 3.7.x (https://vborg.vbsupport.ru/showthread.php?t=188383)

AndyA

10-13-2008 09:08 AM

The mod is working great but is there a way to stop it emailing me ( admin ) every day with reports ? Thanks.

raubin

10-13-2008 04:36 PM

Wicked mod mate, very quick and easy install.

Cheers Richie

Hurricane

10-14-2008 06:35 PM

Anyone have this running on a Plesk server? I can't seem to get the pipe working.

saltedm8

10-15-2008 01:15 AM

This mod is sending out a reminder email to even those that only signed up today ( that have not posted yet ) ??

I have checked all my settings and they are fine.. anyone else getting this ?.. cheers

ikorolis

10-20-2008 08:30 AM

Hey ask you something strange happent to me

before using this Email reminder for inactive users 1.1.3 and send to me report

now use yours script and i select send reports but nothing send how to see report

only options have 1.2.8 to see

Inactive Reminders

Settings
Stats
Send Test Email
Emails Sent
Purge Logs

What for all the reports?

jluerken

10-23-2008 11:44 AM

As soon as I set a group here:

Quote:

Please Select Usergroups
Which usergroups do you want to monitor for inactivity?

I get an error message from vBSeo 3.2.0 on each admincp page:

PHP Code:


		
			
Warning: reset(): Passed variable is not an array or object in /path/httpdocs/forum/includes/functions_vbseo_seo.php on line 63

Warning: Invalid argument supplied for foreach() in /path/httpdocs/forum/includes/functions_vbseo_seo.php on line 64

neoxi

10-29-2008 07:08 AM

thank you.. installed :)

Haqa	10-29-2008 01:35 PM

This is a really cool mod (Install clicked) and I'm hoping it's going to keep my userbase active!

However (don't you hate it when someone says that?) I discovered a tiny bug in the"Global Bounce Headers" plugin. If a user has an apostrophe (single quote) in their email address the SQL SELECT statement blows up during account creation.

The fix is to quote $toemail with mysql_real_escape_string. This is the fixed plugin:

Code:

if(preg_match("/Remindermail/i",$headers)){

        $headers = str_replace('text/plain', 'text/html', $headers);

} else {

$result = $vbulletin->db->query_read("SELECT userid,salt FROM " . TABLE_PREFIX . "user WHERE email='" . mysql_real_escape_string($toemail) . "'");

$row = $vbulletin->db->fetch_array($result);

$userid = $row['userid'];

$salt = $row['salt'];

$headers .= "X-Remindermail-BounceId: $userid" . $delimiter;

$headers .= "X-Remindermail-BounceSalt: $salt" . $delimiter;

}

Love it to bits, thanks!

H.

Fungsten

11-10-2008 03:49 PM

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.

dmknights

11-10-2008 09:32 PM

***Installed***
Very useful. Thank you

Skyrider

11-11-2008 07:27 AM

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:

Quote:

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!!','Dear Test User

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

Kindest Regards 
The Team
<a href=\"xxxxxxxxx\">Earth\'s Special Forces :: Forums</a>','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

11-11-2008 02:52 PM

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

Skyrider

11-13-2008 06:20 AM

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

11-15-2008 04:26 AM

Quote:

Originally Posted by Fungsten (Post 1662972)

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

11-15-2008 09:14 AM

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

11-18-2008 01:08 PM

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

Skyrider

11-19-2008 07:46 AM

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	11-19-2008 11:24 AM

can this work on 3.8

Angel-Wings

11-19-2008 03:27 PM

Quote:

Originally Posted by FF|Skyrider (Post 1668520)

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:

Quote:

$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

11-20-2008 07:18 AM

Quote:

Originally Posted by Angel-Wings (Post 1668719)

Thanks, I'll try that :).

Skyrider

11-24-2008 10:49 AM

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

12-11-2008 09:24 AM

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?

Quote:

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

12-17-2008 03:42 PM

Quote:

Originally Posted by snoopy5 (Post 1682999)

Anybody?

cassis2k

12-17-2008 06:49 PM

Great, thanks a lot ^^

ysbet

12-20-2008 12:32 AM

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

12-21-2008 06:07 PM

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

12-21-2008 06:16 PM

It keeps checking usergroups that have been previously unchecked.

Disabled for now.

TerryMason

01-13-2009 12:46 PM

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

Vinyljunky

01-16-2009 01:56 PM

Quote:

Originally Posted by FF|Skyrider (Post 1671897)

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

01-16-2009 02:12 PM

I have vbseo and this going. It works fine.

psychotica

01-22-2009 03:51 PM

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

kevbentz

01-25-2009 04:21 PM

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

01-31-2009 02:55 PM

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

02-05-2009 11:26 PM

hello
does not work on 3.8.x ?

dirtycrow

02-08-2009 02:01 AM

Quote:

Originally Posted by relaxiha (Post 1735634)

hello
does not work on 3.8.x ?

wondering the same.

Leo Brazil

02-09-2009 04:12 PM

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	02-10-2009 10:42 AM

Where i must set this:

Quote:

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

04-20-2009 05:21 PM

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

MikesSite

04-27-2009 06:11 PM

I am using this perfectly fine w/ 3.8.2. Thanks

Sworm

05-01-2009 07:57 PM

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

All times are GMT. The time now is 12:19 AM.

Page 7 of 8

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01464 seconds Memory Usage 1,830KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_php_printable (11)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: