vb.org Archive - Automatic "Send Email" redirect

Page 3 of 4

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Automatic "Send Email" redirect (https://vborg.vbsupport.ru/showthread.php?t=78550)

Dennis Olson

03-29-2005 02:49 PM

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.

Revan

03-30-2005 04:32 AM

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

Thanks Dennis :)

SilverBoy

05-13-2005 09:28 AM

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?

Master Computer

05-21-2005 09:26 PM

Isn't it working in the test email mode?

quipster

06-01-2005 01:36 AM

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.

jb605

07-08-2005 02:15 AM

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, $sendmessage, true, $from);

Should be

PHP Code:


		
			
                    if (!$_POST['test'] AND !$test)

                    {

                        echo $vbphrase['emailing']." \n";

                        vbmail($user['email'], $subject, $sendmessage, true, $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.

jb605

07-08-2005 11:22 AM

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.

ahmedbehiry

10-17-2005 07:16 PM

is there going to be a vbulletin 3.5 version of this hack?

kommuni

12-31-2005 08:14 AM

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

Malke

01-03-2006 12:05 AM

best hack ever

All times are GMT. The time now is 06:56 AM.

Page 3 of 4

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01008 seconds Memory Usage 1,748KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: