";
//deactivate email address
if (filter_var($_POST['email'], FILTER_VALIDATE_EMAIL) && $sName = trim(strip_tags($_POST['email']))){//confirmed
//expects email, allows comments
//deactivate newsList with email addr and set deactivatedOn date
$useEmail = filter_var($sName, FILTER_SANITIZE_EMAIL);
$deSql = 'update EPWnewsList set isActive=0, deactivatedOn="'.date('Y-m-d H:i:s').'" where isActive=1 and emAddr="'.$useEmail.'"';
//echo "
deSql:".$deSql;
mysqli_query($GLOBALS['DB_LINK'],$deSql);
if ($_POST['comments']){ //also submit comments
$useComments = mysqli_real_escape_string($GLOBALS['DB_LINK'], filter_var(trim($_POST['comments']),FILTER_SANITIZE_STRING));
$useIP = getUserIP();
$comSql = 'insert into EPWuserComments(creatorIP,emAddr,comments) values ("'.$useIP.'","'.$useEmail.'","'.$useComments.'")';
//echo "
comSql:".$comSql;
mysqli_query($GLOBALS['DB_LINK'],$comSql);
}
$content = "
Your email address has been removed. [Confirmation will be sent to: ".$sName.']
';
$content .= '
';
}else{
$headerBlurb = ''.$siteName.'
We\'ll miss you, and would appreciate knowing why you\'re going...
Please confirm your email address:
';
if ($_GET['email']) $newsletterEmailHint=$_GET['email'];
$newsletterEmail = $_GET['email'];
$content = $headerBlurb.clrfix().chr(13).'
';
}
?>
$pageTitle);
require_once('./inc/genBreadCrumbs.php'); ?>