Administrative and Maintenance Tools - Send Mass Emails Using the Mailqueue System

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:

PHP Code:

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


CHANGE it to:

PHP Code:

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!
You will get an email when a new version is released.

[Abe1]

Originally Posted by 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.

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]

Originally Posted by LanciaStratos

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]

Originally Posted by Abe1

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.

[Abe1]

Originally Posted by 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.

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]

Originally Posted by 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.

It's specifically for the email users.

Jacquii.