function nodequeue_load_random_node in Nodequeue 6.2

Same name and namespace in other branches

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

Load a random node object from a queue

1 call to nodequeue_load_random_node()

NodequeueExternalFetchingUnitTest::testNodequeueLoadRandom in tests/nodequeue.test

File

./nodequeue.module, line 1459

Maintains queues of nodes in arbitrary order.

Code

function nodequeue_load_random_node($sqid) {
  $count = db_result(db_query(db_rewrite_sql("SELECT COUNT(n.nid) FROM {node} n INNER JOIN {nodequeue_nodes} nn ON n.nid = nn.nid WHERE nn.sqid = %d AND n.status = 1"), $sqid));
  return array_shift(nodequeue_load_nodes($sqid, TRUE, rand(0, $count - 1), 1));
}