echo $use_master_sched ? 1 : 0;
?>
,
};
</script>
<script type="text/javascript" src="js/update.js"></script>
<title>Race Schedule</title>
<?php
require 'inc/stylesheet.inc';
?>
</head>
<body>
<?php
$banner_title = 'Racing Heats';
require 'inc/banner.inc';
running_round_header($now_running);
require_once 'inc/rounds.inc';
$groups = all_schedule_groups();
$sql = 'SELECT' . ' Classes.class, round, heat, lane, finishtime, resultid, completed, ' . ($use_master_sched ? 'round' : 'Rounds.roundid') . ' as racinggroup,' . ($use_master_sched ? 'masterheat' : 'heat') . ' as seq,' . ' RegistrationInfo.carnumber, RegistrationInfo.firstname, RegistrationInfo.lastname,' . ' Classes.classid, Rounds.roundid, RaceChart.racerid' . ' FROM ' . inner_join('RaceChart', 'RegistrationInfo', 'RegistrationInfo.racerid = RaceChart.racerid', 'Roster', 'Roster.racerid = RegistrationInfo.Racerid', 'Rounds', 'Rounds.roundid = Roster.roundid', 'Classes', 'Rounds.classid = Classes.classid') . ' WHERE Rounds.roundid = RaceChart.roundid' . ' ORDER BY ' . ($use_master_sched ? 'round, masterheat, lane' : (schema_version() >= 2 ? 'Classes.sortorder, ' : '') . 'class, round, heat, lane');
$stmt = $db->query($sql);
if ($stmt === FALSE) {
$info = $db->errorInfo();
echo '<h2>Error: ' . $info[2] . '</h2>' . "\n";
}
?>
<table class="main_table">
<?php
function byes($n)
{
$result = '';
while ($n > 0) {
<?php
require 'inc/stylesheet.inc';
?>
<style>
.scroll-bounding-rect {
overflow: hidden;
}
</style>
</head>
<body>
<?php
$banner_title = 'Results By Racer';
require 'inc/banner.inc';
$nlanes = get_lane_count_from_results();
$now_running = get_running_round();
running_round_header($now_running, TRUE);
require_once 'inc/rounds.inc';
$rounds = all_rounds();
$sql = 'SELECT RegistrationInfo.racerid,' . ' Classes.class, round, heat, lane, finishtime, resultid,' . ' carnumber, RegistrationInfo.firstname, RegistrationInfo.lastname,' . ' Classes.classid, Rounds.roundid' . ' FROM ' . inner_join('RaceChart', 'RegistrationInfo', 'RegistrationInfo.racerid = RaceChart.racerid', 'Roster', 'Roster.racerid = RegistrationInfo.racerid', 'Rounds', 'Rounds.roundid = Roster.roundid', 'Classes', 'Rounds.classid = Classes.classid') . ' WHERE Rounds.roundid = RaceChart.roundid' . (isset($_GET['racerid']) ? ' AND RaceChart.racerid = ' . $_GET['racerid'] : '') . ' ORDER BY ' . (schema_version() >= 2 ? 'Classes.sortorder, ' : '') . 'class, round, lastname, firstname, carnumber, resultid, lane';
$stmt = $db->query($sql);
if ($stmt === FALSE) {
$info = $db->errorInfo();
echo '<h2>Error: ' . $info[2] . '</h2>' . "\n";
}
?>
<div class="scroll-bounding-rect">
<table class="main_table">
<?php
function byes($n)
{
$result = '';
