0)
$fkt = number_format($row1['pkt'] / $row1['km'], 2);
$klm = $row1['km'];
$pkt = $row1['pkt'];
$sto = $row1['startort'];
$html_flight .= "$nac $dat - $fkt - Distanz: $klm km - $pkt Punkte - Start: $sto
";
$anz++;
}
return $html_flight;
}
function TransformDate($s) {
$ary = explode("-", $s);
return $ary[2] . "." . $ary[1] . "." . $ary[0];
}
switch($SCORE) {
case "P.F":
$TBLE = "piloten_104";
$TYPE = "104";
$TYPE = "AND f.Kategorien_oid = 'GL' AND f.Parakategorie='F'";
$HEAD = "Kategorie Gleitschirm fun & safety class / Catégorie parapente fun & safety class" . "
\n";
$HEAD .= "Einzelwertung vom $DATE / Classement individuel du $DATE";
$CLUB = 0;
break;
case "P.O":
$TBLE = "piloten_103";
$TYPE = "103";
$HEAD = "Kategorie Gleitschirm open / Catégorie parapente open" . "
\n";
$HEAD .= "Einzelwertung vom $DATE / Classement individuel du $DATE";
$CLUB = 0;
break;
case "P.D":
$TBLE = "piloten_103";
$TYPE = "1031";
$HEAD = "Kategorie Gleitschirm open / Catégorie parapente open" . "
\n";
$HEAD .= "Einzelwertung vom $DATE / Classement individuel du $DATE";
$CLUB = 0;
$WHERE = "WHERE sex = 'f'";
break;
case "P.C":
$TBLE = "club_103";
$TYPE = "103";
$HEAD = "Kategorie Gleitschirm / Catégorie parapente" . "
\n";
$HEAD .= "Clubwertung vom $DATE / Classement de club du $DATE";
$CLUB = 1;
break;
case "D.E":
$TBLE = "piloten_101";
$TYPE = "101";
$HEAD = "Kategorie Delta / Catégorie Delta" . "
\n";
$HEAD .= "Einzelwertung vom $DATE / Classement individuel du $DATE";
$CLUB = 0;
break;
case "D.C":
$TBLE = "club_101";
$TYPE = "101";
$HEAD = "Kategorie Delta / Catégorie Delta" . "
\n";
$HEAD .= "Clubwertung vom $DATE / Classement de club du $DATE";
$CLUB = 1;
break;
case "S.E":
$TBLE = "piloten_102";
$TYPE = "102";
$HEAD = "Kategorie Starrflügler / Catégorie ailes rigides" . "
\n";
$HEAD .= "Einzelwertung vom $DATE / Classement individuel du $DATE";
$CLUB = 0;
break;
case "S.C":
$TBLE = "club_102";
$TYPE = "102";
$HEAD = "Kategorie Starrflügler / Catégorie ailes rigides" . "
\n";
$HEAD .= "Clubwertung vom $DATE / Classement de club du $DATE";
$CLUB = 1;
break;
default:
$TBLE = "";
}
?>
Score.Glider.PHP
*) = Film-&Koordinatenkontrolle wurden gemacht/Contrôles des films et
cordonnées on été faits
$disp_rang $nme, $vme, $clb - $typ - $anz $anz_caption - $pkt Punkte
";
print $html_pilot_head;
if($disp_rang <= $NUM)
print GetFlights($row1['id_teilnehmer'], $TYPE);
print "
";
}
}
if($CLUB == 1) {
$rang = 0;
$disp_rang = 1;
$prev_pkt = 0;
$sql1 = "SELECT * FROM $TBLE ORDER BY pkt desc";
$res1 = mysql_db_query($database, $sql1, $link);
while($row1 = mysql_fetch_array($res1)) {
$rang++;
$nme = $row1['name'];
$pkt = $row1['pkt'];
if($prev_pkt != $pkt)
$disp_rang = $rang;
$prev_pkt = $pkt;
$html_club_head = "$disp_rang $nme - $pkt Punkte
";
print $html_club_head;
// Pilotendaten
$sql2 = "SELECT * FROM piloten_$TYPE WHERE verein = '" . EscapeForMySQL($nme) . "' ORDER BY pkt desc LIMIT 0,4";
//print $sql2;
$res2 = mysql_db_query($database, $sql2, $link);
while($row2 = mysql_fetch_array($res2)) {
$p_nme = $row2['name'];
$p_vme = $row2['vname'];
$p_typ = $row2['f_typ'];
$p_anz = $row2['anz_fluge'];
$p_pkt = $row2['pkt'];
$anz_caption = "Flüge";
if($p_anz < 2)
$anz_caption = "Flug";
$html_pilot_head = "$p_nme, $p_vme, $p_typ - $p_anz $anz_caption - $p_pkt Punkte
";
if($disp_rang <= $NUM)
print $html_pilot_head;
}
print "
";
}
}
?>
Aktuelle Rangliste siehe / Liste de résultats actuels voir www.shv-fsvl.ch/sport/d/resultate