Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Automatic "Send Email" redirect Details »»
Automatic "Send Email" redirect
Version: 1.5.0, by Revan Revan is offline
Developer Last Online: Jun 2014 Show Printable Version Email this Page

Version: 3.0.7 Rating:
Released: 03-21-2005 Last Update: 03-29-2005 Installs: 11
DB Changes
 
No support by the author.

Do you run a large forum, and need to send emails to all your users? Do you have to set the email per batch to a low number because of PHP limitations? And most importantly; would you have liked to see the emails work their magic while you go attend other duties?
If your answer to the aboves is yes, then this hack is for you!

What this hack does, is cache the email you are trying to send in a temporary SQL table, then instead of having a form with hidden fields and forcing you to hit submit, it reads this table at reload.
After the mail is sent, the table is emptied.

Thanks goes to DeMiNe0 for telling me to make this, and for helping me test it



Files modified: 1
DB Tables added: 1
Difficulty: Easy

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #22  
Old 03-29-2005, 02:49 PM
Dennis Olson Dennis Olson is offline
 
Join Date: Jul 2004
Location: Wisconsin
Posts: 137
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Copied from a Google search....

Quote:
Why do i get a query syntax error 1064 from MySQL when the syntax seems correct?

You will get a MySQL query syntax error number 1064 when you incorrectly use a reserved word in your query such as "when" or "order".

MySQL 4 has additional reserved words that you cannot use and the full list of them is at http://www.mysql.com/doc/en/Reserved_words.html.
Reply With Quote
  #23  
Old 03-30-2005, 04:32 AM
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Location: Norway
Posts: 1,671
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In short, BALLS
Okay I will rename the stuff, and email people instructions on how to update

Thanks Dennis
Reply With Quote
  #24  
Old 05-13-2005, 09:28 AM
SilverBoy SilverBoy is offline
 
Join Date: Feb 2002
Location: Libya
Posts: 497
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I tried this hack, but it doesn't work good with me

my vb version is 3.0.7

when I select a specific user group, the first page goes ok, but the second will send the emails to all groups withous selection

other situation I send an email to 520 320 members for example (by selection) when it finished the first page and pressing next page link, it began sending to all members.

what's wrong exactly?
Reply With Quote
  #25  
Old 05-21-2005, 09:26 PM
Master Computer Master Computer is offline
 
Join Date: Dec 2002
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Isn't it working in the test email mode?
Reply With Quote
  #26  
Old 06-01-2005, 01:36 AM
quipster quipster is offline
 
Join Date: Jan 2005
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

im running vb-3.06 right now and running a html hack so email.php was edited for that as well.. it seems to be working fine but in test mode it sends out emails as well.. the html email hack im running i got from here -- https://vborg.vbsupport.ru/showthread.php?t=72105 im sure other users will want both of these combined.
Reply With Quote
  #27  
Old 07-08-2005, 02:15 AM
jb605 jb605 is offline
 
Join Date: Feb 2004
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for this great hack. As noted above, it does send out email in test mode actually. I tried the following change, which I believe fixed the problem so that it will ONLY test and not actually send email in test mode.

PHP Code:
                    if (!$_POST['test'] OR !$test)
                    {
                        echo 
$vbphrase['emailing']." \n";
                        
vbmail($user['email'], $subject$sendmessagetrue$from); 
Should be

PHP Code:
                    if (!$_POST['test'] AND !$test)
                    {
                        echo 
$vbphrase['emailing']." \n";
                        
vbmail($user['email'], $subject$sendmessagetrue$from); 
There also might be a bug that if you force close a email batch that is being processed (either by closing your browser, or restarted web server) , for whatever reason (I noticed I put in the wrong from address and all mail is rejected by MTA), then that mail batch is left over in the mailtemp table, and next time when you try to send mass email, the previous left-over batch will likely be the one being actually ran, instead of the new one you just created.
Reply With Quote
  #28  
Old 07-08-2005, 11:22 AM
jb605 jb605 is offline
 
Join Date: Feb 2004
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

After waiting for one whole night for this mass email to finish, I only get up to find that the email.php page becomes blank. So I don't even know where it left off. The mailtemp table was left with that email batch, with nowhere it indicates where it left off.

I will have to either dig my apache log or my maillog to find out where it left off, then modify my mass email search creteria to reflect that, otherwise I will have to start again, which will bother my members again, and might or might not work.

Does anybody else experience this timeout / blank page and left-over mail batch problem?

I think it might be a better idea for the email.php program to check if there is a mail batch left over, and let the admin to decide whether to continuue it or drop it. Also, the mail batch should store where it stopped (how many email sent, how many to go, perpage etc), this way it can easily pickup if the program timed out.
Reply With Quote
  #29  
Old 10-17-2005, 07:16 PM
ahmedbehiry ahmedbehiry is offline
 
Join Date: Nov 2001
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

is there going to be a vbulletin 3.5 version of this hack?
Reply With Quote
  #30  
Old 12-31-2005, 08:14 AM
kommuni kommuni is offline
 
Join Date: Apr 2004
Posts: 58
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ahmedbehiry
is there going to be a vbulletin 3.5 version of this hack?
would also be interested in a 3.5 solution... will try to test this in 3.5
Reply With Quote
  #31  
Old 01-03-2006, 12:05 AM
Malke Malke is offline
 
Join Date: Jan 2004
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

best hack ever
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 06:48 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04714 seconds
  • Memory Usage 2,316KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete