function nodequeue_node_titles in Nodequeue 7.3
Same name and namespace in other branches
- 5.2 nodequeue.module \nodequeue_node_titles()
- 5 nodequeue.module \nodequeue_node_titles()
- 6.2 nodequeue.module \nodequeue_node_titles()
- 7.2 nodequeue.module \nodequeue_node_titles()
In general it's preferable to use Views for this functionality.
File
- ./
nodequeue.module, line 1437 - 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);
}