<body> <?php $banner_title = 'Race Standings'; require 'inc/banner.inc'; ?> <div class="block_buttons"> <div class="center-select"> <h3><?php echo read_raceinfo_boolean('drop-slowest') ? "Dropping each racer's slowest time" : "Averaging all heat times"; ?> </h3> <select> <option selected="selected">All</option> <?php foreach (standings_round_names() as $round) { echo '<option data-roundid="' . $round['roundid'] . '">' . htmlspecialchars($round['name'], ENT_QUOTES, 'UTF-8') . '</option>' . "\n"; } ?> </select> </div> </div> <table class="main_table"> <?php write_standings_table_headers(); $standings = final_standings(); write_standings_table_rows($standings); ?> </table> </body> </html>
} } function add_speed_award(&$row, $classid, $rankid, $limit, $label) { global $awards, $speed_awards_in_bin; $key = bin_key(@$classid, @$rankid); if (!isset($speed_awards_in_bin[$key])) { $speed_awards_in_bin[$key] = 0; } $place = ++$speed_awards_in_bin[$key]; if ($place <= $limit) { $awards[] = array('bin_key' => $key, 'classid' => @$classid, 'rankid' => @$rankid, 'awardkey' => 'speed-' . $place . (isset($classid) ? '-' . $classid : ''), 'awardname' => nth_fastest($place, $label), 'awardtype' => 'Speed Trophy', 'awardtypeid' => 5, 'sort' => $place, 'firstname' => $row['firstname'], 'lastname' => $row['lastname'], 'carnumber' => $row['carnumber']); } } // Collect speed awards foreach (final_standings() as $row) { // Can be BOTH for_group and for_supergroup if ($row['for_supergroup']) { add_speed_award($row, null, null, $n_pack_trophies, supergroup_label()); } if ($row['for_group']) { add_speed_award($row, @$row['classid'], null, $n_den_trophies, $classes[$row['classid']]['class']); } // TODO Speed awards by rank, as well as by class? } // TODO Break ties for award sorting according to class and rank ordering foreach ($db->query('SELECT awardid, awardname, awardtype,' . ' Awards.awardtypeid, Awards.classid, Awards.rankid, sort,' . ' firstname, lastname, carnumber' . ' FROM ' . inner_join('Awards', 'AwardTypes', 'Awards.awardtypeid = AwardTypes.awardtypeid', 'RegistrationInfo', 'Awards.racerid = RegistrationInfo.racerid') . ' ORDER BY sort, lastname, firstname') as $row) { $awards[] = array('bin_key' => bin_key(@$row['classid'], @$row['rankid']), 'classid' => @$row['classid'], 'rankid' => @$row['rankid'], 'awardkey' => 'award-' . $row['awardid'], 'awardname' => $row['awardname'], 'awardtype' => $row['awardtype'], 'awardtypeid' => $row['awardtypeid'], 'sort' => $row['sort'], 'firstname' => $row['firstname'], 'lastname' => $row['lastname'], 'carnumber' => $row['carnumber']); } function compare_by_sort(&$lhs, &$rhs) {