echo read_raceinfo('n-den-trophies', 3); ?> "/> <label for="n-den">Number of trophies per <?php echo group_label_lc(); ?> </label> </p> <p> <input id="n-pack" name="n-pack-trophies" type="number" min="0" max="20" data-enhanced="true" value="<?php echo read_raceinfo('n-pack-trophies', 3); ?> "/> <label for="n-pack">Number of trophies for the <?php echo supergroup_label_lc(); ?> </label> </p> <p> <input type="hidden" name="use-xbs-checkbox" value="yes"/> <input id="use-xbs" name="use-xbs" data-enhanced="true" type="checkbox"<?php if ($use_xbs) { echo ' checked="checked"'; } ?> /> <label>Offer "Exclusively By Scout" award?</label> </p> <p>
} $stmt->closeCursor(); $n_den_trophies = read_raceinfo('n-den-trophies', 3); $n_pack_trophies = read_raceinfo('n-pack-trophies', 3); require_once 'inc/ordinals.inc'; $speed_trophies = top_finishers_by_class($n_den_trophies); foreach ($speed_trophies as $classid => $den_trophies) { for ($place = 0; $place < count($den_trophies); ++$place) { $racerid = $den_trophies[$place]; $racers[$racerid]['awards'][] = ordinal(1 + $place) . ' in ' . group_label_lc(); } } $pack_trophies = top_finishers_overall($n_pack_trophies); for ($place = 0; $place < count($pack_trophies); ++$place) { $racerid = $pack_trophies[$place]; $racers[$racerid]['awards'][] = ordinal(1 + $place) . ' in ' . supergroup_label_lc(); } $sql = 'SELECT awardname, racerid' . ' FROM Awards' . ' ORDER BY sort'; $stmt = $db->query($sql); foreach ($stmt as $rs) { $racerid = $rs['racerid']; if (isset($racers[$racerid])) { $racers[$racerid]['awards'][] = $rs['awardname']; } } // Awards table: // AwardID, AwardName, AwardTypeID, ClassID, RankID, RacerID, Sort // // AwardTypeID just maps to a string, AwardType, through AwardTypes string. ?> <div class="award_racers">