PHP Alarm::get_max_byfield Examples

Example #1

File: mobile_option.php Project: jackpf/ossim-arc

 $incident_ticket_list = Incident_ticket::get_list($conn, "ORDER BY date DESC LIMIT 1");
 $incident_date2 = $incident_ticket_list[0] ? $incident_ticket_list[0]->get_date() : 0;
 if ($incident_list[0] || $incident_ticket_list[0]) {
     $incident_date = strtotime($incident_date1) > strtotime($incident_date2) ? $incident_date1 : $incident_date2;
     if ($incident_date == 0) {
         $incident_date = "__/__/__ --:--:--";
     }
 }
 //$incident_list = Incident::get_list($conn, "ORDER BY priority DESC");
 $incident_list = Incident::search($conn, array("status" => "Open"), "priority", "DESC", 1, 1);
 $incident_max_priority = $incident_list[0] ? $incident_list[0]->get_priority() : "-";
 $incident_max_priority_id = $incident_list[0] ? $incident_list[0]->get_id() : "0";
 // Get unresolved ALARMS
 $unresolved_alarms = Alarm::get_count($conn);
 list($alarm_date, $alarm_date_id) = Alarm::get_max_byfield($conn, "timestamp");
 list($alarm_max_risk, $alarm_max_risk_id) = Alarm::get_max_byfield($conn, "risk");
 if ($alarm_max_risk_id == "") {
     $alarm_max_risk = "-";
 }
 //
 list($siem, $events) = get_siem_events($conn, date("Y-m-d"));
 $i = 0;
 foreach ($siem as $p) {
     $plot .= "[" . $i++ . "," . $p["num_events"] . "],";
 }
 $i = 0;
 foreach ($siem as $p) {
     $legend .= "[" . $i++ . ",'" . ($i % 2 == 0 ? $p["intervalo"] . "h" : "") . "'],";
 }
 $data_pie = top_siem_events($conn, $NUM_HOSTS);
 ?>

Example #2

File: host_report_alarms.php Project: jhbsz/ossimTest

usleep(500000);
require_once 'classes/Session.inc';
$hide_closed = 1;
if ($host != 'any') {
    list($alarm_list, $count) = Alarm::get_list3($conn, $host, $host, $hide_closed, "ORDER BY a.timestamp DESC", 0, 5, $date_from, $date_to, "");
} else {
    list($alarm_list, $count) = Alarm::get_list3($conn, '', '', $hide_closed, "ORDER BY a.timestamp DESC", 0, 5, $date_from, $date_to, "");
}
if ($network) {
    list($host_start, $host_end) = Util::cidr_conv($host);
    $retfields = Alarm::get_max_byfield($conn, "risk", "WHERE (inet_aton('{$host_start}') <= a.src_ip AND inet_aton('{$host_end}') >= a.src_ip) OR (inet_aton('{$host_start}') <= a.dst_ip AND inet_aton('{$host_end}') >= a.dst_ip)");
} else {
    if ($host != 'any') {
        $retfields = Alarm::get_max_byfield($conn, "risk", "WHERE a.src_ip=INET_ATON('{$host}') OR a.dst_ip=INET_ATON('{$host}')");
    } else {
        $retfields = Alarm::get_max_byfield($conn, "risk");
    }
}
$a_maxrisk = $retfields[0];
$backlog_id = $retfields[1];
$alarm_link = "../control_panel/events.php?backlog_id={$backlog_id}";
$a_date = "-";
if ($host != 'any') {
    $temp_url = "../control_panel/alarm_console.php?&hide_closed=1&src_ip=" . urlencode($host) . "&dst_ip=" . urlencode($host);
} else {
    $temp_url = "../control_panel/alarm_console.php?&hide_closed=1";
}
?>

<table align="center" width="100%" height="100%" class="bordered">
	<tr>