vb.org Archive

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)

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!!','<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 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)
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 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)
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 :).


All times are GMT. The time now is 09:32 AM.

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

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01275 seconds
  • Memory Usage 1,747KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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