function nodequeue_node_titles in Nodequeue 5.2

Same name and namespace in other branches

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

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

File

./nodequeue.module, line 2198

Code

function nodequeue_node_titles($sqid, $title = '', $backward = true, $from = 0, $count = 0) {
  $orderby = $backward ? "DESC" : "ASC";
  $sql = db_rewrite_sql("SELECT n.nid, n.title FROM {node} n LEFT JOIN {nodequeue_nodes} nn ON n.nid = nn.nid WHERE nn.sqid = %d AND n.status = 1 ORDER BY nn.position {$orderby}");
  if ($count) {
    $result = db_query_range($sql, $sqid, $from, $count);
  }
  else {
    $result = db_query($sql, $sqid);
  }
  return node_title_list($result, $title);
}