Administrative and Maintenance Tools - Cron Based E-Mail Sending

This modification is no longer available or supported.

This is a 3.6 specific port of the 3.5 Modification.

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.


Upgrading from the 3.5 version.
If you have the 3.5 version installed then you don't need to upgrade - however if you decide to upgrade then you need to delete the current cron job in the Scheduled Tasks Manager and then import the product xml via the ACP Product Manager. The file edits do not need to be changed.


Queue Size

Antivirus has posted a nifty little addon that displays the current size of the mail queue here.



History:

v1.12 : First Release for vB 3.6.

[Paul M]

Originally Posted by Masiello

Number of Emails to Send Per Batch to 6, this presume that process sending 6 email per minute, it is right?

Nope, it will send 6 e-mails every 10 minutes.

Originally Posted by Masiello

when sending the email for all users, for example 600 users, it is possible to close my session from admincp to finish the sending process or I have to waiting logged in total time?

You do not need to stay logged in, it will process the list straight away (just step through the pages) - the e-mails go into the e-mail queue.

[Masiello]

Originally Posted by Paul M

Nope, it will send 6 e-mails every 10 minutes.

Oh yes sorry, speel error, I indeed 6 e-mail x 10 minutes, this is what I need, Thanks Paul

[fly2hi]

hi
i am having this error from the past one month
i check with my hosting company but no use
it just happen for sending mails an nothing else

please try to solve my problem becoz it help me alot from the time i add it
---------------
Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Wednesday, October 3rd 2007 @ 04:31:29 PM
Script : http://www.q8x4.com/vb/cron.php?&rand=827783
Referrer : http://www.q8x4.com/vb/index.php
IP Address : 86.62.250.3
Username : ??? ????
Classname : vB_Database

[Paul M]

That's a mysql problem. If you search vbulletin.com I believe they have more details.

[fly2hi]

Originally Posted by Paul M

That's a mysql problem. If you search vbulletin.com I believe they have more details.

i am lost !!!

its not a mysql problem becoz it just happen with the mail queue and every thing else is working fine.

and i have contact my hosting company they told me the problem with the sleeping quary

and when i contact the vbulletin.com support team they told me its a Cron Based E-Mail Sending add-on problem.

every one is just saying its not my problem

what can i do please help me becoz this corn job solve a big problem i was facing before and i can not stop using it.

[Paul M]

Well I'm sorry they told you that, but the fact remains that it's a mysql issue.

[Antivirus]

Great modification Paul, really helps with sending out emails to large amounts of members. I found myself wondering how many emails were in the queue quite often however, and I got tired of manually running a SELECT query in the console to find out how many emails were remaining in the queue... so i coded the attached add-on for your mod which adds the quantity of remaining emails in the mail queue to the AdminCP page.

You can see a screenpic of what it does in the attached "screenie.gif" image. I just thought I would share it with everyone who's using this mod, makes life a little easier.

[Mudvayne]

Thanks a lot Antivirus

[Antivirus]

Originally Posted by Mudvayne

Thanks a lot Antivirus

You are welcome!

[Greek76]

Ok just a question. Im a little naive from what I see. I want to only send out 200 emails per hour since that is what Hostgator only allows.
I went to acp email options
Use mailqueue I checked to yes...
Number of Emails to Send Per Batch what would I put? I put 85 as I read in the first page but all my emails returned back. So what exactly am I doing wrong I can only send 200 emails per hour so how would I set that up? I also did the two file edits.
Thanks in advance...