Changeset 393 for beta/pages/guildy.php
- Timestamp:
- Oct 25, 2008, 10:50:07 AM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
beta/pages/guildy.php
r383 r393 47 47 48 48 echo " 49 <table border=\"1\" width=\"500\"> 49 <center> 50 <table border=\"1\" width=\"540\"> 50 51 <tr> 51 52 <th align=\"center\">".MakeLink("Frakce","fraction")."</th> … … 64 65 $db -> select_db("characters"); 65 66 66 $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.' LIMIT 0,30;');67 $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.';'); 67 68 while($row = $sql -> fetch_array()) 68 69 { … … 87 88 } 88 89 89 echo "</table> ";90 echo "</table></center>"; 90 91 91 92 ?>
Note:
See TracChangeset
for help on using the changeset viewer.