".$port_info['device_name']." [".$port_info['port']."]
\n";
$sw_auth=NULL;
$sw_mac=NULL;
if ($port_info['vendor_id'] == 9) {
$sw_auth = get_record_sql($db_link,"SELECT mac FROM User_auth WHERE deleted=0 and ip='".$port_info['ip']."'");
$sw_mac = mac_simplify($sw_auth['mac']);
$sw_mac = preg_replace("/.{2}$/","",$sw_mac);
}
if ($port_info['snmp_index'] > 0) {
print "
\n";
print "| Список маков активных на порту |
\n";
if (! $port_info['fdb_snmp_index']) { $port_info['snmp_index'] = $port_info['port']; }
$fdb = get_fdb_port_table($port_info['ip'], $port_info['snmp_index'], $port_info['community'], $port_info['snmp_version']);
foreach ($fdb as $a_mac => $a_port) {
$a_mac = dec_to_hex($a_mac);
if (!empty($sw_mac) and preg_match('/^'.$sw_mac.'/',mac_simplify($a_mac))) { continue; }
print "";
$auth = get_auth_by_mac($db_link, $a_mac);
print "| " .$auth['auth'] . " | ". $auth['mac']." | \n";
print "
";
}
print "
\n";
}
?>
| Mac |
User |
Last found |
Список маков когда-либо обнаруженных на порту
\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 = mysqli_query($db_link, $d_sql);
while (list ($f_ip, $f_int, $f_mac, $f_auth_id, $f_dns, $f_last) = mysqli_fetch_array($t_device)) {
$name = $f_ip;
if (isset($f_dns) and $f_dns != '') {
$name = $f_dns;
}
print "";
print "| " . expand_mac($db_link,$f_mac) . " | \n";
print "" . $name . " | \n";
print "$f_last | \n";
print "
";
}
$maclist = mysqli_query($db_link, "SELECT mac,timestamp from Unknown_mac where port_id=$port_id order by timestamp desc");
while (list ($fmac, $f_last) = mysqli_fetch_array($maclist)) {
print "";
print "| " . expand_mac($db_link,$fmac) . " | \n";
print "Unknown | \n";
print "$f_last | \n";
print "
";
}
?>