• '; print_url($device['name'],'/admin/devices/editdevice.php?id='.$device['id']); print_child($device['id'],$hash); print '
    • '; } } $dSQL = 'SELECT * FROM devices WHERE deleted=0'; $switches = get_records_sql($db_link,$dSQL); $dev_hash = NULL; foreach ($switches as $row) { $dev_id=$row['id']; $dev_hash[$dev_id]['id']=$dev_id; $dev_hash[$dev_id]['name']=$row['device_name']; $pSQL = 'SELECT * FROM device_ports WHERE uplink = 1 and device_id='.$dev_id; $uplink = get_record_sql($db_link,$pSQL); if (empty($uplink)) { continue; } if (empty($uplink['target_port_id'])) { continue; } $dev_hash[$dev_id]['uplink']=$uplink['port_name']; $parentSQL='SELECT * FROM device_ports WHERE device_ports.id='.$uplink['target_port_id']; $parent=get_record_sql($db_link,$parentSQL); $dev_hash[$dev_id]['parent_id']=$parent['device_id']; $dev_hash[$dev_id]['parent_port']=$parent['port_name']; } print '
    '; foreach ($dev_hash as $device) { if (isset($device['parent_id'])) { continue; } print ''; } print '
    '; require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php"); ?>