-> Shing Mun Valley Park"; } $headertitle = "Live Track system | " . $title ; $headerdescription = ""; $headerimg = "https://livetrack.sportsystem.hk/trails-of-fire-2018b/cover.jpg"; $Temperature = "25.6°C-30.6°C"; $Humidity = "78%-92%"; $EventDate = "2018-07-02 10:00"; $Distance = "12.2km"; require ("header_inline.php"); /*---------------*/ $select_gender = ""; $select_group = ""; $select_course = "tof18b"; //if (intval($_GET['course'])) //{ // $select_course = $_GET['course']; //} if (intval($_GET['group'])) { $select_group = $_GET['group']; } if (intval($_GET['gender']) == 1) { $select_gender = "M"; } if (intval($_GET['gender']) == 2) { $select_gender = "F"; } if ($select_group) { $field = 'place_group'; } if ($select_gender) { $field = 'place_gender'; } $sql = "select * from ". $table_prefix ."course"; $stmt = $db->prepare($sql); $stmt->execute(); $coursestemp = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($coursestemp as $temp) { $courses[$temp['code']] = $temp; } $current_course = $courses[$select_course]; //d($courses); //d($select_course); $sql = "select * from ". $table_prefix ."membergroups order by sorting"; $stmt = $db->prepare($sql); $stmt->execute(); $runner_groupstemp = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($runner_groupstemp as $temp) { $runner_groups[$temp['id']] = $temp; } $sql = "select cp_code,count(bibno) as c from ". $table_prefix ."trackrecord_summary where cp_code is not null group by cp_code"; //d($sql); $stmt = $db->prepare($sql); $stmt->execute(); $overall = $stmt->fetchAll(PDO::FETCH_ASSOC); //$catwhere = ' and find_in_set(37,cat) '; // 2 Races (Tai Mo Shan + Lantau Peak) if ($field == "place_group") { $sql = "select * from ". $table_prefix ."runners where 1=1 " . $catwhere . " and group_id = " . $select_group . " order by bibno"; $stmt = $db->prepare($sql); $stmt->execute(); $runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($runnerstemp as $temp) { $runner[intval($temp['bibno'])] = $temp; } } else if ($field == "place_gender") { $sql = "select * from ". $table_prefix ."runners where 1=1 " . $catwhere . " and gender = '" . $select_gender . "' order by bibno"; $stmt = $db->prepare($sql); $stmt->execute(); $runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($runnerstemp as $temp) { $runner[intval($temp['bibno'])] = $temp; } } else { $field = "place_course"; $sql = "select * from ". $table_prefix ."runners where 1=1 and `show` = 1 " . $catwhere . " order by bibno"; $stmt = $db->prepare($sql); $stmt->execute(); $runnerstemp = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($runnerstemp as $temp) { $runner[intval($temp['bibno'])] = $temp; } } //d($field); //exit(); //d($trackrecordarray); /*-------------------------------------------------------------*/ /*-------------------------------------------------------------*/ /*-------------------------------------------------------------*/ /*-------------------------------------------------------------*/ $starttime = $current_course['startdatetime']; // find_in_set(2,cat) and if ($field == "place_group") { $sql = "select * from ". $table_prefix ."trackrecord_summary su left join ". $table_prefix . "runners ru on CONVERT(su.bibno,SIGNED INTEGER) = CONVERT(ru.bibno,SIGNED INTEGER) where 1=1 " . $catwhere . " and su.place_group is not null and su.group = " . $select_group . " order by place_group "; } if ($field == "place_gender") { $sql = "select * from ". $table_prefix ."trackrecord_summary su left join ". $table_prefix . "runners ru on CONVERT(su.bibno,SIGNED INTEGER) = CONVERT(ru.bibno,SIGNED INTEGER) where 1=1 " . $catwhere . " and su.place_gender is not null and ru.gender = '" . $select_gender . "' order by place_group "; } if ($field == "place_course") { $sql = "select su.* from ". $table_prefix ."trackrecord_summary su left join ". $table_prefix . "runners ru on CONVERT(su.bibno,SIGNED INTEGER) = CONVERT(ru.bibno,SIGNED INTEGER) where 1=1 " . $catwhere . " and su.place_course is not null order by place_course "; } //d($sql); $stmt = $db->prepare($sql); $stmt->execute(); $resulttemp = $stmt->fetchAll(PDO::FETCH_ASSOC); //d($resulttemp); foreach ($resulttemp as $r) { $result[intval($r['bibno'])] = $r; //$result[$r['bibno']]['result'][$r['cp_code']] = $r[''] $runner[intval($r['bibno'])][$r['cp_code']] = $r; } //d($runner); /*-------------------------------------------------------------*/ /*-------------------------------------------------------------*/ /*-------------------------------------------------------------*/ /*-------------------------------------------------------------*/ //d($trackrecordsummary); function cmp($a, $b) { global $field; if ( !$a['FINISH'][$field] && !$b['FINISH'][$field] && !$a['START'][$field] && !$b['START'][$field] && !$a['CHECKIN'][$field] && !$b['CHECKIN'][$field] ) { return intcmp($a['bibno'], $b['bibno']); } if ($a['FINISH'][$field] || $b['FINISH'][$field]) { if ($a['FINISH'][$field] && $b['FINISH'][$field]) return intcmp($a['FINISH'][$field], $b['FINISH'][$field]); if ($a['FINISH'][$field] && !$b['FINISH'][$field]) return -1; if (!$a['FINISH'][$field] && $b['FINISH'][$field]) return 1; } if ($a['CHECKIN'][$field] || $b['CHECKIN'][$field]) { /* if (!$b['START'][$field]) return -1; if (!$a['START'][$field]) return 1; if ($a['START'][$field] || $b['START'][$field]) return intcmp($a['START'][$field], $b['START'][$field]); */ if (!$b['CHECKIN'][$field]) return -1; if (!$a['CHECKIN'][$field]) return 1; if ($a['CHECKIN'][$field] || $b['CHECKIN'][$field]) return strcmp($a['CHECKIN'][$field], $b['CHECKIN'][$field]); } if ($a['START'][$field] || $b['START'][$field]) { /* if (!$b['START'][$field]) return -1; if (!$a['START'][$field]) return 1; if ($a['START'][$field] || $b['START'][$field]) return intcmp($a['START'][$field], $b['START'][$field]); */ if (!$b['START'][$field]) return -1; if (!$a['START'][$field]) return 1; if ($a['START'][$field] || $b['START'][$field]) return strcmp($a['START'][$field], $b['START'][$field]); } return intcmp($a['bibno'], $b['bibno']); } //d($runner); usort($runner, "cmp"); //array_orderby($runner, ['FINISH'][$field], SORT_NATURAL , SORT_STRING ); ?>

