<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 c.name as chname,   
            c.race,   
            at.type,   
            at.name,   
            at.rating   
        from characters as c,   
          arena_team as at   
        where c.guid = at.captainGuid   
        order by at.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['race'] == "1" or $row['race'] == "3" or $row['race'] == "4" or $row['race'] == "7" or $row['race'] == "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>