';
echo i18n_field( $course, "name");
echo '';
}
*/
//echo ' ';
echo '';
echo i18n_text("Overall Rank");
echo '';
echo '
';
//echo ' ';
echo '';
echo i18n_text("Male Group");
echo '';
echo '';
//echo ' ';
echo '';
echo i18n_text("Female Group");
echo '';
echo '';
foreach ($runner_groups as $group)
{
//echo ' ';
echo '';
echo i18n_field( $group, "name");
echo '';
echo '';
}
?>
prepare($sql);
$stmt->execute();
$CHECKIN_marker_id = $stmt->fetchColumn();
$sql = 'SELECT count(*) FROM `' . $table_prefix . 'trackrecord_summary` WHERE `marker_id` = ' . $CHECKIN_marker_id . ' and course_code = "' . $current_course['code'] . '" and dnf <> "disqualify" ';
$stmt = $db->prepare($sql);
$stmt->execute();
$s[$current_course['code']]['CHECKIN'] = $stmt->fetchColumn();
$sql = 'SELECT marker_id FROM `' . $table_prefix . 'course_markers` WHERE `course_code` = "' . $current_course['code'] . '" and code = "FINISH" ';
$stmt = $db->prepare($sql);
$stmt->execute();
$CHECKIN_marker_id = $stmt->fetchColumn();
$sql = 'SELECT count(*) FROM `' . $table_prefix . 'trackrecord_summary` WHERE `marker_id` = ' . $CHECKIN_marker_id . ' and course_code = "' . $current_course['code'] . '" and dnf <> "disqualify" ';
$stmt = $db->prepare($sql);
$stmt->execute();
$s[$current_course['code']]['FINISH'] = $stmt->fetchColumn();
foreach ($s[$current_course['code']] as $tempkey=>$temp)
{
echo '
';
echo $tempkey . ": " . $temp;
echo '
';
}
----- */
?>
| '; echo i18n_text("Place"); echo ' | '; echo ''; echo 'BIB'; echo ' | '; echo ''; echo i18n_text("Name"); echo ' | '; if (!$select_group) { echo ''; echo i18n_text("Category"); echo ' | '; } if (!$select_group && !$select_gender) { echo ''; echo i18n_text("Gender"); echo ' | '; } //echo ''; //echo i18n_text("Checkin"); //echo ' | '; //echo ''; //echo i18n_text("Start Time"); //echo ' | '; //echo ''; //echo i18n_text("Check Point"); //echo ' | '; echo ''; echo i18n_text("Finish"); echo ' | '; echo ''; //d($runner); foreach ($runner as $r) { echo '
|---|---|---|---|---|---|---|---|---|
| '; if (!$r['FINISH'][$field] && !$r['START'][$field]) { echo "DNS"; } if (!$r['FINISH'][$field] && $r['START'][$field]) { echo "DNF"; } //ho $field; echo $r['FINISH'][$field]; echo ' | '; echo ''; echo $r['bibno']; echo ' | '; echo ''; echo displayFirstLastname($r['firstname'], $r['lastname']); if ($r['nameonbadge']) echo ' (' . trim($r['nameonbadge']) . ')'; echo ' | '; if (!$select_group) { echo ''; $g = $runner_groups[$r['group_id']]; echo i18n_field( $g, "name"); echo ' | '; } if (!$select_group && !$select_gender) { echo ''; echo ' ' . $r['gender']; //$cats = explode(",", $r['cat']); //if (!in_array(2,$cats)) //echo 'xxxxxxxxxxx'; echo ' | '; } //echo '';
//echo $r['START']['recorddatetime'];
/*
if($r['START']['duration'])
{
echo Duration($r['START']['duration'], false, true);
echo ' ';
echo $r['START']['recorddatetime'];
}
if ($r['START'][$field]) {
echo ' (' . $r['START'][$field] . ')';
echo ' ';
}
*/
//echo ' | ';
/*
echo '';
if($r['MIDPOINT']['duration'])
{
echo Duration($r['MIDPOINT']['duration'], false, true);
echo ' ';
echo $r['MIDPOINT']['recorddatetime'];
echo ' ';
}
if ($r['MIDPOINT'][$field]) {
//echo '(' . $r['MIDPOINT'][$field] . ')';
}
echo ' | ';
*/
/*
echo '';
if($r['CHECKIN']['recorddatetime'])
{
echo ' ';
echo $r['CHECKIN']['recorddatetime'];
echo ' ';
}
echo ' | ';
*/
echo '';
if($r['FINISH']['duration'])
{
if ($r['FINISH']['duration'] == 9999999)
{
echo 'No start time';
} else {
echo Duration($r['FINISH']['duration'], false, true);
}
echo ' ';
echo $r['FINISH']['recorddatetime'];
echo ' ';
}
if ($r['FINISH'][$field]) {
//echo ' (' . $r['FINISH'][$field] . ')';
//echo '';
}
echo ' | ';
echo '