function nodequeue_load_nodes in Nodequeue 6.2

Same name and namespace in other branches

1. 7.3 nodequeue.module \nodequeue_load_nodes()
2. 7.2 nodequeue.module \nodequeue_load_nodes()

Load an array of node objects belonging to a particular nodequeue.

5 calls to nodequeue_load_nodes()

NodequeueExternalFetchingUnitTest::testNodequeueLoadNodes in tests/nodequeue.test

nodequeue_load_back in ./nodequeue.module

Load the last node of a queue

nodequeue_load_front in ./nodequeue.module

Load the first node of a queue

nodequeue_load_random_node in ./nodequeue.module

Load a random node object from a queue

nodequeue_view_nodes in ./nodequeue.module

Get node_view output from a nodequeue

File

./nodequeue.module, line 1412

Maintains queues of nodes in arbitrary order.

Code

function nodequeue_load_nodes($sqid, $backward = FALSE, $from = 0, $count = 5, $published_only = TRUE) {
  $orderby = $backward ? "DESC" : "ASC";
  $published_sql = '';
  if ($published_only) {
    $published_sql = 'AND n.status = 1';
  }
  $sql = db_rewrite_sql("SELECT n.nid FROM {node} n INNER JOIN {nodequeue_nodes} nn ON n.nid = nn.nid WHERE nn.sqid = %d " . $published_sql . " ORDER BY nn.position " . $orderby);
  if ($count) {
    $result = db_query_range($sql, $sqid, $from, $count);
  }
  else {
    $result = db_query($sql, $sqid);
  }
  $nodes = array();
  while ($nid = db_fetch_object($result)) {
    $nodes[] = node_load($nid->nid);
  }
  return $nodes;
}