} } //print_r($_SESSION); /* Run the Query again for the actual data (with the LIMIT) */ $result = $qs->ExecuteOutputQuery($sql, $db); if ($use_ac) { $qs->GetCalcFoundRows($cnt_sql, $db); } $et->Mark("Retrieve Query Data"); if ($debug_mode == 1) { $qs->PrintCannedQueryList(); $qs->DumpState(); echo "{$sql}<BR>"; } /* Print the current view number and # of rows */ $qs->PrintResultCnt("", array(), $displaytitle); echo '<FORM METHOD="post" name="PacketForm" id="PacketForm" ACTION="base_stat_uaddr.php">'; $qro->PrintHeader(); $i = 0; $hosts_ips = array_keys($hosts); $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()) { $currentIP = baseLong2IP($myrow[0]); $num_events = $myrow[1]; $num_sensors = $myrow[2];
/* Run the Query again for the actual data (with the LIMIT) */ session_write_close(); $result = $qs->ExecuteOutputQuery($sql, $db); 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'];
$event_cnt = EventCnt($db, "", "", "SELECT sum(cid) FROM ac_alertsclas_classid {$where}"); } //echo $sql; /* Run the Query again for the actual data (with the LIMIT) */ $result = $qs->ExecuteOutputQuery($sql, $db); if ($use_ac) { $qs->GetCalcFoundRows($cnt_sql, $db); } $et->Mark("Retrieve Query Data"); if ($debug_mode == 1) { $qs->PrintCannedQueryList(); $qs->DumpState(); echo "{$sql}<BR>"; } /* Print the current view number and # of rows */ $qs->PrintResultCnt(); echo '<FORM METHOD="post" NAME="PacketForm" ACTION="base_stat_class.php">'; $qro->PrintHeader(); $i = 0; while (($myrow = $result->baseFetchRow()) && $i < $qs->GetDisplayRowCnt()) { $class_id = $myrow[0]; if ($class_id == "") { $class_id = 0; } $total_occurances = $myrow[1]; $sensor_num = $myrow[2]; $sig_num = $myrow[3]; $sip_num = $myrow[4]; $dip_num = $myrow[5]; $min_time = $myrow[6]; $max_time = $myrow[7];