<?
//ini_set("display_errors","on");
session_start();
setlocale(LC_ALL,"hu_HU.ISO8859-2");
include("../include/vars.php");
include("../include/db_functions.php");
include("../include/template_functions.php");
include("../include/mail_functions.php");
include("../include/common_functions.php");
$sql=DB_Query("select * from newsletter_outbound where sent=0 order by id asc limit 25");
while($row=dB_FetchArray($sql)){
    $rowemail=DB_GetRow("select * from emails where id='".$row[email_id]."'");
    $rowmail=DB_GetRow("select * from newsletters where id='".$row[newsletter_id]."'");
    $rowsite=DB_GetRow("select * from sites where id='".$rowmail[site_id]."'");
    $mail=renderMail($row[newsletter_id],true,$rowemail[id]);
    SendNewsLetter($rowemail[email],"\"".$rowsite[name]."\"<noreply@".$rowsite[domain].">",$mail,$rowmail[subject],$rowmail[id],$rowsite[id],$row[id]);
}

function SendNewsLetter($cim,$felado,$html,$subj,$id,$siteid,$nlobid){
    require_once("../include/htmlmimemail/htmlMimeMail.php");
    $html=eregi_replace("/images/newsletter/","",$html);
    copy("../images/newsletter/head_".$siteid.".jpg","head_".$siteid.".jpg") or die("SADH");
    $ImgsToAttach[0][0]="head_".$siteid.".jpg";
    $ImgsToAttach[0][1]="image/jpeg";
    $sql=DB_Query("select * from newsletter_boxes where newsletter_id='".$id."'");
    $ct=1;
    while($row=DB_FetchArray($sql)){
	$html=eregi_replace("/pictures/newsletter/".$id."/",$id."_",$html);
	copy("../pictures/newsletter/".$id."/".$row[box_id].".jpg",$id."_".$row[box_id].".jpg");
	$ImgsToAttach[$ct][0]=$id."_".$row[box_id].".jpg";
	$ImgsToAttach[$ct][1]="image/jpeg";
	++$ct;
    }
    $mail = new htmlMimeMail();
    $mail->build_params['html_charset']  = 'UTF-8';
    $mail->build_params['text_charset']  = 'UTF-8';
    $mail->build_params['head_charset']  = 'UTF-8';
    for($i=0;$i<sizeof($ImgsToAttach);++$i){
        $img[$i]=$mail->getFile($ImgsToAttach[$i][0]);
        $mail->addHtmlImage($img[$i],$ImgsToAttach[$i][0],$ImgsToAttach[$i][1]);
    }
    $html=stripslashes($html);
    $mail->setHtml($html, $text);
    $mail->setReturnPath($felado);
    $mail->setFrom($felado);
    $mail->setSubject($subj);
    $mail->send(array($cim), 'smtp');
    DB_Query("update newsletter_outbound set sent=1 where id='".$nlobid."'");
}
?>