Automatic "Send Email" redirect

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

[Revan]

Is that all? You seem to have cut the error message in half.

[Raptor]

yep thats verbatim

[Revan]

Well you must understand that I can't diagnose a problem when you obviously cut out of the message exactly WHAT the error is, and WHERE it is.
It's 100 % impossible that that is a verbatim copy of the error, because vB doesn't output mySQL errors without the MySQL error code and message.

[Raptor]

Database error in vBulletin 3.0.7:

Invalid SQL: 
				INSERT INTO `mailtemp` 
					(`test`, `serializeduser`, `from`, `subject`, `message`)
				VALUES
					('0',
					'a:26:{s:8:"username";s:0:"";s:11:"usergroupid";a:8:{i:0;s:2:"87";i:1;s:2:"89";i:2;s:1:"6";i:3;s:2:"61";i:4;s:1:"5";i:5;s:2:"80";i:6;s:1:"2";i:7;s:2:"91";}s:10:"adminemail";s:1:"0";s:5:"email";s:0:"";s:11:"parentemail";s:0:"";s:9:"coppauser";s:2:"-1";s:8:"homepage";s:0:"";s:3:"icq";s:0:"";s:3:"aim";s:0:"";s:5:"yahoo";s:0:"";s:3:"msn";s:0:"";s:9:"signature";s:0:"";s:9:"usertitle";s:0:"";s:13:"joindateafter";s:0:"";s:14:"joindatebefore";s:0:"";s:17:"lastactivityafter";s:0:"";s:18:"lastactivitybefore";s:0:"";s:13:"lastpostafter";s:0:"";s:14:"lastpostbefore";s:0:"";s:13:"birthdayafter";s:0:"";s:14:"birthdaybefore";s:0:"";s:10:"postslower";s:0:"";s:10:"postsupper";s:0:"";s:15:"reputationlower";s:0:"";s:15:"reputationupper";s:0:"";s:9:"ipaddress";s:0:"";}',
					'raptor@digital-forums.com',
					'80 FREE 8X DVD-R @ WWW.NEODISCS.COM !',
					'As a Digital-Forums member you are entitled to 80 FREE 8X DVD-R when you spend ?50 or more at www.neodiscs.com

Go get 'em !')
			
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'em !')' at line 8

mysql error number: 1064

Date: Sunday 27th of March 2005 03:35:06 AM
Script: http://www.digital-forums.com/admincp/email.php
Referer: http://www.digital-forums.com/adminc...l.php?do=start
Username: Raptor
IP Address: xx.xx.xx.xx

[Raptor]

screen shot

[Revan]

Yep see now I can determine the error... try replacing one of the edits with this:

PHP Code:

        if (!$_GET['isredirect'])
        {
            $DB_site->query("
                INSERT INTO `" . TABLE_PREFIX . "mailtemp` 
                    (`test`, `serializeduser`, `from`, `subject`, `message`)
                VALUES
                    ('" . intval($_POST['test']) . "',
                    '" . serialize($_POST['user']) . "',
                    '" . mysql_real_escape_string($_POST['from']) . "',
                    '" . mysql_real_escape_string($_POST['subject']) . "',
                    '" . mysql_real_escape_string($_POST['message']) . "')
            ");
        } 


Might also want to take this bit and replacing into the first edit:

PHP Code:

        $message = stripslashes($mailtemp['message']);
        $subject = stripslashes($mailtemp['subject']); 


[H2k_Coder]

WooooW very nice Hack i have other board use IPB and they have Something like this hack ..

Thankyou For Released this great hack going to Install it

[Marco van Herwaarden]

In your email.php, find:

PHP Code:

                    '" . mysql_real_escape_string($_POST['from']) . "',
                    '" . mysql_real_escape_string($_POST['subject']) . "',
                    '" . mysql_real_escape_string($_POST['message']) . "') 


And replace with:

PHP Code:

                    '" . addslashes(mysql_real_escape_string($_POST['from'])) . "',
                    '" . addslashes(mysql_real_escape_string($_POST['subject'])) . "',
                    '" . addslashes(mysql_real_escape_string($_POST['message'])) . "') 


Not tested.

[Revan]

Btw, mysql_real_escape_string is a function more powerful than addslashes, but it does the same. Do not perform the above edit. Double escaping should be avoided, afaik :P

[Marco van Herwaarden]

Actually you are right, must still have been sleeping. Double quoting should not be done.

Hmm strange that he stil got that error then.