$this->title =& $title;
}
+ /**
+ * List all deleted pages recorded in the archive table. Returns result
+ * wrapper with (ar_namespace, ar_title, count) fields, ordered by page
+ * namespace/title. Can be called staticaly.
+ *
+ * @return ResultWrapper
+ */
/* static */ function &listAllPages() {
$dbr =& wfGetDB( DB_SLAVE );
$archive = $dbr->tableName( 'archive' );
return $dbr->resultObject( $dbr->query( $sql, 'PageArchive::listAllPages' ) );
}
+ /**
+ * List the revisions of the given page. Returns result wrapper with
+ * (ar_minor_edit, ar_timestamp, ar_user, ar_user_text, ar_comment) fields.
+ *
+ * @return ResultWrapper
+ */
function &listRevisions() {
$dbr =& wfGetDB( DB_SLAVE );
- $sql = "SELECT ar_minor_edit,ar_timestamp,ar_user,ar_user_text,ar_comment
- FROM archive WHERE ar_namespace=" . $this->title->getNamespace() .
- " AND ar_title='" . $dbr->strencode( $this->title->getDBkey() ) .
- "' ORDER BY ar_timestamp DESC";
- return $dbr->resultObject( $dbr->query( $sql ) );
+ return $dbr->resultObject( $dbr->select( 'archive',
+ array( 'ar_minor_edit', 'ar_timestamp', 'ar_user', 'ar_user_text', 'ar_comment' ),
+ array( 'ar_namespace' => $this->title->getNamespace(),
+ 'ar_title' => $this->title->getDBkey() ),
+ 'PageArchive::listRevisions',
+ array( 'ORDER BY' => 'ar_timestamp DESC' ) ) );
}
+ /**
+ * Fetch (and decompress if necessary) the stored text for the deleted
+ * revision of the page with the given timestamp.
+ *
+ * @return string
+ */
function getRevisionText( $timestamp ) {
$dbr =& wfGetDB( DB_SLAVE );
$row = $dbr->selectRow( 'archive',
array( 'ar_text', 'ar_flags' ),
array( 'ar_namespace' => $this->title->getNamespace(),
'ar_title' => $this->title->getDbkey(),
- 'ar_timestamp' => $timestamp ) );
+ 'ar_timestamp' => $dbr->timestamp( $timestamp ) ) );
return Article::getRevisionText( $row, "ar_" );
}
+ /**
+ * Fetch (and decompress if necessary) the stored text of the most
+ * recently edited deleted revision of the page.
+ *
+ * If there are no archived revisions for the page, returns NULL.
+ *
+ * @return string
+ */
function getLastRevisionText() {
$dbr =& wfGetDB( DB_SLAVE );
- $archive = $dbr->tableName( 'archive' );
-
- # Get text of first revision
- $sql = "SELECT ar_text,ar_flags FROM $archive WHERE ar_namespace=" . $this->title->getNamespace() . " AND ar_title='" .
- $dbr->strencode( $this->title->getDBkey() ) . "' ORDER BY ar_timestamp DESC LIMIT 1";
- $ret = $dbr->query( $sql );
- $row = $dbr->fetchObject( $ret );
- $dbr->freeResult( $ret );
+ $row = $dbr->selectRow( 'archive',
+ array( 'ar_text', 'ar_flags' ),
+ array( 'ar_namespace' => $this->title->getNamespace(),
+ 'ar_title' => $this->title->getDBkey() ),
+ 'PageArchive::getLastRevisionText',
+ 'ORDER BY ar_timestamp DESC LIMIT 1' );
if( $row ) {
return Article::getRevisionText( $row, "ar_" );
} else {
}
}
+ /**
+ * Quick check if any archived revisions are present for the page.
+ * @return bool
+ */
function isDeleted() {
$dbr =& wfGetDB( DB_SLAVE );
$n = $dbr->selectField( 'archive', 'COUNT(ar_title)',
return ($n > 0);
}
- function undelete() {
+ /**
+ * This is the meaty bit -- restores archived revisions of the given page
+ * to the cur/old tables. If the page currently exists, all revisions will
+ * be stuffed into old, otherwise the most recent will go into cur.
+ * The deletion log will be updated with an undeletion notice.
+ *
+ * Returns true on success.
+ *
+ * @param array $timestamps Pass an empty array to restore all revisions, otherwise list the ones to undelete.
+ * @return bool
+ */
+ function undelete( $timestamps ) {
global $wgUser, $wgOut, $wgLang, $wgDeferredUpdateList;
- global $wgUseSquid, $wgInternalServer, $wgLinkCache;
+ global $wgUseSquid, $wgInternalServer, $wgLinkCache;
$fname = "doUndeleteArticle";
+ $restoreAll = empty( $timestamps );
+ $restoreRevisions = count( $timestamps );
$dbw =& wfGetDB( DB_MASTER );
extract( $dbw->tableNames( 'cur', 'archive', 'old' ) );
$namespace = $this->title->getNamespace();
- $t = $dbw->strencode( $this->title->getDBkey() );
+ $ttl = $this->title->getDBkey();
+ $t = $dbw->strencode( $ttl );
# Move article and history from the "archive" table
- $sql = "SELECT COUNT(*) AS count FROM $cur WHERE cur_namespace={$namespace} AND cur_title='{$t}' FOR UPDATE";
+ $sql = "SELECT COUNT(*) AS count FROM $cur WHERE cur_namespace={$namespace} AND cur_title='{$t}'";
+ global $wgDBtype;
+ if( $wgDBtype != 'PostgreSQL' ) { # HACKHACKHACKHACK
+ $sql .= ' FOR UPDATE';
+ }
$res = $dbw->query( $sql, $fname );
$row = $dbw->fetchObject( $res );
$now = wfTimestampNow();
if( $row->count == 0) {
# Have to create new article...
- $sql = "SELECT ar_text,ar_timestamp,ar_flags FROM $archive WHERE ar_namespace={$namespace} AND ar_title='{$t}' " .
- "ORDER BY ar_timestamp DESC LIMIT 1 FOR UPDATE";
+ $sql = "SELECT ar_text,ar_comment,ar_user,ar_user_text,ar_timestamp,ar_minor_edit,ar_flags FROM $archive WHERE ar_namespace={$namespace} AND ar_title='{$t}' ";
+ if( !$restoreAll ) {
+ $max = $dbw->addQuotes( $dbw->timestamp( array_shift( $timestamps ) ) );
+ $sql .= "AND ar_timestamp={$max} ";
+ }
+ $sql .= "ORDER BY ar_timestamp DESC LIMIT 1 FOR UPDATE";
$res = $dbw->query( $sql, $fname );
$s = $dbw->fetchObject( $res );
- $max = $s->ar_timestamp;
+ if( $restoreAll ) {
+ $max = $s->ar_timestamp;
+ }
+ $text = Article::getRevisionText( $s, "ar_" );
+
$redirect = MagicWord::get( MAG_REDIRECT );
- $redir = $redirect->matchStart( $s->ar_text ) ? 1 : 0;
+ $redir = $redirect->matchStart( $text ) ? 1 : 0;
+
+ $rand = wfRandom();
+ $dbw->insert( 'cur', array(
+ 'cur_id' => $dbw->nextSequenceValue( 'cur_cur_id_seq' ),
+ 'cur_namespace' => $namespace,
+ 'cur_title' => $ttl,
+ 'cur_text' => $text,
+ 'cur_comment' => $s->ar_comment,
+ 'cur_user' => $s->ar_user,
+ 'cur_timestamp' => $s->ar_timestamp,
+ 'cur_minor_edit' => $s->ar_minor_edit,
+ 'cur_user_text' => $s->ar_user_text,
+ 'cur_is_redirect' => $redir,
+ 'cur_random' => $rand,
+ 'cur_touched' => $dbw->timestamp( $now ),
+ 'inverse_timestamp' => wfInvertTimestamp( wfTimestamp( TS_MW, $s->ar_timestamp ) ),
+ ), $fname );
- $seqVal = $dbw->addQuotes( $dbw->nextSequenceValue( 'cur_cur_id_seq' ) );
-
- $sql = "INSERT INTO $cur (cur_id,cur_namespace,cur_title,cur_text," .
- "cur_comment,cur_user,cur_user_text,cur_timestamp,inverse_timestamp,cur_minor_edit,cur_is_redirect,cur_random,cur_touched)" .
- "SELECT $seqVal,ar_namespace,ar_title,ar_text,ar_comment," .
- "ar_user,ar_user_text,ar_timestamp,99999999999999-ar_timestamp,ar_minor_edit,{$redir},RAND(),'{$now}' FROM $archive " .
- "WHERE ar_namespace={$namespace} AND ar_title='{$t}' AND ar_timestamp={$max}";
- $dbw->query( $sql, $fname );
$newid = $dbw->insertId();
- $oldones = "AND ar_timestamp<{$max}";
+ if( $restoreAll ) {
+ $oldones = "AND ar_timestamp<" . $dbw->addQuotes( $dbw->timestamp( $max ) );
+ }
} else {
# If already exists, put history entirely into old table
$oldones = "";
# We should merge.
}
+ if( !$restoreAll ) {
+ $oldts = array();
+ foreach( $timestamps as $ts ) {
+ array_push( $oldts, $dbw->addQuotes( $dbw->timestamp( $ts ) ) );
+ }
+ $oldts = join( ",", $oldts );
+ $oldones = "AND ar_timestamp IN ( {$oldts} )";
+ }
$sql = "INSERT INTO $old (old_namespace,old_title,old_text," .
"old_comment,old_user,old_user_text,old_timestamp,inverse_timestamp,old_minor_edit," .
"old_flags) SELECT ar_namespace,ar_title,ar_text,ar_comment," .
"ar_user,ar_user_text,ar_timestamp,99999999999999-ar_timestamp,ar_minor_edit,ar_flags " .
"FROM $archive WHERE ar_namespace={$namespace} AND ar_title='{$t}' {$oldones}";
- $dbw->query( $sql, $fname );
+ if( $restoreAll || !empty( $oldts ) ) {
+ $dbw->query( $sql, $fname );
+ }
# Finally, clean up the link tables
if( $newid ) {
$wgLinkCache->forUpdate( true );
# Create a dummy OutputPage to update the outgoing links
$dummyOut = new OutputPage();
- # Get the text
- $text = $dbw->selectField( 'cur', 'cur_text',
- array( 'cur_id' => $newid, 'cur_namespace' => $namespace ),
- $fname, 'FOR UPDATE'
- );
$dummyOut->addWikiText( $text );
$u = new LinksUpdate( $newid, $this->title->getPrefixedDBkey() );
# Now that it's safely stored, take it out of the archive
$sql = "DELETE FROM $archive WHERE ar_namespace={$namespace} AND " .
"ar_title='{$t}'";
+ if( !$restoreAll ) {
+ $sql .= " AND ar_timestamp IN ( {$oldts}";
+ if( $newid ) {
+ if( !empty( $oldts ) ) $sql .= ",";
+ $sql .= $max;
+ }
+ $sql .= ")";
+ }
$dbw->query( $sql, $fname );
# Touch the log?
$log = new LogPage( 'delete' );
- $log->addEntry( 'restore', $this->title, "" );
+ if( $restoreAll ) {
+ $reason = "";
+ } else {
+ $reason = wfMsg( 'undeletedrevisions', $restoreRevisions );
+ }
+ $log->addEntry( 'restore', $this->title, $reason );
return true;
}
*/
class UndeleteForm {
var $mAction, $mTarget, $mTimestamp, $mRestore, $mTargetObj;
+ var $mTargetTimestamp;
function UndeleteForm( &$request, $par = "" ) {
$this->mAction = $request->getText( 'action' );
} else {
$this->mTargetObj = NULL;
}
+ if( $this->mRestore ) {
+ $timestamps = array();
+ foreach( $_REQUEST as $key => $val ) {
+ if( preg_match( '/^ts(\d{14})$/', $key, $matches ) ) {
+ array_push( $timestamps, $matches[1] );
+ }
+ }
+ rsort( $timestamps );
+ $this->mTargetTimestamp = $timestamps;
+ }
}
function execute() {
}
/* private */ function showList() {
- global $wgLang, $wgUser, $wgOut;
+ global $wgLang, $wgContLang, $wgUser, $wgOut;
$fname = "UndeleteForm::showList";
# List undeletable articles
$wgOut->addHTML( "<ul>\n" );
while( $row = $result->fetchObject() ) {
$n = ($row->ar_namespace ?
- ($wgLang->getNsText( $row->ar_namespace ) . ":") : "").
+ ($wgContLang->getNsText( $row->ar_namespace ) . ":") : "").
$row->ar_title;
$link = $sk->makeKnownLinkObj( $undelete,
htmlspecialchars( $n ), "target=" . urlencode( $n ) );
<form id=\"undelete\" method=\"post\" action=\"{$action}\">
<input type=\"hidden\" name=\"target\" value=\"{$encTarget}\" />
<input type=\"submit\" name=\"restore\" value=\"{$button}\" />
- </form>");
+ ");
# Show relevant lines from the deletion log:
$wgOut->addHTML( "<h2>" . htmlspecialchars( LogPage::logName( 'delete' ) ) . "</h2>\n" );
$logViewer =& new LogViewer(
new LogReader(
new FauxRequest(
- array( 'page', $this->mTargetObj->getPrefixedText() ) ) ) );
+ array( 'page' => $this->mTargetObj->getPrefixedText(),
+ 'type' => 'delete' ) ) ) );
$logViewer->showList( $wgOut );
# The page's stored (deleted) history:
$wgOut->addHTML("<ul>");
$target = urlencode( $this->mTarget );
while( $row = $revisions->fetchObject() ) {
+ $ts = wfTimestamp( TS_MW, $row->ar_timestamp );
+ $checkBox = "<input type=\"checkbox\" name=\"ts$ts\" value=\"1\" />";
$pageLink = $sk->makeKnownLinkObj( $titleObj,
$wgLang->timeanddate( $row->ar_timestamp, true ),
- "target=$target×tamp={$row->ar_timestamp}" );
+ "target=$target×tamp=$ts" );
$userLink = htmlspecialchars( $row->ar_user_text );
if( $row->ar_user ) {
$userLink = $sk->makeKnownLinkObj(
$userLink );
}
$comment = $sk->formatComment( $row->ar_comment );
- $wgOut->addHTML( "<li>$pageLink . . $userLink (<i>$comment</i>)</li>\n" );
+ $wgOut->addHTML( "<li>$checkBox $pageLink . . $userLink (<i>$comment</i>)</li>\n" );
}
$revisions->free();
- $wgOut->addHTML("</ul>");
+ $wgOut->addHTML("</ul>\n</form>");
return true;
}
global $wgOut;
if( !is_null( $this->mTargetObj ) ) {
$archive = new PageArchive( $this->mTargetObj );
- if( $archive->undelete() ) {
+ if( $archive->undelete( $this->mTargetTimestamp ) ) {
$wgOut->addWikiText( wfMsg( "undeletedtext", $this->mTarget ) );
return true;
}