Resultat från

Hittar du inte ditt resultat? Hör av dig till oss via epost: resultat@racetimer.se eller via telefon: 08-559 242 45 / 070-554 69 41.

Tjejtrampet nummerordning Tjejtrampet namnordning Tjejtrampet resultatordning

"; if(isset($_GET['submit']) && $_GET['s']!="") { $s = $_GET['s']; $query; if(is_numeric($s)) { $query = "select startnumber,fname||' '||lname as name,club,teamname, case when runner.starttime is NULL then ltrim((goaltime-cl.starttime)::time(0),'0:') else ltrim((goaltime-runner.starttime)::time(0),'0:') end as time, goaltime-cl.starttime as cmptime from runner natural join team join cl on runner.classid=cl.classid where startnumber=$s and goaltime is not null"; } else { $array = explode(' ',$s); $where = " where goaltime is not null "; for($i=0;$i"; echo " Startnr Namn Tid Se målgångsvideo"; while($line = pg_fetch_array($res)) { echo "".$line['startnumber']." ".$line['name']." ".$line['time']." "; $filename = $video_prefix."_nr".$line['startnumber'].".mpg"; $filepath = "videos/".$video_prefix."/".$filename; $abspath = $_SERVER["DOCUMENT_ROOT"]."/".$filepath; if(file_exists($abspath)) { echo "$filename"; } echo " "; } echo ""; } else if ( $_GET['order']=='nr' or $_GET['order']=='nn' or $_GET['order']=='pl' ) { $where = "where goaltime is not null and goaltime>cl.starttime"; $order; $time; if ($_GET['order']=='nr') { $order = "order by startnumber"; $time = "case when runner.starttime is NULL then ltrim((goaltime-cl.starttime)::time(0),'0:') else ltrim((goaltime-runner.starttime)::time(0),'0:') end as time"; } else if ($_GET['order']=='pl') { $order = "order by goaltime-runner.starttime,startnumber"; $time = "case when runner.starttime is NULL then ltrim((goaltime-cl.starttime)::time(0),'0:') else ltrim((goaltime-runner.starttime)::time(0),'0:') end as time"; //$time = "ltrim((goaltime-cl.starttime)::time(0),'0:') as time"; } else { $order = "order by lname,fname,startnumber"; $time = "case when runner.starttime is NULL then ltrim((goaltime-cl.starttime)::time(0),'0:') else ltrim((goaltime-runner.starttime)::time(0),'0:') end as time"; } $q = "select startnumber,lname||' '||fname as name,club,$time from runner join cl on runner.classid=cl.classid $where $order"; $qres = pg_query($q); //echo "NamnFöretag / LagnamnNr"; $firstline = true; $i = 1; while($line = pg_fetch_array($qres)) { if($firstline) { $firstline = false; echo "\n"; echo ""; if ($_GET['order']=='pl') echo ""; echo ""; echo ""; //if ($_GET['order']=='pl') echo ""; //else echo ""; echo ""; } if($prevres == $line['time']) { $place = ''; } else { $place = $i; } echo "\t\n\t\t"; if ($_GET['order']=='pl') echo ""; echo "\n\t"; $i++; $prevres = $line['time']; } if($firstline) echo "

Resultaten kommer senare under dagen

"; else echo "\n

Placering	Startnummer	Namn		Resultat	Resultat (Tid från startskott)	Resultat (Nettotid - från passering av startlinje)
" . $place . "	" .htmlspecialchars($line['startnumber']). "	" .htmlspecialchars($line['name']) ."	" .htmlspecialchars($line['club']). "	".$line['time']. "

"; } ?>