Changeset 178 for minimanager/stat.php

Timestamp:

Dec 23, 2007, 2:55:36 PM (17 years ago)

Author:

george

Message:

Minimanager 0.1.6b

File:

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

minimanager/stat.php

@@ -8 +8 @@
  * License: GNU General Public License v2(GPL)
  */
- 
+
 require_once("header.php");
 valid_login(1);
@@ -61 +61 @@
  $total_gms = $sql->result($query,1);
 
+ $data = date("Y-m-d H:i:s");
+ $data_1 = date_create ($data);
+ $data_1->modify ("-1 day");
+ $data_1 = date_format($data_1,"Y-m-d H:i:s");
+$query = $sql->query("select distinct count(`last_ip`) from `account` where `last_login` > '$data_1' and `last_login` < '$data'");
+ $uniqueIPs = $sql->result($query,0);
+
  $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);
- 
+
  if ($total_chars){
- 
+
  $order_race = (isset($_GET['race'])) ? "AND race =".$sql->quote_smart($_GET['race']) : "";
  $order_class = (isset($_GET['class'])) ? "AND class =".$sql->quote_smart($_GET['class']) : "";
@@ -79 +86 @@
         $order_level = "AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) >= $lvl_min AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) <= $lvl_max";
         } else $order_level = "";
-        
+
  if(isset($_GET['side'])) {
         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 = "";
-        
+
 
  $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']);
 
@@ -96 +103 @@
  $allies_chars = $total_chars - $horde_chars;
  $allies_pros = 100 - $horde_pros;
- 
+
  $output .= "<center>
  <table class=\"hidden\">
@@ -103 +110 @@
                 {$lang_stat['uptime_prec']}: ".round($uptime[2],1)."%<br />
                 {$lang_stat['avg_uptime']}: ".(int)($uptime[0]/60).":".(int)(($uptime[0]%60))."h<br />
-                {$lang_stat['max_uptime']}: ".(int)($uptime[1]/60).":".(int)(($uptime[1]%60))."h<br /><br />
+                {$lang_stat['max_uptime']}: ".(int)($uptime[1]/60).":".(int)(($uptime[1]%60))."h<br />
+                {$lang_stat['unique_ip']}: $uniqueIPs<br />     <br />
                 {$lang_stat['tot_accounts']}: $total_acc<br />
                 {$lang_stat['total_of']} $total_gms {$lang_stat['gms_one_for']} ".round($total_acc/$total_gms,1)." {$lang_stat['players']}<br /><br />
                 {$lang_stat['tot_chars_on_realm']}: $total_chars<br />
                 {$lang_stat['average_of']} ".round($total_chars/$total_acc,1)." {$lang_stat['chars_per_acc']}<br /><br />
-                
+
                 <table class=\"tot_bar\">
                         <tr>
@@ -193 +201 @@
 
  $sql->close();
- 
+
 } else {
         $sql->close();