Cron Based E-Mail Sending

[Paul M]

This modification is no longer available or supported.

This is a 3.6 specific port of the 3.5 Modification (https://vborg.vbsupport.ru/showthread.php?t=107174).

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 (https://vborg.vbsupport.ru/member.php?u=64660) has posted a nifty little addon that displays the current size of the mail queue here (https://vborg.vbsupport.ru/showthread.php?p=1367832#post1367832).



History:

v1.12 : First Release for vB 3.6.

[sabret00the]

what's changed between versions Paul?

[projectego]

/me clicks install

[Calash]

Would this be a good solution for email limits set by a web host? The host I am with currently limits me to 200 emails per hour, and will disable the mail should I go over that. If I set it to 100, and the interval to 1 hour that would get by the limit with room to spare.

Would that be possible with this mod?

[sabret00the]

Would this be a good solution for email limits set by a web host? The host I am with currently limits me to 200 emails per hour, and will disable the mail should I go over that. If I set it to 100, and the interval to 1 hour that would get by the limit with room to spare.

Would that be possible with this mod?
set this to run once an hour.

set your emails to send out batches of 85 and you shuold be more than fine.

[Paul M]

what's changed between versions Paul?Not much really, this basically just completes the porting of my 3.5 mods - which is why it says you can carry on running the 3.5 version if you already have it installed. The only significant change is that you don't need to manually create the cron task when installing it, the product does that (and it runs every 10 mins now, not 15).

[Calash]

Great news. I can send out announcments again :)

I will install soon. Thanks for posting it.

[Hornstar]

This is brilliant, I spent an hour sending out emails the other day, and then firefox crashed half way through after sending 20 000 emails and then I had to try and find a user that was around that number, so I didnt send duplicates to the first 20 000 again, it was a real pain lol

Thanks.

[farukcan]

screenshots...???? :s

[Paul M]

Your kidding, what would I post a screen shot of ?

[grandeur_69]

the screenshots would be exactly the same as 3.5 ... see above.

[sunnycher]

I've installed this.
It's automatically set to send a certain amount of emails at a certain amount of time? I don't need to do anything to these settings?

If I do, where do I do it?

Thanks! I hope this works for me, My members are always saying they never receive my emails.

[Paul M]

Read the notes in the first post. :)

[sunnycher]

Thanks Paul, I did, maybe I'm missing it but.......where do *I set it*?

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).

[Paul M]

Lines above that ;

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).

[sunnycher]

lol Ok, I did all of that, thank you!

I think I was wondering where to set the how many and the time?

But that's ok, thanks Paul!

[dutchbb]

How do we setup the cron job you mention, there is no howto about this?

I would like to use this great hack if only I knew how to do that.

"remember you can set it to process 9999"

is 9999 the maximum or can it be set to whatever the number of registered members is?

[Paul M]

Importing the product creates the vb cron job automatically.

As I recall, 9999 is the max that you can set.

[dutchbb]

WOuld it be possible to set it to a larger number for large forums please? Thanks.

[Paul M]

That limit is nothing to do with this modification, it's part of standard vb.

[dutchbb]

Yes but will I be able to send the email to more than 9999 members? If not this would be useless to forums with more than 10.000 users...

Thanks

[Paul M]

I take it you have not used the ACP to email members.

The number is simply the limit to send in one batch (before you have to press a button to move to the next screen, and send the next batch). There is no limit to how many members you can e-mail.

[dutchbb]

Yes I use it frequently. I understand that it's just to limit the nr in a batch. I thought however that if I use 9999 and this hack it would stop at 9999 and not send an email to the rest of the members...

But after 9999 I would have to click the next button again right? It would be awesome if I could just click once and let it email all members without clicking next.

[Paul M]

Well actually, looking at the page you can set the number as high as you want (I just tried it with 999999).

[dutchbb]

Yes I just tried it with 30000, works perfectly, again: great hack :D

[Paul M]

