if (preg_match("/timestamp/", $criteria_clauses[1])) { $where = "WHERE " . str_replace("timestamp", "day", $criteria_clauses[1]); } $orderby = str_replace("acid_event.", "", $sort_sql[1]); // $orderby not included $sql = "(SELECT DISTINCT ip_src, 'S', sum(cid) as num_events\n\t\tFROM ac_srcaddr_ipsrc {$where} GROUP BY ip_src HAVING num_events>0) UNION \n\t\t(SELECT DISTINCT ip_dst, 'D', sum(cid) as num_events\n\t\tFROM ac_dstaddr_ipdst {$where} GROUP BY ip_dst HAVING num_events>0)"; } //echo $sql; //print_r($_SESSION); /* Run the Query again for the actual data (with the LIMIT) */ $result = $qs->ExecuteOutputQueryNoCanned($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(); $country_acc = array(); $country_uhn = array(); $countries = array(); // Ordered $hosts_ips = array_keys($hosts); 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()) {