Changeset 577 for trunk/pages/guildy.php
- Timestamp:
- Apr 29, 2009, 9:04:21 PM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/pages/guildy.php
r407 r577 27 27 if ($row != "") 28 28 { 29 return "<a href=\"http://".$row."/\" target=\"_blank\"> ".$name."</a>";29 return "<a href=\"http://".$row."/\" target=\"_blank\">www</a>"; 30 30 } 31 31 else … … 50 50 <table border=\"1\" width=\"540\"> 51 51 <tr> 52 <th align=\"center\">".MakeLink(" Frakce","fraction")."</th>52 <th align=\"center\">".MakeLink("","fraction")."</th> 53 53 <th align=\"center\">".MakeLink("Jméno guildy","name")."</th> 54 54 <th align=\"center\">".MakeLink("Celkem členů","member_count")."</th> … … 57 57 <th align=\"center\">".MakeLink("Stránky guildy","homepage")."</th> 58 58 <th align=\"center\">".MakeLink("Založena","createdate")."</th> 59 </tr> 60 "; 59 </tr>"; 61 60 62 63 64 65 $db -> select_db($db_characters); 61 $db->select_db($Config['Mangos']['DatabaseCharacters']); 66 62 67 63 $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.