} /* 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($sql, $db); } $event_cnt = $qs->GetCalcRows($criteria_clauses[9], $result->baseRecordCount(), $db); $debug_time_mode >= 1 ? $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->PrintEstimatedResultCnt(); echo ' <script src="../js/jquery.flot.pie.js" language="javascript" type="text/javascript"></script> '; echo '<FORM METHOD="post" NAME="PacketForm" id="PacketForm" ACTION="base_stat_alerts.php">'; if ($qs->num_result_rows > 0) { $qro->PrintHeader(); } $i = 0; // The below is due to changes in the queries... // We need to verify that it works all the time -- Kevin $report_data = array(); $and = strpos($where, "WHERE") != 0 ? " AND " : " WHERE "; while (($myrow = $result->baseFetchRow()) && $i < $qs->GetDisplayRowCnt()) { if ($myrow["plugin_id"] == "" || $myrow["plugin_sid"] == "") { continue;
/* 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($sql, $db); } $event_cnt = $qs->GetCalcRows($criteria_clauses[2], $result->baseRecordCount(), $db, "select count(*) from (SELECT cnt FROM ac_acid_event as acid_event WHERE 1=1 " . $criteria_clauses[2] . " GROUP BY plugin_id) as cnt"); $debug_time_mode >= 1 ? $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 unique data sources %d-%d of <b>%s</b> matching your selection."); $qs->PrintEstimatedResultCnt($displaying); echo '<FORM METHOD="post" name="PacketForm" id="PacketForm" ACTION="base_stat_plugins.php">'; if ($qs->num_result_rows > 0) { $qro->PrintHeader(); } $i = 0; // The below is due to changes in the queries... // We need to verify that it works all the time -- Kevin $and = strpos($where, "WHERE") != 0 ? " AND " : " WHERE "; $i = 0; $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();