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

$teamType = array(
'2' => '2x2',
'3' => '3x3',
'5' => '5x5'
);

$connect = @mysql_connect($dbip, $dblogin, $dbpass) or die('Не возможно подключится к базе! Ошибка: '.mysql_error());
@mysql_select_db($cdb, $connect) or die('Ошибка запроса MySQL: '.mysql_error());
@mysql_query("SET NAMES 'cp1251'") 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 10;") or die('Ошибка запроса MySQL: '.mysql_error());
echo '
<br><br>Топ арена тима<br><br><br>
<center>
<table class="border" border="1" width="500px">
<tr>
<td>Название команды</td>
<td align=center>Тип команды</td>
<td align=center><center>Лидер команды</center></td>
<td>Фракция</td>
<td align=center>Рейтинг</td>
</tr>';

while($row = @mysql_fetch_assoc($sql))
{
$faction = "horde";
if($row['chrace'] == "1" or $row['chrace'] == "3" or $row['chrace'] == "4" or $row['chrace'] == "7" or $row['chrace'] == "11")
$faction = "alliance";
$img = 'http://livegames.net.ua/wow/images/img/fraction/icon-'.$faction.'.png';

echo '
<tr>
<td><p style="padding-left:5px">'.$row['name'].'</p></td>
<td align=center><center>'.$teamType[$row['type']].'</center></td>
<td>'.$row['chname'].'</td>
<td align=center><center><img src="'.$img.'" title="'.$faction.'"></center></td>
<td align=right><p style="padding-right:8px">'.$row['rating'].'</p></td>
</tr>';
}

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