Status: Not InstalledDon't forget to mark as installed then. :)

[dutchbb]

Yes i did right after posting , good luck with the hotm :)

[trigon]

dummy question: How can i use the cronlog? for example, i sent a mail to 49000 users, all i got is two lines of log:

is it now sent on this two times?

[Paul M]

I don't understand what you are asking.

[djbaxter]

I'm wondering if this would have any effect on the CommBull newsletter add-on (not sure how that one sends emails currently).

Or is only likely to be useful if I use the vBulletin built-in mass emal feature?

[Paul M]

I have no idea, as I know nothing about commbull.

If commbull puts the emails into the vb queue then they will be processed by this mod, if commbull uses some other method then they won't.

[trigon]

I don't understand what you are asking.
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?

[phonexpo]

Hi Paul,

Could I set this up to send a newsletter every Monday at 9am for example?

Thanks,

Patrick

[Paul M]

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).

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.

[phonexpo]

Ok thanks Paul. :)

[maxicep]

i do everything but i cant find mail content block ? where i write mail content ?

[Mudvayne]

Admin CP > Users > Send Email To Users

[adhari_com]

just perfect ... I've modified commbull to use it too, along with automated Generation of commbull.

Thank you.

[Sun Boy]

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!!

[Hornstar]

Just wondering are file edits still necessary? because I hate doing file edits. Is it possible for this hack to be updated so this is not needed?

Thanks.

[Paul M]

Yes they are.

If it were possible not to use them then I wouldn't. :)

[kartik786]

just perfect ... I've modified commbull to use it too, along with automated Generation of commbull.

Thank you.

Can you share the file edits please.

I'm sure many would love this to be integrated with commbull

[Mudvayne]

If you are using the commercial version of Combull then it 'll work with this. There is an option if you want Combull follow the vB default mail queue system. If you enable this & if you have installed this hack then combull will send mail in this queue system.

[Nathan2006]

Thanks Paul

Will give it a go :)

Install

[testebr]

The best mod ever, very useful. Keep it updated always.

thanks

[Rukas]

Does this also queue the "Email Users" system of static created mass emails?

[Paul M]

Sorry, I don't really understand your question - what are "static created mass emails" ?

[Mudvayne]

Does this also queue the "Email Users" system of static created mass emails?
The bottom line is this modification just change the default queue system & send mail based on cron. Now any modification that follows vB's default mail queue system 'll work with this hack.

[Julie]

Woho! Thanks for this :) I've been looking for something like this ever since 98% or so of the e-mails I sent bounced back :P lol... Thanks! :)

[Antivirus]

This sounds like something I could really use Paul, thanks. I take it that this will work regardless of whether or not the board is sending email via SMTP or php's mail() function, correct?

[Paul M]

Correct.

[M-Tuning]

I've installed this product, but is it possible to see how much e-mails have been send?

I've mailed to around 16.000 members yesterday, and i don't think they received mails.

I've set Number of Emails to Send Per Batch to 200 and the cron is unmodified (every 10 minutes)

[Antivirus]

Correct.

Thanks for clarifying that :)

[lazydesis]

does this work if i use SMTP server ?

thanx for the hack :)

[Paul M]

does this work if i use SMTP server ?

thanx for the hack :)Look up the page a few posts. ;)

[lazydesis]

