=".ip2long($cidr_range[0])." and User_auth.ip_int<=".ip2long($cidr_range[1]); } } $enabled_filter=''; if ($enabled>0) { if ($enabled===2) { $enabled_filter = ' and (User_auth.enabled=1 and User_list.enabled=1)'; } if ($enabled===1) { $enabled_filter = ' and (User_auth.enabled=0 or User_list.enabled=0)'; } } if (isset($_POST['ip'])) { $f_ip = $_POST['ip']; } if (!isset($f_ip) and isset($_SESSION[$page_url]['ip'])) { $f_ip=$_SESSION[$page_url]['ip']; } if (!isset($f_ip)) { $f_ip=''; } $_SESSION[$page_url]['ip']=$f_ip; $ip_list_type_filter=''; if ($ip_type>0) { //suspicious if ($ip_type===3) { $ip_list_type_filter = " and (User_auth.dhcp_action IN ('add', 'old', 'del') and (ABS(User_auth.dhcp_time - User_auth.last_found)>259200) and (UNIX_TIMESTAMP()-User_auth.last_found)<259200)"; } //dhcp if ($ip_type===2) { $ip_list_type_filter = " and (User_auth.dhcp_action IN ('add', 'old', 'del'))"; } //static if ($ip_type===1) { $ip_list_type_filter = " and (User_auth.dhcp_action NOT IN ('add', 'old', 'del'))"; } } $ip_where = ''; if (!empty($f_ip)) { if (checkValidIp($f_ip)) { $ip_where = " and ip_int=inet_aton('" . $f_ip . "') "; } if (empty($ip_where)) { $ip_where =" and (mac like '" . mac_dotted($f_ip) . "%' or comments like '".$f_ip."%' or dns_name like '".$f_ip."%' or dhcp_hostname like '".$f_ip."%')"; } $ip_list_filter = $ip_where; } else { $ip_list_filter = $ou_filter.$cidr_filter.$enabled_filter.$ip_list_type_filter; } print_ip_submenu($page_url); ?>
">
- - - - : 
$total) { $page=$total; } if ($page<1) { $page=1; } $start = ($page * $displayed) - $displayed; print_navigation($page_url,$page,$displayed,$count_records[0],$total); ?>
\n"; $cl = "data"; if (!$user['enabled']) { $cl = "warn"; } if ($user['blocked']) { $cl = "error"; } if (!$user['UEnabled'] or $user['UBlocked']) { $cl = "off"; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; if (isset($user['dhcp_hostname']) and strlen($user['dhcp_hostname']) > 0) { print "\n"; } else { print "\n"; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } print "
" . WEB_cell_ou . ""; ?> " . WEB_cell_login . ""; ?> " . WEB_cell_ip . ""; ?> " . WEB_cell_mac . ""; ?> Last"; ?>
".$user['ou_name']."" . $user['login'] . "" . $user['ip'] . "" . expand_mac($db_link,$user['mac']) . "".$user['comments']." [" . $user['dhcp_hostname'] . "]".$user['comments']."".$user['dns_name']."" . get_group($db_link, $user['filter_group_id']) . "" . get_queue($db_link, $user['queue_id']) . "" . get_qa($user['save_traf']) . "" . get_qa($user['dhcp']) . "".$user['dhcp_acl']."".$user['last_found']."" . get_connection($db_link, $user['id']) . "
\n"; print_navigation($page_url,$page,$displayed,$count_records[0],$total); ?>