function nodequeue_node_titles in Nodequeue 6.2
Same name and namespace in other branches
- 5.2 nodequeue.module \nodequeue_node_titles()
- 5 nodequeue.module \nodequeue_node_titles()
- 7.3 nodequeue.module \nodequeue_node_titles()
- 7.2 nodequeue.module \nodequeue_node_titles()
in general it's preferable to use Views for this functionality.
1 call to nodequeue_node_titles()
File
- ./
nodequeue.module, line 1382 - 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";
$published_sql = '';
if ($published_only) {
$published_sql = 'AND n.status = 1';
}
$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 " . $published_sql . " 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);
}