source: trunk/pages/gh.php

<?php

$Output = $server->RealmSelection().

'<h3 class="PageTitle">Seznam spolků, které mají a platí GH:</h3>
<table class="BaseTable"><tr><th>Vedoucí spolku</th><th>Jméno spolku</th><th>Typ domu</th><th>Týdenní poplatek</th><th>Další platba</th></tr>';

$DbResult = $db->query('SELECT GuildHouse.Guild, GuildHouse.NextPayment, guild.name AS Name, GuildHouseType.Name AS TypeName, GuildHouseType.Tax AS Tax, guild.BankMoney, characters.name AS LeaderName FROM GuildHouse LEFT JOIN GuildHouseType ON GuildHouseType.Id = GuildHouse.Type LEFT JOIN '.$Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters'].'.guild ON guildid = GuildHouse.Guild LEFT JOIN '.$Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters'].'.characters ON characters.guid = guild.leaderguid WHERE GuildHouse.Realm = '.$_COOKIE['RealmIndex']);
while($Guild = $DbResult->fetch_assoc())
{      
  if(($Guild['BankMoney'] - ($Guild['Tax'] * 10000)) <= 0) $BackgroundColor = 'style="backgroundcolor: #FF0000"';
    else $BackgroundColor = 'style="backgroundcolor: #00FF00"';
     
  $Output .= '<tr><td>'.$Guild['LeaderName'].'</td><td>'.$Guild['Name'].'</td><td>'.$Guild['TypeName'].'</td><td>'.$Guild['Tax'].' <img src="gh_system/img/gold.gif"></td><td '.$BackgroundColor.'>'.$Guild['NextPayment'].'</td></tr>'; 
      
}
$Output .= '</table><br />'.
'<p>Jak si postavit domek pro guildu a ostatní odpovědi na otázky získáte zde: 
<a href="http://wow.zdechov.net/forum/viewtopic.php?f=9&t=2143">/forum/viewtopic.php?f=9&t=2143</a></p>';

echo($Output);

?>