> :  DNS:  >

0) { $gateway_filter="(router_id=$rgateway) AND"; } $fsql = "SELECT A.proto, A.src_ip, A.src_port, SUM(A.bytes) as tin FROM traffic_detail A WHERE $gateway_filter (auth_id='$id') and `timestamp`>='$date1' and `timestamp`<'$date2' and (A.dst_ip='$ip_aton') GROUP BY A.src_ip, A.src_port, A.proto ORDER BY tin DESC LIMIT 0,10"; $userdata = get_records_sql($db_link, $fsql); foreach ($userdata as $row) { print "\n"; $proto_name = getprotobynumber($row['proto']); if (!$proto_name) { $proto_name = $row['proto']; } print "\n"; print "\n"; $ip_name = '-'; if ($rdns) { $ip_name = ResolveIP($db_link, $row['src_ip']); } print "\n"; print "\n"; print "\n"; print "\n"; } ?>

		DNS
" . $proto_name . "	" . long2ip($row['src_ip']) . "	" . $ip_name . "	" . $row['src_port'] . "	" . fbytes($row['tin']) . "

='$date1' and `timestamp`<'$date2' and (A.src_ip='$ip_aton') GROUP BY A.dst_ip, A.dst_port, A.proto ORDER BY tout DESC LIMIT 0,10"; $userdata = get_records_sql($db_link, $fsql); foreach ($userdata as $row) { print "\n"; $proto_name = getprotobynumber($row['proto']); if (!$proto_name) { $proto_name = $row['proto']; } print "\n"; print "\n"; $ip_name = '-'; if ($rdns) { $ip_name = ResolveIP($db_link, $row['dst_ip']); } print "\n"; print "\n"; print "\n"; print "\n"; } ?>

		DNS
" . $proto_name . "	" . long2ip($row['dst_ip']) . "	" . $ip_name . "	" . $row['dst_port'] . "	" . fbytes($row['tout']) . "