Changeset 579 for trunk/pages/guilda.php

Timestamp:

Apr 30, 2009, 8:10:25 AM (16 years ago)

Author:

george

Message:

• Opraveno: Doplněny ikony pro povolání death knight a soubory přejmenovány dle minimanageru.
• Upraveno: Přeformátování a pročištění různých stránek.

File:

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

trunk/pages/guilda.php

@@ -54 +54 @@
   while($member = $members->fetch_row())
   {    
-    $query = $db->query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".$Config['Mangos']['CharacterDataOffset']['Level']."+1), ' ', -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".($Config['Mangos']['CharacterDataOffset']['Gender'] + 1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender FROM `characters` WHERE `guid` = '".$member[0]."' LIMIT 1;");
-    $online = $query -> fetch_array();
-          $accid = $online["account"];
-          $llogin = count_days($online["logout_time"], time());
+    $query = $db->query('SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['Level'].' + 1), " ", -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data, " ", '.($Config['Mangos']['CharacterDataOffset']['Gender'] + 1).'), " ", -1) as unsigned) ), 8, 0), 4, 1) as gender FROM `characters` WHERE `guid` = '.$member[0].' LIMIT 1;');
+    $online = $query->fetch_assoc();
+          $accid = $online['account'];
+          $llogin = count_days($online['logout_time'], time());
         if($llogin < 1)
         {
@@ -86 +86 @@
                 $lastlogin = '<font color="#8000FF">'.$llogin.'</font>';
         }
-        $level = $online["level"];
+        $level = $online['level'];
         if($level > 0)
                 {
@@ -123 +123 @@
                         $lev = '<font color="#FFF000">'.$level.'</font>';
                 }
-                if ($online[6] == 0)
-                {
-                 $gender = "m";
-    }
-    else
-    {
-      $gender = "f";
-    }
-    echo "
-    <tr>
-      <td align=\"center\">".$member[2]."</td>
-      <td align=\"center\"><img src=\"imgs/icons/".$player -> GetPlayerRace($online["race"])."-".$gender.".gif\"></td>
-      <td align=\"center\"><img src=\"imgs/icons/".$player -> GetPlayerClass($online["class"]).".gif\"></td>
-      <td align=\"center\">".$lev."</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=\"\" />" : "<img src=\"imgs/inc/off.gif\" alt=\"\" />")."</td>     
-    </td>
-    ";
+                if($online[6] == 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">'.$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>');
   }
   echo('</table>');