}
       
}

function gildia(){
include "inc/cnf-in.php";
f_connect_db();
mysql_select_db(DBC_A);
$real = $_GET['realm'];
$realm_query = mysql_query("SELECT * FROM realmlist ORDER BY id desc")or print("Ошибка");

while($realm = mysql_fetch_array($realm_query)){
echo "<div id='admin_info'><a class='brochure' href='?cont=guilds&realm=".$realm['id']."'><span>".$realm['name']."</span></div></a><br />";
}  

if($real == ''){echo"";}else{
echo'<div class="table full-width">
   <table>
    <thead>
     <tr>
      <th><a href="javascript:;" class="sort-link"><span class="arrow">Гильдия</span></a></th>
      <th><a href="javascript:;" class="sort-link"><span class="arrow">Гильд Мастер</span></a></th>
      <th><a href="javascript:;" class="sort-link"><span class="arrow">Денег в ГБ</span></a></th>
     </tr>
    </thead>
    <tbody>';

mysql_select_db ($chardb[($real)]) ;

$query = "SELECT DISTINCT guild.name AS guild_name, characters.name AS leader_name, guild.BankMoney AS guild_bank_money FROM guild, characters WHERE  guild.leaderguid= characters.guid ORDER BY guild_bank_money Desc limit 100 ";

$result = mysql_query ($query) or die ("Нет такой таблицы");

while($data=mysql_fetch_row($result))
{
$gold = floor($data['BankMoney']/10000);
$silver = floor(($data['BankMoney']-$gold*10000)/100);
$bronze = floor($data['BankMoney']-$gold*10000-$silver*100);
$data['BankMoney'] = "$gold <img src='style/images/img/money/gold.gif'> $silver <img src='style/images/img/money/silver.gif'> $bronze <img src='style/images/img/money/cooper.gif'>";

echo "<tr class='row1'>
<td class='name'>",
implode ("<font size='2'><h3 class='Chars'>", $data), "</h3></font>
</td>";

}

echo '</tr></tbody></table></div><br>';