Changeset 40862

Timestamp:

Aug 9, 2019, 12:18:36 PM (7 years ago)

Author:

ippitc

Message:

update to fix query of server up/down status

File:

• trunk/ippMonitor/raw/czartool_labels.php (modified) (2 diffs)

trunk/ippMonitor/raw/czartool_labels.php

@@ -944 +944 @@
     foreach ($servers as &$server) {
 
-        getServerStatus($db, $server, $alive, $running);
+        getServerStatus($db,$proj, $server, $alive, $running);
 
         echo "<tr>\n";
@@ -1036 +1036 @@
 #
 ###########################################################################
-function getServerStatus($db, $server, &$alive, &$running) {
-
-    $sql = "SELECT alive, running FROM servers WHERE server LIKE '$server' ORDER BY timestamp DESC LIMIT 1";
+function getServerStatus($db,$proj, $server, &$alive, &$running) {
+
+    $sql = "SELECT alive, running FROM science_servers WHERE server LIKE '$server' AND telescope LIKE '$proj' ORDER BY timestamp DESC LIMIT 1";
     if($debug){echo "$sql<br>";}