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">
