<?php include('_mod_security.php'); ?>
<?php
	//header('Content-Type: application/json');
	$type = mysqli_real_escape_string($GLOBALS['con'], $_GET['type']);
	$sql = "SELECT COUNT(IF(hotel_".$type." = 1,1,NULL)) AS hotel_count ".
					"FROM guests WHERE user_id = ".mysqli_real_escape_string($GLOBALS['con'], $_SESSION['user_id'])." AND event_id = ".mysqli_real_escape_string($GLOBALS['con'], $_SESSION['active_event'])." AND ".
					"((guest_type = 'P' AND (rsvp_temple = 1 OR rsvp_av = 1 OR rsvp_kv = 1 OR rsvp_bv = 1 OR rsvp_dv = 1)) OR ".
					"(guest_type = 'C' AND primary_guest_id = 0 AND (rsvp_temple = 1 OR rsvp_av = 1 OR rsvp_kv = 1 OR rsvp_bv = 1 OR rsvp_dv = 1)) OR ".
					"(guest_type = 'P' AND (rsvp_temple <> 1 AND rsvp_av <> 1 AND rsvp_kv <> 1 AND rsvp_bv <> 1 AND rsvp_dv <> 1) AND (SELECT COUNT(*) FROM guests g3 WHERE g3.primary_guest_id = guests.id AND (g3.rsvp_temple = 1 OR g3.rsvp_av = 1 OR g3.rsvp_kv = 1 OR g3.rsvp_bv = 1 OR g3.rsvp_dv = 1) ) > 0  )) ";
	$result = mysqli_query($GLOBALS['con'], $sql);
	if (mysqli_num_rows($result) > 0) :
		$row = mysqli_fetch_object($result);
		echo json_encode(array('hotel_count' => $row->hotel_count));
	endif;
?>