Vorrunden-Gruppentabellen\n"; } // load team list and define some accessor functions $teams = Query('SELECT id, name, `group`, bias FROM wm_teams WHERE valid=1', RESOLVE_IDS); function cget($tid, $c) { global $teams; if (!isset($teams[$tid]) || !isset($teams[$tid][$c])) { return 0; } return $teams[$tid][$c]; } function cinc($tid, $c, $inc=1) { global $teams; if (isset($teams[$tid])) { $teams[$tid][$c] = cget($tid, $c) + $inc; } } // enter games foreach(Query('SELECT teamA, teamB, goalsA, goalsB FROM wm_matches WHERE class>=100') as $item) { $ta = $item['teamA']; $tb = $item['teamB']; $ga = $item['goalsA']; $gb = $item['goalsB']; if (($ga == NULL) || ($gb == NULL)) { continue; } cinc($ta, 'N'); cinc($tb, 'N'); cinc($ta, 'GF', $ga); cinc($ta, 'GA', $gb); cinc($tb, 'GF', $gb); cinc($tb, 'GA', $ga); if ($ga == $gb) { cinc($ta, 'D'); cinc($tb, 'D'); } else if ($ga > $gb) { cinc($ta, 'W'); cinc($tb, 'L'); } else { cinc($ta, 'L'); cinc($tb, 'W'); } } // fill in missing fields foreach($teams as $id => $team) { $gf = cget($id, 'GF'); $gd = $gf - cget($id, 'GA'); $sc = 3 * cget($id, 'W') + cget($id, 'D'); $teams[$id]['GD'] = $gd; $teams[$id]['S'] = $sc; $teams[$id]['X'] = $sc * 1000000 + $gd * 30000 + $gf * 1000 + $team['bias'] * 100 - $id; } // generate tables $gname = NULL; $gteams = array(); function cmp_teams($ta, $tb) { global $teams; return $teams[$tb]['X'] - $teams[$ta]['X']; } function DumpGroup() { global $gname, $gteams, $teams; if ($gname && $gteams) { usort($gteams, 'cmp_teams'); echo "

Gruppe $gname

\n"; echo "\n"; echo "\n"; foreach ($gteams as $id) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $d = cget($id, 'GD'); if ($d < 0) { echo "\n"; } else if ($d > 0) { echo "\n"; } else { echo "\n"; } echo "\n"; echo "\n"; } echo "
Mannschaft\n"; echo "Sp\n"; echo "S\n"; echo "U\n"; echo "N\n"; echo "T\n"; echo "GT\n"; echo "TD\n"; echo "Pkt\n"; echo "
" . htmlescape($teams[$id]['name']) . "" . cget($id, 'N') . "" . cget($id, 'W') . "" . cget($id, 'D') . "" . cget($id, 'L') . "" . cget($id, 'GF') . "" . cget($id, 'GA') . "–" . (-$d) . "+$d±$d" . cget($id, 'S') . "
\n"; } $gname = NULL; $gteams = array(); } echo "
\n"; foreach($teams as $id => $item) { $g = $item['group']; if ($g != $gname) { DumpGroup(); $gname = $g; } $gteams[] = $id; } DumpGroup(); echo "
\n"; if (!IncludeOnly) { EndPage(); CloseDB(); } ?>