Changeset 19 for minimanager/stat.php

Timestamp:

Aug 13, 2007, 9:05:34 PM (17 years ago)

Author:

george

Message:

Aktualizace MaNGOS Minimanageru na verzi 0.1.4a.

File:

• minimanager/stat.php (modified) (7 diffs)

minimanager/stat.php

@@ -55 +55 @@
 );
 
- $mysql = new MySQL;
- $mysql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
- $query = $mysql->query("SELECT count(*) FROM account UNION SELECT count(*) FROM account WHERE gmlevel > 0");
- $total_acc = $mysql->result($query,0);
- $total_gms = $mysql->result($query,1);
+ $sql = new SQL;
+ $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
+ $query = $sql->query("SELECT count(*) FROM account UNION SELECT count(*) FROM account WHERE gmlevel > 0");
+ $total_acc = $sql->result($query,0);
+ $total_gms = $sql->result($query,1);
 
- $mysql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
- $query = $mysql->query("SELECT count(*) FROM `character`");
- $total_chars = $mysql->result($query,0);
+ $sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+ $query = $sql->query("SELECT count(*) FROM `character`");
+ $total_chars = $sql->result($query,0);
  
- $query = $mysql->query("SELECT AVG(uptime)/60,MAX(uptime)/60,(100*SUM(uptime)/(UNIX_TIMESTAMP()-MIN(starttime))) FROM uptime");
- $uptime = $mysql->fetch_row($query);
+ $query = $sql->query("SELECT AVG(uptime)/60,MAX(uptime)/60,(100*SUM(uptime)/(UNIX_TIMESTAMP()-MIN(starttime))) FROM uptime");
+ $uptime = $sql->fetch_row($query);
  
  if ($total_chars){
  
- $order_race = (isset($_GET['race'])) ? "AND race =".$mysql->quote_smart($_GET['race']) : "";
- $order_class = (isset($_GET['class'])) ? "AND class =".$mysql->quote_smart($_GET['class']) : "";
+ $order_race = (isset($_GET['race'])) ? "AND race =".$sql->quote_smart($_GET['race']) : "";
+ $order_class = (isset($_GET['class'])) ? "AND class =".$sql->quote_smart($_GET['class']) : "";
 
  if(isset($_GET['level'])){
-        $lvl_min = $mysql->quote_smart($_GET['level']);
+        $lvl_min = $sql->quote_smart($_GET['level']);
         $lvl_max = $lvl_min + 4;
         $order_level = "AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) >= $lvl_min AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) <= $lvl_max";
@@ -80 +80 @@
         
  if(isset($_GET['side'])) {
-        if ($mysql->quote_smart($_GET['side']) == "h") $order_side = "AND race IN(2,5,6,8,10)";
-                elseif ($mysql->quote_smart($_GET['side']) == "a") $order_side = "AND race IN (1,3,4,7,11)";
+        if ($sql->quote_smart($_GET['side']) == "h") $order_side = "AND race IN(2,5,6,8,10)";
+                elseif ($sql->quote_smart($_GET['side']) == "a") $order_side = "AND race IN (1,3,4,7,11)";
         } else $order_side = "";
         
@@ -88 +88 @@
  
  //there is always less hordies
- $query = $mysql->query("SELECT count(guid) FROM `character` WHERE race IN(2,5,6,8,10)");
- $horde_chars = $mysql->result($query,0);
+ $query = $sql->query("SELECT count(guid) FROM `character` WHERE race IN(2,5,6,8,10)");
+ $horde_chars = $sql->result($query,0);
  $horde_pros = round(($horde_chars*100)/$total_chars ,1);
  $allies_chars = $total_chars - $horde_chars;
@@ -117 +117 @@
 // RACE
 foreach ($race as $id){
-        $query = $mysql->query("SELECT count(guid) FROM `character` WHERE race = $id[0] $order_class $order_level $order_side");
-        $race[$id[0]][2] = $mysql->result($query,0);
+        $query = $sql->query("SELECT count(guid) FROM `character` WHERE race = $id[0] $order_class $order_level $order_side");
+        $race[$id[0]][2] = $sql->result($query,0);
         $race[$id[0]][3] = round((($race[$id[0]][2])*100)/$total_chars,1);
  }
@@ -140 +140 @@
 // CLASS
 foreach ($class as $id){
-                $query = $mysql->query("SELECT count(guid) FROM `character` WHERE class = $id[0] $order_race $order_level $order_side");
-                $class[$id[0]][2] = $mysql->result($query,0);
+                $query = $sql->query("SELECT count(guid) FROM `character` WHERE class = $id[0] $order_race $order_level $order_side");
+                $class[$id[0]][2] = $sql->result($query,0);
                 $class[$id[0]][3] = round((($class[$id[0]][2])*100)/$total_chars,1);
  }
@@ -163 +163 @@
 // LEVEL
 foreach ($level as $id){
-                $query = $mysql->query("SELECT count(guid) FROM `character` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) >= $id[1]
+                $query = $sql->query("SELECT count(guid) FROM `character` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) >= $id[1]
                                                                 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) <= $id[2] $order_race $order_class $order_side");
-                $level[$id[0]][3] = $mysql->result($query,0);
+                $level[$id[0]][3] = $sql->result($query,0);
                 $level[$id[0]][4] = round((($level[$id[0]][3])*100)/$total_chars,1);
  }
@@ -189 +189 @@
         </center>";
 
- $mysql->close();
+ $sql->close();
  
 } else {
-        $mysql->close();
+        $sql->close();
         error($lang_global['err_no_result']);
         }