Changeset 10 for scripts/online.php

Timestamp:

Jun 6, 2008, 9:12:32 AM (16 years ago)

Author:

george

Message:

Opraveno: Použití nulových hodnot při aktualizaci dat serverů namísto hodnoty NULL.

File:

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

scripts/online.php

@@ -48 +48 @@
  
   // Calculate latency average 
-  $DbResult = $Database->query("SELECT AVG(`latency`) as `latency` FROM `servers_online` WHERE `server` = ".$Server['id']." AND `state` = 1 AND `latency` != 0");
+  $DbResult = $Database->query("SELECT COALESCE(AVG(`latency`), 0) as `latency` FROM `servers_online` WHERE `server` = ".$Server['id']." AND `state` = 1 AND `latency` != 0");
   $DbRow = $DbResult->fetch_array();
   $Latency = $DbRow['latency'];
@@ -54 +54 @@
 
   // Calculate cached percentage online state
-  $DbResult = $Database->query("SELECT COUNT(*) as `count`, SUM(`state`) as `online` FROM `servers_online` WHERE `server` = ".$Server['id']);
+  $DbResult = $Database->query("SELECT COALESCE(COUNT(*), 1) as `count`, COALESCE(SUM(`state`), 0) as `online` FROM `servers_online` WHERE `server` = ".$Server['id']);
   $DbRow = $DbResult->fetch_array();