0) { $gateway_filter="(router_id=$rgateway) AND"; } $countSQL="SELECT Count(*) FROM Traffic_detail as A WHERE $gateway_filter $ip_where `timestamp`>='$date1' AND `timestamp`<'$date2'"; $count_records = get_single_field($db_link,$countSQL); $total=ceil($count_records/$displayed); if ($page>$total) { $page=$total; } if ($page<1) { $page=1; } $start = ($page * $displayed) - $displayed; print_navigation($page_url,$page,$displayed,$count_records,$total); $gateway_list = get_gateways($db_link); ?>
='$date1' AND `timestamp`<'$date2' ORDER BY `timestamp` ASC LIMIT $start,$displayed) as T ON A.id = T.id ORDER BY $sort_table.$sort_field $order"; $userdata = get_records_sql($db_link, $fsql); foreach ($userdata as $row) { print "\n"; print "\n"; print "\n"; print "\n"; 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"; $ip_name = '-'; if ($rdns) { $ip_name = ResolveIP($db_link, $row['dst_ip']); } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } ?>

id"; print $url; ?>

".WEB_date.""; print $url; ?>

".WEB_traffic_source_address.""; print $url; ?>

DNS

".WEB_traffic_dest_address.""; print $url; ?>

DNS

".WEB_bytes.""; print $url; ?>

Pkt"; print $url; ?>

" . $row['id'] . "

"; print_auth_simple($db_link, $row['auth_id']); print "

" . $row['timestamp'] . "

" . $gateway_list[$row['router_id']] . "

" . $proto_name . "

" . long2ip($row['src_ip']) . "

" . $ip_name . "

" . $row['src_port'] . "

" . long2ip($row['dst_ip']) . "

" . $ip_name . "

" . $row['dst_port'] . "

" . fbytes($row['bytes']) . "

" . $row['pkt'] . "