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.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
i want to know: Are the mails sent or not? And how can i check this?
I have only two logs, but in my mailqueue i set it to 100 mail per batch, so i must have more then 2 logs, right?
i want to know: Are the mails sent or not? And how can i check this?
I have only two logs, but in my mailqueue i set it to 100 mail per batch, so i must have more then 2 logs, right?
I cannot tell you if you mails were sent, check your server logs. If you actually put 49,000 emails in the queue then it would take many hours to send them, and there would be loads of cron entries, which suggests to me that either you didn't send 49,000 via the ACP e-mail user function, or you didn't do the file edits correctly (or at all).
Quote:
Originally Posted by phonexpo
Could I set this up to send a newsletter every Monday at 9am for example?
No, I think you misunderstand what this is for. This simply changes the way queued mails are sent by vb, and also edits the ACP function to send mails to the queue. This is not a mod to produce newsletters.
I've installed it, and it seems to have worked, but the problem is that the server seems to have stopped sending mail notifications for new replies and stuff!!
Cron Based E-Mail Sending Details »»
About Developer
Visit Web Site
Uses Plugins 
No support by the author.
12-28-2006, 02:09 AM