總成績 Overall result | 鳯凰山 LANTAU PEAK | 大帽山 TAI MO SHAN
'; 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 ''; } ?>




'; echo ''; echo ''; echo ''; if (!$select_group) { echo ''; } if (!$select_group && !$select_gender) { echo ''; } if (SHOWCHECKIN) { echo ''; } //echo ''; echo ''; echo ''; foreach ($runner as $r) { //d($r['CHECKIN'][$field]); if ($r['show']) { echo ''; echo ''; echo ''; echo ''; if (!$select_group) { echo ''; } if (!$select_group && !$select_gender) { echo ''; } if (SHOWCHECKIN) { echo ''; } /* echo ''; */ echo ''; echo ''; //d($r); } } ?>
'; echo i18n_text("Place"); echo ''; echo 'BIB'; echo ''; echo i18n_text("Name"); echo ''; echo i18n_text("Category"); echo ''; echo i18n_text("Gender"); echo ''; echo i18n_text("Check in"); echo ''; //echo i18n_text("Check Point"); //echo ''; echo i18n_text("Finish"); echo '
'; if (!$r['FINISH'][$field] && ((!$r['START'][$field] && !$r['CHECKIN'][$field]))) { echo "DNS"; } if (!$r['FINISH'][$field] && ($r['START'][$field] || $r['CHECKIN'][$field])) { echo "DNF"; } echo $r['FINISH'][$field]; echo ''; echo $r['bibno']; echo ''; echo displayFirstLastname($r['firstname'], $r['lastname']); if ($r['nameonbadge']) echo ' (' . trim($r['nameonbadge']) . ')'; echo ''; $g = $runner_groups[$r['group_id']]; echo i18n_field( $g, "name"); echo ''; echo ' ' . $r['gender']; //$cats = explode(",", $r['cat']); //if (!in_array(2,$cats)) //echo 'xxxxxxxxxxx'; echo ''; echo $r['CHECKIN']['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 '
'; 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 '
'; 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 '
(int)$b)return 1; if((int)$a < (int)$b)return -1; } ?>