Changeset 142 for minimanager/stat.php

Timestamp:

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

Author:

george

Message:

Minimanager 0.1.5b

File:

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

minimanager/stat.php

@@ -61 +61 @@
  $total_gms = $sql->result($query,1);
 
- $sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $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']);
  $query = $sql->query("SELECT count(*) FROM `character`");
  $total_chars = $sql->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 AVG(uptime)/60,MAX(uptime)/60,(100*SUM(uptime)/(UNIX_TIMESTAMP()-MIN(starttime))) FROM uptime");
  $uptime = $sql->fetch_row($query);
@@ -87 +88 @@
  $output .= "<div class=\"top\"><h1>{$lang_stat['srv_statistics']}</h1></div>";
  
+ $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
+
  //there is always less hordies
  $query = $sql->query("SELECT count(guid) FROM `character` WHERE race IN(2,5,6,8,10)");