if ($varLadder) {
$queryLadderPlayers = mysql_query("SELECT players FROM ladder WHERE id = '" . $varLadder . "'") or die;
$queryLadderPlayers = mysql_fetch_row($queryLadderPlayers);
$ladderPlayersArray = explode("|", $queryLadderPlayers[0], -1);
echo "
\n";
echo " - \n";
echo " Rank\n";
echo "
\n";
echo " - \n";
echo " Players\n";
echo "
\n";
echo " - \n";
echo " Wins\n";
echo "
\n";
echo " - \n\n";
echo " Losses\n";
echo "
\n";
echo " - \n\n";
echo " Streak\n";
echo "
\n";
echo " - \n";
echo " Percentage\n";
echo "
\n";
echo " - \n";
echo " Team\n";
echo "
\n";
echo " - \n";
echo " Flag\n";
echo "
\n";
for($ladderPlayersCount = 0; $ladderPlayersCount < count($ladderPlayersArray); $ladderPlayersCount++) {
$ladderPlayerCurrent = $ladderPlayersArray[$ladderPlayersCount];
$queryLadderWins = mysql_query("SELECT game FROM ladder WHERE winner = '" . $ladderPlayerCurrent . "'") or die;
$playerWins = 0;
while ($ladderWinsArray = mysql_fetch_array($queryLadderWins, MYSQL_ASSOC)) {
foreach ($ladderWinsArray as $ladderWins) { $playerWins++; }
}
$queryLadderWinner = mysql_query("SELECT winner FROM ladder WHERE challenger = '" . $ladderPlayerCurrent . "' OR opponent = '" . $ladderPlayerCurrent . "' ORDER BY timestamp DESC") or die;
$playerLosses = 0;
$playerStreak = 0;
$playerStreakLost = 0;
while ($ladderWinnerArray = mysql_fetch_array($queryLadderWinner, MYSQL_ASSOC)) {
foreach ($ladderWinnerArray as $ladderWinner) {
$playerLosses++;
if (!$playerStreakLost) {
if ($ladderWinner == $ladderPlayerCurrent) {
$playerStreak++;
} else {
$playerStreakLost = 1;
}
}
}
}
$playerLosses -= $playerWins;
$playerPercentage = ($playerWins / ($playerWins + $playerLosses)) * 100;
$playerPercentage .= "%";
echo " - \n";
echo " 0\n";
echo "
\n";
echo " - \n";
echo " $ladderPlayerCurrent\n";
echo "
\n";
echo " - ";
echo " $playerWins\n";
echo "
\n";
echo " - \n";
echo " $playerLosses\n";
echo "
\n";
echo " - \n";
echo " $playerStreak\n";
echo "
\n";
echo " - ";
echo " $playerPercentage\n";
echo "
\n";
echo " - ";
echo " Team\n";
echo "
\n";
echo " - ";
echo " Flag\n";
echo "
\n";
}
echo "
";
}