class eyesConnect
{
	public function getCode() {
		include_once('config.php');
    	$db= new mysqli($dbHost, $dbUsername, $dbPassword, $dbDatabase);
		if($db) {
			$sql= "SELECT id, code FROM codes WHERE active= 1 ORDER BY id DESC LIMIT 1";
			$code= $db->prepare($sql);
			$code->execute();
			$code->bind_result($codeId, $codeValue);
			while ( $code->fetch() ) {
				EyesConnect::expire($codeId);
				return $codeValue;
			}		
		} else {
			return 'Poop';
		}
	}
	
	private function expire($id) {
		include_once('config.php');
    	$db= new mysqli($dbHost, $dbUsername, $dbPassword, $dbDatabase);
		if($db) {
			$sql = "UPDATE codes SET active = 0 WHERE id = '$id'";
			$code= $db->prepare($sql);
			$code->execute();
			error_log($sql);
		} else {
		}
	}
	
	private function notify() {
		include_once('config.php');
		$db= new mysqli($dbHost, $dbUsername, $dbPassword, $dbDatabase);
		if($db) {
			$sql= "SELECT count(*) FROM codes WHERE active= 1";
			$code= $db->prepare($sql);
			$code->execute();
			$num= $code->store_result();
			return $num;
		} else {
			return 'poop!';
		}
	}
}