foreach ($arrDBConns as $key => $value) {
if (strtolower($value['DBXLNode']) == 'datanode') {
$strPanelColor = 'success';
// check the number of connections
$intConnections = getConnections($key);
$intMaxConnections = getDBSystemParam($key, 'max_connections');
if ($intMaxConnections >= $intConnections && $intMaxConnections > 0) {
$perConnections = round($intConnections / $intMaxConnections * 100, 0);
} else {
$intConnections = '?';
$intMaxConnections = '?';
$perConnections = '???';
$strPanelColor = 'warning';
}
// display number of deadlocks
$intDeadlocks = getDeadlocks($key);
if ($intDeadlocks != '0') {
$strPanelColor = 'warning';
}
// try to ping the server
if (testPing($value['DBIP'])) {
$strPing = 'check';
} else {
$strPing = 'exclamation';
$strPanelColor = 'danger';
}
// check the listed port to see if it responds
if (testPort($value['DBIP'], $value['DBPort'])) {
$strPort = 'check';
} else {
$strPort = 'exclamation';
<div class="row">
<div class="col-sm-12">
<h4>Health</h4>
<?php
// check the number of connections
$intConnections = getConnections($strNode);
$intMaxConnections = getDBSystemParam($strNode, 'max_connections');
$strPanelColor = 'success';
if ($intMaxConnections >= $intConnections && $intMaxConnections > 0) {
$perConnections = round($intConnections / $intMaxConnections * 100, 0);
} else {
$perConnections = '???';
$strPanelColor = 'warning';
}
// display number of deadlocks
$intDeadlocks = getDeadlocks($strNode);
if ($intDeadlocks != '0') {
$strPanelColor = 'warning';
}
// try to ping the server
if (testPing($value['DBIP'])) {
$strPing = 'check';
} else {
$strPing = 'exclamation';
$strPanelColor = 'danger';
}
// check the listed port to see if it responds
if (testPort($arrDBConns[$strNode]['DBIP'], $arrDBConns[$strNode]['DBPort'])) {
$strPort = 'check';
} else {
$strPort = 'exclamation';
