<?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>';  
?>