Re: XoopsMultiMailer Problem! [Q and A] - XOOPS Web Application System

1

XoopsMultiMailer Problem!

2004/5/8 19:33
Jack404
Just popping in
Posts: 56
Since: 2003/5/16

Part of my code for my site is as follows:


[Begin Snippet]



global $xoopsDB;

global $xoopsUser;



include_once XOOPS_ROOT_PATH.'/class/xoopsmailer.php';

include_once XOOPS_ROOT_PATH.'/class/mail/xoopsmultimailer.php';



$myts =& MyTextSanitizer::getInstance();

$xoopsMailer =& getMailer();



$sql = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13"';

$result = $xoopsDB->query($sql);

$email = $result;



$body = $myts->oopsStripSlashesGPC($_POST['mail_body']);

$subject = $myts->oopsStripSlashesGPC($_POST['mail_subject']);

$headers  = "MIME-Version: 1.0rn";

$headers .= "Content-type: text/html; charset=iso-8859-1rn";



$sent = $xoopsMailer->sendMail($email, $subject, $body, $headers);

if ($sent) {

    redirect_header('index.php',5,"Send mail complete!");

} else {

        $errors = $xoopsMailer->getErrors();

        die('There was an error.<br>'.$errors);

}



exit();



[End Snippet]

The code fails every time I run it, and the error that I get is "SMTP Error: The following recipients failed [Resource id #26]"

I know this means that something's going wrong with the array of emails, but I'm not sure how to fix it. If anyone could help, I'd be very grateful :)

2

Re: XoopsMultiMailer Problem!

2004/5/8 22:16
Jack404
Just popping in
Posts: 56
Since: 2003/5/16

[bump]
PING? PONG!
[/bump]

3

Re: XoopsMultiMailer Problem!

2004/5/8 22:48
Mithrandir
XOOPS is my life!
Posts: 6320
Since: 2003/6/21


$result = $xoopsDB->query($sql);

$email = $result;

As far as I can see, you are giving the emails array the value of a resultset.
Instead do this:


$result = $xoopsDB->query($sql);

$email = array();

while ($thisemail = $xoopsDB->fetchArray($result)) {

    $email[] = $thisemail['email'];

}

NOT TESTED - but should to the best of my knowledge work

4

Re: XoopsMultiMailer Problem!

2004/5/8 22:54
Jack404
Just popping in
Posts: 56
Since: 2003/5/16

Dang, I thought that would work too.

The error message now reads "SMTP Error: The following recipients failed [Array]"

At least it's not Resource id #26 anymore ;)

EDIT: Turning on PHP Debug showed this:

Notice: Array to string conversion in i:\ajxdesigns\class\mail\phpmailer\class.phpmailer.php on line 370

5

Re: XoopsMultiMailer Problem!

2004/5/8 22:58
tl
Friend of XOOPS
Posts: 999
Since: 2002/6/23

Try to turn MySQL/Block debug on to see if the query statement is right. You got three types of quotes: ' ` "

Quote:

$sql = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0"

6

Re: XoopsMultiMailer Problem!

2004/5/8 23:00
Jack404
Just popping in
Posts: 56
Since: 2003/5/16

Yup, query was fine... funny how mySQL works :)

I just figured out what's wrong... I used the list() php function to get the array to change to a list, and now it works perfectly :)

7

Re: XoopsMultiMailer Problem!

2004/5/9 0:04
Jack404
Just popping in
Posts: 56
Since: 2003/5/16

I've got another problem...


$sql[1] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 1,45';

$sql[2] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 46,90';

$sql[3] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 91,135';

$sql[4] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 136,180';

$sql[5] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 181,225';

$sql[6] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 226,270';

$sql[7] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 271,315';

$sql[8] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 316,360';

$sql[9] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 361,405';

$sql[10] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 406,450';



$email[1] = array();

$email[2] = array();

$email[3] = array();

$email[4] = array();

$email[5] = array();

$email[6] = array();

$email[7] = array();

$email[8] = array();

$email[9] = array();

$email[10] = array();



$result[1] = $xoopsDB->query($sql[1]);

$result[2] = $xoopsDB->query($sql[2]);

$result[3] = $xoopsDB->query($sql[3]);

$result[4] = $xoopsDB->query($sql[4]);

$result[5] = $xoopsDB->query($sql[5]);

$result[6] = $xoopsDB->query($sql[6]);

$result[7] = $xoopsDB->query($sql[7]);

$result[8] = $xoopsDB->query($sql[8]);

$result[9] = $xoopsDB->query($sql[9]);

$result[10] = $xoopsDB->query($sql[10]);



while ($thisemail = $xoopsDB->fetchArray($result[1])) {

        $email[1][] = $thisemail['email'];

}

while ($thisemail = $xoopsDB->fetchArray($result[2])) {

        $email[2][] = $thisemail['email'];

}

while ($thisemail = $xoopsDB->fetchArray($result[3])) {

        $email[3][] = $thisemail['email'];

}

while ($thisemail = $xoopsDB->fetchArray($result[4])) {

        $email[4][] = $thisemail['email'];

}

while ($thisemail = $xoopsDB->fetchArray($result[5])) {

        $email[5][] = $thisemail['email'];

}

while ($thisemail = $xoopsDB->fetchArray($result[6])) {

        $email[6][] = $thisemail['email'];

}

while ($thisemail = $xoopsDB->fetchArray($result[7])) {

        $email[7][] = $thisemail['email'];

}

while ($thisemail = $xoopsDB->fetchArray($result[8])) {

        $email[8][] = $thisemail['email'];

}

while ($thisemail = $xoopsDB->fetchArray($result[9])) {

        $email[9][] = $thisemail['email'];

}

while ($thisemail = $xoopsDB->fetchArray($result[10])) {

        $email[10][] = $thisemail['email'];

}



list($emails[1]) = $email[1];

list($emails[2]) = $email[2];

list($emails[3]) = $email[3];

list($emails[4]) = $email[4];

list($emails[5]) = $email[5];

list($emails[6]) = $email[6];

list($emails[7]) = $email[7];

list($emails[8]) = $email[8];

list($emails[9]) = $email[9];

list($emails[10]) = $email[10];

I have 450 users I need to mail with my script, so I want to break it down. The code I pasted above does the trick, but is there a way to break it down using PHP or some other XOOPS function?

I know this isn't a forum for PHP, but I'm not sure how to use for() or while() statements in the code :/

Stats
Goal:	$100.00
Due Date:	May 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

XoopsMultiMailer Problem!

Re: XoopsMultiMailer Problem!

Re: XoopsMultiMailer Problem!

Re: XoopsMultiMailer Problem!

Re: XoopsMultiMailer Problem!

Re: XoopsMultiMailer Problem!

Re: XoopsMultiMailer Problem!

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}