Exemple #1
0
  </div>

  <div class="settings_group">
    <div class="settings_group_image">
      <img src="img/settings-gold-medal.png"/>
    </div>

    <div class="settings_group_settings">
      <p>
        <input id="n-den" name="n-den-trophies" type="number" min="0" max="20" data-enhanced="true"
               value="<?php 
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>
Exemple #2
0
$sql = 'SELECT racerid, carnumber, lastname, firstname, class' . ' FROM RegistrationInfo' . ' INNER JOIN Classes' . ' ON Classes.classid = RegistrationInfo.classid' . ' WHERE passedinspection = 1 AND exclude = 0' . ' ORDER BY carnumber';
$racers = array();
$stmt = $db->query($sql);
foreach ($stmt as $rs) {
    $racerid = $rs['racerid'];
    $racers[$racerid] = array('racerid' => $racerid, 'carnumber' => $rs['carnumber'], 'lastname' => $rs['lastname'], 'firstname' => $rs['firstname'], 'class' => $rs['class'], 'awards' => array());
}
$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'];
    }
}