=? and user_auth.ip_int<=?"; } $params[]=ip2long($cidr_range[0]); $params[]=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)'; } } $dynamic_filter=''; if ($dynamic_enabled>0) { if ($dynamic_enabled ==1) { $dynamic_filter = ' and user_auth.dynamic=1'; } if ($dynamic_enabled ==2) { $dynamic_filter = ' and user_auth.dynamic=0'; } } $dhcp_filter=''; if ($dhcp_enabled>0) { if ($dhcp_enabled ==1) { $dhcp_filter = ' and user_auth.dhcp=1'; } if ($dhcp_enabled ==2) { $dhcp_filter = ' and user_auth.dhcp=0'; } } if (isset($_POST['search_str'])) { $f_search_str = trim($_POST['search_str']); } if (!isset($f_search_str) and isset($_SESSION[$page_url]['search_str'])) { $f_search_str=$_SESSION[$page_url]['search_str']; } if (!isset($f_search_str)) { $f_search_str=''; } $_SESSION[$page_url]['search_str']=$f_search_str; $f_search=replaceSpecialChars($f_search_str); $ip_list_type_filter=''; if ($ip_type>0) { //suspicious - dhcp not found 3 last days 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.arp_found)>259200) and (UNIX_TIMESTAMP()-user_auth.arp_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_search_str)) { $f_ip = normalizeIpAddress($f_search_str); if (!empty($f_ip)) { $ip_where = " and ip=?"; $params[]= $f_ip; $f_search_str = $f_ip; } else { if (checkValidMac($f_search_str)) { $ip_where =" and mac=?"; $params[]= mac_dotted($f_search_str); } else { $ip_where =" and (mac LIKE ? or login LIKE ? or user_auth.description LIKE ? or user_list.description LIKE ? or dns_name LIKE ? or dhcp_hostname LIKE ?)"; $mac_search = MaybeMac($f_search); if (!empty($mac_search)) { $params[]=MaybeMac($f_search).'%'; } else { $params[]=$f_search_str.'%'; } $params[]=$f_search.'%'; $params[]=$f_search.'%'; $params[]=$f_search.'%'; $params[]=$f_search.'%'; $params[]=$f_search.'%'; } } } $ip_list_filter = $ou_filter.$cidr_filter.$enabled_filter.$ip_list_type_filter.$dynamic_filter.$dhcp_filter.$ip_where; 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,$total); ?>
\n"; $cl = "data"; if (!$user['enabled']) { $cl = "warn"; } if ($user['blocked']) { $cl = "error"; } if ($user['uenabled'] !== 1 || $user['ublocked'] == 1) { $cl = "off"; } print "\n"; print "\n"; if (empty($user['login'])) { $user_name = $user['user_id']; } else { $user_name = $user['login']; } print "\n"; print "\n"; print "\n"; if (isset($user['dhcp_hostname']) and strlen($user['dhcp_hostname']) > 0) { print "\n"; } else { print "\n"; } $aliases = get_records_sql($db_link, 'SELECT * FROM user_auth_alias WHERE auth_id=?', [$user['id']]); $dns_display = $user['dns_name']; if ($user["dns_ptr_only"]) { $dns_display.=' (ptr)'; } if (!empty($aliases)) { $dns_display .= '
'; $alias_list = []; foreach ($aliases as $alias) { $alias_list[] = htmlspecialchars($alias['alias'], ENT_QUOTES, 'UTF-8'); } $dns_display .= implode('
', $alias_list); } print "\n"; print "\n"; print "\n"; print_td_qa($user['save_traf'],FALSE,$cl); print_td_qa($user['dhcp'],FALSE,$cl); print "\n"; print "\n"; print "\n"; print "\n"; } print "
" . WEB_cell_ou . ""; ?> " . WEB_cell_login . ""; ?> " . WEB_cell_ip . ""; ?> " . WEB_cell_mac . ""; ?> Arp/Mac"; ?>
".$user['ou_name']."" . $user_name . "" . $user['ip'] . "" . expand_mac($db_link,$user['mac']) . "".$user['description']." [" . $user['dhcp_hostname'] . "]".$user['description']."".$dns_display."" . get_group($db_link, $user['filter_group_id']) . "" . get_queue($db_link, $user['queue_id']) . "".$user['dhcp_acl'].""; if (!empty($user['arp_found'])) { print $user['arp_found']; } else { print "-"; } print " / "; if (!empty($user['mac_found'])) { print $user['mac_found']; } else { print "-"; } print "" . get_connection($db_link, $user['id']) . "
\n"; print_navigation($page_url,$page,$displayed,$count_records,$total); ?>