{"id":5,"date":"2013-01-22T00:04:38","date_gmt":"2013-01-22T00:04:38","guid":{"rendered":"https:\/\/www.owensoundcycling.ca\/?page_id=5"},"modified":"2015-11-03T12:37:01","modified_gmt":"2015-11-03T17:37:01","slug":"race-results","status":"publish","type":"page","link":"https:\/\/www.owensoundcycling.ca\/index.php\/race-results\/","title":{"rendered":"Race Results"},"content":{"rendered":"<p><?php \n\n\necho \"Mode = \" . $_GET['mode'];\n\n\/\/require_once '.\/races\/admin\/init.php'; \nif (is_file(\"..\/races\/config\/config.php\")) { \n  include \"..\/races\/config\/config.php\"; \n} else { \n  print \"Error, cannot find config file\\n\"; \n  exit; \n} \n\n\n\/\/var_dump($tables);\n\nif (isset($error_level)) {\n error_reporting($error_level); \n} else { \n  error_reporting($er);\n} \nrequire_once '.\/races\/admin\/mysql.inc'; \n\/\/require_once \".\/races\/admin\/defaultconfig.inc\"; \n\/\/require_once '.\/races\/admin\/connect.php'; \n\/\/include_once \".\/races\/admin\/languages.php\"; \n\/\/include_once \".\/races\/admin\/lib.php\"; \n\n\n$database_connection = mysql_connect($database_host,$database_user,$database_password);\nmysql_select_db($database_name, $database_connection );\necho \"database connection \" . var_dump($database_connection);\n\nif( !isset($_GET['mode']) ) {\n\n  \/\/ \n  \/\/ SHOW  RECENT RACES (THIS SEASON)\n  \/\/ \n  $thisYear = date('Y') . '%';\n  \n  $listquery = \"SELECT raceid, race.typeid, tag, race.date, \" . \n               \" location.name, course.dist, course.description \" . \n              \" FROM race, sysracetype, course, location \" . \n             \" WHERE race.courseid = course.courseid \" . \n               \" AND race.typeid = sysracetype.typeid \" . \n               \" AND course.locid = location.locid \" . \n               \" AND race.date < now() \" . \n               \" AND race.date LIKE '$thisYear'\" .\n          \" ORDER BY race.date DESC \"; \n           \n\n  $result = mysql_query($listquery,$database_connection);\n  $errno = mysql_errno($database_connection);\n  if ($errno) {\n        print \"Sql error \". $errno . \" in $query\";\n        exit();\n  }\n  print(\"\n\n<h3>Recent Club Races<\/h3>\n<p>&#8220;);<br \/>\n  print(&#8220;<\/p>\n<table width='98%' border='0' cellspacing='4'>\\n&#8221;);<br \/>\n  print(&#8221; <\/p>\n<tr>\\n&#8221;); print(&#8221; <\/p>\n<th align=\\\"left\\\">Date<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221; <\/p>\n<th align=\\\"left\\\">Course<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221; <\/p>\n<th align=\\\"left\\\">Dist<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221; <\/p>\n<th align=\\\"left\\\">Type<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221; <\/tr>\n<p>\\n&#8221;); $odd = 1; <\/p>\n<p>  var_dump($result);<\/p>\n<p>  while ($race = mysql_fetch_array($result)) {<br \/>\n   if( $odd ) {<br \/>\n    $odd = 0;<br \/>\n    $class = &#8220;resultrowodd&#8221;;<br \/>\n    } else {<br \/>\n      $odd = 1;<br \/>\n      $class = &#8220;resultroweven&#8221;;<br \/>\n    } <\/p>\n<p>    print(&#8216;<\/p>\n<tr class=\"' . $class . '\">&#8216;);<br \/>\n    print(&#8220;\\n&#8221;);<br \/>\n    $RaceDate = sprintf(&#8216;<a title=\"Detailed Race Results\" ' . \n                        ' href=\"?mode=race&#038;raceid=%d\">%s<\/a>&#8216;,<br \/>\n                        $race[&#8220;raceid&#8221;],<br \/>\n                        $race[&#8220;date&#8221;] ); <\/p>\n<p>    print(&#8220;<\/p>\n<td>&#8221; . $RaceDate . &#8220;<\/td>\n<p>\\n&#8221;); <\/p>\n<p>    $RaceName = sprintf(&#8216;<a title=\"Course Summary\/Statistics\" ' . \n                      ' href=\"racestats.php?raceid=%d\">%s%s %s<\/a>&#8216;,<br \/>\n                        $race[&#8220;raceid&#8221;],<br \/>\n                        $race[&#8220;name&#8221;],<br \/>\n                        $race[&#8220;description&#8221;]<br \/>\n                          ? &#8216;,&#8217;<br \/>\n                          : &#8221;,<br \/>\n                        $race[&#8220;description&#8221;] ); <\/p>\n<p>    print(&#8220;<\/p>\n<td>&#8221; . $RaceName . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n    print(&#8220;<\/p>\n<td>&#8221; . $race[&#8220;dist&#8221;] . &#8216; &#8216; . $dist_unit . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n    print(&#8220;<\/p>\n<td>&#8221; . $race[&#8220;tag&#8221;] . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n    print(&#8220;<\/tr>\n<p>\\n&#8221;);<br \/>\n  }<br \/>\n  print(&#8220;<\/table>\n<p>\\n&#8221;);<br \/>\n} else if($_GET[&#8216;mode&#8217;] == &#8216;race&#8217; ) {<\/p>\n<p>  if (isset($_GET[&#8216;raceid&#8217;]))<br \/>\n    {<br \/>\n    $raceid = sprintf(&#8216;%d&#8217;,$_GET[&#8216;raceid&#8217;]);<br \/>\n    }<br \/>\n  else<br \/>\n    {<br \/>\n    $raceid = 0;<br \/>\n    }<br \/>\n \/\/ print(&#8220;<\/p>\n<h4>&#8221; . getRaceDesc( $raceid, $dist_unit ) . &#8220;<\/h4>\n<p>&#8220;);<\/p>\n<p>  $raceQuery = &#8220;SELECT course.dist, course.map, race.conditions &#8221; .<br \/>\n                &#8221;  FROM race, course &#8221; .<br \/>\n                &#8221; WHERE race.courseid = course.courseid &#8221; .<br \/>\n                &#8221;   AND race.raceid = &#8221; . $raceid;<\/p>\n<p>  $result = mysql_query(&#8220;$raceQuery&#8221;);<br \/>\n  if( $row = mysql_fetch_array($result)) {<br \/>\n    $courseDist = $row[&#8220;dist&#8221;];<br \/>\n    $conditions = $row[&#8220;conditions&#8221;];<br \/>\n    $map = $row[&#8220;map&#8221;];<\/p>\n<p>    if( $map )<br \/>\n      {<br \/>\n      print(&#8220;<\/p>\n<p><a href=\\\"$map\\\" target=\\\"_blank\\\" >Profile\/Map<\/a><\/p>\n<p>&#8220;);<br \/>\n      }<\/p>\n<p>    if( $conditions )<br \/>\n      {<br \/>\n      print( &#8216;<textarea readonly cols=\"65\" rows=\"4\">&#8216; . $conditions . &#8216;<\/textarea>&#8216;);<br \/>\n      }<\/p>\n<p>    } else {<br \/>\n      \/\/Error(&#8216;Unknown raceID &#8216; . $raceid);<br \/>\n    }<\/p>\n<p>\/\/<br \/>\n\/\/ SHOW SELECTED RACE&#8217;S RESULTS<br \/>\n\/\/ (SORT BY DNF TO PUT ALL NON-FINISHERS LAST.)<br \/>\n\/\/<br \/>\n$listquery = &#8220;SELECT result.time, &#8221; .<br \/>\n             &#8221;       HOUR(result.time), &#8221; .    \/\/ [1]<br \/>\n             &#8221;       MINUTE(result.time), &#8221; .  \/\/ [2]<br \/>\n             &#8221;       SECOND(result.time), &#8221; .  \/\/ [3]<br \/>\n             &#8221;       rider.id, rider.gender, &#8221; .<br \/>\n             &#8221;       rider.first, rider.last, &#8221; .<br \/>\n             &#8221;       result.dnf, &#8221; .<br \/>\n             &#8221;       race.courseid &#8221; .<br \/>\n             &#8221;  FROM race, result, rider &#8221; .<br \/>\n             &#8221; WHERE race.raceid = result.raceid &#8221; .<br \/>\n             &#8221;   AND result.riderid = rider.id&#8221; .<br \/>\n             &#8221;   AND race.raceid = $raceid &#8221; .<br \/>\n          &#8221; ORDER BY result.dnf, result.time ASC &#8220;;<\/p>\n<p>  $result = mysql_query($listquery);<\/p>\n<p>  print(&#8220;<\/p>\n<table width='98%' border='0' cellspacing='4'>\\n&#8221;);<br \/>\n  print(&#8221;  <\/p>\n<tr>\\n&#8221;);<br \/>\n  print(&#8221;    <\/p>\n<th align=\\\"left\\\">Place<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221;    <\/p>\n<th align=\\\"left\\\">Name<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221;    <\/p>\n<th align=\\\"left\\\">M\/F<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221;    <\/p>\n<th align=\\\"center\\\">Gender<br \/>Place<\/th>\n<p>\\n&#8221;);<\/p>\n<p>  print(&#8221;    <\/p>\n<th align=\\\"right\\\">Time<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221;    <\/p>\n<th align=\\\"right\\\">Speed<br \/>$dist_unit\/h<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221;    <\/p>\n<th align=\\\"right\\\">At<\/th>\n<p>\\n&#8221;);<br \/>\n  print(&#8221;  <\/tr>\n<p>\\n&#8221;);<\/p>\n<p>  $posit = 1;<br \/>\n  $positM = 1;<br \/>\n  $positF = 1;<br \/>\n  $odd = 1;<br \/>\n  $delete = 0;<br \/>\n  $some = 0;<br \/>\n  while ($race = mysql_fetch_array($result))<br \/>\n    {<br \/>\n    $some++;<\/p>\n<p>    if( $odd )<br \/>\n      {<br \/>\n      $odd = 0;<br \/>\n      $class = &#8220;resultrowodd&#8221;;<br \/>\n      }<br \/>\n    else<br \/>\n      {<br \/>\n      $odd = 1;<br \/>\n      $class = &#8220;resultroweven&#8221;;<br \/>\n      }<\/p>\n<p>    print(&#8216;<\/p>\n<tr class=\"' . $class . '\">&#8216;);<br \/>\n    print(&#8220;\\n&#8221;);<\/p>\n<p>    \/\/<br \/>\n    \/\/ DON&#8217;T COUNT POSITION IF &#8220;DNF&#8221;<br \/>\n    \/\/<br \/>\n    if( !$race[&#8220;dnf&#8221;] )<br \/>\n      {<br \/>\n      print(&#8216;<\/p>\n<td align=\"right\">&#8216; . $posit++ . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n      }<br \/>\n    else<br \/>\n      {<br \/>\n      print(&#8220;<\/p>\n<td><\/td>\n<p>\\n&#8221;);<br \/>\n      }<\/p>\n<p>    $FullName = sprintf(&#8216;<a title=\"List all of %s\\'s races\" ' .\n                        '   href=\"?mode=listriders&#038;riderid=%d\">%s<\/a>&#8216;,<br \/>\n                       trim($race[&#8220;first&#8221;]),<br \/>\n                       $race[&#8220;id&#8221;],<br \/>\n                       trim($race[&#8220;last&#8221;]). &#8220;, &#8221; .<br \/>\n                       trim($race[&#8220;first&#8221;]) );<\/p>\n<p>    print(&#8220;<\/p>\n<td>&#8221; . $FullName . &#8220;<\/td>\n<p>\\n&#8221;);<\/p>\n<p>    print(&#8216;<\/p>\n<td align=\"center\">&#8216; . $race[&#8220;gender&#8221;] . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n    if( !$race[&#8220;dnf&#8221;] )<br \/>\n      {<br \/>\n      if($race[&#8220;gender&#8221;] == &#8220;M&#8221;)<br \/>\n        {<br \/>\n        print(&#8216;<\/p>\n<td align=\"center\">&#8216; . $positM++ . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n        }<br \/>\n      else<br \/>\n        {<br \/>\n        print(&#8216;<\/p>\n<td align=\"center\">&#8216; . $positF++ . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n        }<\/p>\n<p>    $TimeLink = sprintf(&#8216;<a title=\"List all of %s\\'s races on this   course\" ' .\n                      '   href=\"?mode=listriders&#038;riderid=%d&#038;courseid=%d\">%s<\/a>&#8216;,<br \/>\n                       trim($race[&#8220;first&#8221;]),<br \/>\n                       $race[&#8220;id&#8221;],$race[&#8220;courseid&#8221;], $race[&#8220;time&#8221;] );<\/p>\n<p>      print(&#8220;<\/p>\n<td align='right'>&#8221; . $TimeLink . &#8220;<\/td>\n<p>\\n&#8221;);<\/p>\n<p>      $thisHour = $race[1];<br \/>\n      $thisMin = $race[2];<br \/>\n      $thisSec = $race[3];<br \/>\n      $timeInSecs = (60*60*$thisHour + 60*$thisMin + $thisSec); <\/p>\n<p>      \/\/<br \/>\n      \/\/ CALC SPEED<br \/>\n      \/\/<br \/>\n      if( $timeInSecs )<br \/>\n        {<br \/>\n        $speed = sprintf(&#8220;%.2f&#8221;, ($courseDist * 60*60)\/$timeInSecs);<br \/>\n        }<br \/>\n      else<br \/>\n        {<br \/>\n        $speed = &#8220;???&#8221;;<br \/>\n        }<br \/>\n      print(&#8220;<\/p>\n<td align='right'>&#8221; . $speed . &#8220;<\/td>\n<p>\\n&#8221;);<\/p>\n<p>      \/\/<br \/>\n      \/\/ CALCULATE DELTA<br \/>\n      \/\/<br \/>\n      if( $posit > 2 )<br \/>\n        {<br \/>\n        $deltaSecs = $timeInSecs<br \/>\n                   &#8211; (60*60*$firstHour + 60*$firstMin + $firstSec);<\/p>\n<p>        $hh = intval( $deltaSecs\/3600 );<br \/>\n              $deltaSecs = ($deltaSecs- ($hh * 3600));<br \/>\n              $mm = intval($deltaSecs \/ 60);<br \/>\n              $ss = ($deltaSecs &#8211; ($mm * 60));<\/p>\n<p>        \/\/<br \/>\n        \/\/ UNLIKELY TO BE AN HOUR<br \/>\n        \/\/<br \/>\n        if( $hh )<br \/>\n          $delta = sprintf(&#8220;+%02d:%02d:%02d&#8221;, $hh, $mm, $ss );<br \/>\n        else<br \/>\n          $delta = sprintf(&#8220;+%02d:%02d&#8221;, $mm, $ss );       <\/p>\n<p>        }<br \/>\n      else<br \/>\n        {<br \/>\n        $delta =&#8221;;<br \/>\n        $firstHour = $race[1];<br \/>\n        $firstMin = $race[2];<br \/>\n        $firstSec = $race[3];<br \/>\n        }<br \/>\n      print(&#8220;<\/p>\n<td align='right'>&#8221; . $delta . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n      }<br \/>\n    else<br \/>\n      {<br \/>\n      \/\/<br \/>\n      \/\/ DNF &#8211; no time, gender posit, speed or delta<br \/>\n      \/\/<br \/>\n      print(&#8220;<\/p>\n<td><\/td>\n<p>\\n&#8221;);<br \/>\n      print(&#8220;<\/p>\n<td align='right'>DNF<\/td>\n<p>\\n&#8221;);<br \/>\n      print(&#8220;<\/p>\n<td><\/td>\n<p>\\n&#8221;);<br \/>\n      print(&#8220;<\/p>\n<td><\/td>\n<p>\\n&#8221;);<br \/>\n      }<br \/>\n    print(&#8220;<\/tr>\n<p>\\n&#8221;);<\/p>\n<p>    }<br \/>\n    print(&#8220;<\/table>\n<p>\\n&#8221;); <\/p>\n<p>    if(!$some)<br \/>\n      {<br \/>\n      print &#8216;<\/p>\n<p>Results not yet entered. Try again later.<\/p>\n<p>&#8216;;<br \/>\n      }<\/p>\n<p>  } else if ($_GET[&#8216;mode&#8217;] == &#8216;listriders&#8217; ) {<br \/>\n    $where = &#8221;;<\/p>\n<p>    \/\/<br \/>\n    \/\/ PREPARE A WHERE CLAUSE ADDITION<br \/>\n    \/\/<\/p>\n<p>    \/\/<br \/>\n    \/\/ FLAG &#8211; DO WE NEED TO TEST FOR First OR LAST NAME?<br \/>\n    \/\/<br \/>\n    $bFirst = 0;<br \/>\n    $bLast = 0;<\/p>\n<p>    if( isset($_GET[&#8220;riderid&#8221;]) &#038;&#038; $_GET[&#8220;riderid&#8221;] ) {<br \/>\n      $where = sprintf(&#8216; AND rider.id = %d&#8217;,  $_GET[&#8220;riderid&#8221;]);<\/p>\n<p>      \/\/<br \/>\n      \/\/ FIRST AND LAST EFFECTIVELY SET.<br \/>\n      \/\/<br \/>\n      $bFirst = 1;<br \/>\n      $bLast = 1;<br \/>\n    } else {<br \/>\n      if( isset($_GET[&#8220;last&#8221;]) &#038;&#038; $_GET[&#8220;last&#8221;] ) {<br \/>\n        $bLast = 1;<br \/>\n        $where = sprintf(&#8216; AND rider.last like &#8220;%s%%&#8221;&#8216;,  $_GET[&#8220;last&#8221;]);<br \/>\n      }<br \/>\n      if( isset($_GET[&#8220;first&#8221;]) &#038;&#038; $_GET[&#8220;first&#8221;] ) {<br \/>\n        $bFirst = 1;<br \/>\n        $whereFirst = sprintf(&#8216; AND rider.first like &#8220;%s%%&#8221;&#8216;, $_GET[&#8220;first&#8221;]);<br \/>\n        $where = $where . $whereFirst;<br \/>\n      }<br \/>\n    }<\/p>\n<p>    if( isset($_GET[&#8220;year&#8221;]) &#038;&#038; $_GET[&#8220;year&#8221;] &#038;&#038; $_GET[&#8220;year&#8221;] != -1 ) {<br \/>\n      $whereYear = sprintf(&#8216; AND YEAR(race.date) = %d&#8217;,  $_GET[&#8220;year&#8221;]);<br \/>\n      $where = $where . $whereYear;<br \/>\n    }<br \/>\n    if( isset($_GET[&#8220;month&#8221;]) &#038;&#038; $_GET[&#8220;month&#8221;] &#038;&#038; $_GET[&#8220;month&#8221;] != -1 ) {<br \/>\n      $whereMonth = sprintf(&#8216; AND month(race.date) = %d&#8217;, $_GET[&#8220;month&#8221;]);<br \/>\n      $where = $where . $whereMonth;<br \/>\n    }  <\/p>\n<p>    if( isset($_GET[&#8220;courseid&#8221;]) &#038;&#038; $_GET[&#8220;courseid&#8221;] &#038;&#038; $_GET[&#8220;courseid&#8221;] != -1 ) {<br \/>\n      $whereCourse = sprintf(&#8216; AND race.courseid = %d&#8217;, $_GET[&#8220;courseid&#8221;]);<br \/>\n      $where = $where . $whereCourse;<br \/>\n    }<\/p>\n<p>    $orderAscDesc = &#8220;&#8221;;  <\/p>\n<p>    if( isset($_GET[&#8220;sortField&#8221;]) &#038;&#038; $_GET[&#8220;sortField&#8221;] )  {<br \/>\n      if( isset($_GET[&#8220;sortDirection&#8221;]) &#038;&#038; $_GET[&#8220;sortDirection&#8221;] ) {<br \/>\n        if( $_GET[&#8220;sortDirection&#8221;] == &#8220;DESC&#8221; ) {<br \/>\n          $orderAscDesc = &#8220;DESC&#8221;;<br \/>\n        } else {<br \/>\n          $orderAscDesc = &#8220;&#8221;;<br \/>\n        }<br \/>\n      }<br \/>\n    $orderby =  sprintf(&#8216; ORDER BY %s %s&#8217;, $_GET[&#8220;sortField&#8221;], $orderAscDesc );<br \/>\n    } else {<br \/>\n      $orderby =  &#8221; ORDER BY race.date DESC &#8220;;<br \/>\n    }<\/p>\n<p>    if( !$bLast &#038;&#038; !$bFirst )  {<br \/>\n      print &#8216;<\/p>\n<p>Must enter (partial) first or last name. &#8216;;<br \/>\n      print &#8216;<a href=\"results.php\">Try again<\/a><\/p>\n<p>&#8216;;<br \/>\n    } else {<br \/>\n      \/\/<br \/>\n      \/\/ SHOW SELECTED RACES<br \/>\n      \/\/<br \/>\n      $listquery = &#8220;SELECT race.raceid, race.typeid, tag,  race.date, &#8221; .<br \/>\n             &#8221;  location.name, course.dist, course.description,  &#8221; .<br \/>\n             &#8221;  result.time, result.dnf, &#8221; .<br \/>\n             &#8221;       rider.first, rider.last &#8220;.<br \/>\n             &#8221;  FROM race, sysracetype, course, location, &#8221; .<br \/>\n             &#8221;       result, rider &#8221; .<br \/>\n             &#8221; WHERE race.courseid = course.courseid &#8221; .<br \/>\n             &#8221;   AND race.typeid = sysracetype.typeid &#8221; .<br \/>\n             &#8221;   AND course.locid = location.locid &#8221; .<br \/>\n             &#8221;   AND race.raceid = result.raceid&#8221; .<br \/>\n             &#8221;   AND result.riderid = rider.id&#8221; .<br \/>\n             $where .<br \/>\n             $orderby;<\/p>\n<p>      $result = mysql_query($listquery);<\/p>\n<p>      print(&#8220;<\/p>\n<table width='98%' border='0' cellspacing='4'>\\n&#8221;);<br \/>\n      print(&#8221;  <\/p>\n<tr>\\n&#8221;);<\/p>\n<p>      $params = PrepareLinkParams(&#8216;date&#8217;, $orderAscDesc);<\/p>\n<p>      $SortDateLink = sprintf(&#8216;<a title=\"Sort by Date\" ' .\n                          '   href=\"?mode=listriders&#038;%s\">Date<\/a>&#8216;,<br \/>\n                           $params );<\/p>\n<p>    print(&#8221;    <\/p>\n<th align=\\\"left\\\">  $SortDateLink  <\/th>\n<p>\\n&#8221;);<br \/>\n    print(&#8221;    <\/p>\n<th align=\\\"left\\\">Course<\/th>\n<p>\\n&#8221;);<br \/>\n    print(&#8221;    <\/p>\n<th align=\\\"right\\\">Dist<\/th>\n<p>\\n&#8221;);<br \/>\n    print(&#8221;    <\/p>\n<th align=\\\"left\\\">Type<\/th>\n<p>\\n&#8221;);<br \/>\n    print(&#8221;    <\/p>\n<th align=\\\"left\\\">Name<\/th>\n<p>\\n&#8221;);<\/p>\n<p>    $params = PrepareLinkParams(&#8216;time&#8217;, $orderAscDesc);<br \/>\n    $SortTimeLink = sprintf(&#8216;<a title=\"Sort by Time\" ' .\n                          '   href=\"?mode=listriders&#038;%s\">Time<\/a>&#8216;,<br \/>\n                           $params );<\/p>\n<p>    print(&#8221;    <\/p>\n<th align=\\\"right\\\">  $SortTimeLink  <\/th>\n<p>\\n&#8221;);<br \/>\n    print(&#8221;  <\/tr>\n<p>\\n&#8221;);<\/p>\n<p>    $some = 0;<br \/>\n    $odd = 1;<\/p>\n<p>    while ($race = mysql_fetch_array($result)) {<br \/>\n      $some++;<\/p>\n<p>      if( $odd ) {<br \/>\n        $odd = 0;<br \/>\n        $class = &#8220;resultrowodd&#8221;;<br \/>\n      } else {<br \/>\n        $odd = 1;<br \/>\n        $class = &#8220;resultroweven&#8221;;<br \/>\n      }<\/p>\n<p>      print(&#8216;<\/p>\n<tr class=\"' . $class . '\">&#8216;);<\/p>\n<p>      print(&#8220;\\n&#8221;);<\/p>\n<p>      $RaceDate = sprintf(&#8216;<a title=\"Detailed Race Results\" ' .\n                        '   href=\"?mode=race&#038;raceid=%d\">%s<\/a>&#8216;,<br \/>\n                         $race[&#8220;raceid&#8221;],<br \/>\n                         $race[&#8220;date&#8221;] );<\/p>\n<p>      print(&#8220;<\/p>\n<td>&#8221; . $RaceDate . &#8220;<\/td>\n<p>\\n&#8221;);<\/p>\n<p>      $RaceName = sprintf(&#8216;<a title=\"Course Summary\/Statistics\" ' .\n                          '   href=\"racestats.php?raceid=%d\">%s%s %s<\/a>&#8216;,<br \/>\n                         $race[&#8220;raceid&#8221;],<br \/>\n                         $race[&#8220;name&#8221;],<br \/>\n                         $race[&#8220;description&#8221;]<br \/>\n                           ? &#8216;,&#8217;<br \/>\n                           : &#8221;,<br \/>\n                         $race[&#8220;description&#8221;] );<\/p>\n<p>      print(&#8220;<\/p>\n<td>&#8221; . $RaceName . &#8220;<\/td>\n<p>\\n&#8221;);<\/p>\n<p>      print(&#8220;<\/p>\n<td align='right'>&#8221; . $race[&#8220;dist&#8221;] . &#8216; &#8216; . $dist_unit . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n      print(&#8220;<\/p>\n<td>&#8221; . $race[&#8220;tag&#8221;] . &#8220;<\/td>\n<p>\\n&#8221;);<\/p>\n<p>      $FullName = trim($race[&#8220;last&#8221;]). &#8220;, &#8221; . trim($race[&#8220;first&#8221;]);<\/p>\n<p>      print(&#8220;<\/p>\n<td>&#8221; . $FullName . &#8220;<\/td>\n<p>\\n&#8221;);<br \/>\n      $sTime = $race[&#8220;dnf&#8221;] == 1 ? &#8220;DNF&#8221; : $race[&#8220;time&#8221;];<br \/>\n      print(&#8220;<\/p>\n<td align='right'>&#8221; . $sTime . &#8220;<\/td>\n<p>\\n&#8221;);<\/p>\n<p>      print(&#8220;<\/tr>\n<p>\\n&#8221;);<\/p>\n<p>      }<br \/>\n    print(&#8220;<\/table>\n<p>\\n&#8221;);<\/p>\n<p>    if(!$some) {<br \/>\n      print &#8216;<\/p>\n<p>No matching results were found.<\/p>\n<p>&#8216;;<br \/>\n    }<br \/>\n  }<br \/>\n}<\/p>\n<p>function PrepareLinkParams($FieldToSort, $orderAscDesc)<br \/>\n  {<br \/>\n  \/\/<br \/>\n  \/\/ LINK HAS ALL ORIGINAL PARAMS.<br \/>\n  \/\/ BUT SORT ORDER REVERSED (IF IT WAS THERE)<br \/>\n  \/\/ AND SORT COLUMN SET TO USER CHOSEN COLUMN<br \/>\n  \/\/<br \/>\n  $params = &#8221;;<br \/>\n  foreach( $_GET as $key => $value)<br \/>\n    {<br \/>\n    if( $key != &#8216;sortField&#8217; &#038;&#038; $key != &#8216;sortDirection&#8217; )<br \/>\n      $params = $params . &#8220;$key=$value&#8221; . &#8216;&#038;&#8217;;<br \/>\n    }<\/p>\n<p>  $params = $params . &#8220;sortField=$FieldToSort&#8221; . &#8216;&#038;&#8217;;<\/p>\n<p>  if( $orderAscDesc == &#8220;DESC&#8221; )<br \/>\n    {<br \/>\n    $orderAscDesc = &#8220;&#8221;;<br \/>\n    }<br \/>\n  else<br \/>\n    {<br \/>\n    $orderAscDesc = &#8220;DESC&#8221;;<br \/>\n    }<\/p>\n<p>  $params = $params . &#8220;sortDirection=$orderAscDesc&#8221;;<br \/>\n  return $params;<br \/>\n  }<\/p>\n<p>  ?><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"_EventAllDay":false,"_EventTimezone":"","_EventStartDate":"","_EventEndDate":"","_EventStartDateUTC":"","_EventEndDateUTC":"","_EventShowMap":false,"_EventShowMapLink":false,"_EventURL":"","_EventCost":"","_EventCostDescription":"","_EventCurrencySymbol":"","_EventCurrencyCode":"","_EventCurrencyPosition":"","_EventDateTimeSeparator":"","_EventTimeRangeSeparator":"","_EventOrganizerID":[],"_EventVenueID":[],"_OrganizerEmail":"","_OrganizerPhone":"","_OrganizerWebsite":"","_VenueAddress":"","_VenueCity":"","_VenueCountry":"","_VenueProvince":"","_VenueState":"","_VenueZip":"","_VenuePhone":"","_VenueURL":"","_VenueStateProvince":"","_VenueLat":"","_VenueLng":"","_VenueShowMap":false,"_VenueShowMapLink":false,"footnotes":""},"class_list":["post-5","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.owensoundcycling.ca\/index.php\/wp-json\/wp\/v2\/pages\/5","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.owensoundcycling.ca\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.owensoundcycling.ca\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.owensoundcycling.ca\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.owensoundcycling.ca\/index.php\/wp-json\/wp\/v2\/comments?post=5"}],"version-history":[{"count":176,"href":"https:\/\/www.owensoundcycling.ca\/index.php\/wp-json\/wp\/v2\/pages\/5\/revisions"}],"predecessor-version":[{"id":264,"href":"https:\/\/www.owensoundcycling.ca\/index.php\/wp-json\/wp\/v2\/pages\/5\/revisions\/264"}],"wp:attachment":[{"href":"https:\/\/www.owensoundcycling.ca\/index.php\/wp-json\/wp\/v2\/media?parent=5"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}