Changeset 577 for trunk/pages/guildy.php

Timestamp:

Apr 29, 2009, 9:04:21 PM (15 years ago)

Author:

george

Message:

• Opraveno: Vyčítání položek ze sloupce Data u postav je nyní nastavování přes konfigurační soubor. Nutno synchronizovat např. dle minimanageru souboru scripts/defines.php při každé změně verze herního klienta.

File:

• trunk/pages/guildy.php (modified) (3 diffs)

trunk/pages/guildy.php

@@ -27 +27 @@
   if ($row != "")
   {
-    return "<a href=\"http://".$row."/\" target=\"_blank\">".$name."</a>";
+    return "<a href=\"http://".$row."/\" target=\"_blank\">www</a>";
   }
   else
@@ -50 +50 @@
 <table border=\"1\" width=\"540\">
   <tr>
-    <th align=\"center\">".MakeLink("Frakce","fraction")."</th>
+    <th align=\"center\">".MakeLink("","fraction")."</th>
     <th align=\"center\">".MakeLink("Jméno guildy","name")."</th>
     <th align=\"center\">".MakeLink("Celkem členů","member_count")."</th>
@@ -57 +57 @@
     <th align=\"center\">".MakeLink("Stránky guildy","homepage")."</th>
     <th align=\"center\">".MakeLink("Založena","createdate")."</th>
-  </tr>
-";
+  </tr>";
 
-
-
-
-$db -> select_db($db_characters);
+$db->select_db($Config['Mangos']['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.';');