include ("mysqlLS.inc")?>
Länderspiele - Bilanz
Länderspielbilanz
Bilanz weiss - positiv, gelb - negativ, ocker - ausgeglichen
Zur weiteren Info auf die Landesfahne klicken !
$pkt = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$z = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$wme = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$eme = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$wmq = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$emq = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$ver = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$gew = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$un = array (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
$auswahl = array ("Ägypten", "Albanien", "Algerien", "Argentinien", "Armenien", "Aserbaidschan", "Australien",
"Belgien", "Böhmen-Mähren", "Bolivien", "Bosnien-Herzegowina", "Brasilien","Bulgarien", "Chile", "China",
"Costa Rica", "Dänemark", "DDR", "Ecuador", "Elfenbeinküste", "England", "Estland", "Faröer", "Finnland", "Frankreich",
"Georgien", "Ghana", "Gibraltar", "Griechenland", "GUS", "Iran", "Irland*", "Island", "Israel", "Italien",
"Japan", "Jugoslawien", "Kamerun", "Kanada", "Kasachstan", "Kolumbien", "Kroatien", "Kuweit", "Lettland",
"Liechtenstein", "Litauen", "Luxemburg", "Malta", "Marokko", "Mexiko", "Moldawien", "Neuseeland",
"Niederlande", "Nigeria", "Nordirland", "Norwegen", "Österreich", "Oman", "Paraguay", "Peru", "Polen",
"Portugal", "Rumänien", "Russland", "Saarland", "San Marino", "Saudi-Arab", "Schottland",
"Schweden", "Schweiz", "Serbien#", "Serbien und Montenegro", "Slowakei-", "Slowenien",
"Sowjetunion", "Spanien", "Südafrika", "Südkorea", "Thailand", "Tschechische Republik", "Tschechoslowakei",
"Türkei", "Tunesien", "Ukraine", "Ungarn", "Uruguay", "USA", "VA Emirate",
"Wales", "Weissrussland", "Zypern");
for ($k = 0; $k < 91; $k++){
$auswahl2[$k] = $auswahl[$k];
$land[$k] = $auswahl[$k];
}
?>
echo "";
echo "| Land | ";
echo "Sp | ";
echo "g | ";
echo "u | ";
echo "v | ";
echo "Tore | ";
echo "WMQ | ";
echo "EMQ | ";
echo "WM | ";
echo "EM | ";
echo "11 | ";
echo "Spiele | ";
echo "
";
//--------------------- Schleife über Länder
for ($k = 0; $k < 91; $k++) {
$sql = mysql_query("SELECT * FROM spiele WHERE heim LIKE '%$auswahl2[$k]%' OR gast LIKE '%$auswahl2[$k]%';");
while ($ds = mysql_fetch_object($sql)){
$heim = $ds -> heim;
$gast = $ds -> gast;
$ee = $ds -> ee;
$he = $ds -> he;
$pkt = $ds -> pkt;
$tpl = $ds -> tpl;
$tmin = $ds -> tmin;
$nr = $ds -> nr;
$art = $ds -> art;
$bem= $ds -> bem;
$bem2 = $ds -> bem2;
//----------------- Umwandlung von ee -------------------------
$t1 = substr($ee, 0, 2);
$t2 = substr($ee, 3, 2);
$t11 = substr($t1, 0, 1);
$t21 = substr($t2, 0, 1);
if ($t11 === "0"){
$t1 = substr($ee, 1, 1);
}
else {
$t1 = $t1;
}
if ($t21 === "0"){
$t2 = substr($ee, 4, 1);
}
else {
$t2 = $t2;
}
$ee = "$t1".":"."$t2";
//----------------- Umwandlung von he -------------------------
$u1 = substr($he, 0, 2);
$u2 = substr($he, 3, 2);
$u11 = substr($u1, 0, 1);
$u21 = substr($u2, 0, 1);
if ($u11 === "0"){
$u1 = substr($he, 1, 1);
}
else {
$u1 = $u1;
}
if ($u21 === "0"){
$u2 = substr($he, 4, 1);
}
else {
$u2 = $u2;
}
$he = "$u1".":"."$u2";
//............................................................
if ($pkt ==3) {
$gew[$k] = $gew[$k] +1;
}
if ($pkt ==1) {
$un[$k] = $un[$k] +1;
}
if ($pkt ==0) {
$ver[$k] = $ver[$k] +1;
}
$z[$k] = $z[$k] + 1;
$tp[$k] = $tp[$k] + $tpl;
$tm[$k] = $tm[$k] + $tmin;
if ($art === "WM-Q"){
$wmq[$k] = $wmq[$k] + 1;
}
if ($art === "EM-Q"){
$emq[$k] = $emq[$k] + 1;
}
//---------------------------------------------
$test1 = substr($art, 0,3);
//----------------------------------------------
if ($test1 === "EM_"){
$eme[$k] = $eme[$k] + 1;
}
if ($test1 === "WM_"){
$wme[$k] = $wme[$k] + 1;
}
//----------------------------------------------
$test2 = strpos($bem, "Elfm");
//-----------------------------------------------
if ($test2 <> 0){
$elf[$k] = $elf[$k] + 1;
}
$land[$k] = $heim;
if ($land[$k] == "Deutschland") {
$land[$k] = $gast;
}
$tore[$k] = "$tp[$k]".":"."$tm[$k]";
}
$spg = $spg + $z[$k];
$gewg = $gewg + $gew[$k];
$ung = $ung + $un[$k];
$verg = $verg + $ver[$k];
$tplg = $tplg + $tp[$k];
$tming = $tming + $tm[$k];
$tg = "$tplg".":"."$tming";
$wmqg = $wmqg + $wmq[$k];
$emqg = $emqg + $emq[$k];
$wmeg = $wmeg + $wme[$k];
$emeg = $emeg + $eme[$k];
$elfg = $elfg + $elf[$k];
} // -- Schleifenende -----------------------
mysql_close($dz);
//-------------------- Ausgabenschleife
for ($k = 0; $k < 90; $k++) {
if ($wmq[$k] === 0) $wmq[$k] = ".";
if ($wme[$k] === 0) $wme[$k] = ".";
if ($emq[$k] === 0) $emq[$k] = ".";
if ($eme[$k] === 0) $eme[$k] = ".";
$rest = $k % 2;
if ($rest === 0){
?>
}
if ($rest === 1){
?>
}
if ($gew[$k] > $ver[$k]) {
?>
|
}
if ($gew[$k] < $ver[$k]) {
?>
|
}
if ($gew[$k] == $ver[$k]) {
?>
|
}
?>
|
|
|
|
|
|
|
|
|
|
switch ($land[$k]) {
case "Irland*":
$bild[$k] = "Irland"; break;
case "Elfenbeinküste":
$bild[$k] = "Elfenbeinkueste"; break;
case "Serbien#":
$bild[$k] = "Serbien"; break;
case "Slowakei-":
$bild[$k] = "Slowakei"; break;
case "Türkei":
$bild[$k] = "Tuerkei"; break;
case "Südkorea":
$bild[$k] = "Suedkorea"; break;
case "Südafrika":
$bild[$k] = "Suedafrika"; break;
case "Dänemark":
$bild[$k] = "Daenemark"; break;
case "Russland":
$bild[$k] = "russ"; break;
case "Rumänien":
$bild[$k] = "Rumaenien"; break;
case "Ägypten":
$bild[$k] = "Aegypten"; break;
case "Österreich":
$bild[$k] = "Oesterreich"; break;
case "Böhmen-Mähren":
$bild[$k] = "Boehmen-Maehren"; break;
case "Faröer":
$bild[$k] = "Faroer"; break;
case "Weissrussland":
$bild[$k] = "wrl"; break;
default:
$bild[$k] = $land[$k];
}
?>
 |
} // .................................... Schleifenende Ausgabe
?>
| Gesamt |
echo "$spg";
echo " | $gewg";
echo " | $ung";
echo " | $verg";
echo " | $tg";
echo " | $wmqg";
echo " | $emqg";
echo " | $wmeg";
echo " | $emeg";
echo " | $elfg";
echo " |
";
?>
echo "| . | ";
echo "Sp | ";
echo "g | ";
echo "u | ";
echo "v | ";
echo "Tore | ";
echo "WMQ | ";
echo "EMQ | ";
echo "WM-ER | ";
echo "EM-ER | ";
echo "11 | ";
echo "
";
?>
Die 7 Entscheidungen per Elfmeterschiessen wurden als Sieg für den Gewinner gewertet.