Changeset 6 for scripts/online.php

Timestamp:

Jun 4, 2008, 9:01:09 AM (16 years ago)

Author:

george

Message:

Upraveno: Změna systému sledování procentuálního online stavu. Přidána tabulka servers_online pro uchování stavu serveru za poslední definovanou periodu. Dosavadní systém počítal online stav od počáteční registrace daného serveru což je nevyhovující a zavádějící.

File:

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

scripts/online.php

@@ -3 +3 @@
 require ('../includes/config.php');
 
-mysql_connect($db_config['host'], $db_config['user'], $db_config['pass']);
-mysql_select_db($db_config['name']);
+$Database = new mysqli($db_config['host'], $db_config['user'], $db_config['pass']);
+$Database->select_db($db_config['name']);
 
 function CheckPortStatus($Ip, $Port)
@@ -12 +12 @@
   {
     fclose($Socket);
-    return(true);
+    return(1);
   } else
   {
-    return(false);
+    return(0);
   }
 }
 
+$TextState = array('Offline', 'Online');
+
 echo("Kontroluji stav serveru...<br>\n");
+$PlayersCount = 0;
 $OnlineCount = 0;
 $OfflineCount = 0;
-$Servers = mysql_query("SELECT `id`,`ip`,`port`,`name` FROM `servers`");
-while($Server = mysql_fetch_array($Servers))
+$Servers = $Database->query("SELECT `id`,`ip`,`port`,`name` FROM `servers`");
+while($Server = $Servers->fetch_array())
 {
   echo($Server['name'].' - ');
-  if(CheckPortStatus($Server['ip'], $Server['port']))
-  {
-    mysql_query("UPDATE `servers` SET `online_checks` = `online_checks` + 1, `online` = `online` + 1 WHERE `id`=".$Server['id']);
-    echo('Online');
-    $OnlineCount++;
-  } else
-  {
-    mysql_query("UPDATE `servers` SET `online_checks` = `online_checks` + 1 WHERE `id` =".$Server['id']);
-    echo('Offline');
-    $OfflineCount++;
-  }
-  echo("<br>\n");
+  $OnlineState = CheckPortStatus($Server['ip'], $Server['port']);
+  $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.")");
+
+  // Delete old records
+  $Database->query("DELETE FROM `servers_online` WHERE `server` = ".$Server['id']." AND time < DATE_SUB(NOW(), INTERVAL 1 DAY)");
+ 
+  // 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']);
+  $DbResult->free();
+  echo($TextState[$OnlineState]."<br>\n");
+  flush();
 }
-mysql_free_result($Servers);
+$Servers->free();
 
 echo('Total: '.($OnlineCount + $OfflineCount).', Online: '.$OnlineCount.', Offline: '.$OfflineCount."<br>\n");