Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Send Mass Emails Using the Mailqueue System Details »
Send Mass Emails Using the Mailqueue System
Mod Version: 1.0, by Abe1 (Coder) Abe1 is offline
Developer Last Online: Jun 2010 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.8 Rating: (5 votes - 4.80 average) Installs: 65
Released: 18 Feb 2007 Last Update: Never Downloads: 325
Not Supported Code Changes  

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


CHANGE it to:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.

Download Now

Only licensed members can download files, Click Here for more information.

Supporters / CoAuthors

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #31  
Old 06 Jul 2007, 03:06
Abe1's Avatar
Abe1 Abe1 is offline
 
Join Date: Feb 2004
Real name: Abe
Originally Posted by DiesellMinded View Post
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.
__________________
MY HACKS -

Active Link Security 3.0.X | Add Title to Rank Images 3.5.X | Admin Log In As User 3.5.X 3.6.X | Advanced BBCode Permissions 3.5.X 3.6.X | Can't See Attachments Before Thanking a Post 3.5.X | Can't Thank and Groan the Same Post 3.5.X | Delete Post when Giving Infraction 3.6.X | Edit New Thread Button 3.5.X | External Data Provider Usergroup Permissions Setting 3.5.X | Forms Hack 3.5.X, 3.6.X | Log Logins Hack 3.5.X 3.6.X | Moderator Statistics 3.5.X | Post Award Hack 3.0.X 3.5.X | [AJAX] Post Thank You Hack 3.0.X 3.5.X 3.6.X | [AJAX] Post Groan Hack 3.5.X 3.6.X | Post Thank You Hack Stats for vBadvanced CMPS 2.x 3.5.X | Search Title only in search drop-down 3.5.X, 3.6.X | 'vBMenu' DHTML User Option 3.5.X 3.6.X | vBShout on all pages! 3.5.X
Reply With Quote
  #32  
Old 06 Jul 2007, 03:40
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
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
__________________
Is your forum registered? - https://www.forumregister.com
Reply With Quote
  #33  
Old 06 Jul 2007, 03:42
Abe1's Avatar
Abe1 Abe1 is offline
 
Join Date: Feb 2004
Real name: Abe
Originally Posted by DiesellMinded View Post
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?
__________________
MY HACKS -

Active Link Security 3.0.X | Add Title to Rank Images 3.5.X | Admin Log In As User 3.5.X 3.6.X | Advanced BBCode Permissions 3.5.X 3.6.X | Can't See Attachments Before Thanking a Post 3.5.X | Can't Thank and Groan the Same Post 3.5.X | Delete Post when Giving Infraction 3.6.X | Edit New Thread Button 3.5.X | External Data Provider Usergroup Permissions Setting 3.5.X | Forms Hack 3.5.X, 3.6.X | Log Logins Hack 3.5.X 3.6.X | Moderator Statistics 3.5.X | Post Award Hack 3.0.X 3.5.X | [AJAX] Post Thank You Hack 3.0.X 3.5.X 3.6.X | [AJAX] Post Groan Hack 3.5.X 3.6.X | Post Thank You Hack Stats for vBadvanced CMPS 2.x 3.5.X | Search Title only in search drop-down 3.5.X, 3.6.X | 'vBMenu' DHTML User Option 3.5.X 3.6.X | vBShout on all pages! 3.5.X
Reply With Quote
  #34  
Old 06 Jul 2007, 05:29
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
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?
__________________
Is your forum registered? - https://www.forumregister.com
Reply With Quote
  #35  
Old 06 Jul 2007, 18:55
Abe1's Avatar
Abe1 Abe1 is offline
 
Join Date: Feb 2004
Real name: Abe
That first option should make this thing work.

Can you verify in your database if the emails are actually going into queue.
__________________
MY HACKS -

Active Link Security 3.0.X | Add Title to Rank Images 3.5.X | Admin Log In As User 3.5.X 3.6.X | Advanced BBCode Permissions 3.5.X 3.6.X | Can't See Attachments Before Thanking a Post 3.5.X | Can't Thank and Groan the Same Post 3.5.X | Delete Post when Giving Infraction 3.6.X | Edit New Thread Button 3.5.X | External Data Provider Usergroup Permissions Setting 3.5.X | Forms Hack 3.5.X, 3.6.X | Log Logins Hack 3.5.X 3.6.X | Moderator Statistics 3.5.X | Post Award Hack 3.0.X 3.5.X | [AJAX] Post Thank You Hack 3.0.X 3.5.X 3.6.X | [AJAX] Post Groan Hack 3.5.X 3.6.X | Post Thank You Hack Stats for vBadvanced CMPS 2.x 3.5.X | Search Title only in search drop-down 3.5.X, 3.6.X | 'vBMenu' DHTML User Option 3.5.X 3.6.X | vBShout on all pages! 3.5.X
Reply With Quote
  #36  
Old 09 Jul 2007, 11:33
Concha Concha is offline
 
Join Date: Aug 2006
thanks


Installed OK
Reply With Quote
  #37  
Old 09 Jul 2007, 16:40
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
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
__________________
Is your forum registered? - https://www.forumregister.com
Reply With Quote
  #38  
