Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Mass Mail/Newsletters Via Cronjob Details »
Mass Mail/Newsletters Via Cronjob
Mod Version: 1.1, by Jafo232 (Coder) Jafo232 is offline
Developer Last Online: Jan 2020 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.5.3 Rating: (2 votes - 5.00 average) Installs: 32
Released: 04 Jan 2006 Last Update: 06 Jan 2006 Downloads: 81
Supported DB Changes Uses Plugins Additional Files  

For those of you who use the "Send Email to Users" function in the admin cp may have noticed it is less than efficient. This is really not the Vbulletin teams fault, it is just the fact that sending a lot of emails via PHP is like emptying lake with a bucket.

For administrators with a very large user base, sending email this way is not only very time consuming, but can be taxing on a servers resources.

With this extension, you can save your mass mailings or newsletters in a batch that can be sent at any time you wish, or on a schedule using a program like crontab.

You can even use a separate server to send the email if you wish.

Version 1.1 now supports the hack Send HTML via admin CP so you can batch mail HTML emails.



Requirements:

Perl (Some hosts call this CGI) w/ the DBI module (MySQL driver)
Net::SMTP module IF you plan on using SMTP (common Perl module)
Sendmail or SMTP
Access to crontab (for scheduled processing)
Telnet/SSH access to your server (for testing purposes only)

As for Telnet/SSH access, you will most likely need this unless you can schedule a cronjob via your servers admin GUI.


CHANGELOG:

01/05/2005: Added support for SMTP
01/05/2005: Modified code to include Vbulletin generated mail headers and encoding


Installation (detailed in readme file):

Install the product via your admin cp.

Open the list.cgi file and edit the database variables and upload to server IN ASCII MODE. Do not use Binary or Auto mode to upload list.cgi. You should upload this file in an area that is NOT accessible by a web browser.

Click Install

That is it. If you wish to use scheduled batches then you will have to set up a cronjob to execute the list.cgi file.

You can execute the list.cgi file any time you wish on your server like so:

"perl list.cgi"



What does this do exactly?:

In a nutshell, when you enter a message into the mass mail feature of Vbulletin, it saves the message details to a new table created by the product (massmail). When list.cgi is executed, it will go through this table and email everyone in the table and delete their entry after the mail is sent.



Usage:

The only thing you should do differently is set the "Emails to send at once" value to at least the amount of users you have registered. It defaults at 500 but the whole point of this hack is to eliminate having to send email in blocks and wait for the process to finish. Just set it to a real high number.



To Do:

For those Windows servers, I suppose the Send_Mail routine could use SMTP. This is not hard to do I just never use Windows servers so what's the point?

Download Now

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

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.
Similar Mod
Mod Developer Type Replies Last Post
Set mass moving / pruning of threads as a cronjob Stadler vBulletin 3.0 Beta Releases 3 06 Aug 2004 03:04

  #31  
Old 01 Feb 2006, 19:02
NxTek NxTek is offline
 
Join Date: Jun 2003
I'm sending out about 5300 each month with no problem. I was under the impression this mod would send out the monthly reminder without me manually doing it.
Reply With Quote
  #32  
Old 01 Feb 2006, 19:03
Jafo232 Jafo232 is offline
 
Join Date: May 2004
Your impressions were wrong.
Reply With Quote
  #33  
Old 01 Feb 2006, 19:28
NxTek NxTek is offline
 
Join Date: Jun 2003
Yes I guess so
Reply With Quote
  #34  
Old 02 Feb 2006, 16:48
NxTek NxTek is offline
 
Join Date: Jun 2003
When trying to uninstall -

Database error in vBulletin 3.5.2:

Invalid SQL:
DROP massmail;

MySQL Error : You have an error in your SQL syntax near 'massmail' at line 1 Error Number : 1064
Date : Thursday, February 2nd 2006 @ 08:21:39 AM
Script : http://www.xxxx.com/forums/admincp/plugin.php
Referrer : http://www.xxxx.com/forums/admincp/p...s-Mail-Cron&s=
Reply With Quote
  #35  
Old 04 Feb 2006, 22:09
lisquid lisquid is offline
 
Join Date: Apr 2005
Hey

