Changeset 304 for minimanager/index.php

Timestamp:

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

Author:

george

Message:

Aktualizace na minimanager 0.1.6d.

File:

• minimanager/index.php (modified) (3 diffs)

minimanager/index.php

@@ -22 +22 @@
 if (test_port($server[$realm_id]['addr'],$server[$realm_id]['game_port'])) {
 
-        $query = $sql->query("SELECT uptime/60 FROM uptime ORDER BY starttime DESC LIMIT 1");
+        $query = $sql->query("SELECT uptime FROM uptime ORDER BY starttime DESC LIMIT 1");
         $uptime = $sql->result($query, 0);
-        $output .= "<h1><font color=\"#55aa55\">{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['online']} : (".(int)($uptime/60).":".(($uptime >= 60 )?(int)($uptime-60*(int)($uptime/60)):(int)$uptime)."h)</font></h1>";
+        $output .= "<h1><font color=\"#55aa55\">{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['online']} : (".(int)($uptime/60/60/24)."D : ".(($uptime/60/60 >= 24 )?(int)($uptime/60/60-24*(int)($uptime/60/60/24)):(int)($uptime/60/60))."H : ".(($uptime/60 >= 60 )?(int)($uptime/60-60*(int)($uptime/60/60)):(int)($uptime/60))."M : ".(($uptime >= 60 )?(int)($uptime-60*(int)($uptime/60)):(int)$uptime)."S)</font></h1>";
         $online = true;
         } else {
@@ -91 +91 @@
                         CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS highest_rank,
                         CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1) AS UNSIGNED) AS level,account,
-                  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(229+1)."), ' ', -1) AS UNSIGNED) as GNAME
+                        CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) as GNAME,
+                        mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender
                         FROM `character` WHERE `online`= 1 $order_side ORDER BY $order_by $order_dir");
 
@@ -167 +168 @@
                 $output .= "<tr>
                  <td><a href=\"char.php?id=$char[0]\"><span onmousemove='toolTip(\"".get_player_user_level($gm)."\",\"item_tooltip\")' onmouseout='toolTip()'>$char[1]</span></a></td>
-             <td><img src='img/c_icons/{$char[2]}-0.gif' onmousemove='toolTip(\"".get_player_race($char[2])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
+             <td><img src='img/c_icons/{$char[2]}-{$char[10]}.gif' onmousemove='toolTip(\"".get_player_race($char[2])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
                  <td><img src='img/c_icons/{$char[3]}.gif' onmousemove='toolTip(\"".get_player_class($char[3])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
                  <td>$lev</td>
                  <td><span onmouseover='toolTip(\"".$CHAR_RANK[$CHAR_RACE[$char[2]][1]][pvp_ranks($char[6])]."\",\"item_tooltip\")' onmouseout='toolTip()' style='color: white;'><img src='img/ranks/rank".pvp_ranks($char[6],$CHAR_RACE[$char[2]][1]).".gif'></span></td>
-                 <td><a href=\"guild.php?id=$char[9]\">$guild_name[0]</a></td>
+                 <td><a href=\"guild.php?action=view_guild&amp;error=3&amp;id=$char[9]\">$guild_name[0]</a></td>
                  <td>".get_map_name($char[5])."</td>
                  <td>".get_zone_name($char[4])."</td>