403Webshell
Server IP : 172.67.201.108  /  Your IP : 216.73.217.99
Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5
System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64
User : ec2-user ( 1000)
PHP Version : 8.4.23
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /home/mitzvahm/wwwdevplanner/mod/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /home/mitzvahm/wwwdevplanner/mod/favorlist.php
<?php include('_mod_security.php'); ?>
<?php
	// *** venue ***
	$sql = "SELECT * FROM events WHERE user_id = ".$_SESSION['user_id']."  AND id = ".$_SESSION['active_event']." ";
	$result_event = mysqli_query($GLOBALS['con'], $sql);
	$num_venues = 0;
	if (mysqli_num_rows($result_event) > 0) :
		$row_event = mysqli_fetch_object($result_event);
		if (!empty($row_event->temple_name)) :
			$ar_venue['temple'] = venue_decode('temple');
		endif;
		if (!empty($row_event->av_name)) :
			$ar_venue['av'] = venue_decode('av');
		endif;
		if (!empty($row_event->kv_name)) :
			$ar_venue['kv'] = venue_decode('kv');
		endif;
		if (!empty($row_event->bv_name)) :
			$ar_venue['bv'] = venue_decode('bv');
		endif;
		if (!empty($row_event->dv_name)) :
			$ar_venue['dv'] = venue_decode('dv');
		endif;
		$current_venue_name = reset($ar_venue);
		$current_venue = key($ar_venue);
		if (!empty($_GET['venue'])) :
			$current_venue = $_GET['venue'];
		endif;
		$current_venue = mysqli_real_escape_string($GLOBALS['con'], trim($current_venue));
	endif;
	// *** Favors ***
	$sql = "SELECT * FROM favors WHERE venue = '".$current_venue."' AND user_id = ".$_SESSION['user_id']."  AND event_id = ".$_SESSION['active_event']." ";
	$result_favors = mysqli_query($GLOBALS['con'], $sql);
	$num_favors = mysqli_num_rows($result_favors);
	// *** Guests ***
	$sql = "SELECT g.*, IF(g.guest_type = 'P',0,1) AS sort_type, IF(g.guest_type = 'P',g.id,g.primary_guest_id) AS sort_id, IF(g.guest_type = 'C','Child','Adult') AS guest_group  FROM guests g WHERE g.guest_type <> 'G' AND g.rsvp_".$current_venue." = 1 AND g.user_id = ".$_SESSION['user_id']."  AND g.event_id = ".$_SESSION['active_event']." ";
	$search_parm = mysqli_real_escape_string($GLOBALS['con'], trim($_POST['strSearch']));
	if ($search_parm != '') :
		$sql = $sql." AND ".search_sql($_POST['strSearch'],'last_name,first_name')." ";
	endif;
	$sql = $sql." ORDER BY sort_id ASC, sort_type ASC, g.last_name ASC";
	$result = mysqli_query($GLOBALS['con'], $sql);
	//*** favor types
	mysqli_data_seek($result_favors, 0);
	$sql_favors = '';
	$pick_any = false;
	while($row_favors = mysqli_fetch_object($result_favors)) :
		$num_cells_gender[$row_favors->id] = 0;
		$num_cells_size[$row_favors->id] = 0;
		$pick_gender[$row_favors->id] = false;
		$pick_size[$row_favors->id] = false;
		if ($row_favors->gender_m == 1) :
			$pick_any = true;
			$pick_gender[$row_favors->id] = true;
			$num_cells_gender[$row_favors->id] = $num_cells_gender[$row_favors->id] + 1;
		endif;
		if ($row_favors->gender_f == 1) :
			$pick_any = true;
			$pick_gender[$row_favors->id] = true;
			$num_cells_gender[$row_favors->id] = $num_cells_gender[$row_favors->id] + 1;
		endif;
		if ($row_favors->size_xs == 1) :
			$pick_any = true;
			$pick_size[$row_favors->id] = true;
			$num_cells_size[$row_favors->id] = $num_cells_size[$row_favors->id] + 1;
		endif;
		if ($row_favors->size_s == 1) :
			$pick_any = true;
			$pick_size[$row_favors->id] = true;
			$num_cells_size[$row_favors->id] = $num_cells_size[$row_favors->id] + 1;
		endif;
		if ($row_favors->size_m == 1) :
			$pick_any = true;
			$pick_size[$row_favors->id] = true;
			$num_cells_size[$row_favors->id] = $num_cells_size[$row_favors->id] + 1;
		endif;
		if ($row_favors->size_l == 1) :
			$pick_any = true;
			$pick_size[$row_favors->id] = true;
			$num_cells_size[$row_favors->id] = $num_cells_size[$row_favors->id] + 1;
		endif;
		if ($row_favors->size_xl == 1) :
			$pick_any = true;
			$pick_size[$row_favors->id] = true;
			$num_cells_size[$row_favors->id] = $num_cells_size[$row_favors->id] + 1;
		endif;
		if ($row_favors->size_xxl == 1) :
			$pick_any = true;
			$pick_size[$row_favors->id] = true;
			$num_cells_size[$row_favors->id] = $num_cells_size[$row_favors->id] + 1;
		endif;
	endwhile;
	$xls_sql = "SELECT f.description, g.first_name, g.last_name, IF(g.guest_type = 'C','Child','Adult') AS guest_age, gf.size, gf.gender, e.".$current_venue."_rename AS event ".
				//$sql_inserts.
				"FROM (events e INNER JOIN guests g ON (e.id = g.event_id AND e.user_id = g.user_id)) INNER JOIN guests_favors gf ON (g.id = gf.guest_id) INNER JOIN favors f ON (gf.favor_id = f.id)  WHERE g.guest_type <> 'G' AND g.rsvp_".$current_venue." = 1 AND g.user_id = ".$_SESSION['user_id']." AND g.event_id = ".$_SESSION['active_event']."  ".
				//"GROUP BY g.last_name, g.first_name, g.id, g.placecard_".$current_venue."_text, t.table_no, t.table_desc ".
				"ORDER BY f.description ASC, g.last_name ASC, g.first_name ASC";
	$ix_list = "favorlist&venue=".$current_venue;
	$ix_form = "guest_form&ref=favorlist";
	$vert_text_size = 10;
	
	function favor_exists($guest_id, $favor_id, $venue)
	{
		$sql = "SELECT * FROM guests_favors WHERE guest_id = ".$guest_id." AND favor_id = ".$favor_id." AND venue = '".$venue."' AND user_id = ".$_SESSION['user_id']."  AND event_id = ".$_SESSION['active_event']." ";
		//echo "===".$sql."===";
		$result = mysqli_query($GLOBALS['con'], $sql);
		if (mysqli_num_rows($result) > 0) :
			return true;
		else :
			return false;
		endif;
	}

	function favor_gender_match($guest_id, $favor_id, $venue, $gender)
	{
		$sql = "SELECT * FROM guests_favors WHERE guest_id = ".$guest_id." AND favor_id = ".$favor_id." AND venue = '".$venue."' AND gender = '".$gender."' AND user_id = ".$_SESSION['user_id']."  AND event_id = ".$_SESSION['active_event']." ";
		//echo " ===".$sql."=== ";
		$result = mysqli_query($GLOBALS['con'], $sql);
		if (mysqli_num_rows($result) > 0) :
			return true;
		else :
			return false;
		endif;
	}

	function favor_size_match($guest_id, $favor_id, $venue, $size)
	{
		$sql = "SELECT * FROM guests_favors WHERE guest_id = ".$guest_id." AND favor_id = ".$favor_id." AND venue = '".$venue."' AND size = '".$size."' AND user_id = ".$_SESSION['user_id']."  AND event_id = ".$_SESSION['active_event']." ";
		//echo "===".$sql."===";
		$result = mysqli_query($GLOBALS['con'], $sql);
		if (mysqli_num_rows($result) > 0) :
			return true;
		else :
			return false;
		endif;
	}
