Changeset 190 for guildy.php

Timestamp:

Jan 1, 2008, 6:32:42 PM (17 years ago)

Author:

george

Message:

Opraveno: Zobrazování bodů cti v seznamu členů guildy.

File:

• guildy.php (modified) (5 diffs)

guildy.php

@@ -30 +30 @@
 if(!array_key_exists('guild', $_GET))
 {
-  echo('<h3>Seznam guild:</h3><div align="center">');
+  echo('<h3>Seznam spolkù:</h3><div align="center">');
   echo('<table class="TableGuilda" border="1" cellpadding="3" cellspacing="0"><tr>');
   HeaderText('Název', 'name');
@@ -49 +49 @@
 } else {
   $GuildId = addslashes($_GET['guild']);
-  $Result = $Database->query('SELECT `guild`.name, guild.guildid, guild.leaderguid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 1421), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` WHERE guild.guildid='.$GuildId.' GROUP BY guild.name');
+  $Result = $Database->query('SELECT `guild`.name, guild.guildid, guild.leaderguid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", '.(CHAR_DATA_OFFSET_LEVEL+1).'), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` WHERE guild.guildid='.$GuildId.' GROUP BY guild.name');
   if($Result->num_rows > 0)
   {
@@ -55 +55 @@
     //  if($Guild['homepage'] != '') $Guild['name'] = $Guild['name'].' <a href="'.$Guild['homepage'].'">WWW</a>';
     //if($Guild['info'] != '') $Guild['info'] = ''.$Guild['info'].'</i>';
-    echo('<h3>Seznam èlenù guildy '.$Guild['name'].'</h3><div align="center">');
+    echo('<h3>Seznam èlenù spolku '.$Guild['name'].'</h3><div align="center">');
     $Result = $Database->select('character', 'name', $Guild['leaderguid'].'=guid');
     $GuildMaster = $Result->fetch_array();
-    echo('Vedoucí guildy: '.$GuildMaster['name'].'<br>');
+    echo('Vedoucí spolku: '.$GuildMaster['name'].'<br>');
     echo('<table class="TableGuilda" border="1" cellpadding="1" cellspacing="0">');
     echo('<tr>');
@@ -72 +72 @@
     while($GuildRank = $Result->fetch_array()) $GuildRanks[$GuildRank['rid']] = $GuildRank;
   
-    $Result = $Database->query('SELECT guild_member.rank, guild_member.guid, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", 35), " ", -1)*1 as level, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", 1421), " ", -1)*1 as honor, character.name FROM guild_member JOIN `character` ON guild_member.guid = character.guid AND guild_member.guildid='.$Guild['guildid'].' ORDER BY '.$order_by.' '.$order_dir);
+    $Result = $Database->query('SELECT guild_member.rank, guild_member.guid, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", '.(CHAR_DATA_OFFSET_LEVEL+1).'), " ", -1)*1 as level, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)*1 as honor, character.name FROM guild_member JOIN `character` ON guild_member.guid = character.guid AND guild_member.guildid='.$Guild['guildid'].' ORDER BY '.$order_by.' '.$order_dir);
     while($Member = $Result->fetch_array())
     {
@@ -81 +81 @@
     }
     echo('</table>');
-    echo('<a href="guildy.php">Zpìt na seznam guild</a></div>');
-  } else echo('Guilda nenalezena!');
+    echo('<a href="guildy.php">Zpìt na seznam spolkù</a></div>');
+  } else echo('Spolek nenalezen!');
 }