function block_revision_load in Block Revisions 7

Same name and namespace in other branches

1. 6 block_revisions.module \block_revision_load()

File

./block_revisions.module, line 50

Code

function block_revision_load($vid, $delta) {
  $query = 'SELECT br.bid, 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 = :bid AND br.vid = :vid';
  $revision = db_query($query, array(
    ':bid' => $delta,
    ':vid' => $vid,
  ))
    ->fetchObject();
  return $revision;
}