"; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $sqlstring = "SELECT min(Severity) FROM OMCR_ALARMEVENT" . " WHERE bssid=$rmBssid" . " AND ObjectId='$rmObjectid'" . " AND Severity>0 AND Severity<=3"; echo $sqlstring . "

"; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $row = mysqli_fetch_row($result); if ( $row[0] == null ) // All alarm cleared $row[0] = 0; $sqlstring = "UPDATE OMCR_BSSTREE SET MaxSeverity=" . $row[0] . " WHERE bssid=$rmBssid" . " AND ObjectId='$rmObjectid'"; echo $sqlstring . "
"; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); header("Location: " . "alarmevent.php?" . "language=$language" . (isset($bssid)? "&bssid=$bssid":"") . (isset($perBssid)? "&perBssid=$perBssid":"") . (isset($perSeverity)? "&perSeverity=$perSeverity":"") . (isset($perObjectid)? "&perObjectid=$perObjectid":"") . (isset($perStartPeriod)? "&perStartPeriod=$perStartPeriod":"") . (isset($perEndPeriod)? "&perEndPeriod=$perEndPeriod":"") . (isset($perSignal_Element)? "&perSignal_Element=$perSignal_Element":"") . "&offset=$offset" //"&offset=" . ($offset-$stepsize) ); } ?>

0" . (isset($perBssid)?" AND t1.bssid=$perBssid":"") . (isset($perObjectid)?" AND t1.ObjectId REGEXP '$perObjectid'":"") . (isset($perSeverity)?" AND t1.Severity$perSeverity":"") . (isset($perStartPeriod)?" AND t1.EventTime>='$perStartPeriod'":"") . (isset($perEndPeriod)? " AND t1.EventTime<='$perEndPeriod'":"") . ( ( isset($perBssid) || isset($perObjectid) || isset($perSeverity) || isset($perStartPeriod) || isset($perEndPeriod) )? "":" AND (t1.Severity>0 OR t1.ClearTime >= NOW()-INTERVAL 60 MINUTE)" ) . (isset($XXX)? " AND ($XXX)":"") . " AND t1.Severity <= $alarm_to_show AND t1.Cause = t2.Cause "; //echo $sqlstring . "
"; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $no_of_records=mysqli_num_rows($result); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo ${$parameter}[total] . ": " .$no_of_records . " " . ${$parameter}[record]; echo "	\n"; echo "$stepsize " . ${$parameter}[record] . "/" . ${$parameter}[pages]; echo "	\n"; if ($no_of_records) echo (floor($offset/$stepsize) + 1) . "/" . (ceil($no_of_records/$stepsize)) . " " . ${$parameter}[pages]; else echo "0/0 " . ${$parameter}[pages]; echo "	"; echo ""; echo " "; echo "{${$parameter}[pages]}   "; if ($offset > $stepsize-1) { echo ""; echo ""; echo "\n"; } else { echo ""; echo ""; echo "\n"; } if ($no_of_records > $offset + $stepsize) { echo ""; echo ""; echo "\n"; } else { echo ""; echo ""; echo "\n"; } echo "
\n"; // // Only show alarm with Severity <= $alarm_to_show if ($offset >= 0) { $sqlstring .= "ORDER BY EventTime DESC,GlobalEventNumber DESC LIMIT $offset,$stepsize"; } else { $sqlstring .= "ORDER BY EventTime DESC,GlobalEventNumber DESC LIMIT 0," . ($stepsize+$offset); } //echo $sqlstring . " "; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $no_of_fields = mysql_num_fields($result); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; while ( $row = mysqli_fetch_row($result) ) { list($mybssid,$myobjectid,$myeventinfo,$myseverity, $myeventtime,$mycleartime, $cause)=$row; echo ""; for ($i=0;$i<$no_of_fields;$i++) { if (!strcmp(mysql_field_name($result, $i),"Severity")) { $severity_field_no = $i; echo "\n"; break; case 1: echo "" . ${$parameter}[critical] . "\n"; break; case 2: echo "" . ${$parameter}[major] . "\n"; break; case 3: echo ${$parameter}[minor] . "\n"; break; case 4: echo ${$parameter}[minor] . "\n"; break; default: echo $row[$i] . "\n"; break; } } else if (!strcmp(mysql_field_name($result, $i),"Cause")) { // Not need to display } else // Is not Severity or Cause { printf("\n",(isset($row[$i])? $row[$i]:"-")); } } // end_of_for () // Manual clear button for non-clear alarm if ($row[$severity_field_no] > 0) echo ""; else echo ""; echo "\n"; } echo " {${$parameter}[bssid]} {${$parameter}[objectid]} {${$parameter}[description]} {${$parameter}[severity]} {${$parameter}[eventtime]} {${$parameter}[cleartime]} - - "; switch ($row[$i]) { case 0: echo ${$parameter}[clear] . " %s - \n"; if (mysqli_num_rows($result) == 0) echo " {${$parameter}[norecord]} "; echo "

\n"; echo "{${$parameter}[note]}\n"; mysql_free_result($result); ?>