$value) { if ($value != '') { switch ($var) { case 'device': case 'device_id': $where .= generate_query_values_and($value, 'device_id'); break; case 'interface': $where .= generate_query_values_and($value, 'ifDescr', 'LIKE'); break; case 'address': $value = str_replace([':', ' ', '-', '.', '0x'], '', $value); $where .= generate_query_values_and($value, 'ifPhysAddress', '%LIKE%'); break; } } } $where .= ' AND `ifPhysAddress` IS NOT NULL'; //Exclude empty MACs // Show MACs only for permitted ports $query_permitted = generate_query_permitted(['port']); $query = 'FROM `ports` '; $query .= $where . $query_permitted; $query_count = 'SELECT COUNT(*) ' . $query; $query = 'SELECT * ' . $query; $query .= ' ORDER BY `ifPhysAddress`'; $query .= " LIMIT $start,$pagesize"; // Query addresses $entries = dbFetchRows($query, $param); // Query address count if ($pagination) { $count = dbFetchCell($query_count, $param); } $list = ['device' => FALSE]; if (!isset($vars['device']) || empty($vars['device']) || $vars['page'] == 'search') { $list['device'] = TRUE; } $string = generate_box_open($vars['header']); $string .= '' . PHP_EOL; if (!$short) { $string .= ' ' . PHP_EOL; $string .= ' ' . PHP_EOL; if ($list['device']) { $string .= ' ' . PHP_EOL; } $string .= ' ' . PHP_EOL; $string .= ' ' . PHP_EOL; $string .= ' ' . PHP_EOL; $string .= ' ' . PHP_EOL; $string .= ' ' . PHP_EOL; } $string .= ' ' . PHP_EOL; foreach ($entries as $entry) { if (port_permitted($entry['port_id'])) { humanize_port($entry); $string .= ' ' . PHP_EOL; if ($list['device']) { $dev = device_by_id_cache($entry['device_id']); $string .= ' ' . PHP_EOL; } if ($entry['ifInErrors_delta'] > 0 || $entry['ifOutErrors_delta'] > 0) { $port_error = generate_port_link($entry, 'Errors', 'port_errors'); } $string .= ' ' . PHP_EOL; $string .= ' ' . PHP_EOL; $string .= ' ' . PHP_EOL; $string .= ' ' . PHP_EOL; } } $string .= ' ' . PHP_EOL; $string .= '

Device	Interface	MAC Address	Description
' . generate_device_link($dev) . '	' . generate_port_link_short($entry) . ' ' . $port_error . '	' . generate_popup_link('mac', $entry['human_mac'], ['page' => 'search', 'search' => 'mac', 'address' => $entry['human_mac']]) . '	' . $entry['ifAlias'] . '

'; $string .= generate_box_close(); // Print pagination header if ($pagination) { $string = pagination($vars, $count) . $string . pagination($vars, $count); } // Print MAC addresses echo $string; } // EOF