function UpdateWhoisCache($db) { global $debug_mode, $whois_cache_lifetime; $cnt = 0; $ip_result = $db->baseExecute("SELECT DISTINCT ip_src FROM acid_event " . "LEFT JOIN acid_ip_cache ON ipc_ip = ip_src " . "WHERE ipc_whois IS NULL"); while (($row = $ip_result->baseFetchRow()) != NULL) { //if ($debug_mode > 0) echo $row[0] . " - " . baseLong2IP($row[0]) . "<BR>"; baseGetWhois(baseLong2IP($row[0]), $db, $whois_cache_lifetime); ++$cnt; } $ip_result->baseFreeRows(); $ip_result = $db->baseExecute("SELECT DISTINCT ip_dst FROM acid_event " . "LEFT JOIN acid_ip_cache ON ipc_ip = ip_dst " . "WHERE ipc_whois IS NULL"); while (($row = $ip_result->baseFetchRow()) != NULL) { //if ($debug_mode > 0) echo $row[0] . " - " . baseLong2IP($row[0]) . "<BR>"; baseGetWhois(baseLong2IP($row[0]), $db, $whois_cache_lifetime); ++$cnt; } $ip_result->baseFreeRows(); ErrorMessage(gettext("Added ") . $cnt . gettext(" hostnames to the Whois cache")); }
if ($num_dst_ip == 0) { echo '<TD ALIGN="center" bgcolor="#F2F2F2">' . $num_dst_ip . '</TD>'; } else { echo '<TD ALIGN="center" bgcolor="#F2F2F2"><A target="main" class="flnk" HREF="' . $tmp_dst_iplookup . '">' . $num_dst_ip . '</A></TD>'; } echo ' <TD align="center" bgcolor="#F2F2F2">' . $start_time . ' <TD align="center" bgcolor="#F2F2F2" valign="middle">' . $stop_time . ' </TR> </TABLE></CENTER>'; if ($action == "events") { echo '<BR> <CENTER><P>'; PrintEventsByIP($db, $ip); echo ' </CENTER>'; } else { if ($action == "whois") { echo "\n<B>" . gettext("Whois Information") . "</B>" . "<PRE>" . baseGetWhois($ip, $db, $whois_cache_lifetime) . "</PRE>"; } else { if ($action == "portscan") { echo '<HR> <CENTER><P>'; PrintPortscanEvents($db, $ip); echo ' </CENTER>'; } } } echo "\n</FORM>\n"; PrintBASESubFooter(); $et->PrintTiming(); $db->baseClose(); echo "</body>\r\n</html>";