Changeset 142 for minimanager/index.php

Timestamp:

Nov 23, 2007, 11:29:33 PM (17 years ago)

Author:

george

Message:

Minimanager 0.1.5b

File:

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

minimanager/index.php

@@ -8 +8 @@
  * License: GNU General Public License v2(GPL)
  */
- 
+
 require_once("header.php");
 valid_login(0);
-
+require_once("scripts/id_tab.php");
 require_once("scripts/get_lib.php");
 require_once("scripts/bbcode_lib.php");
@@ -20 +20 @@
 $output .= "<div class=\"top\">";
 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");
         $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>";
         $online = true;
-        } else { 
+        } else {
                 $output .= "<h1><font class=\"error\">{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['offline_or_let_height']}</font></h1>";
                 $online = false;
@@ -31 +31 @@
 $output .= "Mangos: {$server[$realm_id]['rev']} Using DB: {$mangos_db[$realm_id]['db_rev']}</div>";
 
-$sql->db($mangos_db[$realm_id]['name']);
+$sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
+$sql->db($characters_db[$realm_id]['name']);
+
 //MOTD part
 $start = (isset($_GET['start'])) ? $sql->quote_smart($_GET['start']) : 0;
@@ -45 +47 @@
 $output .= "<center>
                         <table class=\"lined\">
-                        <tr> 
+                        <tr>
                         <th align=\"right\">";
 if ($user_lvl) $output .= "<a href=\"motd.php?action=add_motd\">{$lang_index['add_motd']}</a>";
@@ -70 +72 @@
         $order_dir = ($dir) ? "ASC" : "DESC";
         $dir = ($dir) ? 0 : 1;
-        
+
         $result = $sql->query("SELECT count(*) FROM `character` WHERE `online`= 1");
         $total_online = $sql->result($result, 0);
@@ -83 +85 @@
 
         require_once("scripts/defines.php");
-        
+
         $result = $sql->query("SELECT guid,name,race,class,zone,map,
-                        CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_KILL+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`, ' ', ".(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
                         FROM `character` WHERE `online`= 1 $order_side ORDER BY $order_by $order_dir");
 
@@ -92 +95 @@
         <font class=\"bold\">{$lang_index['tot_users_online']} : $total_online</font><br /><br />
         <table class=\"lined\">
-        <tr> 
-        <th width=\"26%\"><a href=\"index.php?order_by=name&amp;dir=$dir\">".($order_by=='name' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['name']}</a></th>
-        <th width=\"7%\"><a href=\"index.php?order_by=race&amp;dir=$dir\">".($order_by=='race' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['race']}</a></th>
-        <th width=\"7%\"><a href=\"index.php?order_by=class&amp;dir=$dir\">".($order_by=='class' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['class']}</a></th>
-        <th width=\"7%\"><a href=\"index.php?order_by=level&amp;dir=$dir\">".($order_by=='level' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['level']}</a></th>
-        <th width=\"20%\"><a href=\"index.php?order_by=map&amp;dir=$dir\">".($order_by=='map' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['map']}</a></th>
-        <th width=\"25%\">{$lang_index['zone']}</td>
-    <th width=\"10%\"><a href=\"index.php?order_by=highest_rank&amp;dir=$dir\">".($order_by=='highest_rank' ? "<img src=\"img/arr_".($dir ? "up" : "dw").".gif\" /> " : "")."{$lang_index['honor_kills']}</a></th>
+        <tr>
+        <th width=\"20%\"><a href=\"index.php?order_by=name&amp;dir=$dir\"".($order_by=='name' ? " class=\"$order_dir\"" : "").">{$lang_index['name']}</a></th>
+        <th width=\"5%\"><a href=\"index.php?order_by=race&amp;dir=$dir\"".($order_by=='race' ? " class=\"$order_dir\"" : "").">{$lang_index['race']}</a></th>
+        <th width=\"5%\"><a href=\"index.php?order_by=class&amp;dir=$dir\"".($order_by=='class' ? " class=\"$order_dir\"" : "").">{$lang_index['class']}</a></th>
+        <th width=\"5%\"><a href=\"index.php?order_by=level&amp;dir=$dir\"".($order_by=='level' ? " class=\"$order_dir\"" : "").">{$lang_index['level']}</a></th>
+      <th width=\"5%\"><a href=\"index.php?order_by=highest_rank&amp;dir=$dir\"".($order_by=='highest_rank' ? " class=\"$order_dir\"" : "").">Rank</a></th>
+        <th width=\"15%\"><a href=\"index.php?order_by=GNAME&amp;dir=$dir\"".($order_by=='GNAME' ? " class=\"$order_dir\"" : "").">Guild</a></th>
+        <th width=\"20%\"><a href=\"index.php?order_by=map&amp;dir=$dir\"".($order_by=='map' ? " class=\"$order_dir\"" : "").">{$lang_index['map']}</a></th>
+        <th width=\"25%\">{$lang_index['zone']}</th>
         </tr>";
 
@@ -105 +109 @@
 
         while($char = $sql->fetch_row($result)){
+
+                $guild_name = $sql->fetch_row($sql->query("SELECT `name` FROM `guild` WHERE `guildid`=".$char[9].";"));
+
+                $accid = $char[8];
+
+                $sql->db("realmd");
+                $gmlvl = $sql->query("SELECT `gmlevel` FROM `account`WHERE `id`='$accid';");
+                $gml = $sql->fetch_row($gmlvl);
+                $gm = $gml[0];
+
+                $sql->db($characters_db[$realm_id]['name']);
+
+                $level = $char[7];
+
+                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>';
+                }
+
                 $output .= "<tr>
-                 <td><a href=\"char.php?id=$char[0]\">$char[1]</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><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[3]}.gif' onmousemove='toolTip(\"".get_player_class($char[3])."\",\"item_tooltip\")' onmouseout='toolTip()' /></td>
-                 <td>$char[7]</td>
-                 <td>".get_map_name($char[5])."</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>".get_map_name($char[5])."</td>
                  <td>".get_zone_name($char[4])."</td>
-                 <td>$char[6]</td>
          </tr>";
         }
    $output .= "</table><br /></center>";
 }
+
 $sql->close();