='$date1' AND User_stats_full.timestamp<'$date2' "; if ($rou !== 0) { $trafSQL = $trafSQL . " AND User_list.ou_id=$rou"; } if ($rgateway == 0) { $trafSQL = $trafSQL . " GROUP by User_auth.id,User_stats_full.router_id"; } else { $trafSQL = $trafSQL . " AND User_stats_full.router_id=$rgateway GROUP by User_auth.id,User_stats_full.router_id"; } $countSQL = "SELECT Count(*) FROM ($trafSQL) A"; $res = mysqli_query($db_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; #set sort $trafSQL=$trafSQL ." $sort_sql LIMIT $start,$displayed"; print_navigation($page_url,$page,$displayed,$count_records[0],$total); print "

\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $total_in = 0; $total_out = 0; $traf = mysqli_query($db_link, $trafSQL); while (list ($s_login,$s_ou_id,$u_id,$s_ip,$s_auth_id, $s_router_id, $traf_day_in, $traf_day_out, $p_in, $p_out) = mysqli_fetch_array($traf)) { if ($traf_day_in + $traf_day_out ==0) { continue; } $total_in += $traf_day_in; $total_out += $traf_day_out; $s_router = $gateway_list[$s_router_id]; $cl = "data"; if ($traf_day_out > 2 * $traf_day_in) { $cl = "nb"; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; ?>

Логин	IP	Gate	Входящий	Исходящий	Max in, pkt/s	Max out, pkt/s
$s_login	$s_ip	$s_router	" . fbytes($traf_day_in) . "	" . fbytes($traf_day_out) . "	" . fpkts($p_in) . "	" . fpkts($p_out) . "
Итого			" . fbytes($total_in) . "	" . fbytes($total_out) . "