|
|
|
|
|
|
Unable to connect to database.".mysql_error());
$sql = "delete from ".$tableprefix."_search where newsnr='$newsnr'";
if(!$result = mysql_query($sql, $db))
die(" | | Unable to connect to database.".mysql_error());
$sql = "delete from ".$tableprefix."_news_attachs where newsnr='$newsnr'";
if(!$result = mysql_query($sql, $db))
die(" |
| Unable to connect to database.".mysql_error());
}
else
{
$tmpsql="select * from ".$tableprefix."_texts where textid='delnews' and lang='$act_lang'";
if(!$result = mysql_query($tmpsql, $db))
die(" |
| Unable to connect to database.");
if($myrow=mysql_fetch_array($result))
$mailmsg_html = stripslashes($myrow["text"]);
else
$mailmsg_html = $l_delnewsmail;
$tmpsql="select * from ".$tableprefix."_data where newsnr='$newsnr'";
if(!$result = mysql_query($tmpsql, $db))
die(" |
| Unable to connect to database.");
if(!$myrow=mysql_fetch_array($result))
die(" |
Unable to connect to database.");
$mailmsg_html=str_replace("{email}",$userdata["email"],$mailmsg_html);
$mailmsg_html=str_replace("{newsnr}",$newsnr,$mailmsg_html);
$mailmsg=undo_htmlentities($mailmsg_html);
$mailmsg=str_replace("
","\r\n",$mailmsg);
$mailmsg=strip_tags($mailmsg);
$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();
if(($notifymode==0) || ($myrow["category"]==0))
$tmpsql="select u.* from ".$tableprefix."_notifylist nl, ".$tableprefix."_users u where u.usernr=nl.usernr";
else
$tmpsql="select u.* from ".$tableprefix."_users u, ".$tableprefix."_cat_adm ca where u.usernr=ca.usernr and ca.catnr=".$myrow["category"];
if(!$tmpresult = mysql_query($tmpsql, $db))
die(" |
| Could not connect to the database.".mysql_error());
while($tmprow=mysql_fetch_array($tmpresult))
{
$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"],"delete proposal");
}
}
}
else if(isset($propnr))
{
$sql="delete from ".$tableprefix."_tmpdata where entrynr='$propnr'";
if(!$result = mysql_query($sql, $db))
die(" |
| Unable to connect to database.".mysql_error());
}
else
die(" |
| ".$l_callingerror);
echo " |
";
echo "| ";
echo "$l_entrydeleted |
";
$linkurl="$act_script_url?$langvar=$act_lang&mode=edlst&layout=$layout";
if(isset($backurl))
$linkurl.="&backurl=".urlencode($backurl);
echo "";
echo "| ";
echo "";
echo "$l_editownproposals |
";
}
?>