<?php include('_mod_security.php'); ?>
<?php
	session_start();
	// ****** Prepare database query ******
	$sql = "SELECT *, IF(guest_type = 'P',0,1) AS sort_type, IF(guest_type = 'P',id,primary_guest_id) AS sort_id ".
	" FROM guests WHERE guest_type <> 'G' AND table_".mysqli_real_escape_string($GLOBALS['con'], trim($_GET['venue']))." = ".mysqli_real_escape_string($GLOBALS['con'], trim($_GET['id']))." AND invite_".mysqli_real_escape_string($GLOBALS['con'], trim($_GET['venue']))." = 1 AND rsvp_".mysqli_real_escape_string($GLOBALS['con'], trim($_GET['venue']))." = 1  AND event_id = ".$_SESSION['active_event']." AND user_id = ".$_SESSION['user_id']. " ".
	" ORDER BY sort_id ASC, sort_type ASC, last_name ASC";
	$result = mysqli_query($GLOBALS['con'], $sql);
	while ($row = mysqli_fetch_object($result)) :
		$extra_class = '';
		if ($row->guest_type == 'C') :
			$extra_class = ' italic ';
		endif;
		$guest_name = format_guest_name_string($row->salutation, $row->first_name, $row->last_name, $row->suffix);
?>
		<div class="draggable_guest <?php echo $extra_class; ?>" title="<?php echo $guest_name; ?>" gid="<?php echo $row->id; ?>" <?php if ($row->guest_type != 'P') : /*echo 'style="margin-left:15px;"';*/ endif; ?> >
			<?php echo $guest_name; ?>
		</div>
<?php
	endwhile;
	echo 'Total guests: '.mysqli_num_rows($result);
?>