" . $user['login'] . ""; ?>
> : 

0) { $gateway_filter="(User_stats.router_id=$rgateway) AND"; } $sSQL = "SELECT id,ip,comments FROM User_auth WHERE (User_auth.user_id=$id) Order by IP"; $usersip = mysqli_query($db_link, $sSQL); $ipcount = 0; $itog_in = 0; $itog_out = 0; while ($row = mysqli_fetch_array($usersip)) { $fid = $row["id"]; $fip = $row["ip"]; $fcomm = $row["comments"]; $sSQL = "SELECT SUM(byte_in)+SUM(byte_out) as t_sum FROM User_stats WHERE $gateway_filter User_stats.timestamp>='$date1' AND User_stats.timestamp<'$date2'AND auth_id=$fid"; $day_summary = get_record_sql($db_link, $sSQL); if (!empty($day_summary)) { $summ = $day_summary['t_sum']; } else { $summ = 0; } if ($summ > 0) { $ipcount ++; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $display_date_format='%Y-%m-%d %H'; if ($days_shift <=1) { $display_date_format='%Y-%m-%d %H'; } if ($days_shift >1 and $days_shift <=30) { $display_date_format='%Y-%m-%d'; } if ($days_shift >30 and $days_shift <=730) { $display_date_format='%Y-%m'; } if ($days_shift >730) { $display_date_format='%Y'; } $sSQL = "SELECT User_stats.router_id,DATE_FORMAT(User_stats.timestamp,'$display_date_format') as tHour,SUM(byte_in),SUM(byte_out) FROM User_stats WHERE User_stats.timestamp>='$date1' AND User_stats.timestamp<'$date2' and auth_id=$fid"; if ($rgateway == 0) { $sSQL = $sSQL . " GROUP BY DATE_FORMAT(User_stats.timestamp,'$display_date_format'),User_stats.router_id ORDER BY tHour,User_stats.router_id"; } else { $sSQL = $sSQL . " and User_stats.router_id=$rgateway GROUP BY DATE_FORMAT(User_stats.timestamp,'$display_date_format'),User_stats.router_id ORDER BY tHour"; } $userdata = mysqli_query($db_link, $sSQL); $sum_in = 0; $sum_out = 0; while (list ($u_router_id, $udata, $uin, $uout) = mysqli_fetch_array($userdata)) { print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $sum_in += $uin; $sum_out += $uout; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $itog_in += $sum_in; $itog_out += $sum_out; } } if ($ipcount > 1) { print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } ?>
$fip$fcommTOP 10".WEB_report_detail."
$gateway_list[$u_router_id]" . $udata . "" . fbytes($uin) . "" . fbytes($uout) . "
" . WEB_title_sum . " " . fbytes($sum_in) . "" . fbytes($sum_out) . "
".WEB_title_itog." " . fbytes($itog_in) . "" . fbytes($itog_out) . "