<div class="post">
<div class="post_header"><a href="#">Арена ТоП</a></div>
<div class="post_body" align="center"><p>
<?php
require_once('conf.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 '
<center>
<table class="border" border="0" width="500px">
<tr>
<td bgcolor=#684b2c>Название команды</td>
<td align=center bgcolor=#684b2c>Тип команды</td>
<td align=center bgcolor=#684b2c><center>Лидер команды</center></td>
<td bgcolor=#684b2c>Фракция</td>
<td align=center bgcolor=#684b2c>Рейтинг</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 bgcolor=#7b5a37><p style="padding-left:5px">'.$row['name'].'</p></td>
<td align=center bgcolor=#7b5a37><center>'.$teamType[$row['type']].'</center></td>
<td bgcolor=#7b5a37>'.$row['chname'].'</td>
<td align=center bgcolor=#7b5a37><center><img src="'.$img.'" title="'.$faction.'"></center></td>
<td align=right bgcolor=#7b5a37><p style="padding-right:8px">'.$row['rating'].'</p></td>
</tr>';
}
echo '
</table>
</center><br><br>';
?>
<br />
</p>
<div class='news-post-down'>
<p>
</p>
</div>
</div>
</div>
)
