Changeset 307 for minimanager/stat.php

Timestamp:

Mar 13, 2008, 8:18:42 PM (17 years ago)

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

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

minimanager/stat.php

@@ -69 +69 @@
 
  $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
- $query = $sql->query("SELECT count(*) FROM `character`");
+ $query = $sql->query("SELECT count(*) FROM `characters`");
  $total_chars = $sql->result($query,0);
 
@@ -98 +98 @@
 
  //there is always less hordies
- $query = $sql->query("SELECT count(guid) FROM `character` WHERE race IN(2,5,6,8,10)");
+ $query = $sql->query("SELECT count(guid) FROM `characters` WHERE race IN(2,5,6,8,10)");
  $horde_chars = $sql->result($query,0);
  $horde_pros = round(($horde_chars*100)/$total_chars ,1);
@@ -128 +128 @@
 // RACE
 foreach ($race as $id){
-        $query = $sql->query("SELECT count(guid) FROM `character` WHERE race = $id[0] $order_class $order_level $order_side");
+        $query = $sql->query("SELECT count(guid) FROM `characters` 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);
@@ -151 +151 @@
 // CLASS
 foreach ($class as $id){
-                $query = $sql->query("SELECT count(guid) FROM `character` WHERE class = $id[0] $order_race $order_level $order_side");
+                $query = $sql->query("SELECT count(guid) FROM `characters` 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);
@@ -174 +174 @@
 // LEVEL
 foreach ($level as $id){
-                $query = $sql->query("SELECT count(guid) FROM `character` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) >= $id[1]
+                $query = $sql->query("SELECT count(guid) FROM `characters` 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] = $sql->result($query,0);