OK ..gotcha ..thanx ... but looks like doesnt work for me :(

when i send mails using ACP> Users> Send Email it starts sending mails as usual (one after another) and doesnt say anything about them sent to queue.

Did i do some mistake :(

[Paul M]

Did you do the file edits ?

Also, what do you mean exactly - they will still get listed in the ACP exactly the same (well, much faster actually) - did you actually check your servers outgoing mail queue ?

[lazydesis]

oh ..so u saying that for ACP> Users> Send Email it will still show, sent sent sent for every user?

[Paul M]

oh ..so u saying that for ACP> Users> Send Email it will still show, sent sent sent for every user?Yes, that will not change, all that changes is that they will be sent to vb's mail queue for processing in batches by this mod, not sent direct to your servers mail system.

[pictureboarduk]

Cool, installed.

[kylek]

Our host requires emails to be spaced 6 seconds between each one and only 200 per hour, is this something that could be set up with this if at all possible?

[Paul M]

200 per hour would be easy to set-up (with the default 10 minutes between batches, just set each batch to 32 max). I don't know of any system that would put a six second delay between e-mails.

You could also set the cron to run once a minute, processing 3 e-mails each time.

[kylek]

Right now we have only found phplist which so far I cant get working at all. They say you can adjust the seconds between messages.

"The MAILQUEUE_THROTTLE setting inserts a pause (in seconds) between each message, i.e. it will space messages apart by a number of seconds."

Example:
# batch processing disabled:
define (http://www.php.net/define)("MAILQUEUE_BATCH_SIZE",0);

# Batch_period is not effective when batch processing is disabled:
define (http://www.php.net/define)("MAILQUEUE_BATCH_PERIOD",3600);

# Pause between messages (in seconds) to send no more than 360 messages per hour:
define (http://www.php.net/define)('MAILQUEUE_THROTTLE',10);

[Paul M]

Sorry, I cannot help you with phplist, only this modification.

If you choose the once per minute option then I really don't see what the problem is, there is no good reason to send the three e-mails 6 seconds apart , that's just nonsense.

In fact, there isn't really much reason to do it at all, if your host really insists on such stupid rules then tbh, you should start looking for another.

[kylek]

Sorry wasn't expecting help with phplist, only answering your comment on systems that would give 6 second delays.

Hostgator is the one who has these guidelines for shared servers.

I will set it for one a minute and give it a try, this way they cant say we are breaking the rules and we defiantly wont go over their 200 per hour policy.

[FReeSTER]

I've installed this product, but is it possible to see how much e-mails have been send?

I've mailed to around 16.000 members yesterday, and i don't think they received mails.

I've set Number of Emails to Send Per Batch to 200 and the cron is unmodified (every 10 minutes)I have the same problem, it works great but no email sends..... I have follow every single instructions but now the email dont work at all.

Anyhelp please

[Paul M]

This does not alter how your sever sends e-mails, if you have followed the instructions then the e-mails are passed by vb to your server just the same as always (just in batches every 10 minutes, not straight away). Are you sure you did this (below)

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).

[kollam003]

thanks Paul for the hack :)

[axi]

so according to the instructions above, if i want to send 450 emails per hour. once installed i turn on the use mailqueue system in email options?

and then for 'Number of Emails to Send Per Batch' i put in 75 ? As it sends emails every 10 minutes is that right? That will be 450 emails per hour??

Nothing else needs to be mofified right???

[Paul M]

75 * 6 = 450, correct.

[axi]

thanks!

[NathanLedet]

I'm just a little confused on which numbers to change...

Cron Email set to 10 minutes

in ACP > Email Options > Number of Emails to Send Per Batch = 80

Users > Send Email to Users > Emails to send at once = 800 (I have less than 800 users)

So, i type in the message that is to be sent...and click "Submit", and it confirms that all e-mails have been sent (or, sent to the queue)

Every 10 minutes, 80 e-mails get sent....Is this correct????

Thanks!

[Nathan2006]

I have been getting bounced emails from yahoo saying that I have sent the limit of 100 emails to them within 1 hour.

If I set "Number of Emails to Send Per Batch" to 1 would it send out 10 emails every 10 minutes?

So it would be 60 every 1 hour?

Thanks for any help :)

[Paul M]

Nope, it would send 1 e-mail every 10 minutes.

[txsbmw]

I just updated to 3.6.8 (previously 3.6.7pl1 or whatever it was, lol) and this mod is no longer working. Host company just shut down the forums because I exceeded the 200 per hour limit.

Trying to remember, but this mod required php file edits right?

[Paul M]

Yes it does require edits.

[txsbmw]

Thanks, I applied the updates to those PHP files so everything should be working fine now.

[Nathan2006]

Nope, it would send 1 e-mail every 10 minutes.


Thanks for that Paul,

They have increesed my emails to 500 per hour :)

[Masiello]

This mod is just what I need for my hosting server configuration, when I send mass emails the server go in overload and stop sending giving me database error in Admin Control Panel, with this mod I am able to set the sending in queue and for sure all email finish at destination!
Thanks Paul, I'll try this later :)
I always say that the Paul M and Cybernetec Mod's are the best!

[Masiello]

Hello Paul, I've not touch any setting in the CronJob and setting Number of Emails to Send Per Batch to 6, this presume that process sending 6 email per minute, it is right? Also this working when I send users email to all users? And 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?

Thanks in advance for the clarify

[Paul M]

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.


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]

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]

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 :D

