Changeset 393 for beta/pages/guildy.php


Ignore:
Timestamp:
Oct 25, 2008, 10:50:07 AM (16 years ago)
Author:
george
Message:
  • Upraveno: Vzhled beta webu. \n* Odstraněno: Staré nepoužívané složky.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • beta/pages/guildy.php

    r383 r393  
    4747
    4848echo "
    49 <table border=\"1\" width=\"500\">
     49<center>
     50<table border=\"1\" width=\"540\">
    5051  <tr>
    5152    <th align=\"center\">".MakeLink("Frakce","fraction")."</th>
     
    6465$db -> select_db("characters");
    6566
    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.';');
    6768while($row = $sql -> fetch_array())
    6869{
     
    8788}
    8889
    89 echo "</table>";
     90echo "</table></center>";
    9091
    9192?>
Note: See TracChangeset for help on using the changeset viewer.