Changeset 609 for trunk/pages/guildy.php

Timestamp:

Aug 7, 2009, 10:03:50 PM (15 years ago)

Author:

george

Message:

• Upraveno: Stránky přizpůsobeny pro podporu více světů. Doplněna stránka seznamu světů.

File:

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

trunk/pages/guildy.php

@@ -42 +42 @@
   </tr>');
 
-$db->select_db($Config['Mangos']['DatabaseCharacters']);
+$db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
 
 $sql = $db->query('SELECT `guild`.homepage, `guild`.name, `guild`.guildid, `guild`.createdate, COUNT(`guild_member`.`guildid`) AS member_count ,`leader`.`race` IN (1, 3, 4, 7, 11) AS fraction , `leader`.`guid` AS leader FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `characters` AS `memebers` ON `memebers`.`guid`= `guild_member`.`guid` JOIN `characters` AS `leader` ON `leader`.`guid`= `guild`.`leaderguid` GROUP BY guild.name ORDER BY '.$order_by.' '.$order_dir.';');