function block_revision_list in Block Revisions 6

Same name and namespace in other branches

1. 7 block_revisions.admin.inc \block_revision_list()

Return revision information for the given block.

1 call to block_revision_list()

block_revisions_overview in ./block_revisions.admin.inc

Menu callback for the revisions overview page.

File

./block_revisions.admin.inc, line 119

Admin functions and page callbacks for the Block Revisions module.

Code

function block_revision_list($delta) {
  $revisions = array();
  $query = "SELECT vid, body, format, br.timestamp, br.log, u.uid, u.name FROM {boxes_revisions} br LEFT JOIN {users} u ON br.uid = u.uid WHERE br.bid = %d ORDER BY timestamp DESC";
  $result = db_query($query, $delta, $delta);
  while ($revision = db_fetch_object($result)) {
    $revisions[$revision->vid] = $revision;
  }
  return $revisions;
}