// Teamname $dsp->AddDoubleRow(t('Teamame'), $team['name']); // Disqualified if ($team['disqualified']) { $dsp->AddDoubleRow("", "<font color=\"#ff0000\">" . t('Disqualifiziert') . "</font>"); } // Banner if ($team['banner']) { $dsp->AddSingleRow("<img src=\"ext_inc/team_banners/{$team['banner']}\" alt=\"{$team['banner']}\">"); } // Leader include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); $dsp->AddDoubleRow(t('Teamleiter'), $dsp->FetchUserIcon($team['userid'], $team['username']) . " (Platz: " . $seat2->SeatNameLink($team['userid'], '', '') . ")"); // Members $dsp->AddDoubleRow(t('Mitglieder'), $tfunc->GetMemberList($_GET["teamid"])); // Stats $game_anz = 0; $won = 0; $lost = 0; $games = $db->qry("SELECT g1.score AS s1, g2.score AS s2, g1.leaderid\n FROM %prefix%t2_games AS g1\n LEFT JOIN %prefix%t2_games AS g2 ON (g1.tournamentid = g2.tournamentid) AND (g1.round = g2.round) AND ((g1.position + 1) = g2.position)\n WHERE ((g1.score != 0) OR (g2.score != 0))\n AND ((g1.position / 2) = FLOOR(g1.position / 2))\n AND ((g1.leaderid = %int%) OR (g2.leaderid = %int%))\n ", $team['userid'], $team['userid']); while ($game = $db->fetch_array($games)) { $game_anz++; if ($game['leaderid'] == $team['userid']) { $game[s1] > $game[s2] ? $won++ : $lost++; } else { $game[s1] > $game[s2] ? $lost++ : $won++; } } $db->free_result($games); $stats2 = t('Spiele gewonnen') . ": {$won}" . HTML_NEWLINE . t('Spiele verloren') . ": {$lost}" . HTML_NEWLINE . t('Spiele insgesamt') . ": {$game_anz}";