?>
<script>
	check_favor = function(gid, fid)
	{
		if ($('input[id="favor_enable_' + gid + '_' + fid + '"]').attr('checked') == 'checked')
		{
			$('.favor_' + gid + '_' + fid).attr('disabled', null);
		}
		else
		{
			$('.favor_' + gid + '_' + fid).attr('disabled', 'disabled');
			$('.favor_' + gid + '_' + fid).attr('checked', null);
		} 
	}

	propagate_column_favor = function(fid)
	{
		if ($('#column_favor_' + fid).attr('checked') == 'checked')
		{
			if (confirm('Are you sure?'))
			{
				//$('input[id^="placecard_print_"]:enabled').attr('checked', 'checked').change();
				$('.favor_enable_' + fid + ':not(:checked)').attr('checked', 'checked').change();
			}
			else
			{
				$('#column_favor_' + fid).attr('checked',null);
			}
		}
	}
	switch_favor = function(gid, fid, venue)
	{
		$('#ajax_update').load('ajax.php?call=favorlist_update&func=favor&venue=' + venue + '&gid=' + gid + '&fid=' + fid +
				'&enable=' + val_checkbox($('input[name=favor_enable_' + gid + '_' + fid + ']:checked').val()), 
				function() 
				{
					check_favor(gid, fid);
					total_stats_favor(venue, fid, 'enable', '', 'total_favor_enable_' + fid);
				} );
		if (document.getElementById('favor_enable_' + gid + '_' + fid).checked)
		{
			//$('.favor_' + gid + '_' + fid).attr('disabled', null);
		}
		else
		{
			$('#column_favor_' + fid).attr('checked',null);
		}
	}
	
	switch_gender = function(gender, gid, fid, venue)
	{
		$('#ajax_update').load('ajax.php?call=favorlist_update&func=gender&venue=' + venue + '&gid=' + gid + '&fid=' + fid +
				'&gender=' + gender, 
				function() 
				{
					total_stats_favor(venue, fid, 'gender', 'm', 'total_favor_gender_m_' + fid);
					total_stats_favor(venue, fid, 'gender', 'f', 'total_favor_gender_f_' + fid);
				} );
		if (document.getElementById('favor_enable_' + gid + '_' + fid).checked)
		{
			//alert('switch_invited');
		}
		else
		{
			//document.getElementById('column_print_all').checked = false;
		}
	}
	
	switch_size = function(size, gid, fid, venue)
	{
		$('#ajax_update').load('ajax.php?call=favorlist_update&func=size&venue=' + venue + '&gid=' + gid + '&fid=' + fid +
				'&size=' + size, 
				function() 
				{
					//total_stats_favor(venue, fid, 'size', size, 'total_favor_size_' + size.toLowerCase() + '_' + fid);
					total_stats_favor(venue, fid, 'size', 'XS', 'total_favor_size_xs_' + fid);
					total_stats_favor(venue, fid, 'size', 'S', 'total_favor_size_s_' + fid);
					total_stats_favor(venue, fid, 'size', 'M', 'total_favor_size_m_' + fid);
					total_stats_favor(venue, fid, 'size', 'L', 'total_favor_size_l_' + fid);
					total_stats_favor(venue, fid, 'size', 'XL', 'total_favor_size_xl_' + fid);
					total_stats_favor(venue, fid, 'size', 'XXL', 'total_favor_size_xxl_' + fid);
				} );
		if (document.getElementById('favor_enable_' + gid + '_' + fid).checked)
		{
			//alert('switch_invited');
		}
		else
		{
			//document.getElementById('column_print_all').checked = false;
		}
	}
	
	total_stats_favor = function(venue, fid, func, value, result)
	{
		$.ajax({
			url: "ajax.php?call=favorlist_stats&func=" + func + "&value=" + value + "&venue=" + venue + "&fid=" + fid,
			cache: false,
			dataType: "json",
			success: function(json) {
					$('#' + result).text(json.total_count);
			}
			 ,error: function (request, status, error) { /* alert(status + ", " + error); */ }
		})
	}

	$(document).ready(function()	
	{
	})
	
	// ****** Prepare popup form settings *****
	var win_page = 'page_form.php';
	var win_width = 600;
	var win_height = 400;
	var print_section = 'div_db_grid';
