Changeset 8 for scripts/online.php

Timestamp:

Jun 5, 2008, 9:38:23 PM (16 years ago)

Author:

george

Message:

Přidáno: Zaznamenávání a zobrazování údaje o odezevně serverů.
Upraveno: Šablony stránek a použití jazykových proměnných ve větší míře.

File:

• scripts/online.php (modified) (2 diffs)

scripts/online.php

@@ -1 +1 @@
 <?php
+
+// Script executed by cron every 5 minutes
 
 include('../includes/config.php');
@@ -34 +36 @@
 {
   echo($Server['name'].' - ');
+  $MeasureStart = microtime(TRUE);
   $OnlineState = CheckPortStatus($Server['ip'], $Server['port']);
+  $Latency = (microtime(TRUE) - $MeasureStart) * 1000;
   $OnlineCount += $OnlineState;
   $OfflineCount += 1 - $OnlineState;
   // Insert new online state
-  $Database->query("INSERT INTO `servers_online` (`server` ,`time` ,`state` ,`players_count`) VALUES (".$Server['id'].", NOW() , ".$OnlineState.", ".$PlayersCount.")");
+  $Database->query("INSERT INTO `servers_online` (`server`, `time`, `state`, `players_count`, `latency`) VALUES (".$Server['id'].", NOW() , ".$OnlineState.", ".$PlayersCount.", ".$Latency.")");
 
   // Delete old records
-  $Database->query("DELETE FROM `servers_online` WHERE `server` = ".$Server['id']." AND time < DATE_SUB(NOW(), INTERVAL 1 DAY)");
+  $Database->query("DELETE FROM `servers_online` WHERE `server` = ".$Server['id']." AND time < DATE_SUB(NOW(), INTERVAL ".$Config['OnlineStatePeriodLength']." DAY)");
  
+  // Calculate latency average 
+  $DbResult = $Database->query("SELECT AVG(`latency`) as `latency` FROM `servers_online` WHERE `server` = ".$Server['id']." AND `state` = 1 AND `latency` != 0");
+  $DbRow = $DbResult->fetch_array();
+  $Latency = $DbRow['latency'];
+  $DbResult->free();
+
   // Calculate cached percentage online state
   $DbResult = $Database->query("SELECT COUNT(*) as `count`, SUM(`state`) as `online` FROM `servers_online` WHERE `server` = ".$Server['id']);
   $DbRow = $DbResult->fetch_array();
-  $Database->query("UPDATE `servers` SET `online` = ".round($DbRow['online'] / $DbRow['count'] * 100, 2)." WHERE `id` = ".$Server['id']);
+
+  // Update servers info
+  $Database->query("UPDATE `servers` SET `online` = ".round($DbRow['online'] / $DbRow['count'] * 100, 2).", `latency` = ".$Latency." WHERE `id` = ".$Server['id']);
   $DbResult->free();
   echo($TextState[$OnlineState]."<br>\n");