is_valid()) {
$infoMessage = '';
if ($optOutNewListingAlert || $optOutMarketing) {
$dbh = Data_Database::getInstance();
if ($optOutNewListingAlert) {
$sql = "SELECT `b`.`iSavedSearchID`
FROM `tblUser` `a`
JOIN `tblSavedSearch` `b` ON (`a`.`pk_iUserID` = `b`.`iUserID`)
WHERE `b`.iAlert = 1 AND `a`.`szEmail` = '".cleanDBValue($email)."'";
$newListingAlerts = $dbh->selectQuery($sql);
$alertsDeactivated = 0;
if ($newListingAlerts->queryCount) {
while (false !== ($row = $newListingAlerts->fetchAssoc())) {
$alertObj = new Search_Saver($row['iSavedSearchID']);
if ($alertObj->deactivateAlert()) {
$alertsDeactivated++;
}
}
if ($alertsDeactivated) {
$infoMessage = 'You have been unsubscrbed from our "New Listings in Your Area!" email. ';
} else {
$error = true;
$infoMessage = 'There was an error unsubscribing you from our "New Listings in Your Area!" email, please try again later. ';
}
} else {
$infoMessage = 'You have been unsubscrbed from our "New Listings in Your Area!" email. ';
}
}
if ($optOutMarketing) {
$optOut = new Email_OptIn($email);
if ($optOut->exists()) {
if ($optOut->optOut()) {
if (!$error) {
$success = true;
$displayForm = false;
}
$infoMessage .= "You have been unsubscrbed from our marketing e-mails.";
} else {
$error = true;
$infoMessage .= 'There was an error unsubscrbing you from our marketing e-mails, please try again later.';
}
} else {
$error = true;
$infoMessage .= "You are already unsubscribed from our marketing e-mails. If you received an e-mail from us, it was a one time message or our systems haven't been updated yet.";
}
}
} else {
$error = true;
$infoMessage = "Please select a list to unsubscribe from.";
}
}
elseif($email != '') {
//Dont throw an error if e-mail address is blank!!!
$error = true;
$infoMessage = "Your e-mail address is invalid.";
}
$styles = array();
if($chrome->tags['iSiteID'] != 1) {
$styles[] = '';
}
$styles[] = '';
$page = new Display_Template();
$page->assign('title', $chrome->tags['NAME'] . ' | User Login');
$page->assign('styles', $styles);
$page->assign('infoMessage', $infoMessage);
$page->assign('error', $error);
$page->assign('success', $success);
$page->assign('displayForm', $displayForm);
$page->assign('email', $email);
$page->display_chrome('htmlHeader.tpl');
$page->display_chrome('topNav.tpl');
$page->display_chrome('unsubscribe.tpl');
$page->display_chrome('footer.tpl');
$page->display_chrome('htmlFooter.tpl');