</script>

<h1>Favor List Worksheet</h1>

<?php
	if (empty($_SESSION['active_event'])) :
?>
		<h3>No Bar/Bat Mitzvah defined - please create or activate a Bar/Bat Mitzvah!</h3>
<?php
	endif;
?>
<?php get_reports('guest_favors_by_venue,favor_labels'); ?>
<?php get_notes(); ?>
<?php get_help_guide('help_favorlist'); ?>

<div class="form_message">
	<?php
		$i = 0;
		foreach($ar_venue as $key=>$value) :
			$i = $i + 1;
			$checked = '';
			if ($key == $current_venue) :
				$checked = 'checked="checked"';
			endif;
	?>
				<span style="color:#000000;">
				<input type="radio" name="venue" id="venue_<?php echo $key; ?>" <?php echo $checked; ?> onclick="window.location.href = 'index.php?IX=favorlist&venue=<?php echo $key; ?>'"  /><?php echo $value; ?>&nbsp;&nbsp;
				</span>
	<?php
		endforeach;
		if ($i <= 0) :
	?>
			No venues currently defined.  Please define at least one venue for the party <a href="index.php?IX=event_form&id=<?php echo $_SESSION['active_event']; ?>">here</a>.
	<?php
			return;
		endif;
	?>
</div>

