function _nodequeue_dragdrop_get_nodes in Nodequeue 6.2

Same name and namespace in other branches

1. 7.3 includes/nodequeue.admin.inc \_nodequeue_dragdrop_get_nodes()
2. 7.2 includes/nodequeue.admin.inc \_nodequeue_dragdrop_get_nodes()

Return a list of nodes in a specific subqueue.

1 call to _nodequeue_dragdrop_get_nodes()

nodequeue_arrange_subqueue in includes/nodequeue.admin.inc

View the contents of a subqueue, with links to re-order the queue.

File

includes/nodequeue.admin.inc, line 729

Admin page callbacks for the nodequeue module.

Code

function _nodequeue_dragdrop_get_nodes($queue, $subqueue) {
  $order = $queue->reverse ? 'DESC' : 'ASC';
  $visible = nodequeue_nids_visible($subqueue->sqid);

  // Get a list of all nodes in the subqueue, regardless of access restrictions.
  $result = db_query('SELECT DISTINCT(n.nid), nq.position FROM {node} n LEFT JOIN {nodequeue_nodes} nq ON nq.nid = n.nid WHERE nq.sqid = %d ORDER BY nq.position ' . $order, $subqueue->sqid);
  $nodes = array();
  while ($sq_node = db_fetch_object($result)) {
    $node = node_load($sq_node->nid);
    $node->visible = isset($visible[$sq_node->nid]) ? TRUE : FALSE;
    $node->position = $sq_node->position;
    $nodes[] = $node;
  }
  return $nodes;
}