Resultat från 2005

'00:00:00'::time order by (goaltime-starttime)*grade limit $first"; } else if($class==4) { $q = "select *,ltrim((goaltime-starttime)::time(0)::varchar,'0:') as result, ltrim(((goaltime-starttime)*grade)::time(0)::varchar,'0:') as graded from runner join pts_age_grades_women_2005 on runner.yob=pts_age_grades_women_2005.yob where classid=".$class." and (goaltime-starttime)>'00:00:00'::time order by (goaltime-starttime)*grade limit $first"; } else { $q = "select *,ltrim((goaltime-starttime)::time(0)::varchar,'0:') as result from runner where classid=".$class." and (goaltime-starttime)>'00:00:00'::time order by (goaltime-starttime) limit $first"; } $qres = pg_query($q); $qclass = "select classname from cl where classid=$class"; $resclass = pg_query($qclass); if($line = pg_fetch_array($resclass)) { echo "

".$line['classname']."

"; } $i=1; $firstline=1; while($line = pg_fetch_array($qres)) { if($firstline==1) { $firstline=0; echo "\n"; echo ""; if($class==3 || $class==4) echo ""; echo ""; } if($prevres == $line['result']) { $place = ''; } else { $place = $i; } echo "\t\n\t\t"; if($class==3 || $class==4) echo ""; echo "\n\t"; $i++; $prevres = $line['result']; } if($i==1) echo "

Resultaten kommer senare under dagen

"; else echo "\n

Placering	Startnummer	Namn/födelseår	Förening	Tid	Ålderskorrigerad tid	Målgångsvideo
" .$place. "	" .htmlspecialchars($line['startnumber']) . "	" .htmlspecialchars($line['fname']) ." " .htmlspecialchars($line['lname'])." -".$line['yob']. "	" .htmlspecialchars($line['club']). "	".$line['result']. "	".$line['graded']. "	"; $filename = $videofilename."_2005_nr".$line['startnumber'].".mpg"; $filepath = "videos/".$videofilename."-2005/".$filename; $abspath = $_SERVER["DOCUMENT_ROOT"]."/".$filepath; if(file_exists($abspath)) { echo "$filename"; } echo "

"; } if(isset($_GET['class'])) { if($_GET['class']==100) { $query1 = "select startnumber,club,classid,(goaltime-runner.starttime)::interval(0) as cmptime from runner where classid>6 and goaltime>starttime and club<>'';"; $res1 = pg_query($query1); while($line1 = pg_fetch_array($res1)) { $query_place = "select count(*)+1 from runner where classid=".$line1['classid']." and (goaltime-starttime)::interval(0)<'".$line1['cmptime']."' and goaltime is not null and starttime is not null and (goaltime-starttime)::interval>'00:00:00'::interval"; $res_place = pg_query($query_place); $line_place = pg_fetch_array($res_place); $query_max = "select count(*)+1 from runner where classid=".$line1['classid']." and goaltime is not null and starttime is not null and (goaltime-starttime)::interval>'00:00:00'::interval"; $res_max = pg_query($query_max); $line_max = pg_fetch_array($res_max); $points = $line_max[0]-$line_place[0]; $teampoints[$line1[club]] += $points; } if($teampoints) { arsort($teampoints); $i=1; echo "

Lagresultat ungdomar

"; echo ""; foreach ($teampoints as $key => $val) { echo "\n"; } echo "

".$i++."

" . $key . "

" . $val . " poäng

"; } } else { listres($dbconn,2000000,$_GET['class']); } } ?>