Administrative and Maintenance Tools - Cron Based E-Mail Sending

This modification is no longer available or supported.

In default vBulletin if you send a large number of e-mails, vbulletin either puts them in it's queue and then attempts to send them as each user visits a page, or just simply tries to send them straight away (This is the case when you use the Administrators email users inteface).

As a result of this your server can become seriously overloaded very quickly - so sending several thousand e-mails (like a newsletter) can become very difficult (hours spent clicking 'next' in the ACP) - as a result of these problems, this very simple modification was born.

This modification does two things ;

1. E-mails from the ACP inteface are sent to the mail queue, not straight to the mail system.

2. The processing of the mail queue is set-up as a vb cron item.

Obviously for this to work, you must turn on e-mail queuing in the ACP options - set 'Use Mailqueue System' to 'Yes', and 'Number of Emails to Send Per Batch' to a realistic value (based on the cron setting, as below).

There are two realisitc options for the cron job, you can either set it to run every minute, and set the items to be processed to something small (like 10), or you can do what this modification does by default and set it to run every 10 minutes, and set the items to be processed to something larger (like 100).

Remember, 10 per minute = 600 per hour, 100 per 10 minutes is also 600 per hour. The numbers really depend on how quick you want large queues processed, and how much your mail server can handle in one go.

Once working, when using the ACP mail users inteface, remember you can set it to process 9999 at once (not 500 or whatever) as the mails will now go into the queue, not be sent directly.

Note: This modification will affect any queued e-mails such as subscription e-mails. It will not affect registration e-mails as they bypass queuing anyway.

This modification includes the code by Antivirus that displays the current size of the mail queue (v3.7.002 onwards).

Version 3.7.003 has the option to add a small delay before each e-mail is sent (between 1 and 9 seconds). Use this option carefully.



History:

v3.7.001 : First Release for vB 3.7
v3.7.002 : Added mail queue size display code.
v3.7.003 : Added option for a delay between the sending of each e-mail.

[Mr-Mo3ath]

thats come to me
Database error in vBulletin 3.7.4:

Invalid SQL:

UPDATE datastore SET
data = data - 350,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, November 17th 2008 @ 05:34:20 PM
Error Date : Monday, November 17th 2008 @ 05:35:01 PM
Script : http://8888888/admincp/cronadmin.php...cron&cronid=24
Referrer : http://8888888/admincp/cronadmin.php?do=modify
IP Address : 8888
Username : *****
Classname : v888_Database
MySQL Version :

[wreckless]

I randomly check the queue and I see emails waiting to send. I think my registration emails are some how getting caught up. Is this possible?

[Paul M]

They are most likely subscription emails. Registration emails are not queued by vb afaik.

[Plasma2002]

Hey man, just wanted to say thanks. This is something that should be a part of vBulletin in the first place. Youve made my day easier as well as many others' im assuming.

Thank you

[axi]

hi how do i get it to send 40 an hour i tried adjusting settings in sceduled task settings for this but it still tried to send the full thing in 1 hour can anyone suggest please thanks??

[axi]

Originally Posted by axi

hi how do i get it to send 40 an hour i tried adjusting settings in sceduled task settings for this but it still tried to send the full thing in 1 hour can anyone suggest please thanks??

bump!!

[cellow]

Note: This modification will affect any queued e-mails such as subscription e-mails. It will not affect registration e-mails as they bypass queuing anyway.

This is not working 4 me. I looked up in the database and could see that every email is in the queue. Activation-emails, registration email :-(

How can i solve this problem?

[kinkarso]

Just installed it. I'm wondering, do I have to go to cpanel and create the cron job for this to function? ..

Can't seem to find the option to edit the number of emails to send / batch in cron, and the per minute settings.

[Paul M]

This runs via the vb cron system, not cpanel.

[MuTheMatrix]

Thanks a lot for this mod.