:  : 

\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $sort_sql=" ORDER BY tin DESC"; if (!empty($sort_field) and !empty($order)) { $sort_sql = " ORDER BY $sort_field $order"; } $gateway_list = get_gateways($db_link); $trafSQL = "SELECT User_list.login,User_list.ou_id,User_auth.user_id, User_stats.auth_id, User_stats.router_id, SUM( byte_in ) AS tin, SUM( byte_out ) AS tout FROM User_stats,User_auth,User_list WHERE User_list.id=User_auth.user_id AND User_stats.auth_id = User_auth.id AND User_stats.timestamp>='$date1' AND User_stats.timestamp<'$date2' "; if ($rou !== 0) { $trafSQL = $trafSQL . " AND User_list.ou_id=$rou"; } if ($rgateway == 0) { $trafSQL = $trafSQL . " GROUP by User_auth.user_id,User_stats.router_id"; } else { $trafSQL = $trafSQL . " AND User_stats.router_id=$rgateway GROUP by User_auth.user_id,User_stats.router_id"; } #set sort $trafSQL=$trafSQL ." $sort_sql"; $total_in = 0; $total_out = 0; $traf = get_records_sql($db_link, $trafSQL); foreach ($traf as $row) { if ($row['tin'] + $row['tout'] == 0) { continue; } $total_in += $row['tin']; $total_out += $row['tout']; $s_router = !empty($gateway_list[$row['router_id']]) ? $gateway_list[$row['router_id']] : ''; $cl = $row['tout'] > 2 * $row['tin'] ? "nb" : "data"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; ?>

".WEB_cell_login."	".WEB_cell_gateway."	".WEB_title_input."	".WEB_title_output."
" . $row['login'] . "	$s_router	" . fbytes($row['tin']) . "	" . fbytes($row['tout']) . "
".WEB_title_itog."		" . fbytes($total_in) . "	" . fbytes($total_out) . "