[Antivirus]

Thanks a lot Antivirus :D

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...

[Paul M]

As the notes tell you - the Cron runs every 10 minutes (i.e. 6 times an hour) - so if you set it to 85 then 85 x 6 = 510 per hour - well over your limit. You need to set it to about 32 maximum.

[Greek76]

Thanks Paul seems to be working perfect!

[toucan42]

Thanks for this hack and thanks for the report hack on the admincp homepage.

One question - there is a CVS folder in the zip that is empty - should this be uploaded?

[Paul M]

Nope, ignore it.

[redraider]

Need some help with this. It was working fine till I installed the vb368 PL2 (only the changed files). Now the queue processes, but the emails are not sent.

If I disable the queue processing, the emails are sent just fine.

Could anyone help?

[Paul M]

Nothing in PL2 can affect this modification.

[laura66a]

Hello.

This doesn't seem to work if SMTP port 587 is specifiied in PHP.

Laura

[dartho]

great add-on, Paul.

I have a question in regards to vBulletin "cron" jobs.

If I have it right, these are triggered by users visiting the forums.

If a forum were to have no visitors in say a two hour period, are missed vb cron jobs then executed? The result being that the task for this add-on may run all missed tasks and thereby possibly causing quotas to be exceeded?

[Paul M]

If I have it right, these are triggered by users visiting the forums.
That's correct.

If a forum were to have no visitors in say a two hour period, are missed vb cron jobs then executed?
They will be executed as soon as you get a visitor after the two hour period, not during it.

The result being that the task for this add-on may run all missed tasks and thereby possibly causing quotas to be exceeded?
Sorry, but I don't understand what you mean by this.

[Paul M]

This doesn't seem to work if SMTP port 587 is specifiied in PHP.

Huh ?

Can you please be a bit more specific.

[dartho]

If a forum were to have no visitors in say a two hour period, are missed vb cron jobs then executed? The result being that the task for this add-on may run all missed tasks and thereby possibly causing quotas to be exceeded?


Sorry, but I don't understand what you mean by this.

To re-phrase, are missed cron jobs still executed at the next opporutinty? For example, if there are no visitors for 2 hours then the (default - every 10 minutes) 'process mail queue' cron job would would miss 12 'executions' of the job. Would these missed 'executions' then all (12) be run at the next opportunity, or would the never be run.

The reason I ask is that if I were on a throttled account of say 500 emails/hour and had configured my vb system to send batches of 100 emails every 10 minutes (using this add-on) and if all 12 missed executions were run at the next opportunity, that would be 1200 emails send in a short space of time - totally trashing my 500 email/hour limit.

Clear as mud?

[Paul M]

No, that will not happen - the cron job is only triggered once - if you have no visitors for two hours then it won't fire 12 times, just the once.

[laura66a]

Huh ?

Can you please be a bit more specific.

Sure.

I have Cron Mail Queue installed and it was working great. I have it set to send 5 emails per minute which works fine for my site when I send out my weekly updates.

