<?PHP
	
	require_once "./admin/db/config.php";
	
	if (isset($_POST['subscriberEMAIL']) == 'subscriberEMAIL') {
		
		$email = $_POST['email'];
		
		if (isset($connection)) {
			$checkEmail = $connection->query("SELECT * FROM `subscribers` WHERE `email` = '$email'");
			if ($checkEmail) {
				if ($checkEmail->num_rows > 0) {
					echo "EXISTS";
				} else {
					$addSubscriber = $connection->query("INSERT INTO `subscribers`(`email`) VALUES ('$email')");
					if ($addSubscriber) {
						echo "SUCCESS";
					} else {
						echo "ERROR";
					}
				}
			} else {
				echo "ERROR";
			}
		} else {
			echo "ERROR";
		}
	}
	
	if (isset($_POST['category__change__status']) == 'category__change__status') {
		$id = (int)$_POST['id'];
		if (isset($connection)) {
			$getStatus = (int)$connection->query("SELECT `status` FROM `category` WHERE `id` = $id")->fetch_object()->status;
			$changeTo = 1;
			if ($getStatus == 1) {
				$changeTo = 0;
			}
			$changeStatus = $connection->query("UPDATE `category` SET `status` = $changeTo WHERE `id` = $id");
			if ($changeStatus) {
				echo "TRUE";
			} else {
				echo "FALSE";
			}
		} else {
			echo "FALSE";
		}
		
	}
	
	
	if (isset($_POST['sub_category__change__status']) == 'sub_category__change__status') {
		$id = (int)$_POST['id'];
		if (isset($connection)) {
			$getStatus = (int)$connection->query("SELECT `status` FROM `sub_category` WHERE `id` = $id")->fetch_object()->status;
			$changeTo = 1;
			if ($getStatus == 1) {
				$changeTo = 0;
			}
			$changeStatus = $connection->query("UPDATE `sub_category` SET `status` = $changeTo WHERE `id` = $id");
			if ($changeStatus) {
				echo "TRUE";
			} else {
				echo "FALSE";
			}
		} else {
			echo "FALSE";
		}
		
	}
	
	
	if (isset($_POST['services__change__status']) == 'services__change__status') {
		$id = (int)$_POST['id'];
		if (isset($connection)) {
			$getStatus = (int)$connection->query("SELECT `status` FROM `page` WHERE `id` = $id")->fetch_object()->status;
			$changeTo = 1;
			if ($getStatus == 1) {
				$changeTo = 0;
			}
			$changeStatus = $connection->query("UPDATE `page` SET `status` = $changeTo WHERE `id` = $id");
			if ($changeStatus) {
				echo "TRUE";
			} else {
				echo "FALSE";
			}
		} else {
			echo "FALSE";
		}
		
	}