- '') AND (U.ip_int BETWEEN S.ip_int_start AND S.ip_int_stop) $cidr_filter AND S.office=1 AND U.deleted=0 ORDER BY net,mac,arp_found,id"; $auth_list = get_records_sql($db_link,$sSQL, $params); $f_subnet=NULL; $f_mac=NULL; $f_id=NULL; $f_index = 0; $f_count = 0; foreach ($auth_list as $row) { if (empty($row['mac'])) { continue; } if (empty($row['net'])) { continue; } //инициализируем перебор по первой записи if (empty($f_subnet)) { $d_params = $params; //считаем сколько у нас дублей $dSQL = "SELECT U.*, S.subnet as net FROM user_auth U, subnets S WHERE S.office=1 AND U.deleted=0 AND (U.ip_int BETWEEN S.ip_int_start AND S.ip_int_stop) $cidr_filter AND U.mac=? AND S.subnet=?"; $d_params[]= $row['mac']; $d_params[]= $row['net']; $doubles = get_records_sql($db_link,$dSQL, $d_params); $f_count = count($doubles); if ($f_count > 1) { //сохраняем для обработки $f_subnet = $row['net']; $f_mac=$row['mac']; $f_id=$row['id']; $f_index = 0; } else { continue; } } //начинаем перебор - проверяем if ($row['net'] === $f_subnet and $row['mac']===$f_mac) { $f_index++; if (empty($row['arp_found']) || is_empty_datetime($row['arp_found'])) { $row['arp_found'] = ''; } if (empty($row['ts']) || is_empty_datetime($row['ts'])) { $row['ts'] = ''; } if (empty($row['changed_time']) || is_empty_datetime($row['changed_time'])) { $row['changed_time'] = ''; } print "\n"; $cl = "data"; print "\n"; print "\n"; print "\n"; print "\n"; if (isset($row['dhcp_hostname']) and strlen($row['dhcp_hostname']) > 0) { print "\n"; } else { print "\n"; } print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; } else { $f_subnet = NULL; $f_mac = NULL; $f_id = NULL; $f_index = 0; $f_count = 0; } } print "

1) { $checked = true; $mac_simplified = mac_simplify($row['mac']); $mac_rules = get_records_sql($db_link, "SELECT * FROM auth_rules WHERE rule_type = 2 AND LENGTH(rule) > 0 AND user_id = ?", [ $row['user_id'] ]); foreach ($mac_rules as $rule_row) { if (!empty($rule_row['rule'])) { $pattern = '/^' . preg_quote(mac_simplify($rule_row['rule']), '/') . '/'; if (preg_match($pattern, $mac_simplified)) { $checked = false; break; } } } if ($checked) { print " checked"; } } print ">	" . get_login($db_link,$row['user_id']) . "	" . $row['ip'] . "	" . expand_mac($db_link,$row['mac']) . "	".$row['description']." [" . $row['dhcp_hostname'] . "]	".$row['description']."	".$row['dns_name']."	".$row['ts']."	".$row['last_found']."

\n"; ?>