I recently changed my SMTP port setting from 25 to 587 at the request of my provider. There is a vBulletin option for this, but you also have to change SMTP_Port= in PHP to 587 as well to get it to work.

After I made the change, my last round of weekly updates went out all at once instead of 5 per minute. They all were successful, but they did go out all at once.

Laura

[Paul M]

The change you made cannot affect this modification in any way, maybe your e-mail server just queued them all up.

[laura66a]

The change you made cannot affect this modification in any way, maybe your e-mail server just queued them all up.

Perhaps it can't affect the mod, but the PHP change can certainly affect the way vBulletin works relative to the mod.

I did change this back to port 25 and it worked as expected sending 5 emails per minute.

Laura

[plothook]

* Clicks Mark as Uninstalled *
Just what we needed to get all our stuff out past our hosts 200 emails/hour limit @30 emails /10 minutes
Now everyone will get their daily e-mail notifications, even if it does take the system 3-4 hours to get the job done.

Thanks Paul!
---------------------------------
now if it only were truely CRON based and didn't depend on site activity, though we always get more than enough site hits to trigger things

[SVTCobraLTD]

Installed using hostgator. Thank you, exactually what I needed and will be setting it to 25 emails per batch. Thanks - Nominated for mod of the month.

SVT

[SVTCobraLTD]

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. :)

A great addition to this great hack.

SVT

[dartho]

^
|
|
|

What (s)he said x 2 :up:

[Farcaster]

I have to agree. This plus the crontab based vbcron jobs is a killer combination!

[BlizzardHQ]

Working great still in Beta 3.

Hostgator is now imposing a 200 per hour limit. I recommended this on their forum for all vB users for that :)

[SVTCobraLTD]

Yea it sucks having vB on hostgator site and can only send 200 emails a day. This is the perfect fix for that. Props to Dr Pepper Addict :up:

SVT

[kushal]

Yes, it will solve lot of problems for us.

[RFViet]

Installed, thanks.

[almqdad]

I am getting this error after upgrading php verion

Database error in vBulletin 3.6.5:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Wednesday, January 2nd 2008 @ 12:16:37 AM
Script : http://alhawza.net/forum/forumdisplay.php?f=50
Referrer : http://alhawza.net/forum/showthread.php?t=50724
IP Address : 87.230.151.169
Username : منا(العلم)هل
Classname : vB_Database

is there a way to resolve this issue

[Paul M]

Increase your sql timeout, or reduce the number of emails you send in one batch.

[SBlueman]

I'd like to set it so it sends 100 emails per hour....what do I need to edit? The ACP functions confuse me and I don't know what to edit and where.

[USAMustangs.com]

Thanks. It seems to be working fine for now.

This is a fantastic feature for vB forums. My host has a hourly email limit of 250. There are a many instances where I need to send out a mass pm to my members. I just end up exceeding my mail quota and everything gets returned. Hopefully, this will permanently solve that problem.

This is a feature that should come OEM in vBulletin. Makes no sense to me why it's not built into vB in the first place, considering the nature of these types of forums.

[jshg46]

installed

Is there any way to get around the server not sending subscription emails right away instead they are being put in the mail deal also. so in tread replys email.

[Paul M]

Subscription etc emails are designed to be queued, thats standard vb.

[dtv100]

I try this on our site and seding 50k emails dont overload the server any more thanks .

[Budweiser]

Thank you for writing this Mod. I just downloaded it and will be installing it soon. I have been using the YABB forum for several years and just installed VB and VBadvanced. I was never able to use the YABB email system and thought I would have the same problem with VB (untill I found your Mod). If anyone is curious... I use aplus.net and their mail limitation is 500 per 1/2 hour.

[kylek]

Yea it sucks having vB on hostgator site and can only send 200 emails a day. This is the perfect fix for that. Props to Dr Pepper Addict :up:

SVT


HostGator has changed the email limits to 500 per hour now.

http://forums.hostgator.com/showthread.php?t=26795

