arena

<style>
body {
    margin: 0;
    background:#ddd;
}
h2 {
    margin:5px;
}
table {
    border-collapse:collapse;
    background:#333;
    color:#BBB;
}
th {
    border-left:1px solid #000;
    border-right:1px solid #000;
    border-bottom:1px solid #000;
    color:#fe5;
}
#border {
    border-left:1px solid #000;
    border-right:1px solid #000;
    border-bottom:1px solid #000;
}
#border td {
    border-left:1px solid #000;
    border-right:1px solid #000;
}
a:link {
    color:#00f;
}
a:hover {
    color:#00f;
    text-decoration:none;
}
a:active {
    color:#00f;
}
a:visited {
    color:#00f;
}
td a:link {
    color:#BBB;
}
td a:hover {
    color:#BBB;
    text-decoration:none;
}
td a:active {
    color:#BBB;
}
td a:visited {
    color:#BBB;
}
</style>
<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$cdb = 'characters';

$connect = mysql_connect($host,$user,$pass) or die('Нет подключения к базе данных');
mysql_select_db ($cdb, $connect) or die(mysql_error());
print "<h2 align=\"center\">Топ арены</h2>";
print "<h3 align=\"center\">Команды арены <a href=\"".$_SERVER['PHP_SELF']."\">2х2</a> - <a href=\"?id=2\">3x3</a> - <a href=\"?id=3\">5x5</a></h3>";
if (!isset($_GET['id']) && !isset($_GET['teamId'])){
    print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\"><tr>
    <th width=\"30\">№</th>
    <th>Название</th>
    <th width=\"120\">Капитан</th>
    <th width=\"100\">Рейтинг</th>
    <th width=\"80\">Игр за неделю</th>
    <th width=\"80\">Побед за неделю</th>
    <th width=\"80\">Игр за сезон</th>
    <th width=\"80\">Побед за сезон</th>
    </tr></table>";
    $sql_arena2 = mysql_query("SET NAMES cp1251");
    $sql_arena2 = mysql_query("SELECT * FROM `arena_team` WHERE `type` = 2 ORDER BY `rating` DESC LIMIT 100", $connect) or die(mysql_error());
    $id2 = 1;
    while ($result_arena2 = mysql_fetch_array($sql_arena2)){
        $id_team2 = $result_arena2['arenaTeamId'];
        $name_team2 = $result_arena2['name'];
        $guid2 = $result_arena2['captainGuid'];
        $rating2 = $result_arena2['rating'];
        $seasonGames2 = $result_arena2['seasonGames'];
        $weekGames2 = $result_arena2['weekGames'];
        $seasonWins2 = $result_arena2['seasonWins'];
        $weekWins2 = $result_arena2['weekWins'];
        $char_name2 = mysql_query("SELECT `name` FROM `characters` WHERE `guid` = $guid2", $connect) or die(mysql_error());
        $result_name2 = mysql_fetch_array($char_name2);
        $name2 = $result_name2['name'];

        print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\" id=\"border\"><tr>
        <td align=\"center\" width=\"30\">$id2</td>
        <td align=\"center\"><a href=\"?teamId=$id_team2\" title=\"Подробнее\">$name_team2</a></td>
        <td align=\"center\" width=\"120\">$name2</td>
        <td align=\"center\" width=\"100\">$rating2</td>
        <td align=\"center\" width=\"80\">$weekGames2</td>
        <td align=\"center\" width=\"80\">$weekWins2</td>
        <td align=\"center\" width=\"80\">$seasonGames2</td>
        <td align=\"center\" width=\"80\">$seasonWins2</td>
        </tr></table>";
    $id2++;
    }
}
if ($_GET['id'] == 2){
    print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\"><tr>
    <th width=\"30\">№</th>
    <th>Название</th>
    <th width=\"120\">Капитан</th>
    <th width=\"100\">Рейтинг</th>
    <th width=\"80\">Игр за неделю</th>
    <th width=\"80\">Игр за сезон</th>
    <th width=\"80\">Побед за неделю</th>
    <th width=\"80\">Побед за сезон</th>
    </tr></table>";
    $sql_arena3 = mysql_query("SET NAMES cp1251");
    $sql_arena3 = mysql_query("SELECT * FROM `arena_team` WHERE `type` = 3 ORDER BY `rating` DESC LIMIT 100", $connect) or die(mysql_error());
    $id3 = 1;
    while ($result_arena3 = mysql_fetch_array($sql_arena3)){
        $id_team3 = $result_arena3['arenaTeamId'];
        $name_team3 = $result_arena3['name'];
        $guid3 = $result_arena3['captainGuid'];
        $rating3 = $result_arena3['rating'];
        $seasonGames3 = $result_arena3['seasonGames'];
        $weekGames3 = $result_arena3['weekGames'];
        $seasonWins3 = $result_arena3['seasonWins'];
        $weekWins3 = $result_arena3['weekWins'];
        $char_name3 = mysql_query("SELECT `name` FROM `characters` WHERE `guid` = $guid3", $connect) or die(mysql_error());
        $result_name3 = mysql_fetch_array($char_name3);
        $name3 = $result_name3['name'];

        print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\" id=\"border\"><tr>
        <td align=\"center\" width=\"30\">$id3</td>
        <td align=\"center\"><a href=\"?teamId=$id_team3\" title=\"Подробнее\">$name_team3</a></td>
        <td align=\"center\" width=\"120\">$name3</td>
        <td align=\"center\" width=\"100\">$rating3</td>
        <td align=\"center\" width=\"80\">$weekGames3</td>
        <td align=\"center\" width=\"80\">$weekWins3</td>
        <td align=\"center\" width=\"80\">$seasonGames3</td>
        <td align=\"center\" width=\"80\">$seasonWins3</td>
        </tr></table>";
    $id3++;
    }
}
if ($_GET['id'] == 3){
    print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\"><tr>
    <th width=\"30\">№</th>
    <th>Название</th>
    <th width=\"120\">Капитан</th>
    <th width=\"100\">Рейтинг</th>
    <th width=\"80\">Игр за неделю</th>
    <th width=\"80\">Игр за сезон</th>
    <th width=\"80\">Побед за неделю</th>
    <th width=\"80\">Побед за сезон</th>
    </tr></table>";
    $sql_arena5 = mysql_query("SET NAMES cp1251");
    $sql_arena5 = mysql_query("SELECT * FROM `arena_team` WHERE `type` = 5 ORDER BY `rating` DESC LIMIT 100", $connect) or die(mysql_error());
    $id5 = 1;
    while ($result_arena5 = mysql_fetch_array($sql_arena5)){
        $id_team5 = $result_arena5['arenaTeamId'];
        $name_team5 = $result_arena5['name'];
        $guid5 = $result_arena5['captainGuid'];
        $rating5 = $result_arena5['rating'];
        $seasonGames5 = $result_arena5['seasonGames'];
        $weekGames5 = $result_arena5['weekGames'];
        $seasonWins5 = $result_arena5['seasonWins'];
        $weekWins5 = $result_arena5['weekWins'];
        $char_name5 = mysql_query("SELECT `name` FROM `characters` WHERE `guid` = $guid5", $connect) or die(mysql_error());
        $result_name5 = mysql_fetch_array($char_name5);
        $name5 = $result_name5['name'];

        print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"800\" id=\"border\"><tr>
        <td align=\"center\" width=\"30\">$id5</td>
        <td align=\"center\"><a href=\"?teamId=$id_team5\" title=\"Подробнее\">$name_team5</a></td>
        <td align=\"center\" width=\"120\">$name5</td>
        <td align=\"center\" width=\"100\">$rating5</td>
        <td align=\"center\" width=\"80\">$weekGames5</td>
        <td align=\"center\" width=\"80\">$weekWins5</td>
        <td align=\"center\" width=\"80\">$seasonGames5</td>
        <td align=\"center\" width=\"80\">$seasonWins5</td>
        </tr></table>";
    $id5++;
    }
}
if ($_GET['teamId']){
    $sql_arena_name = mysql_query("SET NAMES cp1251");
    $sql_arena_name = mysql_query("SELECT `name` FROM `arena_team` WHERE `arenaTeamId` = ".$_GET['teamId']."", $connect) or die(mysql_error());
    $result_arena_name = mysql_fetch_array($sql_arena_name);
    $sql_member = mysql_query("SET NAMES cp1251");
    $sql_member = mysql_query("SELECT * FROM `arena_team_member` WHERE `arenaTeamId` = ".$_GET['teamId']." ORDER BY `personalRating` DESC", $connect) or die(mysql_error());
    print "<h3 align=\"center\">Состав команды <font color=\"red\">".$result_arena_name['name']."</font></h3>
    <table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"900\"><tr>
    <th width=\"30\">№</th>
    <th>Имя</th>
    <th width=\"100\">Выиграно за неделю</th>
    <th width=\"100\">Проиграно за неделю</th>
    <th width=\"100\">Всего игр за неделю</th>
    <th width=\"100\">Выиграно за сезон</th>
    <th width=\"100\">Проиграно за сезон</th>
    <th width=\"100\">Всего игр за сезон</th>
    <th width=\"100\">Личный рейтинг</th>
    </tr></table>";
    $id_m = 1;
    while ($result_member = mysql_fetch_array($sql_member)){
        $guid_member = $result_member['guid'];
        $mWeekGames = $result_member['weekGames'];
        $mSeasonGames = $result_member['seasonGames'];
        $mWeekWins = $result_member['weekWins'];
        $mSeasonWins = $result_member['seasonWins'];
        $mWeekLoss = $mWeekGames - $mWeekWins;
        $mSeasonLoss = $mSeasonGames - $mSeasonWins;
        $personal = $result_member['personalRating'];
        $sql_charname = mysql_query("SELECT `name` FROM `characters` WHERE `guid` = $guid_member", $connect) or die(mysql_error());
        $result_charname = mysql_fetch_array($sql_charname);
        $charname = $result_charname['name'];

        print "<table cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"900\" id=\"border\"><tr>
        <td align=\"center\" width=\"30\">$id_m</td>
        <td align=\"center\">$charname</td>
        <td align=\"center\" width=\"100\">$mWeekWins</td>
        <td align=\"center\" width=\"100\">$mWeekLoss</td>
        <td align=\"center\" width=\"100\">$mWeekGames</td>
        <td align=\"center\" width=\"100\">$mSeasonWins</td>
        <td align=\"center\" width=\"100\">$mSeasonLoss</td>
        <td align=\"center\" width=\"100\">$mSeasonGames</td>
        <td align=\"center\" width=\"100\">$personal</td>
        </tr></table>";
        $id_m++;
    }
}
mysql_close($connect);
?>