'); echo('DeviceVPNASNRouter IDPortsNeighboursRoutes'); foreach (dbFetchRows("SELECT * FROM `eigrp_ases` LEFT JOIN `eigrp_vpns` USING (`device_id`, `eigrp_vpn`) WHERE 1 ".$GLOBALS['cache']['where']['devices_permitted']) as $as) { $device = device_by_id_cache($as['device_id']); $port_count = dbFetchCell("SELECT COUNT(*) FROM `eigrp_ports` WHERE device_id = ? AND `eigrp_vpn` = ? AND `eigrp_as` = ?", array($as['device_id'], $as['eigrp_vpn'], $as['eigrp_as'])); //$peer_count = dbFetchCell("SELECT COUNT(*) FROM `eigrp_peers` WHERE device_id = ? AND `eigrp_vpn` = ? AND `eigrp_as` = ?", array($as['device_id'], $as['eigrp_vpn'], $as['eigrp_as'])); echo(''); echo(' '.generate_device_link($device, NULL, [ 'tab' => 'routing', 'proto' => 'eigrp' ]). ''); echo(' '.$as['eigrp_vpn_name'] . ''); echo(' ' . $as['eigrp_as'] . ''); echo(' ' . $as['cEigrpAsRouterId'] . ''); echo(' ' . $port_count . ''); echo(' ' . $as['cEigrpNbrCount'] . ''); echo(' ' . $as['cEigrpTopoRoutes'] . ''); //echo(' ' . $peer_count . ''); echo(''); } echo(''); echo generate_box_close(); // EOF