".$port_info['device_name']." [".$port_info['port']."]
\n"; $sw_auth=NULL; $sw_mac=NULL; $sw_auth = get_record_sql($db_link,"SELECT mac FROM user_auth WHERE deleted=0 and ip=?", [ $port_info['ip'] ]); if (!empty($sw_auth)) { $sw_mac = mac_simplify($sw_auth['mac']); $sw_mac = preg_replace("/.{2}$/","",$sw_mac); } $snmp_ok = 0; if (!empty($device['ip']) and $device['snmp_version'] > 0) { $snmp_ok = check_snmp_access($device['ip'], $snmp); } if ($snmp_ok and $port_info['snmp_index'] > 0) { print "\n"; print "\n"; $fdb = get_fdb_table($port_info['ip'], $snmp); $f_port = $port_info['snmp_index']; $port_by_snmp = 0; if (!empty($fdb)) { foreach ($fdb as $a_mac => $a_port) { if (!empty($ports_by_snmp_index[$a_port])) { $port_by_snmp=1; break; } } } if (!$port_by_snmp) { $f_port = $port_info['port']; } if (!empty($fdb)) { foreach ($fdb as $a_mac => $a_port) { if ($a_port == $f_port) { $a_mac = dec_to_hex($a_mac); //mikrotik patch if (!empty($sw_mac) and preg_match('/^'.$sw_mac.'/',mac_simplify($a_mac))) { continue; } print ""; $auth = get_auth_by_mac($db_link, $a_mac); if (!empty($auth)) { print "\n"; } print ""; } } } print "

".WEB_device_port_mac_table_show."
" .$auth['auth'] . "	". $auth['mac']."

\n"; } else { print "No SNMP access!"; } unset_lock_discovery($db_link,$device_id); ?> ".WEB_device_port_mac_table_history."
\n"; $d_sql = "select A.ip,A.ip_int,A.mac,A.id,A.dns_name,A.last_found from user_auth as A, connections as C where C.port_id=$port_id and A.id=C.auth_id ORDER BY A.ip_int"; $t_device = get_records_sql($db_link, $d_sql); if (!empty($t_device)) { foreach ($t_device as $row) { $name = $row['ip']; if (!empty($row['dns_name']) and isset($row['dns'])) { $name = $row['dns_name']; } print ""; print "\n"; print "\n"; print "\n"; print ""; } } $maclist = get_records_sql($db_link, "SELECT mac,ts from unknown_mac where port_id=? ORDER BY ts desc", [ $port_id ]); if (!empty($maclist)) { foreach ($maclist as $row) { print ""; print "\n"; print "\n"; print "\n"; print ""; } } print "

" . expand_mac($db_link,$row['mac']) . "	" . $name . "	".get_datetime_display($row['last_found'])."
" . expand_mac($db_link,$row['mac']) . "	Unknown	".get_datetime_display($row['ts'])."

\n"; require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/footer.php"); ?>