'; $var_NL = "\n\n"; $var_SP = ' - '; $org_ToEmail = $ToEmail; $var_Parts = split('@',$ToEmail); //echo "
"; //print_r($var_Parts); //echo "
"; $var_EmailSite = $var_Ask.$var_Att.$var_Parts[1]; $var_EmailUser = $var_Parts[0].$var_Att.$var_Parts[1]; //echo "
"; //echo "
to: $ToEmail
"; //echo "
from: $FromEmail
"; //echo "
site: $var_EmailSite
"; //echo "
user: $var_EmailUser
"; $sql = " SELECT tb_EmailBlackList.col_WatchList, tb_EmailBlackListMessage.col_Subject, tb_EmailBlackListMessage.col_Message, tb_EmailBlackListMessage.col_Text FROM tb_EmailBlackList LEFT JOIN tb_EmailBlackListMessage ON tb_EmailBlackListMessage.col_Type = tb_EmailBlackList.col_Type WHERE col_ActiveYN = 'Yes' AND (tb_EmailBlackList.col_WatchList = '$var_EmailSite' OR tb_EmailBlackList.col_WatchList = '$var_EmailUser')"; //echo "
$sql
"; if ($result = mysqli_query($cms_dblink,$sql)) { $rows = mysqli_num_rows($result); $myrow = mysqli_fetch_array($result); $var_WatchList = $myrow["col_WatchList"]; $var_Subject = $myrow["col_Subject"]; $var_Message = $myrow["col_Message"]; $var_Text = $myrow["col_Text"]; } if ($var_WatchList) { $ToEmail = $FromEmail; $var_Status = 'blacklist'; $var_EmailMessage = " *** email $org_ToEmail matches watchlist $var_WatchList *** "; $Subject = ($var_Subject && $Subject) ? $var_Subject.$var_SP.$Subject : $Subject; $Html = ($var_Message && $Html) ? $var_Message.$var_BR.$var_EmailMessage.$var_BR.$Html : $Html; $Text = ($var_Text && $Text) ? $var_Text.$var_NL.$var_EmailMessage.$var_NL.$Text : $Text; } $str_result = $result ? 'good' : 'failed'; //echo "
result: $str_result
"; //echo "
rows: $rows
"; //echo "
watch: $var_WatchList
"; //echo "
status: $var_Status
"; return $var_Status; } ?>