Changeset 691 for trunk/pages/spolky.php

Timestamp:

Mar 19, 2010, 9:46:30 PM (14 years ago)

Author:

george

Message:

• Opraveno: Generování pěkného pro další stránky.

File:

• trunk/pages/spolky.php (modified) (2 diffs)

trunk/pages/spolky.php

@@ -49 +49 @@
 $db2 = $Realm->CharactersDatabase;
 
-$sql = $db2->query('SELECT `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.';');
+$sql = $db2->query('SELECT `guild`.name, `guild`.guildid, FROM_UNIXTIME(`guild`.`createdate`) AS `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.';');
 while($row = $sql->fetch_assoc())
 {
@@ -64 +64 @@
   echo('<tr>
     <td align="center">'.FrakceImg($row['fraction']).'</td>
-    <td align="center"><a href="'.$html->Link('/spolek/'.$row['guildid'].'/').'">'.$row['name'].'</a></td>
+    <td align="center"><a href="'.$html->Link('/spolek/?id='.$row['guildid']).'">'.$row['name'].'</a></td>
     <td align="center">'.$row['member_count'].'</td>
     <td align="center">'.$online_mem['online_mem'].'</td>