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 = mysqli_query($db_link, $fsql); while (list ($uproto, $uip, $uport, $ubytes) = mysqli_fetch_array($userdata)) { print "\n"; print "\n"; print "\n"; $ip_name = '-'; if ($rdns) { $ip_name = ResolveIP($db_link,$uip); } print "\n"; print "\n"; print "\n"; print "\n"; } ?>

		DNS
" . $uproto . "	" . long2ip($uip) . "	" . $ip_name . "	" . $uport . "	" . fbytes($ubytes) . "

='$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 = mysqli_query($db_link, $fsql); while (list ($uproto, $uip, $uport, $ubytes) = mysqli_fetch_array($userdata)) { print "\n"; if ($uproto==='6') { $uproto = 'tcp'; } if ($uproto==='17') { $uproto = 'udp'; } print "\n"; print "\n"; $ip_name = '-'; if ($rdns) { $ip_name = ResolveIP($db_link,$uip); } print "\n"; print "\n"; print "\n"; print "\n"; } ?>

		DNS
" . $uproto . "	" . long2ip($uip) . "	" . $ip_name . "	" . $uport . "	" . fbytes($ubytes) . "