Changeset 595 for trunk/pages/guilda.php

Timestamp:

May 19, 2009, 7:58:09 AM (15 years ago)

Author:

george

Message:

• Upraveno: Navrácení zmenšeného textu na normální a nastavení přetekání obsahu obsahové části stránky.
• Upraveno: Počeštěny tlačítka menu. Přesunuty odkazy Jak začít, Registrace a Správa účtu nahoru.
• Opraveno: Validace XHTML kódu stránek guildy a guilda.

File:

• trunk/pages/guilda.php (modified) (4 diffs)

trunk/pages/guilda.php

@@ -15 +15 @@
 {
   $guild_id = $id;
-  $guild_data = $db -> query("SELECT `guildid`, `name`, `createdate` FROM `guild` WHERE `guildid` = ".$guild_id." LIMIT 1;") -> fetch_array();
-  $members = $db -> query("SELECT guild_member.guid, guild_member.rank AS mrank, `characters`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".$Config['Mangos']['CharacterDataOffset']['Level']." + 1), ' ', -1) AS level, (SELECT rname FROM guild_rank WHERE guildid =".$guild_id." AND rid = mrank+1) AS rname, guild_member.pnote, guild_member.offnote FROM guild_member,`characters` LEFT JOIN guild_member k1 ON k1.`guid`=`characters`.`guid` WHERE guild_member.guildid = ".$guild_id." AND guild_member.guid=`characters`.guid ORDER BY mrank");
-  $total_members = $members -> num_rows;
-  $members_data = $members -> fetch_array();
-  $online_mem = $db -> query("SELECT count(*) AS online_mem  FROM `guild_member`, `characters`, `guild` WHERE guild.guildid = ".$guild_id." AND guild_member.guildid = guild.guildid AND guild_member.guid = characters.guid AND characters.online = 1;") -> fetch_array();;
+  $DbResult = $db->query('SELECT `guildid`, `name`, `createdate` FROM `guild` WHERE `guildid` = '.$guild_id.' LIMIT 1');
+  $guild_data = $DbResult->fetch_assoc();
+  $members = $db->query('SELECT guild_member.guid, guild_member.rank AS mrank, `characters`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['Level'].' + 1), " ", -1) AS level, (SELECT rname FROM guild_rank WHERE guildid ='.$guild_id.' AND rid = mrank + 1) AS rname, guild_member.pnote, guild_member.offnote FROM guild_member,`characters` LEFT JOIN guild_member k1 ON k1.`guid`=`characters`.`guid` WHERE guild_member.guildid = '.$guild_id.' AND guild_member.guid=`characters`.guid ORDER BY mrank');
+  $total_members = $members->num_rows;
+  $members_data = $members->fetch_assoc();
+  $DbResult = $db->query('SELECT count(*) AS online_mem  FROM `guild_member`, `characters`, `guild` WHERE guild.guildid = '.$guild_id.' AND guild_member.guildid = guild.guildid AND guild_member.guid = characters.guid AND characters.online = 1');
+  $online_mem = $DbResult->fetch_assoc();
+
   // guild info
   $date_arr = explode(' ', $guild_data['createdate']);
@@ -27 +30 @@
   $human_date = date('d.m.Y H:i:s', $time);
   echo('<a href="?page=guildy">&lt;- Zpět na výpis</a><br />');
