Changeset 627 for trunk/pages/gh.php

Timestamp:

Aug 19, 2009, 9:06:06 AM (15 years ago)

Author:

george

Message:

• Upraveno: Strkutura a názvy tabulek gm_tym, finance, finance_rewards.
• Upraveno: Stránka informací o serveru doplněna pro podporu zobrazení více fyzických serverů.
• Přidáno: Zobrazení dřívějších GM v dolní částí stránky GM týmu.

File:

• trunk/pages/gh.php (modified) (1 diff)

trunk/pages/gh.php

@@ -6 +6 @@
 <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.Id, 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.Id LEFT JOIN '.$Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters'].'.characters ON characters.guid = guild.leaderguid');
+$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())
 {