if ($result->baseRecordCount() == 0 && $use_ac) { $result = $qs->ExecuteOutputQuery($sql2, $db); } $qs->num_result_rows = $result->baseRecordCount(); $et->Mark("Retrieve Query Data"); // if ($debug_mode == 1) { // $qs->PrintCannedQueryList(); // $qs->DumpState(); // echo "$sql<BR>"; // } /* Print the current view number and # of rows */ $displaying = gettext("Displaying sensors %d-%d of <b>%s</b> matching your selection."); $qs->PrintResultCnt("", array(), $displaying); echo '<FORM METHOD="post" NAME="PacketForm" id="PacketForm" ACTION="base_stat_sensor.php">'; if ($qs->num_result_rows > 0) { $qro->PrintHeader(); } $i = 0; $sensorips = GetSensorSidsNames($db); $report_data = array(); // data to fill report_data if (is_array($_SESSION["server"]) && $_SESSION["server"][0] != "") { $_conn = $dbo->custom_connect($_SESSION["server"][0], $_SESSION["server"][2], $_SESSION["server"][3]); } else { $_conn = $dbo->connect(); } while (($myrow = $result->baseFetchRow()) && $i < $qs->GetDisplayRowCnt()) { $device_id = $myrow['device_id']; list($myrow['name'], $myrow['sensor_ip']) = explode(' - ', GetSensorName($myrow['sensor_id'], $db, true)); $sensor_ip = $myrow['name'] == 'N/A' ? 'N/A' : $myrow['sensor_ip']; $device_ip = $myrow['device_ip'] != '' ? $myrow['device_ip'] . ($myrow['interface'] != '' ? ':' . $myrow['interface'] : '') : '-';
$sqlgraph = "SELECT COUNT(acid_event.cid) as num_events, {$interval} FROM acid_event " . $join_sql . $where_sql . $criteria_sql . $grpby; //echo $sqlgraph."<br>"; /* Print the current view number and # of rows */ $_SESSION['siem_current_query_graph'] = $sqlgraph; // do we need load extradata? $need_extradata = 0; foreach ($_SESSION['views'][$_SESSION['current_cview']]['cols'] as $field) { if (preg_match("/^(USERDATA|USERNAME|FILENAME|PASSWORD|PAYLOAD|CONTEXT)/i", $field)) { $need_extradata = 1; } } $qs->PrintResultCnt($sqlgraph, $trdata); //base_state_query.inc.php // COLUMNS of Events Table (with ORDER links) //$htmlPdfReport->set('<table cellpadding=2 cellspacing=0 class="w100">'); $qro->PrintHeader('', 1); $i = 0; $hosts_ips = array_keys($hosts); $report_data = array(); // data to fill report_data $sensornames = GetSensorSidsNames($db); if (is_array($_SESSION["server"]) && $_SESSION["server"][0] != "") { $_conn = $dbo->custom_connect($_SESSION["server"][0], $_SESSION["server"][2], $_SESSION["server"][3]); } else { $_conn = $dbo->connect(); } while (($myrow = $result->baseFetchRow()) && $i < $qs->GetDisplayRowCnt()) { unset($cell_data); unset($cell_more); unset($cell_pdfdata); unset($cell_align);