Awesome, trying this!
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?