Team Trivia | Local Loader

= '".$start_date."' and game_date <= '".$end_date."' order by game_date asc"; // echo $query."
"; $result = mysqli_query($local, $query); if ($result) { $num = mysqli_num_rows($result); //if ($num > 0) { while ($row = mysqli_fetch_assoc($result)) { $show_type = $row['show_type']; $question_set_id = $row['question_set_id']; $show_game_date = date('Y-m-d', strtotime($row['game_date'])); $show_loc_ID = $row['loc_ID']; $show_show_ID = $row['show_ID']; $loc_name = $row['loc_name']; $logo_loc = $row['logo_loc']; $question_set_id = $row['question_set_id']; $corp_event = $row['corp_event']; if ($show_type=="trivia") { $bg_style = "trivia_box"; } elseif ($show_type=="sound") { $bg_style = "soundcheck_box"; } elseif ($show_type=="feud") { $bg_style = "feud_box"; } ?>

"; ?>

'; } elseif ($show_type=="sound") { echo '

'; } elseif ($show_type=="feud") { echo '

'; } ?>

'; ?>

"; $xresult = mysqli_query($local, $xquery); $xnum = mysqli_num_rows($xresult); //echo $xnum."
"; if ($xnum==0) { ?> 0) { if ($show_game_date==$todayis) { ?> GO TO GAME NAVIGATION

GO TO ARRANGER

RESET

Past Dates:
"; $result = mysqli_query($local, $query); while ($row = mysqli_fetch_assoc($result)) { $tpgd = $row['game_date']; $tpl = $row['loc_ID']; $tps = $row['show_ID']; ?>

'R'"; $result = mysqli_query($local, $query); while ($row = mysqli_fetch_assoc($result)) { $orig_ID = $row['orig_ID']; $questions_used = "|".$questions_used; } ?> 0) { $query = "select id, team_rank, final_score, teamname, aka, players, team_ID from team_scoring where game_date = '".$this_game_date."' and loc_ID = ".$loc_ID." and show_ID = ".$show_ID." and team_ID > 0 and usr_ID = ".$usr_ID." order by team_rank asc ".$limit; } else { $query = "select id, team_rank, final_score, teamname, aka, players, team_ID from team_scoring where game_date = '".$this_game_date."' and loc_ID = ".$loc_ID." and show_ID = ".$show_ID." order by team_rank asc ".$limit; } $result = mysqli_query($local, $query); $i = 0; while ( $row = mysqli_fetch_assoc($result) ) { $scoreID = $row['id']; $team_rank = $row['team_rank']; $final_score = $row['final_score']; $teamname = $row['teamname']; $team_ID = $row['team_ID']; $aka = $row['aka']; if ($team_ID > 0) { ?>

Rank	Team Name	Final Score
	()

"; $query = "select count(id) as 'num_teams', sum(players) as 'num_players' from team_scoring where game_date = '".$this_game_date."' and loc_ID = ".$loc_ID." and show_ID = ".$show_ID; $result = mysqli_query($local, $query); $row = mysqli_fetch_assoc($result); $num_teams = $row['num_teams']; $num_players = $row['num_players']; echo "Number of Teams: ".$num_teams."
"; echo "Number of Players:
"; $query = "select count(id) as 'num_leagues' from team_scoring where game_date = '".$this_game_date."' and loc_ID = ".$loc_ID." and show_ID = ".$show_ID." and team_ID > 0"; $result = mysqli_query($local, $query); $row = mysqli_fetch_assoc($result); $num_leagues = $row['num_leagues']; echo "Number of League Teams: ".$num_leagues."

"; ?> Amount Received from Location:

Misc Expenses: Reason:

Notes:

Technical Notes / Issues: