Детализация для $fip :: ");
?>
Топ 10 по входящему трафику
| Протокол |
Откуда |
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 = mysqli_query($db_link, $fsql);
while (list ($uproto, $uip, $uport, $ubytes) = mysqli_fetch_array($userdata)) {
print "\n";
print "| " . $uproto . " | \n";
print "" . long2ip($uip) . " | \n";
$ip_name = '-';
if ($rdns) { $ip_name = ResolveIP($db_link,$uip); }
print "" . $ip_name . " | \n";
print "" . $uport . " | \n";
print "" . fbytes($ubytes) . " | \n";
print "
\n";
}
?>
Топ 10 по исходящему трафику
| Протокол |
Куда |
DNS |
Порт |
Байт |
='$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";
print "| " . $uproto . " | \n";
print "" . long2ip($uip) . " | \n";
$ip_name = '-';
if ($rdns) { $ip_name = ResolveIP($db_link,$uip); }
print "" . $ip_name . " | \n";
print "" . $uport . " | \n";
print "" . fbytes($ubytes) . " | \n";
print "
\n";
}
?>