My host limits me to 600 emails an hour do you think you could give us the option to send the emails in batch ammounts every [integer of time we input beetween batches here] until complete?
Reply With Quote
  #36  
Old 22 Feb 2006, 16:33
UK Jimbo's Avatar
UK Jimbo UK Jimbo is offline
 
Join Date: Sep 2002
I like the sound of this hack, it would be really nice to get it to have it look at load averages and only proceed with the next block if the load on the server is below a given amount. I'll see if I can add this feature in
__________________
administrator: visordown.com
Reply With Quote
  #37  
Old 02 Jun 2006, 09:37
oliwood oliwood is offline
 
Join Date: Feb 2002
Originally Posted by ChurchMedia
Just FYI, I used this to try to send out 28,000 newsletters. It killed my server and MySQL is dead and won't restart. When it was working it would send out 5-10 emails to the same person every once and a while. My site is down now. I'm not sure what caused it exactly, but I'll have to stick to my other mail program.
exactly the same for me... is there a bugfix ofr have i to remove this nice hack?

The cronjob runs once a day at 1 a.m. but also the Mails were send 10 times to poeple and the my server crachs after half an hour.

Would it help to add a sleep 1 after the removing of the MySQL entry?

Last edited by oliwood; 02 Jun 2006 at 11:31.
Reply With Quote
  #38  
Old 26 Aug 2006, 18:57
dutchbb dutchbb is offline
 
Join Date: Dec 2003
Wow I really need this, is there a 3.6 release planned please?
Reply With Quote
  #39  
Old 29 Aug 2006, 12:43
Joep11 Joep11 is offline
 
Join Date: May 2005
Originally Posted by Triple_T
Wow I really need this, is there a 3.6 release planned please?
Curious about that too!
Reply With Quote
  #40  
Old 29 Sep 2006, 20:38
grandeur_69 grandeur_69 is offline
 
Join Date: Feb 2003
i haven't read the whole post, so pardon if this is repeated, but doesn't vB have a batching option? or is this something different?
Reply With Quote
  #41  
Old 19 Feb 2007, 22:25
masterross's Avatar
masterross masterross is offline
 
Join Date: Dec 2005
hi,

i've got this error after sending first mail:

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

any help?
Reply With Quote
  #42  
Old 12 Mar 2007, 12:01
rastler rastler is offline
 
Join Date: Jan 2006
Real name: Leeladhar
A query on Mass Mail Hack

Hi,

I have a doubt,

If we use this Hack will the mails be sent twice, Once using the PERL file and the massmail table and second with existing mail system of vbMail ?

Rastler
Reply With Quote
  #43  
Old 18 Dec 2007, 15:02
xcingix's Avatar
xcingix xcingix is offline
 
Join Date: Feb 2006
Real name: Daniel Michel
Originally Posted by NxTek View Post
When trying to uninstall -

Database error in vBulletin 3.5.2:

Invalid SQL:
DROP massmail;

MySQL Error : You have an error in your SQL syntax near 'massmail' at line 1 Error Number : 1064
Date : Thursday, February 2nd 2006 @ 08:21:39 AM
Script : http://www.xxxx.com/forums/admincp/plugin.php
Referrer : http://www.xxxx.com/forums/admincp/p...s-Mail-Cron&s=
I have the same problem.
I have left this product in my instillation for years because I cant uninstall it.
Can someone help me uninstall this?
Reply With Quote
  #44  
Old 18 Dec 2007, 15:14
UK Jimbo's Avatar
UK Jimbo UK Jimbo is offline
 
Join Date: Sep 2002
I've not ever installed this software but I'm pretty confident that the uninstall is trying to remove the massmail table from the database. In which case the correct syntax is:


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

__________________
administrator: visordown.com
Reply With Quote
  #45  
Old 18 Dec 2007, 15:25
xcingix's Avatar
xcingix xcingix is offline
 
Join Date: Feb 2006
Real name: Daniel Michel
Originally Posted by UK Jimbo View Post
I've not ever installed this software but I'm pretty confident that the uninstall is trying to remove the massmail table from the database. In which case the correct syntax is:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
just run that query and it will be uninstalled?
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 02:20.

Layout Options | Width: Wide Color: