function views_revisions_page in Views Revisions 6

Same name and namespace in other branches

1. 7 views_revisions.module \views_revisions_page()

Page callback function for the views revisions page.

1 string reference to 'views_revisions_page'

views_revisions_menu in ./views_revisions.module

Implements hook_menu().

File

./views_revisions.module, line 105

A module to provide revisions of Views.

Code

function views_revisions_page($name) {
  $html = "<h2>{$name}</h2><p>" . l('Go Back to View', "admin/build/views/edit/{$name}") . " &raquo;</p>";
  $vid = db_result(db_query("SELECT vid FROM {views_view} WHERE name = '%s'", $name));
  if (!$vid) {
    $html .= t('Failed to load view!');
    return $html;
  }
  $revisions = db_query("SELECT vr.vrvid, vr.vid, vr.uid, vr.created, vr.log, u.name\n    FROM {views_revisions} vr\n    LEFT OUTER JOIN {users} u ON vr.uid = u.uid\n    WHERE vr.vid = %d\n    ORDER BY vr.created DESC", $vid);
  $header = array(
    array(
      "data" => t('User'),
    ),
    array(
      "data" => t('Message'),
    ),
    array(
      "data" => t('Created'),
    ),
    array(
      "data" => t('Revision'),
    ),
  );
  $rows = array();
  $revision_count == 0;
  while ($revision = db_fetch_object($revisions)) {
    $row = array(
      l($revision->name, "user/{$revision->uid}"),
      $revision->log,
      format_date($revision->created, 'custom', 'Y-m-d H:i:s'),
      l('View', "admin/build/views/revisions/revision/{$revision->vrvid}"),
    );
    $rows[] = $row;
    $revision_count++;
  }
  if ($revision_count == 0) {
    $html .= t('There are no revisions for this view.');
    return $html;
  }
  $html .= theme('table', $header, $rows);
  return $html;
}