Changeset 577 for trunk/pages/guildy.php


Ignore:
Timestamp:
Apr 29, 2009, 9:04:21 PM (16 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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/pages/guildy.php

    r407 r577  
    2727  if ($row != "")
    2828  {
    29     return "<a href=\"http://".$row."/\" target=\"_blank\">".$name."</a>";
     29    return "<a href=\"http://".$row."/\" target=\"_blank\">www</a>";
    3030  }
    3131  else
     
    5050<table border=\"1\" width=\"540\">
    5151  <tr>
    52     <th align=\"center\">".MakeLink("Frakce","fraction")."</th>
     52    <th align=\"center\">".MakeLink("","fraction")."</th>
    5353    <th align=\"center\">".MakeLink("Jméno guildy","name")."</th>
    5454    <th align=\"center\">".MakeLink("Celkem členů","member_count")."</th>
     
    5757    <th align=\"center\">".MakeLink("Stránky guildy","homepage")."</th>
    5858    <th align=\"center\">".MakeLink("Založena","createdate")."</th>
    59   </tr>
    60 ";
     59  </tr>";
    6160
    62 
    63 
    64 
    65 $db -> select_db($db_characters);
     61$db->select_db($Config['Mangos']['DatabaseCharacters']);
    6662
    6763$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.';');
Note: See TracChangeset for help on using the changeset viewer.