mt_getrandmax())
$maximum=mt_getrandmax();
mt_srand((double)microtime()*1000000);
$unsubscribeid=mt_rand(10000,$maximum);
$sql = "select * from ".$tableprefix."_subscriptions where unsubscribeid='$unsubscribeid'";
if(!$result = mysql_query($sql, $db))
die("| Could not connect to the database.");
}while($myrow=mysql_fetch_array($result));
}
else
{
$unsubscribeid=0;
$confirmed=0;
do{
$maximum=9999999999;
if($maximum>mt_getrandmax())
$maximum=mt_getrandmax();
mt_srand((double)microtime()*1000000);
$subscribeid=mt_rand(10000,$maximum);
$sql = "select * from ".$tableprefix."_subscriptions where subscribeid='$subscribeid'";
if(!$result = mysql_query($sql, $db))
die(" |
| Could not connect to the database.");
}while($myrow=mysql_fetch_array($result));
}
$sql = "insert into ".$tableprefix."_subscriptions (email, confirmed, language, subscribeid, enterdate, lastsent, emailtype, unsubscribeid, category) ";
$sql.= "values ('$email', $confirmed, '$act_lang', $subscribeid, '$actdate', '$actdate', $emailtype, $unsubscribeid, $newscat[$i])";
if(!$result = mysql_query($sql, $db))
die(" |
| Could not connect to the database.");
$subscriptionnr=mysql_insert_id($db);
if($maxconfirmtime>0)
{
$tmpsql="select * from ".$tableprefix."_categories where catnr=".$newscat[$i];
if(!$tmpresult = mysql_query($tmpsql, $db))
die(" |
| Could not connect to the database.".mysql_error());
if($tmprow=mysql_fetch_array($tmpresult))
{
$catname=stripslashes($tmprow["catname"]);
$tmpsql2="select * from ".$tableprefix."_catnames where catnr=".$tmprow["catnr"]." and lang='".$act_lang."'";
if(!$tmpresult2=mysql_query($tmpsql2,$db))
die(" |
| Unable to connect to database.".mysql_error());
if($tmprow2=mysql_fetch_array($tmpresult2))
{
if(strlen($tmprow2["catname"])>0)
$catname=stripslashes($tmprow2["catname"]);
}
}
else
$catname=$l_unknown;
$confirmhours=$maxconfirmtime*24;
$confirmtime="$confirmhours $l_hours";
$confirmurl=$simpnews_fullurl."subscription.php?$langvar=$act_lang&mode=confirm&email=$email&id=$subscribeid";
$tmpsql="select * from ".$tableprefix."_texts where textid='msubnot' and lang='$act_lang'";
if(!$tmpresult = mysql_query($tmpsql, $db))
die(" |
Could not connect to the database.");
if($tmprow=mysql_fetch_array($tmpresult))
{
$mailmsg=stripslashes($tmprow["text"]);
$mailmsg=undo_htmlspecialchars($mailmsg);
$mailmsg_html=stripslashes($tmprow["text"]);
}
else
{
$mailmsg = $l_msubscriptionconfirmmail;
$mailmsg_html=$l_msubscriptionconfirmmail_html;
}
$mailmsg = str_replace("{catname}",$catname,$mailmsg);
$mailmsg = str_replace("{confirmtime}",$confirmtime,$mailmsg);
$mailmsg = str_replace("{sitename}",$sitename,$mailmsg);
$mailmsg = str_replace("{confirmurl}",$confirmurl,$mailmsg);
$mailmsg.= "\n\n---\n$defsignature\n\n\n";
$mailmsg=str_replace("\r","",$mailmsg);
$mailmsg=str_replace("\n",$crlf,$mailmsg);
$mailmsg_html = str_replace("{catname}",$catname,$mailmsg_html);
$mailmsg_html = str_replace("{confirmtime}",$confirmtime,$mailmsg_html);
$mailmsg_html = str_replace("{sitename}",$sitename,$mailmsg_html);
$mailmsg_html = str_replace("{confirmurl}",$confirmurl,$mailmsg_html);
$mailmsg_html.= "\n\n
\n$defsignature\n\n\n";
$mailmsg_html = str_replace("\n","
".$crlf,$mailmsg_html);
$mailmsg_html = undo_htmlspecialchars($mailmsg_html);
$subject = $l_subscriptionconfirmsubject;
$subject = str_replace("{sitename}",$sitename,$subject);
if($simpnewsmailname)
$fromadr="\"$simpnewsmailname\" <$simpnewsmail>";
else
$fromadr=$simpnewsmail;
$mail = new htmlMimeMail();
$mail->setCrlf($crlf);
$mail->setTextWrap($mailmaxlinelength);
$mail->setTextCharset($contentcharset);
if($emailtype==0)
{
$mail->setHTMLCharset($contentcharset);
$mail->setHTML($mailmsg_html,$mailmsg);
}
else
{
$mail->setText($mailmsg);
}
$mail->setSubject($subject);
$mail->setFrom($fromadr);
$receiver=array($email);
if(!$insafemode)
@set_time_limit($msendlimit);
if($use_smtpmail)
{
$mail->setSMTPParams($smtpserver,$smtpport,NULL,$smtpauth,$smtpuser,$smtppasswd);
$sendresult=$mail->send($receiver, "smtp");
}
else
$sendresult=$mail->send($receiver, "mail");
do_emaillog($sendresult,$email,"subcribe newsletter");
}
else if($newsubscriptionnotify==1)
{
$tmpsql="select * from ".$tableprefix."_categories where catnr=".$newscat[$i];
if(!$tmpresult = mysql_query($tmpsql, $db))
die(" |
| Could not connect to the database.".mysql_error());
if($tmprow=mysql_fetch_array($tmpresult))
{
$catname=stripslashes($tmprow["catname"]);
$tmpsql2="select * from ".$tableprefix."_catnames where catnr=".$tmprow["catnr"]." and lang='".$act_lang."'";
if(!$tmpresult2=mysql_query($tmpsql2,$db))
die(" |
| Unable to connect to database.".mysql_error());
if($tmprow2=mysql_fetch_array($tmpresult2))
{
if(strlen($tmprow2["catname"])>0)
$catname=stripslashes($tmprow2["catname"]);
}
}
else
$catname=$l_unknown;
$tmpsql="select u.* from ".$tableprefix."_newsubnotify nsn, ".$tableprefix."_users u where u.usernr=nsn.usernr";
if(!$tmpresult = mysql_query($tmpsql, $db))
die(" |
| Could not connect to the database.".mysql_error());
while($tmprow=mysql_fetch_array($tmpresult))
{
$linkurl=$simpnews_fullurl."admin/subscribers.php?$langvar=".$tmprow["language"]."&mode=display&input_subscriptionnr=$subscriptionnr";
$tmpsql2="select * from ".$tableprefix."_texts where lang='".$tmprow["language"]."' and textid='newsubsubj'";
if(!$tmpresult2 = mysql_query($tmpsql2, $db))
die(" |
| Could not connect to the database.".mysql_error());
if(!$tmprow2=mysql_fetch_array($tmpresult2))
$subject=$l_newsubsubj;
else
$subject=undo_htmlspecialchars($tmprow2["text"]);
$subject=str_replace("{sitename}",$simpnewssitename,$subject);
$subject=strip_tags($subject);
$tmpsql2="select * from ".$tableprefix."_texts where lang='".$tmprow["language"]."' and textid='newsubmsg'";
if(!$tmpresult2 = mysql_query($tmpsql2, $db))
die(" |
Could not connect to the database.".mysql_error());
if(!$tmprow2=mysql_fetch_array($tmpresult2))
$mailmsg=$l_newsubmsg;
else
$mailmsg=undo_htmlspecialchars($tmprow2["text"]);
$mailmsg=str_replace("{sitename}",$simpnewssitename,$mailmsg);
$mailmsg=str_replace("{email}",$email,$mailmsg);
$mailmsg=str_replace("{category}",$catname,$mailmsg);
$mailmsg=str_replace("{linkurl}","$linkurl",$mailmsg);
$mailmsg_asc=str_replace("
","\r\n",$mailmsg);
$mailmsg_asc=strip_tags($mailmsg_asc);
$mail = new htmlMimeMail();
$mail->setCrlf($crlf);
$mail->setTextWrap($mailmaxlinelength);
$mail->setHTMLCharset($contentcharset);
$mail->setTextCharset($contentcharset);
$mail->setHTML($mailmsg,$mailmsg_asc);
$mail->setSubject($subject);
if($simpnewsmailname)
$fromadr="\"$simpnewsmailname\" <$simpnewsmail>";
else
$fromadr=$simpnewsmail;
$mail->setFrom($fromadr);
$receiver=array($tmprow["email"]);
if(!$insafemode)
@set_time_limit($msendlimit);
if($use_smtpmail)
{
$mail->setSMTPParams($smtpserver,$smtpport,NULL,$smtpauth,$smtpuser,$smtppasswd);
$sendresult=$mail->send($receiver, "smtp");
}
else
$sendresult=$mail->send($receiver, "mail");
do_emaillog($sendresult,$tmprow["email"],"new newsletter subscription (1)");
}
}
}
$redirect=1;
if($subredirecturl)
$backurl=$subredirecturl;
include_once('./includes/head.inc');
?>
|
|
";
echo "";
echo "$l_subscriptiondone | ";
if($maxconfirmtime>0)
{
echo "";
echo "";
$tmpsql="select * from ".$tableprefix."_texts where textid='subconfinfo' and lang='$act_lang'";
if(!$tmpresult = mysql_query($tmpsql, $db))
die("| Could not connect to the database.");
if($tmprow=mysql_fetch_array($tmpresult))
echo stripslashes($tmprow["text"]);
else
echo "$l_subscriptionconfirminfo";
echo " | ";
}
if(!isset($backurl))
{
if(!isset($category))
$category=0;
$backurl="news.php?$langvar=$act_lang&layout=$layout&category=$category";
}
if($redirectdelay>=0)
{
echo "";
echo "| ";
echo "$l_redirected | ";
}
echo "";
echo "| ";
echo "$l_news | ";
echo " |
";
include_once('./includes/footer.inc');
exit;
?>