Changeset 334 for guildy.php

Timestamp:

Apr 13, 2008, 9:11:05 AM (16 years ago)

Author:

george

Message:

Přidáno: Zobrazení frakce ve výpisu spolků.

File:

• guildy.php (modified) (2 diffs)

guildy.php

@@ -1 @@
-<?
+<?php
   include('global.php');
   ShowHeader();
@@ -32 +32 @@
   echo('<h3>Seznam spolkù:</h3><div align="center">');
   echo('<table class="TableGuilda" border="1" cellpadding="3" cellspacing="0"><tr>');
+  HeaderText('F', 'fraction');
   HeaderText('Název', 'name');
   HeaderText('Poèet èlenù', 'member_count');
   HeaderText('Souèet levelù', 'guild_level');
   HeaderText('Souèet bodù cti', 'guild_honor');
-  HeaderText('Webové stránky', 'name');    
+  HeaderText('Webové stránky', '');    
   echo('</tr>');
 //  DB_Query(' COUNT(guild_member.guildid) as member_count FROM guild JOIN guild_member ON guild_member.guildid = guild.guildid GROUP BY guild.name ORDER BY member_count DESC');
-  $Result = $Database->query('SELECT `guild`.homepage, `guild`.name, guild.guildid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, " ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `characters` ON `characters`.`guid`= `guild_member`.`guid` GROUP BY guild.name ORDER BY '.$order_by.' '.$order_dir);
+  $Result = $Database->query('SELECT `guild`.homepage, `guild`.name, guild.guildid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`memebers`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`memebers`.`data`, " ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)) as guild_honor, `leader`.`race` IN (1, 3, 4, 7, 11) as fraction 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($Guild = $Result->fetch_array())
   {
+    if($Guild['fraction'] == 1) $Fraction = 'aliance'; else $Fraction = 'horda';
     if($Guild['homepage'] == '') $Guild['homepage'] = '&nbsp;'; 
       else $Guild['homepage'] = '<a href="http://'.$Guild['homepage'].'/">'.$Guild['homepage'].'</a>';
-    echo('<tr><td><a href="?guild='.$Guild['guildid'].'">'.$Guild['name'].'</a></td><td>'.$Guild['member_count'].'</td><td>'.$Guild['guild_level'].'</td><td>'.$Guild['guild_honor'].'</td><td>'.$Guild['homepage'].'</td></tr>');
+    echo('<tr><td><img src="images/online_player/'.$Fraction.'.gif" alt="'.$Fraction.'"></td><td><a href="?guild='.$Guild['guildid'].'">'.$Guild['name'].'</a></td><td>'.$Guild['member_count'].'</td><td>'.$Guild['guild_level'].'</td><td>'.$Guild['guild_honor'].'</td><td>'.$Guild['homepage'].'</td></tr>');
   }
   echo('</table></div>');