<?php
include 'globalVars.php';

if (isset($_GET["email"])) {
	$emailAddress		= cleanPost($_GET["email"], $conn);
	$dateUnsubscribed	= date("Y-m-d H:i:s");
} else {
	$emailAddress		= "";
}

$checkQuery = mysqli_query($conn, "SELECT * FROM eventsSubscribers WHERE emailAddress = '$emailAddress'");
if (isset($_GET["show"])) {
	echo mysqli_num_rows($checkQuery) ." RESULTS<br />";
}
if (mysqli_num_rows($checkQuery) > 0) {
	while ($cQ = mysqli_fetch_array($checkQuery)) {
		$unsubbedID		= $cQ["id"];
		$emailAddress	= $cQ["emailAddress"];
		$dateSubscribed	= $cQ["dateSubscribed"];

		if (isset($_GET["show"])) {
			echo "INSERT INTO eventsUnsubscribed (emailAddress, dateUnsubscribed) VALUES ('". addslashes($emailAddress) ."', '$dateUnsubscribed')<br />";
			echo "DELETE FROM eventsSubscribers WHERE id = '$unsubbedID'<br />";
		}
		mysqli_query($conn, "INSERT INTO eventsUnsubscribed (emailAddress, dateSubscribed, dateUnsubscribed) VALUES ('". addslashes($emailAddress) ."', '$dateSubscribed', '$dateUnsubscribed')") or die (mysqli_error($conn));
		mysqli_query($conn, "DELETE FROM eventsSubscribers WHERE id = '$unsubbedID'");

	}
}

$headerTitle		= $LANG_EVENT_UNSUB_TITLE;
$pageTitle			= $LANG_EVENT_UNSUB_TITLE;
$pageURL			= "unsubscribe";
$breadcrumbTitle	= $LANG_EVENT_UNSUB_BC_TITLE;
$emailToReplace		= maskEmail($LANG_DEFAULT_EMAIL);
$pageText			= str_replace("[[LANG_DEFAULT_EMAIL]]", $emailToReplace, $LANG_EVENT_UNSUB_TEXT);

include 'header.php';

?>

	<div id="pageBreadcrumb">
		<div class="container">
			<ol id="pagesBreadcrumb" itemscope itemtype="http://schema.org/BreadcrumbList">
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url ?>" itemprop="item"><span itemprop="name"><?php echo $LANG_MENU_HOME_TITLE ?></span></a><meta itemprop="position" content="1" /></li>
				<li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"><a href="<?php echo $url . $pageURL ?>.html" itemprop="item"><span itemprop="name"><?php echo $breadcrumbTitle ?></span></a><meta itemprop="position" content="2" /></li>
			</ol>
		</div>
	</div>
	<div class="mainContent">
		<div class="container">
			<h2><?php echo $pageTitle ?></h2>
			<p><?php echo $pageText ?></p>
		</div>
	</div>


<?php
include 'footer.php';
?>