• '; print_url($device['parent_port'].'->'.$device['uplink'].' '.$device['name'].' :: ['.$device['model_name'].']','/admin/devices/editdevice.php?id='.$device['id']); print_child($device['id'],$hash); print '
    • '; } } $dSQL = 'SELECT D.*,DM.model_name FROM devices as D,device_models as DM WHERE D.device_model_id=DM.id AND (deleted=0 and device_type<=2)'; $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']; $dev_hash[$dev_id]['model_name']=$row['model_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"); ?>