<?php
require_once('include/config.php');

$connect = @mysql_connect($dbip, $dblogin, $dbpass) or die('Не возможно подключится к базе! Ошибка: '.mysql_error());
@mysql_select_db($cdb, $connect) or die('Ошибка запроса MySQL: '.mysql_error());
@mysql_query("SET NAMES 'UTF8'") or die('Ошибка запроса MySQL: '.mysql_error());
$sql = mysql_query("select _a.*,_c.name as chname,_c.race as chrace,_ats.* from arena_team as _a, characters as _c, arena_team_stats as _ats where _c.guid = _a.captainguid and _ats.arenateamid = _a.arenateamid order by _ats.rating desc limit 50;") or die('Ошибка запроса MySQL: '.mysql_error());
echo '

<span style="color:#37789e;"><p align = "center">Top Arena Teams<h2><a href="./arenatr.php"><p align = "right">3v3</p></a></h2></p>
<center>
<table class="border" border="1" width="500px">

<tr>
<td><span style="color:#37789e;">Ранк</td>
<td><span style="color:#37789e;">Название команды</td>
<td><span style="color:#37789e;">Тип</td>
<td align=center><center><span style="color:#37789e;">Выйгрыши</center></td>
<td><span style="color:#37789e;">Пройгрыши</td>
<td align=center><span style="color:#37789e;">Рейтинг</td>
</tr>';

while($row = @mysql_fetch_assoc($sql))
{

echo '

<td>'.$row['rank'].'</td>
<td>'.$row['name'].'</td>
<td>'.$row['class'].'</td>
<td>'.$row['wins2'].'</td>
<td>'.($row[played] - $row[wins2]).'</td>
<td>'.$row['rating'].'</td>
</tr>';
$count++;
}

echo '
</table>
</center><br><br>';
?>