Send Mass Emails Using the Mailqueue System

[Abe1]

Send Mass Emails Using the Mailqueue System 1.0


I recently changed where I send emails for my forum from. I had been using by server and now switched to an outside place. I found that sending a mass email would take FOREVER since it would take a few seconds per email it had to send out.

I had my vb setting of "Use Mailqueue System" set to 'Yes' but I realized it was NOT using the queue.

I found the way to enable the queue and sending mass emails takes me just a few seconds now! (This hack makes sending emails from your own server much faster also.)

This hack enables the vb queue only if you have 'Use Mailqueue System' turned on. Sending mass emails will take you a few seconds instead of minutes of hours!

Installation:

Open file 'admincp/email.php'.

Search for:
vbmail($user['email'], $vbulletin->GPC['subject'], $sendmessage, true, $vbulletin->GPC['from']);


CHANGE it to:
vbmail($user['email'], $vbulletin->GPC['subject'], $sendmessage, false, $vbulletin->GPC['from']);

Please post your comments or suggestions for this hack. I read ALL posts.

MAKE SURE YOU CLICK INSTALL (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=139779)!
You will get an email when a new version is released.

[maroceve]

it would be great if we could send an html file ...to be sent tru the queue manager...

[obmob]

Sounds interesting, thanks.

[projectego]

This could be just what I was looking for... thanks, Abe1! ;)

[ntock]

Not sure how this is different from? Would def like to know as it seems easier :D

https://vborg.vbsupport.ru/showthread.php?t=133844

Many thanks in advance :)

[Abe1]

Not sure how this is different from? Would def like to know as it seems easier :D

https://vborg.vbsupport.ru/showthread.php?t=133844

Many thanks in advance :)
Didn't see that one but there are may diffs I think. I took a quick look only. That seems to use a cron system rather then the regular queue. If you have a lot of members on your site at once, then my hack would send emails much faster. Also, if you have very few people on your site, his may slow up.

He will only send 10 a min. and you need users to trigger the min. By me, you need the users to trigger but it goes for every trigger, not just once a min.

[bchertov]

it would be great if we could send an html file ...to be sent tru the queue manager...See this hack (Pluggin)

https://vborg.vbsupport.ru/showthread.php?t=137593

[Ahsin1]

Nice hack

It use to take 30 Minz to send emails to 10k users wid this hack it took not even 2 minz

Thanks

[Endurer]

Aweome.. I really am thankful to you for making my life easier.

[Kihon Kata]

Hi Abe,

So, let me ask, one cannot send HTML formatted emails through this? I have a custom mod that allows me to send HTML emails through the vB system. LMK if this would work.

[Abe1]

Hi Abe,

So, let me ask, one cannot send HTML formatted emails through this? I have a custom mod that allows me to send HTML emails through the vB system. LMK if this would work.
I have no idea if it would work with it or not.

[Mecho]

i installed this but when i want to send emails i get this error :

Parse error: syntax error, unexpected '}' in /public_html/forum/admincp/email.php on line 217

any idea ?

[Abe1]

i installed this but when i want to send emails i get this error :



any idea ?
Make sure you did the edit 100% correct. You may have added or deleted something extra.

[phonexpo]

Abe1, I've just installed it, thank you. I'll be testing it soon. Should I have to modify any of my settings in my admincp ?

[Abe1]

Abe1, I've just installed it, thank you. I'll be testing it soon. Should I have to modify any of my settings in my admincp ?
Just make sure you use the setting on how to sends emails is set to use the queue.

[Endurer]

Hi Abe,

So, let me ask, one cannot send HTML formatted emails through this? I have a custom mod that allows me to send HTML emails through the vB system. LMK if this would work.

Yes it works perfectly fine.

[MentaL]

Why aint this default in vb?

[Abe1]

Why aint this default in vb?
No clue.

Or maybe, because they dont think you want mass email clogging the queue.

[phonexpo]

WOW, used it today, e-mail sent to over 2000 members in about 2 seconds, thank you very much :)

[PoetJA-1975]

Very nice that this is compatible with sending html emails via AdminCP! Great share!
Now I have a stoopid question: My vB isn't set to use the Mailqueue System --- Do I need this set to "Yes" before this hack works?

Anyway - Thanx = Very useful mod! = INSTALLED

Jacquii.

[Abe1]

Very nice that this is compatible with sending html emails via AdminCP! Great share!
Now I have a stoopid question: My vB isn't set to use the Mailqueue System --- Do I need this set to "Yes" before this hack works?

