Детализация для $fip
\n"; ?>
Топ 10 по входящему трафику
| Протокол |
Откуда |
DNS |
Порт |
Байт |
='$date1' and date(`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($dbt_link, $fsql);
while (list ($uproto, $uip, $uport, $ubytes) = mysqli_fetch_array($userdata)) {
print "\n";
print "| " . $uproto . " | \n";
print "" . long2ip($uip) . " | \n";
$ip_name = gethostbyaddr(long2ip($uip));
if (! isset($ip_name)) { $ip_name = '-'; }
print "" . $ip_name . " | \n";
print "" . $uport . " | \n";
print "" . fbytes($ubytes) . " | \n";
print "
\n";
}
?>
Топ 10 по исходящему трафику
| Протокол |
Куда |
DNS |
Порт |
Байт |
='$date1' and date(`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($dbt_link, $fsql);
while (list ($uproto, $uip, $uport, $ubytes) = mysqli_fetch_array($userdata)) {
print "\n";
print "| " . $uproto . " | \n";
print "" . long2ip($uip) . " | \n";
$ip_name = gethostbyaddr(long2ip($uip));
if (! isset($ip_name)) { $ip_name = '-'; }
print "" . $ip_name . " | \n";
print "" . $uport . " | \n";
print "" . fbytes($ubytes) . " | \n";
print "
\n";
}
?>
Полный лог
='$date1' and date(`timestamp`)<'$date2')";
$res = mysqli_query($dbt_link, $countSQL);
$count_records = mysqli_fetch_array($res);
$total=ceil($count_records[0]/$displayed);
if ($page>$total) { $page=$total; }
if ($page<1) { $page=1; }
$start = ($page * $displayed) - $displayed;
print_navigation($page_url,$page,$displayed,$count_records[0],$total);
$gateway_list = get_gateways($db_link);
?>
| Дата |
Роутер |
Протокол |
Откуда |
DNS |
Порт |
Куда |
DNS |
Порт |
Байт |
='$date1' and date(`timestamp`)<'$date2')
ORDER BY `timestamp` ASC LIMIT $start,$displayed) as T ON A.id = T.id";
$userdata = mysqli_query($dbt_link, $fsql);
while (list ($udata, $urouter, $uproto, $sip, $sport,$dip, $dport, $ubytes) = mysqli_fetch_array($userdata)) {
print "\n";
print "| $udata | \n";
print "$gateway_list[$urouter] | \n";
print "" . $uproto . " | \n";
print "" . long2ip($sip) . " | \n";
$ip_name = gethostbyaddr(long2ip($sip));
if (! isset($ip_name)) { $ip_name = '-'; }
print "" . $ip_name . " | \n";
print "" .$sport . " | \n";
print "" . long2ip($dip) . " | \n";
$ip_name = gethostbyaddr(long2ip($dip));
if (! isset($ip_name)) { $ip_name = '-'; }
print "" . $ip_name . " | \n";
print "" . $dport . " | \n";
print "" . fbytes($ubytes) . " | \n";
print "
\n";
}
?>