Форум программистов [Powered by Invision Power Board]

Код

function send_mails($p_id, $autor_id)
    {
        global $DB, $ibforums;
        
        include ('sources/gallery/include/expr.lang.ru.php');
        
        $sql = "SELECT `ibf_members`.`email` AS `email` FROM `com_subscription` LEFT JOIN `ibf_members` ON `ibf_members`.`id`=`com_subscription`.`user_id` WHERE `com_subscription`.`pic_id`=".$p_id." AND `com_subscription`.`user_id`!=".$autor_id;
        $result=$DB->query($sql);
        if($res=$DB->fetch_array($result))
        {
            $to = $res['email'];
        }
        
        $bcc = "";
        while ($res=$DB->fetch_array($result))
        {
            $bcc.=$res['email']+", ";
        }    
        if($bcc!="")
        {
            $bcc = substr($bcc, 0, -1);
        }
        $sql="SELECT * FROM `cpg132_pictures` WHERE `pid`=".$p_id;
        $result=$DB->query($sql);
        $res=$DB->fetch_array($result);    
        
        
        
        $subject = $expr['SUBJECT'];
        // To send HTML mail, the Content-type header must be set
        $headers  = 'MIME-Version: 1.0' . "\r\n";
        $headers .= 'Content-type: text/html; charset=windows-1251' . "\r\n";
        
        // Additional headers
        $headers .= "To: ".$to."" . "\r\n";
        $headers .= "From: ".$expr['FROM']."" . "\r\n";
        $headers .= 'Cc: ' . "\r\n";
        $headers .= "Bcc: ".$bcc."" . "\r\n";
        
        $message = $expr['MESSAGE'];
        $message = str_replace("<PHOTO_NAME>",$res['title'],$message);
        $message = str_replace("<LINK>","<a href=\"http://photorakurs.net.ru/forum/index.php?act=showimg&pid=".$res['pid']."\">".$res['title']."</a>",$message);
        
        mail($to, $subject, $message, $headers);
    }