Anyway - Thanx = Very useful mod! = INSTALLED

Jacquii.
Yes.

[bchertov]

it would be great if we could send an html file ...to be sent tru the queue manager...See my hack (https://vborg.vbsupport.ru/showthread.php?t=137593)for this.

[PoetJA-1975]

Thanx ABE ;)

Jacquii.

[DieselMinded]

Installed Thanks!

And what should i set

Email to send at once:

To????

[Abe1]

Installed Thanks!

And what should i set



To????
Anything you want. It will go really quick so you can send like 1000-5000. This setting would be to make the emails and added them to the mail queue.

[Endurer]

Just wanted to let everyone know that this works with vb 3.6.7. PL1 as well.

[webmaster74]

Abe1,

on my Linux RedHat9, vb 3.6.7 PL1, I installed the mod and am attaching a screen capture of the Mailqueue YES radion button selected, and a copy of my admincp/email.php

:confused: did I miss something?

When I tried to send an email to my members, the very normal process of mail sending to 500 members at a time started as before..... is this expected ?

[Abe1]

Abe1,

on my Linux RedHat9, vb 3.6.7 PL1, I installed the mod and am attaching a screen capture of the Mailqueue YES radion button selected, and a copy of my admincp/email.php

:confused: did I miss something?

When I tried to send an email to my members, the very normal process of mail sending to 500 members at a time started as before..... is this expected ?
I dont know. Do you know if it is going into the database or not?

[kollam003]

the emails goes in a second but takes more time to be delivered

[DieselMinded]

Could this Get messed up and cause me not to receive my emails when a new paid subscription is received , I have not got an email for the last 3 subscribers ?

DM

[Abe1]

Could this Get messed up and cause me not to receive my emails when a new paid subscription is received , I have not got an email for the last 3 subscribers ?

DM
This has nothing to do with paid subscriptions.

[DieselMinded]

OK ,

BTW Im using this Hack and sending emails to users is still hit and miss , I have to set it to 100 at a time , then keep hitting next to show the next 100 then a few times it will just load and load then go to a Bad Response from server , Then i hit back page and then next again and it usually goes ,,,

Sending the Mass emails is a PITA , I had hoped this would help me but the issues are the exact same . I cant see where this mod has done anything at all

*upsetwithmyemailsystem

DM

[Abe1]

OK ,

BTW Im using this Hack and sending emails to users is still hit and miss , I have to set it to 100 at a time , then keep hitting next to show the next 100 then a few times it will just load and load then go to a Bad Response from server , Then i hit back page and then next again and it usually goes ,,,

Sending the Mass emails is a PITA , I had hoped this would help me but the issues are the exact same . I cant see where this mod has done anything at all

*upsetwithmyemailsystem

DM
Do you have the setting to use the mail queue system right now?

[DieselMinded]

When enabled, subscription emails generated by your site will be processed in batches to lessen the load on your server. Account activation, lost passwords and other vital emails are sent instantly regardless of this setting. If your site has low traffic, subscription emails may be delayed.

If you have a large site, you may wish to enable locking. This prevents a rare situation where the same email is sent multiple times.

Set To Yes with no Locking

vBulletin includes a mail queuing system to prevent bottlenecks when sending lots of email. Use this option to specify how many emails will be sent per batch.

Set to 10

Set this option to yes to use an SMTP server rather than the internal PHP mail() function.

NO

What do i need to do to get this to work right?

[Abe1]

That first option should make this thing work.

Can you verify in your database if the emails are actually going into queue.

[Concha]

thanks


Installed OK ;)

[DieselMinded]

Can you verify in your database if the emails are actually going into queue.

How Can i manage this? I have a shared Server @ Network Solutions

[Abe1]

How Can i manage this? I have a shared Server @ Network Solutions
The the mail queue table in phpmyadmin.

[DieselMinded]

OK ill check that out before and after I send them

I was talking with my host and they said I cannot send more than 100 EMails at the same time from the server or more than 1000 Per 24hours

Maybe this has something to do with my issues here

[LanciaStratos]

Unfortunately, I can't really say that I recommend this. I'm on a dual Xeon dedicated server with a very large forum (around 98,000 members, 66,700 of which have opted to receive my messages), and this brought my server to a crawl. Server loads spiked to 120+ only seconds after sending a few thousand messages. This may work great for smaller boards, but it looks like us larger forum owners are still going to be left to find other email solutions on our own.

[Abe1]