<?php include('mod/_db_navigator_bar.php'); ?>

<div id="ajax_update" style="width:300px; height:300px; display:none;">
</div>

<div class="db-grid" id="div_db_grid">

	<table id="db_grid_main" class="dbgrid" align="center" cellpadding="0" cellspacing="1" border="0" >
		<thead>
			<tr>
				<td align="center" class="data-grid-label vert_cell" width="175">
					Name
				</td>
				<td align="center" class="data-grid-label vert_cell">
					Type
				</td>
				<td align="center" class="data-grid-label">
					Gender
				</td>
				<td align="center" class="data-grid-label">
					Size
				</td>
				<?php
					mysqli_data_seek($result_favors, 0);
					$sql_favors = '';
					while($row_favors = mysqli_fetch_object($result_favors)) :
				?>
						<td class="data-grid-separator">&nbsp;
						</td>
						<td align="center" colspan="<?php echo $num_cells_gender[$row_favors->id] + $num_cells_size[$row_favors->id] + 1; ?>" class="data-grid-label" >
							<?php echo $row_favors->description; ?>
						</td>
				<?php
					endwhile;
				?>
			</tr>
			<?php
				if ($pick_any == true) :
			?>
					<tr>
						<td align="center" class="data-grid-label">&nbsp;
						</td>
						<td align="center" class="data-grid-label">&nbsp;
						</td>
						<td align="center" class="data-grid-label">&nbsp;
						</td>
						<td align="center" class="data-grid-label">&nbsp;
						</td>
						<?php
							mysqli_data_seek($result_favors, 0);
							$sql_favors = '';
							while($row_favors = mysqli_fetch_object($result_favors)) :
						?>
								<td class="data-grid-separator">&nbsp;
								</td>
								<td align="center" class="data-grid-label" >&nbsp;
								</td>
								<?php
									if ($pick_gender[$row_favors->id] == true) :
								?>
										<td align="center" colspan="<?php echo $num_cells_gender[$row_favors->id]; ?>" class="data-grid-label" >
											Gender
										</td>
								<?php
									endif;
									if ($pick_size[$row_favors->id] == true) :
								?>
										<td align="center" colspan="<?php echo $num_cells_size[$row_favors->id]; ?>" class="data-grid-label" >
											Size
										</td>
								<?php
									endif;
								?>
						<?php
							endwhile;
						?>
					</tr>
					<tr>
						<td align="center" class="data-grid-label">&nbsp;
						</td>
						<td align="center" class="data-grid-label">&nbsp;
						</td>
						<td align="center" class="data-grid-label">&nbsp;
						</td>
						<td align="center" class="data-grid-label">&nbsp;
						</td>
						<?php
							mysqli_data_seek($result_favors, 0);
							$sql_favors = '';
							while($row_favors = mysqli_fetch_object($result_favors)) :
						?>
								<td class="data-grid-separator">&nbsp;
								</td>
								<td align="center" class="data-grid-label" >&nbsp;
								</td>
								<?php
									if ($row_favors->gender_m == 1) :
								?>
										<td align="center" class="data-grid-label">
											M
										</td>
								<?php
									endif;
									if ($row_favors->gender_f == 1) :
								?>
										<td align="center" class="data-grid-label">
											F
										</td>
								<?php
									endif;
									if ($row_favors->size_xs == 1) :
								?>
										<td align="center" class="data-grid-label">
											XS
										</td>
								<?php
									endif;
									if ($row_favors->size_s == 1) :
								?>
										<td align="center" class="data-grid-label">
											S
										</td>
								<?php
									endif;
									if ($row_favors->size_m == 1) :
								?>
										<td align="center" class="data-grid-label">
											M
										</td>
								<?php
									endif;
									if ($row_favors->size_l == 1) :
								?>
										<td align="center" class="data-grid-label">
											L
										</td>
								<?php
									endif;
									if ($row_favors->size_xl == 1) :
								?>
										<td align="center" class="data-grid-label">
											XL
										</td>
								<?php
									endif;
									if ($row_favors->size_xxl == 1) :
								?>
										<td align="center" class="data-grid-label">
											XXL
										</td>
								<?php
									endif;
								?>
						<?php
							endwhile;
						?>
					</tr>
			<?php
				endif;
			?>
			<tr>
				<td align="left" class="data-grid-label">
					Totals
				</td>
				<td class="data-grid-var">&nbsp;
				</td>
				<td class="data-grid-var">&nbsp;
				</td>
				<td class="data-grid-var">&nbsp;
				</td>
				<?php
					mysqli_data_seek($result_favors, 0);
					$sql_favors = '';
					while($row_favors = mysqli_fetch_object($result_favors)) :
				?>
						<td class="data-grid-var-separator">&nbsp;
						</td>
						<td id="total_favor_enable_<?php echo $row_favors->id; ?>" align="right" class="data-grid-var" >&nbsp;
						</td>
						<script>
							total_stats_favor('<?php echo $current_venue; ?>', <?php echo $row_favors->id; ?>, 'enable', '', 'total_favor_enable_<?php echo $row_favors->id; ?>');
						</script>
						<?php
							if ($row_favors->gender_m == 1) :
						?>
								<td id="total_favor_gender_m_<?php echo $row_favors->id; ?>" align="right" class="data-grid-var">&nbsp;
								</td>
								<script>
									total_stats_favor('<?php echo $current_venue; ?>', <?php echo $row_favors->id; ?>, 'gender', 'M', 'total_favor_gender_m_<?php echo $row_favors->id; ?>');
								</script>
						<?php
							endif;
							if ($row_favors->gender_f == 1) :
						?>
								<td id="total_favor_gender_f_<?php echo $row_favors->id; ?>" align="right" class="data-grid-var">&nbsp;
								</td>
								<script>
									total_stats_favor('<?php echo $current_venue; ?>', <?php echo $row_favors->id; ?>, 'gender', 'F', 'total_favor_gender_f_<?php echo $row_favors->id; ?>');
								</script>
						<?php
							endif;
							if ($row_favors->size_xs == 1) :
						?>
								<td id="total_favor_size_xs_<?php echo $row_favors->id; ?>" align="right" class="data-grid-var">&nbsp;
								</td>
								<script>
									total_stats_favor('<?php echo $current_venue; ?>', <?php echo $row_favors->id; ?>, 'size', 'XS', 'total_favor_size_xs_<?php echo $row_favors->id; ?>');
								</script>
						<?php
							endif;
							if ($row_favors->size_s == 1) :
						?>
								<td id="total_favor_size_s_<?php echo $row_favors->id; ?>" align="right" class="data-grid-var">&nbsp;
								</td>
								<script>
									total_stats_favor('<?php echo $current_venue; ?>', <?php echo $row_favors->id; ?>, 'size', 'S', 'total_favor_size_s_<?php echo $row_favors->id; ?>');
								</script>
						<?php
							endif;
							if ($row_favors->size_m == 1) :
						?>
								<td id="total_favor_size_m_<?php echo $row_favors->id; ?>" align="right" class="data-grid-var">&nbsp;
								</td>
								<script>
									total_stats_favor('<?php echo $current_venue; ?>', <?php echo $row_favors->id; ?>, 'size', 'M', 'total_favor_size_m_<?php echo $row_favors->id; ?>');
								</script>
						<?php
							endif;
							if ($row_favors->size_l == 1) :
						?>
								<td id="total_favor_size_l_<?php echo $row_favors->id; ?>" align="right" class="data-grid-var">&nbsp;
								</td>
								<script>
									total_stats_favor('<?php echo $current_venue; ?>', <?php echo $row_favors->id; ?>, 'size', 'L', 'total_favor_size_l_<?php echo $row_favors->id; ?>');
								</script>
						<?php
							endif;
							if ($row_favors->size_xl == 1) :
						?>
								<td id="total_favor_size_xl_<?php echo $row_favors->id; ?>" align="right" class="data-grid-var">&nbsp;
								</td>
								<script>
									total_stats_favor('<?php echo $current_venue; ?>', <?php echo $row_favors->id; ?>, 'size', 'XL', 'total_favor_size_xl_<?php echo $row_favors->id; ?>');
								</script>
						<?php
							endif;
							if ($row_favors->size_xxl == 1) :
						?>
								<td id="total_favor_size_xxl_<?php echo $row_favors->id; ?>" align="right" class="data-grid-var">&nbsp;
								</td>
								<script>
									total_stats_favor('<?php echo $current_venue; ?>', <?php echo $row_favors->id; ?>, 'size', 'XXL', 'total_favor_size_xxl_<?php echo $row_favors->id; ?>');
								</script>
						<?php
							endif;
						?>
				<?php
					endwhile;
				?>
			</tr>
		</thead>
		<tbody>
			<tr>
				<td align="right" class="data-grid-var">
					Mark all &raquo;&nbsp;
				</td>
				<td class="data-grid-var">&nbsp;
				</td>
				<td class="data-grid-var">&nbsp;
				</td>
				<td class="data-grid-var">&nbsp;
				</td>
				<?php
					mysqli_data_seek($result_favors, 0);
					$sql_favors = '';
					while($row_favors = mysqli_fetch_object($result_favors)) :
				?>
						<td class="data-grid-var-separator">&nbsp;
						</td>
						<td align="center" class="data-grid-var" >
							<input name="column_favor_<?php echo $row_favors->id; ?>" id="column_favor_<?php echo $row_favors->id; ?>" type="checkbox" value="1" onchange="propagate_column_favor(<?php echo $row_favors->id; ?>);"  />
						</td>
						<?php
							if ($row_favors->gender_m == 1) :
						?>
								<td align="center" class="data-grid-var">&nbsp;
								</td>
						<?php
							endif;
							if ($row_favors->gender_f == 1) :
						?>
								<td align="center" class="data-grid-var">&nbsp;
								</td>
						<?php
							endif;
							if ($row_favors->size_xs == 1) :
						?>
								<td align="center" class="data-grid-var">&nbsp;
								</td>
						<?php
							endif;
							if ($row_favors->size_s == 1) :
						?>
								<td align="center" class="data-grid-var">&nbsp;
								</td>
						<?php
							endif;
							if ($row_favors->size_m == 1) :
						?>
								<td align="center" class="data-grid-var">&nbsp;
								</td>
						<?php
							endif;
							if ($row_favors->size_l == 1) :
						?>
								<td align="center" class="data-grid-var">&nbsp;
								</td>
						<?php
							endif;
							if ($row_favors->size_xl == 1) :
						?>
								<td align="center" class="data-grid-var">&nbsp;
								</td>
						<?php
							endif;
							if ($row_favors->size_xxl == 1) :
						?>
								<td align="center" class="data-grid-var">&nbsp;
								</td>
						<?php
							endif;
						?>
				<?php
					endwhile;
				?>
			</tr>
			<?php
				$primary_guest_id = 0;
				while($row = mysqli_fetch_object($result)) :
			?>
					<tr>
						<td class="data-grid-var" style="min-width:140px;" >
							<?php
								$guest_group = '';
								if ($row->guest_type != 'P') :
									//echo '&nbsp;&nbsp;&nbsp;';
									$guest_group = 'guest_group="guest_group_'.$primary_guest_id.'"';
								else :
									$primary_guest_id = $row->id;
								endif;
							?>
							<a href="index.php?IX=guest_form&id=<?php echo $row->id; ?>&ref=favorlist" >
								<?php echo format_guest_name_string($row->salutation, $row->first_name, $row->last_name, $row->suffix); ?>
							</a>
						</td>
						<td class="data-grid-var" align="left">
							<?php echo $row->guest_group; ?>
						</td>
						<td class="data-grid-var" align="left">
							<?php echo $row->favor_gender; ?>
						</td>
						<td class="data-grid-var" align="left">
							<?php echo $row->favor_size; ?>
						</td>
						<?php
							mysqli_data_seek($result_favors, 0);
							$sql_favors = '';
							while($row_favors = mysqli_fetch_object($result_favors)) :
								$favor_disabled = '';
						?>
								<td class="data-grid-var-separator">&nbsp;
								</td>
								<td align="center" class="data-grid-var" >
									<input class="favor_enable_<?php echo $row_favors->id; ?>" name="favor_enable_<?php echo $row->id.'_'.$row_favors->id; ?>" id="favor_enable_<?php echo $row->id.'_'.$row_favors->id; ?>" type="checkbox" value="1" onchange="switch_favor(<?php echo $row->id; ?>, <?php echo $row_favors->id; ?>, '<?php echo $current_venue; ?>');"  <?php if (favor_exists($row->id, $row_favors->id, $current_venue)) : echo 'checked="checked"'; else : $favor_disabled = ' disabled="disabled" '; endif; ?> />
								</td>
								<?php
									if ($row_favors->gender_m == 1) :
								?>
										<td align="center" class="data-grid-var">
											<input class="favor_<?php echo $row->id.'_'.$row_favors->id; ?>" name="favor_gender_<?php echo $row->id.'_'.$row_favors->id; ?>" id="favor_gender_m_<?php echo $row->id.'_'.$row_favors->id; ?>" type="radio" value="M" onchange="switch_gender('M' ,<?php echo $row->id; ?>, <?php echo $row_favors->id; ?>, '<?php echo $current_venue; ?>');"  <?php if (favor_gender_match($row->id, $row_favors->id, $current_venue, 'M')) : echo 'checked="checked"'; endif; echo $favor_disabled; ?> />
										</td>
								<?php
									endif;
									if ($row_favors->gender_f == 1) :
								?>
										<td align="center" class="data-grid-var">
											<input class="favor_<?php echo $row->id.'_'.$row_favors->id; ?>" name="favor_gender_<?php echo $row->id.'_'.$row_favors->id; ?>" id="favor_gender_f_<?php echo $row->id.'_'.$row_favors->id; ?>" type="radio" value="F" onchange="switch_gender('F' ,<?php echo $row->id; ?>, <?php echo $row_favors->id; ?>, '<?php echo $current_venue; ?>');"  <?php if (favor_gender_match($row->id, $row_favors->id, $current_venue, 'F')) : echo 'checked="checked"'; endif; echo $favor_disabled; ?> />
										</td>
								<?php
									endif;
									if ($row_favors->size_xs == 1) :
								?>
										<td align="center" class="data-grid-var">
											<input class="favor_<?php echo $row->id.'_'.$row_favors->id; ?>" name="favor_size_<?php echo $row->id.'_'.$row_favors->id; ?>" id="favor_size_xs_<?php echo $row->id.'_'.$row_favors->id; ?>" type="radio" value="XS" onchange="switch_size('XS' ,<?php echo $row->id; ?>, <?php echo $row_favors->id; ?>, '<?php echo $current_venue; ?>');"  <?php if (favor_size_match($row->id, $row_favors->id, $current_venue, 'XS')) : echo 'checked="checked"'; endif; echo $favor_disabled; ?> />
										</td>
								<?php
									endif;
									if ($row_favors->size_s == 1) :
								?>
										<td align="center" class="data-grid-var">
											<input class="favor_<?php echo $row->id.'_'.$row_favors->id; ?>" name="favor_size_<?php echo $row->id.'_'.$row_favors->id; ?>" id="favor_size_s_<?php echo $row->id.'_'.$row_favors->id; ?>" type="radio" value="S" onchange="switch_size('S' ,<?php echo $row->id; ?>, <?php echo $row_favors->id; ?>, '<?php echo $current_venue; ?>');"  <?php if (favor_size_match($row->id, $row_favors->id, $current_venue, 'S')) : echo 'checked="checked"'; endif; echo $favor_disabled; ?> />
										</td>
								<?php
									endif;
									if ($row_favors->size_m == 1) :
								?>
										<td align="center" class="data-grid-var">
											<input class="favor_<?php echo $row->id.'_'.$row_favors->id; ?>" name="favor_size_<?php echo $row->id.'_'.$row_favors->id; ?>" id="favor_size_m_<?php echo $row->id.'_'.$row_favors->id; ?>" type="radio" value="M" onchange="switch_size('M' ,<?php echo $row->id; ?>, <?php echo $row_favors->id; ?>, '<?php echo $current_venue; ?>');"  <?php if (favor_size_match($row->id, $row_favors->id, $current_venue, 'M')) : echo 'checked="checked"'; endif; echo $favor_disabled; ?> />
										</td>
								<?php
									endif;
									if ($row_favors->size_l == 1) :
								?>
										<td align="center" class="data-grid-var">
											<input class="favor_<?php echo $row->id.'_'.$row_favors->id; ?>" name="favor_size_<?php echo $row->id.'_'.$row_favors->id; ?>" id="favor_size_l_<?php echo $row->id.'_'.$row_favors->id; ?>" type="radio" value="L" onchange="switch_size('L' ,<?php echo $row->id; ?>, <?php echo $row_favors->id; ?>, '<?php echo $current_venue; ?>');"  <?php if (favor_size_match($row->id, $row_favors->id, $current_venue, 'L')) : echo 'checked="checked"'; endif; echo $favor_disabled; ?> />
										</td>
								<?php
									endif;
									if ($row_favors->size_xl == 1) :
								?>
										<td align="center" class="data-grid-var">
											<input class="favor_<?php echo $row->id.'_'.$row_favors->id; ?>" name="favor_size_<?php echo $row->id.'_'.$row_favors->id; ?>" id="favor_size_xl_<?php echo $row->id.'_'.$row_favors->id; ?>" type="radio" value="XL" onchange="switch_size('XL' ,<?php echo $row->id; ?>, <?php echo $row_favors->id; ?>, '<?php echo $current_venue; ?>');"  <?php if (favor_size_match($row->id, $row_favors->id, $current_venue, 'XL')) : echo 'checked="checked"'; endif; echo $favor_disabled; ?> />
										</td>
								<?php
									endif;
									if ($row_favors->size_xxl == 1) :
								?>
										<td align="center" class="data-grid-var">
											<input class="favor_<?php echo $row->id.'_'.$row_favors->id; ?>" name="favor_size_<?php echo $row->id.'_'.$row_favors->id; ?>" id="favor_size_xxl_<?php echo $row->id.'_'.$row_favors->id; ?>" type="radio" value="XXL" onchange="switch_size('XXL' ,<?php echo $row->id; ?>, <?php echo $row_favors->id; ?>, '<?php echo $current_venue; ?>');"  <?php if (favor_size_match($row->id, $row_favors->id, $current_venue, 'XXL')) : echo 'checked="checked"'; endif; echo $favor_disabled; ?> />
										</td>
								<?php
									endif;
								?>
						<?php
							endwhile;
						?>
					</tr>
			<?php
				endwhile;
			?>
		</tbody>
	</table>
</div>

Youez - 2016 - github.com/yon3zu
LinuXploit