[gbox master]

is there a how to use for this modification
where are the settings :confused:
how to adjust the settings :confused:
etc etc etc etc:confused :confused:

it would save noobs like me hours of searching in the thousends of settings of the vB :(

[SVTCobraLTD]

HostGator has changed the email limits to 500 per hour now.

http://forums.hostgator.com/showthread.php?t=26795

That is great news. Thanks for sharing.


is there a how to use for this modification
where are the settings :confused:
how to adjust the settings :confused:
etc etc etc etc:confused :confused:

it would save noobs like me hours of searching in the thousends of settings of the vB :(

AdminCP > vBulletin Options > Email Options > Number of Emails to Send Per Batch

SVT

[gbox master]

AdminCP > vBulletin Options > Email Options > Number of Emails to Send Per Batch

SVT

thnx m8 and the time inteval :confused:
and is this all :confused:
so i can start sending my members a update on some things ?
no longer i need to stay up for a couple of hours just to push the button 1000 times :mad:

[SVTCobraLTD]

thnx m8 and the time inteval :confused:
and is this all :confused:
so i can start sending my members a update on some things ?
no longer i need to stay up for a couple of hours just to push the button 1000 times :mad:

If you put 25 in there, it will send out 25 emails every 10 minutes resulting in 150 per hour.

SVT

[zlos]

1. BUG: when using mysql slave server there is an SQL error while importing the product (it tries to issue UPDATE command to a slave server)
2. GREAT MOD: I have 220.000 users in newsletter and it took me 10 minutes to batch the newsletter. You saved 3 hours of my time, which I can now consume on drinking the toast to you ;)

[Paul M]

1. BUG: when using mysql slave server there is an SQL error while importing the product (it tries to issue UPDATE command to a slave server)

This does not run any SQL commands when its installed (unless vbulletin itself runs some, in which case thats a generic vb bug).

[gbox master]

so the time is preset to 1 min??
if so why not a how to with the files that explains some things

[Paul M]

Why not read the first post.

[Peejay]

Another Host Gator user here who is very happy with this hack as it saves me having to worry about the mass mails that go out from the site automatically for innactive users etc...

Many thanks :D

[gbox master]

Why not read the first post.

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).


thats the problem otherwise i would not ask
i dont understand what it say
i dont see any settings
so maybe there should be a good howto for all these hacks and mods
then we would not have to ask so many questions

[zlos]

Hi Paul

My mail processing stopped this night. I have checked database - everything seems to be fine (mailqueue and datastore tables are repaired and returned OK). I see no error logged in apache log. I see no error while trying to invoke scheduled task manually. Mailing works just fine (registration emails and bad posts reports are being sent).
Where to dig now? Over 50.000 mails are waiting in the pipe...

EDIT: I have found erroneous record in mailqueue (partly cut text). Truncating mailqueue helped.

[gbox master]

:confused: now i see some mail thing in the admin pannel see atachment

why not a good howto for this hack please
so we can use it and edit the settings
and some explanation where the settings are located


if there is any member who knows these things please pm me so i can get in touch with some one who knows how this thing works :up:

[Icy]

This is because you have installed Antivirus's plugin, which shows queue stats on Admin Control Panel. There is no settings for this. It will just show your mail queue stats. However you can edit two options.

1. Admin Control Panel > vBulletin Options > Email Options

2. Admin Control Panel > Scheduled Tasks > Scheduled Task Manager

[NeutralizeR]

I'm glad i found this hack, thanks Paul!

Btw, i also have this hack installed. Does it have anything to do with yours?
https://vborg.vbsupport.ru/showthread.php?t=123719

Another question...

Let's say i sent 100.000 emails to my members using "Send email to users" function and i have the default settings (600 emails per hour) enabled. It'll take about 7 days to finish sending emails? In the mean time, users won't receive "password reminder" emails till the queue is free, will they?

[Paul M]

