0) { $gateway_filter="(router_id=?) AND"; $params[]=$rgateway; } $countSQL="SELECT Count(*) FROM traffic_detail as A WHERE $gateway_filter $ip_where ts>=? AND ts< ? "; $params[]=$date1; $params[]=$date2; $count_records = get_single_field($db_link,$countSQL, $params); $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); ?>
= ? AND ts< ? ORDER BY ts ASC LIMIT ? OFFSET ?) as T ON A.id = T.id ORDER BY $sort_table.$sort_field $order"; $params[]=$displayed; $params[]=$start; $userdata = get_records_sql($db_link, $fsql, $params); 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 "

" . get_datetime_display($row['ts']) . "

" . $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'] . "