-  echo('<table border="1">
+  echo('<table class="BaseTable">
     <tr>
-      <td colspan="2"><font size="5">Guilda : '.$guild_data['name'].'</font></td>
+      <td colspan="2" style="font-size: x-large;">Spolek '.$guild_data['name'].'</td>
     </tr>
     <tr>
@@ -39 +42 @@
       <td>'.$total_members.' (Online : '.$online_mem['online_mem'].')</td>
     </tr>
-  </table>');
+  </table><br />');
   
   // members info
-  echo('<table border="1">
+  echo('<table class="BaseTable">
     <tr>
       <th align="center">Jméno</th>
       <th align="center">Rasa</th>
-      <th align="center">Class</th>
+      <th align="center">Třída</th>
       <th align="center">Úroveň</th>
-      <th align="center">Rank</th>
-      <th align="center">Poslední přihlášení (Dny)</th>
+      <th align="center">Hodnost</th>
+      <th align="center">Poslední přihlášení (dny)</th>
       <th align="center">Online</th>     
     </tr>');
@@ -57 +60 @@
     $online = $query->fetch_assoc();
           $accid = $online['account'];
-          $llogin = count_days($online['logout_time'], time());
-        if($llogin < 1)
-        {
-                $lastlogin = '<font color="#009900">'.$llogin.'</font>';
-        }
-        if($llogin >= 1)
-        {
-                $lastlogin = '<font color="#0000CC">'.$llogin.'</font>';
-        }
-        if($llogin > 5)
-        {
-                $lastlogin = '<font color="#FFFF00">'.$llogin.'</font>';
-        }
-        if($llogin > 15)
-        {
-                $lastlogin = '<font color="#FF8000">'.$llogin.'</font>';
-        }
-        if($llogin > 30)
-        {
-                $lastlogin = '<font color="#FF0000">'.$llogin.'</font>';
-        }
-        if($llogin > 60)
-        {
-                $lastlogin = '<font color="#FF00FF">'.$llogin.'</font>';
-        }
-        if($llogin > 90)
-        {
-                $lastlogin = '<font color="#8000FF">'.$llogin.'</font>';
-        }
-        $level = $online['level'];
-        if($level > 0)
-                {
-                        $lev = '<font color="#FFFFFF">'.$level.'</font>';
-                }
-                if($level > 9)
-                {
-                        $lev = '<font color="#858585">'.$level.'</font>';
-                }
-                if($level > 19)
-                {
-                        $lev = '<font color="#339900">'.$level.'</font>';
-                }
-                if($level > 29)
-                {
-                        $lev = '<font color="#3300CC">'.$level.'</font>';
-                }
-                if($level > 39)
-                {
-                        $lev = '<font color="#5552FF">'.$level.'</font>';
-                }
-                if($level > 49)
-                {
-                        $lev = '<font color="#FF8000">'.$level.'</font>';
-                }
-                if($level > 59)
-                {
-                        $lev = '<font color="#FF0000">'.$level.'</font>';
-                }
-                if($level > 69)
-                {
-                        $lev = '<font color="#FF00CC">'.$level.'</font>';
-                }
-                if($level > 70)
-                {
-                        $lev = '<font color="#FFF000">'.$level.'</font>';
-                }
-                if($online['gender'] == 0) $gender = '0';
-    else $gender = '1';
+          
+    $LogoutTime = count_days($online['logout_time'], time());
+    $LogoutTimeColorList = array(0 => '#0000CC', 5 => '#FFFF00', 15 => '#FF8000', 30 => '#FF0000', 60 => '#FF00FF', 90 => '#8000FF');
+    $LogoutTimeColor = '#009900';
+    foreach($LogoutTimeColorList as $Time => $Color)
+    {
+      if($LogoutTime > $Time) $LogoutTimeColor = $Color;
+    }
+    
+        $Level = $online['level'];
+    $LevelColorList = array(9 => '#858585', 19 => '#339900', 29 => '#3300CC', 39 => '#5552FF', 49 => '#FF8000', 59 => '#FF0000', 69 => '#FF00CC', 70 => '#FFF000');
+    $LevelColor = '#FFFFFF';
+    foreach($LevelColorList as $Index => $Color)
+    {
+      if($Level > $Index) $LevelColor = $Color;
+    }
+    
+                if($online['gender'] == 0) $gender = 0;
+    else $gender = 1;
     echo('<tr>'.
       '<td align="center">'.$member[2].'</td>'.
-      '<td align="center"><img src="imgs/icons/'.$online['race'].'-'.$gender.'.gif"></td>'.
-      '<td align="center"><img src="imgs/icons/'.$online['class'].'.gif"></td>'.
-      '<td align="center">'.$lev.'</td>'.
+      '<td align="center"><img src="imgs/icons/'.$online['race'].'-'.$gender.'.gif" alt="pohlaví" /></td>'.
+      '<td align="center"><img src="imgs/icons/'.$online['class'].'.gif" alt="třída" /></td>'.
+      '<td align="center" style="color: '.$LevelColor.'">'.$Level.'</td>'.
       '<td align="center">'.$member[4].' ('.$member[1].')</td>'.
-      '<td align="center">'.$lastlogin.'</td>'.
-      '<td align="center">'.(($online['online']) ? '<img src="imgs/inc/on.gif" alt="online" />' : '<img src="imgs/inc/off.gif" alt="offline" />').'</td></td>');
+      '<td align="center" style="color: '.$LogoutTimeColor.'">'.$LogoutTime.'</td>'.
+      '<td align="center">'.(($online['online']) ? '<img src="imgs/inc/on.gif" alt="online" />' : '<img src="imgs/inc/off.gif" alt="offline" />').'</td>'.
+      '</tr>');
   }
   echo('</table>');