function node_revision_list in Drupal 7

Same name and namespace in other branches

1. 4 modules/node.module \node_revision_list()
2. 5 modules/node/node.module \node_revision_list()
3. 6 modules/node/node.module \node_revision_list()

Returns a list of all the existing revision numbers.

Parameters

$node: The node object.

Return value

An associative array keyed by node revision number.

2 calls to node_revision_list()

node_revision_overview in modules/node/node.pages.inc

Generates an overview table of older revisions of a node.

UpgradePathTaxonomyTestCase::testTaxonomyUpgrade in modules/simpletest/tests/upgrade/upgrade.taxonomy.test

Basic tests for the taxonomy upgrade.

File

modules/node/node.module, line 2225

The core that allows content to be submitted to the site. Modules and scripts may programmatically submit nodes using the usual form API pattern.

Code

function node_revision_list($node) {
  $revisions = array();
  $result = db_query('SELECT r.vid, r.title, r.log, r.uid, n.vid AS current_vid, r.timestamp, u.name FROM {node_revision} r LEFT JOIN {node} n ON n.vid = r.vid INNER JOIN {users} u ON u.uid = r.uid WHERE r.nid = :nid ORDER BY r.vid DESC', array(
    ':nid' => $node->nid,
  ));
  foreach ($result as $revision) {
    $revisions[$revision->vid] = $revision;
  }
  return $revisions;
}