/* .-----------------------------------------------------------------------------. | Software: CMS SmartSite - timer.php | | Version: 0.90 | | Last modified: 2010.12.01 | | Info: http://www.dotflorence.com (webtech@dotflorence.com) | | --------------------------------------------------------------------------- | */ include_once("inc/database.php"); include_once("inc/class/class.phpmailer.php"); $lista = "Newsletter ".$website." (".date("Y-m-d H:i:s").")\n\n"; $query = "Select * FROM ".$pref."schedule WHERE schedule_date<'".date("Y-m-d H:i:s")."' AND status=0 LIMIT 0,".$max_email; $rs = mysql_query($query,$conn) or die("Errore nella query:" . mysql_error()); if (mysql_num_rows($rs)>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 .= " ".$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. Newsletter from $azienda. |
Powered by www.dotflorence.com - ©".date("Y")." |