function nodequeue_node_titles in Nodequeue 7.2

Same name and namespace in other branches

1. 5.2 nodequeue.module \nodequeue_node_titles()
2. 5 nodequeue.module \nodequeue_node_titles()
3. 6.2 nodequeue.module \nodequeue_node_titles()
4. 7.3 nodequeue.module \nodequeue_node_titles()

In general it's preferable to use Views for this functionality.

1 call to nodequeue_node_titles()

NodequeueExternalFetchingUnitTest::testNodequeueNodeTitles in tests/nodequeue.test

File

./nodequeue.module, line 1859

Maintains queues of nodes in arbitrary order.

Code

function nodequeue_node_titles($sqid, $title = '', $backward = TRUE, $from = 0, $count = 0, $published_only = TRUE) {
  $orderby = $backward ? "DESC" : "ASC";
  $query = db_select('node', 'n')
    ->fields('n', array(
    'nid',
    'title',
  ))
    ->condition('nn.sqid', $sqid)
    ->orderBy('nn.position', $orderby)
    ->addTag('node_access');
  $query
    ->leftJoin('nodequeue_nodes', 'nn', 'n.nid = nn.nid');
  if ($published_only) {
    $query
      ->condition('n.status', 1);
  }
  if ($count) {
    $result = $query
      ->range($from, $count)
      ->execute();
  }
  else {
    $result = $query
      ->execute();
  }
  return node_title_list($result, $title);
}