Changeset 304 for minimanager/char_list.php

Timestamp:

Mar 13, 2008, 7:39:11 PM (17 years ago)

Author:

george

Message:

Aktualizace na minimanager 0.1.6d.

File:

• minimanager/char_list.php (modified) (2 diffs)

minimanager/char_list.php

@@ -36 +36 @@
  $query = $sql->query("SELECT guid,name,account,race,class,zone,map,
                 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_KILL+1)."), ' ', -1) AS UNSIGNED) AS highest_rank,
-                online,CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1) AS UNSIGNED) AS level
+                online,CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1) AS UNSIGNED) AS level,
+                mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender
                 FROM `character` ORDER BY $order_by $order_dir LIMIT $start, $itemperpage");
  $this_page = $sql->num_rows($query) or die(error($lang_global['err_no_result']));
@@ -115 +116 @@
                         <td><a href=\"char.php?id=$char[0]\">$char[1]</a></td>
                         <td><a href=\"user.php?action=edit_user&amp;error=11&amp;id=$char[2]\">$owner_acc_name</a></td>
-                        <td><img src='img/c_icons/{$char[3]}-0.gif' onmousemove='toolTip(\"".get_player_race($char[3])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
+                        <td><img src='img/c_icons/{$char[3]}-{$char[10]}.gif' onmousemove='toolTip(\"".get_player_race($char[3])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
                         <td><img src='img/c_icons/{$char[4]}.gif' onmousemove='toolTip(\"".get_player_class($char[4])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
                         <td>$char[9]</td>