Unfortunately, I can't really say that I recommend this. I'm on a dual Xeon dedicated server with a very large forum (around 98,000 members, 66,700 of which have opted to receive my messages), and this brought my server to a crawl. Server loads spiked to 120+ only seconds after sending a few thousand messages. This may work great for smaller boards, but it looks like us larger forum owners are still going to be left to find other email solutions on our own.
Check how many emails get sent at once using the queue. Set it to a very low number. Also, try locking the table.

[LanciaStratos]

Ah, yes, I hadn't considered reducing the queue! What table do I need to lock?

[Abe1]

Ah, yes, I hadn't considered reducing the queue! What table do I need to lock?
Just the vb setting by the mail queue options.

[BillP]

I am trying this on a large board (90K users), and it's taking forever for each screen to finish sending to the mailqueue. I tried 500 users per time, and it took a minute or more for the 500, and then you have to hit "next" so I was looking at a couple of hours of this.

So I stopped, upped it to 10K users per pass, and now it's just taking several minutes for each 10K pass.

On the outbound side, server load is very high, so I have reduced it to process 3 on each mailqueue pass, that seems to help a little. But the site is at a crawl. We have 2 web servers and a mysql slave setup, if it matters.

[baby41]

The the mail queue table in phpmyadmin.

I went to my phpAdmin but I didn't saw any table with that name,can you be more specific,regards.:confused:

[Abe1]

I am trying this on a large board (90K users), and it's taking forever for each screen to finish sending to the mailqueue. I tried 500 users per time, and it took a minute or more for the 500, and then you have to hit "next" so I was looking at a couple of hours of this.

So I stopped, upped it to 10K users per pass, and now it's just taking several minutes for each 10K pass.

On the outbound side, server load is very high, so I have reduced it to process 3 on each mailqueue pass, that seems to help a little. But the site is at a crawl. We have 2 web servers and a mysql slave setup, if it matters.
Then it must take a long time to connect to your mail server.

[Division]

My Emails dont take 3 hours anymore stamped. Only 3 minutes to 30,000

[PoetJA-1975]

Thanx again for the share! Brilliant mod ABE

Jacquii.

[gobears20]

I just installed this and I have a few questions.

Does this have to do with going into your AdminCp and going to Users>Send Email to Users? If it does, one of my big problems that I have had is that I have 13,600 members and when I would try to send an email to them, it would time out after a while and I would have to re-boot my server. Does this hack work well with emailing all of your users? It would be really nice because I have not been able to send out a mass email to them ina while.

[PoetJA-1975]

I just installed this and I have a few questions.

Does this have to do with going into your AdminCp and going to Users>Send Email to Users? If it does, one of my big problems that I have had is that I have 13,600 members and when I would try to send an email to them, it would time out after a while and I would have to re-boot my server. Does this hack work well with emailing all of your users? It would be really nice because I have not been able to send out a mass email to them ina while.
It's specifically for the email users.

Jacquii.

[Abe1]

I just installed this and I have a few questions.

Does this have to do with going into your AdminCp and going to Users>Send Email to Users? If it does, one of my big problems that I have had is that I have 13,600 members and when I would try to send an email to them, it would time out after a while and I would have to re-boot my server. Does this hack work well with emailing all of your users? It would be really nice because I have not been able to send out a mass email to them ina while.
Yes, this hack should help.

[Welshy2008]

Mine says "OK" and emails sent successfully - But no-one receives them. I have set it to "send to members that have selected "No Emails".

Any Ideas Please?

I have also changed the admincp / email.php file as told.

[Abe1]

Mine says "OK" and emails sent successfully - But no-one receives them. I have set it to "send to members that have selected "No Emails".

Any Ideas Please?

I have also changed the admincp / email.php file as told.
This show not effect the actual emails.

[gobears20]

I just want to let you know that this works really well! It is not only fast, it doesn't crash sql!

I have not had communication with my users in a whike, because the last time I sent an email to all users, it took a long time, but it ended up crashing sql. I have 13,640 members on my board. I only sent 50 at a time and it took less than seven minutes.

Thanks so mch for this!

Does anybody know of a fix for send a PM to all users? I have used this and it crashes sql also. Any idea on sending a PM to all users?

[Welshy2008]

It did work, just took a little time to get there. Tested again (only on one user addy) and it went straight through.

What I would like to know is what bbcode? - would I need to add to it to add the "Individual" username of the person that I send them too, Please?

Many Thanks,

Welshy2008

[Welshy2008]

Can anyone answer my post above please?

[hdraye]

would that still work with 4.xx?