$where = $where1 = $where2 = $criteria_clauses[1] != "" ? " WHERE " . $criteria_clauses[1] : " ";
$counter = "count(acid_event.id) as event_cnt";
}
if (preg_match("/^(.*)AND\\s+\\(\\s+timestamp\\s+[^']+'([^']+)'\\s+\\)\\s+AND\\s+\\(\\s+timestamp\\s+[^']+'([^']+)'\\s+\\)(.*)\$/", $where, $matches)) {
if ($matches[2] != $matches[3]) {
$where = $matches[1] . " AND timestamp BETWEEN('" . $matches[2] . "') AND ('" . $matches[3] . "') " . $matches[4];
} else {
$where = $matches[1] . " AND timestamp >= '" . $matches[2] . "' " . $matches[4];
}
}
// Timezone
$tz = Util::get_timezone();
//$qs->AddValidAction("ag_by_id");
//$qs->AddValidAction("ag_by_name");
//$qs->AddValidAction("add_new_ag");
$qs->AddValidAction("del_alert");
//$qs->AddValidAction("email_alert");
//$qs->AddValidAction("email_alert2");
//$qs->AddValidAction("csv_alert");
//$qs->AddValidAction("archive_alert");
//$qs->AddValidAction("archive_alert2");
$qs->AddValidActionOp(gettext("Delete Selected"));
$qs->AddValidActionOp(gettext("Delete ALL on Screen"));
$qs->SetActionSQL($from1 . $where1);
$et->Mark("Initialization");
$qs->RunAction($submit, PAGE_STAT_SENSOR, $db);
$et->Mark("Alert Action");
/* create SQL to get Unique Alerts */
$cnt_sql = "SELECT count(DISTINCT acid_event.device_id) " . $from . $where;
/* Run the query to determine the number of rows (No LIMIT)*/
if (!$use_ac) {