Old 09 Jul 2007, 17:15
Abe1's Avatar
Abe1 Abe1 is offline
 
Join Date: Feb 2004
Real name: Abe
Originally Posted by DiesellMinded View Post
How Can i manage this? I have a shared Server @ Network Solutions
The the mail queue table in phpmyadmin.
__________________
MY HACKS -

Active Link Security 3.0.X | Add Title to Rank Images 3.5.X | Admin Log In As User 3.5.X 3.6.X | Advanced BBCode Permissions 3.5.X 3.6.X | Can't See Attachments Before Thanking a Post 3.5.X | Can't Thank and Groan the Same Post 3.5.X | Delete Post when Giving Infraction 3.6.X | Edit New Thread Button 3.5.X | External Data Provider Usergroup Permissions Setting 3.5.X | Forms Hack 3.5.X, 3.6.X | Log Logins Hack 3.5.X 3.6.X | Moderator Statistics 3.5.X | Post Award Hack 3.0.X 3.5.X | [AJAX] Post Thank You Hack 3.0.X 3.5.X 3.6.X | [AJAX] Post Groan Hack 3.5.X 3.6.X | Post Thank You Hack Stats for vBadvanced CMPS 2.x 3.5.X | Search Title only in search drop-down 3.5.X, 3.6.X | 'vBMenu' DHTML User Option 3.5.X 3.6.X | vBShout on all pages! 3.5.X
Reply With Quote
  #39  
Old 09 Jul 2007, 17:32
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
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
__________________
Is your forum registered? - https://www.forumregister.com
Reply With Quote
  #40  
Old 18 Jul 2007, 23:06
LanciaStratos's Avatar
LanciaStratos LanciaStratos is offline
 
Join Date: Oct 2001
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.
Reply With Quote
  #41  
Old 19 Jul 2007, 11:47
Abe1's Avatar
Abe1 Abe1 is offline
 
Join Date: Feb 2004
Real name: Abe
Originally Posted by LanciaStratos View Post
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.
__________________
MY HACKS -

Active Link Security 3.0.X | Add Title to Rank Images 3.5.X | Admin Log In As User 3.5.X 3.6.X | Advanced BBCode Permissions 3.5.X 3.6.X | Can't See Attachments Before Thanking a Post 3.5.X | Can't Thank and Groan the Same Post 3.5.X | Delete Post when Giving Infraction 3.6.X | Edit New Thread Button 3.5.X | External Data Provider Usergroup Permissions Setting 3.5.X | Forms Hack 3.5.X, 3.6.X | Log Logins Hack 3.5.X 3.6.X | Moderator Statistics 3.5.X | Post Award Hack 3.0.X 3.5.X | [AJAX] Post Thank You Hack 3.0.X 3.5.X 3.6.X | [AJAX] Post Groan Hack 3.5.X 3.6.X | Post Thank You Hack Stats for vBadvanced CMPS 2.x 3.5.X | Search Title only in search drop-down 3.5.X, 3.6.X | 'vBMenu' DHTML User Option 3.5.X 3.6.X | vBShout on all pages! 3.5.X
Reply With Quote
  #42  
Old 19 Jul 2007, 15:15
LanciaStratos's Avatar
LanciaStratos LanciaStratos is offline
 
Join Date: Oct 2001
Ah, yes, I hadn't considered reducing the queue! What table do I need to lock?
Reply With Quote
  #43  
Old 20 Jul 2007, 02:34
Abe1's Avatar
Abe1 Abe1 is offline
 
Join Date: Feb 2004
Real name: Abe
Originally Posted by LanciaStratos View Post
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.
__________________
MY HACKS -

Active Link Security 3.0.X | Add Title to Rank Images 3.5.X | Admin Log In As User 3.5.X 3.6.X | Advanced BBCode Permissions 3.5.X 3.6.X | Can't See Attachments Before Thanking a Post 3.5.X | Can't Thank and Groan the Same Post 3.5.X | Delete Post when Giving Infraction 3.6.X | Edit New Thread Button 3.5.X | External Data Provider Usergroup Permissions Setting 3.5.X | Forms Hack 3.5.X, 3.6.X | Log Logins Hack 3.5.X 3.6.X | Moderator Statistics 3.5.X | Post Award Hack 3.0.X 3.5.X | [AJAX] Post Thank You Hack 3.0.X 3.5.X 3.6.X | [AJAX] Post Groan Hack 3.5.X 3.6.X | Post Thank You Hack Stats for vBadvanced CMPS 2.x 3.5.X | Search Title only in search drop-down 3.5.X, 3.6.X | 'vBMenu' DHTML User Option 3.5.X 3.6.X | vBShout on all pages! 3.5.X
Reply With Quote
  #44  
Old 06 Sep 2007, 07:01
BillP BillP is offline
 
Join Date: Nov 2001
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.
__________________
Bill Plein
Reply With Quote
  #45  
Old 06 Sep 2007, 22:12
baby41 baby41 is offline
 
Join Date: Jun 2007
Originally Posted by Abe1 View Post
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.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 15:43.

Layout Options | Width: Wide Color: