0) { while($riga=mysql_fetch_array($rs)) { $link = "http://".$website."/newsletter.php?id=".$riga['id_letter']; $id = $riga['id']; $query_usr = "Select * FROM ".$pref."users WHERE id='".$riga['id_user']."'"; $rs_usr = mysql_query($query_usr,$conn) or die("Errore nella query users:" . mysql_error()); if ($riga_usr=mysql_fetch_array($rs_usr)) { $usr_email = $riga_usr['email']; $usr_pass = $riga_usr['password']; } $query_let = "SELECT * FROM ".$pref."letter WHERE id='". $riga['id_letter'] ."'"; $rs_let = mysql_query($query_let,$conn) or die("Errore nella query:" . mysql_error()); if ($riga_let=mysql_fetch_array($rs_let)) { $mail_obj = $riga_let['menu']; $num = $riga_let['id_letter']; $lang = $riga_let['lng']; $mail_body = "\n"; $mail_body .= " \n"; $mail_body .= "\n"; $mail_body .= "\n"; $mail_body .= "\n"; $mail_body .= " \n"; $mail_body .= " \n"; $mail_body .= " \n"; $mail_body .= " \n"; $mail_body .= " \n"; $mail_body .= "
\"Bed
\n"; $mail_body .= "
".$riga_let['title']."
\n"; $mail_body .= $riga_let['description']."\n"; $mail_body .= "
 
\n"; if ($lang==1) $mail_body .= "

Hai ricevuto questa newsletter dal sito $azienda.
Per eliminare l'iscrizione alla newsletter visita il seguente indirizzo:
\n{unsubscribe}

\n"; else $mail_body .= "

Newsletter from $azienda.
To unsubscribe or change subscriber options visit:
\n{unsubscribe}

\n"; $mail_body .= "
Powered by www.dotflorence.com - ©".date("Y")."
\n"; $mail_body .= "\n"; $mail_body .= "\n"; } $unsubscribe = "http://".$website."/newsletter.php?tipo=user&act=unsubscribe&email=".$usr_email."&cod=".$usr_pass; $mail_body = str_replace("{link}",$link,$mail_body); $mail_body = str_replace("{unsubscribe}",$unsubscribe,$mail_body); $mail = new PHPMailer(); $mail->IsSendmail(); // telling the class to use SendMail transport $mail->CharSet = $charset; $mail->From = $email_to; $mail->FromName = $website_name; $mail->Subject = $mail_obj; $mail->AltBody = strip_tags($mail_body); $mail->MsgHTML($mail_body); $mail->AddAddress($usr_email, ""); //$mail->AddCc($email_to, ""); //$mail->AddBcc($email_bcc, ""); if($mail->Send()) { $lista.= " Newsletter ". $num ." inviata a: ".$usr_email."\n"; $query_upd = "UPDATE ".$pref."schedule SET status=1 WHERE id='". $id ."'"; mysql_query($query_upd,$conn) or die("Errore nella query:" . mysql_error()); } else { $lista.= " Newsletter ". $num ." NON inviata a: ".$usr_email."\n"; } } $resultmail = @mail($email_bcc,"[Report invio] ".$mail_obj,$lista,"From: ".$email_to."\n"); } if ($_REQUEST['url']!='') { include_once($_REQUEST['url']); exit; } ?>