Let's say i sent 100.000 emails to my members using "Send email to users" function and i have the default settings (600 emails per hour) enabled. It'll take about 7 days to finish sending emails? In the mean time, users won't receive "password reminder" emails till the queue is free, will they?
Yes, it would take 7 days at that rate. As for password reminders, I suspect they are not queued, but I don't know for sure without looking at the VB code. Subscription emails would be delayed.

[mabe38]

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. :)

Where can I see that option???

[Icy]

Where can I see that option???
In Admin Control Panel Index (./admincp/index.php). Above the Administrator Notes.

[haytham]

Thank you.

[toucan42]

Anyone have this working for 3.7? Seems to have been disabled and I just flooded out emails - my host is gonna shoot me (drat!)

[Paul M]

There is a 3.7 version in the appropriate forum.

[toucan42]

Thanks Paul M! Great work =)

[Aneurysm]

I am so glad I found this hack, It will save me from having to upgrade my hosting to a VPS account to get around my host's 25/minute 600/hour outgoing messages limit and it has stopped my yahoo bounces overnight.

[anakayam.us]

hello,i want set 500messages/hour.
batch setting ........ 10/20/30 ?

[Paul M]

80 would be about right (6 x 80 = 480).

[alfieuk]

Hi Paul
i have a problem using this. I have it installed perfectly and it runs without a problem however my host says it is straining the server when it sends emails.

Basically I had it set to email 10 (batch) ever 10 minutes, basically though it is sending 10 at the same time which is what they are complaining about, basically they dont want me sending more than 1 per second. Sorry if this sounds gibberish but how do i set it to send them by seconds, or cant it be done, I have 2500 members, if i set it to send 1 every 10 minutes it will take forever to email my members.

Any help or advice would be very much appreciated.

[Paul M]

There is no way to do that without editing the mail class.

TBH, you seriously need to look for another host if 10 emails is causing them issues.

[alfieuk]

Hi thanks for the reply, they have told us that we can send 3600 per hour but no more than 1 per second. Unfortunately this system sends them all together, whatever the batch is set at, this is the problem unable to solve :(

[Paul M]

"This system" as you call it, is the standard vb mail system. Like I said, the only way to add a delay is to edit the vb mail class.

[asasi]

my server limit us to send just 200 emails per hour. we have about 40000 users and want to send them an newsletter. can I do this with your mod?

regards

[Paul M]

Yes, as long as your send it via the vb mail system.

[asasi]

Is it in admincp ? or need any other mod to install?

[SVTCobraLTD]

Is this updated for 3.6.10pl2? I just sent out a ton of emails and got a lot kicked back saying Domain XXX.com has exceeded the max emails per hour (500) allowed.
Message discarded.
Any ideas on this?

[Paul M]

It doesnt need updating, as it says ;

Version: 3.6.x

[SVTCobraLTD]

It doesnt need updating, as it says ;

Then why would it stop working? Any ideas?

[Paul M]

Because you have changed something. I cannot possible guess what, but nothing just stops working.

[len backus]

edited

[USAMustangs.com]

How can you purge unsent emails out of the queue? Say you inadvertently send a mass pm and forgot to delete certain usergroups before you sent the pm. How would you purge those before they go out?

Thanks

[SVTCobraLTD]

I have the number of emails to go out at 50 yet when I just sent a mass email out, the queue went from 482 to 0 in 4 minutes. Any ideas. I keep going over the 500 allowed.

Im just going to have to wait to click next for the rest of the members for now. What else, if anything, would possibly indirectly effect this product?

[almqdad]

hello

what is the correct way to remove is mod

[SVTCobraLTD]

This has stopped working for me on 3.6.11 so I am trying to reinstall. Hopefully it works again.

[webrats]

3.8 update?

[SVTCobraLTD]

I thought it was working after the install. But I just looked at the stats and this is what I got, see screenshot below. The settings are set to have it active and has been running for a few weeks now and nothing seems to be happening. Any ideas?