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);
