Changeset 307 for minimanager/index.php

Timestamp:

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

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

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

minimanager/index.php

@@ -22 +22 @@
 if (test_port($server[$realm_id]['addr'],$server[$realm_id]['game_port'])) {
 
-        $query = $sql->query("SELECT uptime 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/60/24)."D : ".(($uptime/60/60 >= 24 )?(int)($uptime/60/60-24*(int)($uptime/60/60/24)):(int)($uptime/60/60))."H : ".(($uptime/60 >= 60 )?(int)($uptime/60-60*(int)($uptime/60/60)):(int)($uptime/60))."M : ".(($uptime >= 60 )?(int)($uptime-60*(int)($uptime/60)):(int)$uptime)."S)</font></h1>";
+
+/*      $query = $sql->query("SELECT uptime 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/60/24)."D : ".(($uptime/60/60 >= 24 )?(int)($uptime/60/60-24*(int)($uptime/60/60/24)):(int)($uptime/60/60))."H : ".(($uptime/60 >= 60 )?(int)($uptime/60-60*(int)($uptime/60/60)):(int)($uptime/60))."M : ".(($uptime >= 60 )?(int)($uptime-60*(int)($uptime/60)):(int)$uptime)."S)</font></h1>";
+*/
+    $query = $sql->query("SELECT `starttime` FROM `uptime` ORDER BY `starttime` DESC LIMIT 1");
+    $getuptime = mysql_fetch_row($query);
+$uptimetime = time() - $getuptime[0];
+    $uptime = array(
+    'd' => $uptimetime / 86400 % 7,
+    'h' => $uptimetime / 3600 % 24,
+    'm' => $uptimetime / 60 % 60,
+    's' => $uptimetime / 1 % 60,
+     );
+if ($uptime[d] < 2) {
+$sd = ""; }
+else {
+$sd = "s"; }
+
+if ($uptime[h] < 2) {
+$sh = ""; }
+else {
+$sh = "s"; }
+
+if ($uptime[m] < 2) {
+$sm = ""; }
+else {
+$sm = "s"; }
+
+if ($uptime[s] < 2) {
+$ss = ""; }
+else {
+$ss = "s"; }
+
+if ($uptime[d] > 0) {
+    $output .= "<h1><font color=\"#55aa55\">{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['online']} for " . $uptime[d] . " day$sd " .  $uptime[h] . " hour$sh " .  $uptime[m] . " minute$sm and  " .  $uptime[s] . " second$ss.</font></h1>";
+    } else {
+        if ($uptime[h] > 0) {
+                $output .= "<h1><font color=\"#55aa55\">{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['online']} for " .  $uptime[h] . " hour$sh " .  $uptime[m] . " minute$sm and  " .  $uptime[s] . " second$ss.</font></h1>";
+                } else {
+                $output .= "<h1><font color=\"#55aa55\">{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['online']} for " .  $uptime[m] . " minute$sm and  " .  $uptime[s] . " second$ss.</font></h1>";
+                }
+        }
+
         $online = true;
         } else {
@@ -30 +71 @@
                 $online = false;
                 }
-$output .= "Mangos: {$server[$realm_id]['rev']} Using DB: {$mangos_db[$realm_id]['db_rev']}</div>";
+/*$output .= "Mangos: {$server[$realm_id]['rev']} Using DB: {$mangos_db[$realm_id]['db_rev']}</div>";*/
+        //  This retrieves the actual database version from the database itself,  instead of hardcoding it into a string
+        $sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+        $query_db_version = $sql->query("SELECT version FROM db_version");
+        $db_rev = $sql->result($query_db_version, 0);
+$output .= "Mangos: {$server[$realm_id]['rev']} Using DB: $db_rev</div>";
 
 $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
@@ -75 +121 @@
         $dir = ($dir) ? 0 : 1;
 
-        $result = $sql->query("SELECT count(*) FROM `character` WHERE `online`= 1");
+        $result = $sql->query("SELECT count(*) FROM `characters` WHERE `online`= 1");
         $total_online = $sql->result($result, 0);
 
         if( !$user_lvl && !$server[$realm_id]['both_factions']){
-                $result = $sql->query("SELECT race FROM `character` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `character` WHERE account = '$user_id') LIMIT 1");
+                $result = $sql->query("SELECT race FROM `characters` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `characters` WHERE account = '$user_id') LIMIT 1");
                 if ($sql->num_rows($result)){
                         $order_side = (in_array($sql->result($result, 0, 'race'),array(2,5,6,8,10))) ?
@@ -93 +139 @@
                         CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) as GNAME,
                         mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender
-                        FROM `character` WHERE `online`= 1 $order_side ORDER BY $order_by $order_dir");
+                        FROM `characters` WHERE `online`= 1 $order_side ORDER BY $order_by $order_dir");
 
         $output .= "