5 * @subpackage SpecialPage
9 require_once( 'Revision.php' );
14 function wfSpecialUndelete( $par ) {
17 $form = new UndeleteForm( $wgRequest, $par );
24 * @subpackage SpecialPage
29 function PageArchive( &$title ) {
30 if( is_null( $title ) ) {
31 wfDebugDieBacktrace( 'Archiver() given a null title.');
33 $this->title
=& $title;
37 * List all deleted pages recorded in the archive table. Returns result
38 * wrapper with (ar_namespace, ar_title, count) fields, ordered by page
39 * namespace/title. Can be called staticaly.
41 * @return ResultWrapper
43 /* static */ function listAllPages() {
44 $dbr =& wfGetDB( DB_SLAVE
);
45 $archive = $dbr->tableName( 'archive' );
47 $sql = "SELECT ar_namespace,ar_title, COUNT(*) AS count FROM $archive " .
48 "GROUP BY ar_namespace,ar_title ORDER BY ar_namespace,ar_title";
50 return $dbr->resultObject( $dbr->query( $sql, 'PageArchive::listAllPages' ) );
54 * List the revisions of the given page. Returns result wrapper with
55 * (ar_minor_edit, ar_timestamp, ar_user, ar_user_text, ar_comment) fields.
57 * @return ResultWrapper
59 function listRevisions() {
60 $dbr =& wfGetDB( DB_SLAVE
);
61 $res = $dbr->select( 'archive',
62 array( 'ar_minor_edit', 'ar_timestamp', 'ar_user', 'ar_user_text', 'ar_comment' ),
63 array( 'ar_namespace' => $this->title
->getNamespace(),
64 'ar_title' => $this->title
->getDBkey() ),
65 'PageArchive::listRevisions',
66 array( 'ORDER BY' => 'ar_timestamp DESC' ) );
67 $ret = $dbr->resultObject( $res );
72 * Fetch (and decompress if necessary) the stored text for the deleted
73 * revision of the page with the given timestamp.
77 function getRevisionText( $timestamp ) {
78 $fname = 'PageArchive::getRevisionText';
79 $dbr =& wfGetDB( DB_SLAVE
);
80 $row = $dbr->selectRow( 'archive',
81 array( 'ar_text', 'ar_flags', 'ar_text_id' ),
82 array( 'ar_namespace' => $this->title
->getNamespace(),
83 'ar_title' => $this->title
->getDbkey(),
84 'ar_timestamp' => $dbr->timestamp( $timestamp ) ),
86 return $this->getTextFromRow( $row );
90 * Get the text from an archive row containing ar_text, ar_flags and ar_text_id
92 function getTextFromRow( $row ) {
93 $fname = 'PageArchive::getTextFromRow';
95 if( is_null( $row->ar_text_id
) ) {
96 // An old row from MediaWiki 1.4 or previous.
97 // Text is embedded in this row in classic compression format.
98 return Revision
::getRevisionText( $row, "ar_" );
100 // New-style: keyed to the text storage backend.
101 $dbr =& wfGetDB( DB_SLAVE
);
102 $text = $dbr->selectRow( 'text',
103 array( 'old_text', 'old_flags' ),
104 array( 'old_id' => $row->ar_text_id
),
106 return Revision
::getRevisionText( $text );
112 * Fetch (and decompress if necessary) the stored text of the most
113 * recently edited deleted revision of the page.
115 * If there are no archived revisions for the page, returns NULL.
119 function getLastRevisionText() {
120 $dbr =& wfGetDB( DB_SLAVE
);
121 $row = $dbr->selectRow( 'archive',
122 array( 'ar_text', 'ar_flags', 'ar_text_id' ),
123 array( 'ar_namespace' => $this->title
->getNamespace(),
124 'ar_title' => $this->title
->getDBkey() ),
125 'PageArchive::getLastRevisionText',
126 array( 'ORDER BY' => 'ar_timestamp DESC' ) );
128 return $this->getTextFromRow( $row );
135 * Quick check if any archived revisions are present for the page.
138 function isDeleted() {
139 $dbr =& wfGetDB( DB_SLAVE
);
140 $n = $dbr->selectField( 'archive', 'COUNT(ar_title)',
141 array( 'ar_namespace' => $this->title
->getNamespace(),
142 'ar_title' => $this->title
->getDBkey() ) );
147 * This is the meaty bit -- restores archived revisions of the given page
148 * to the cur/old tables. If the page currently exists, all revisions will
149 * be stuffed into old, otherwise the most recent will go into cur.
150 * The deletion log will be updated with an undeletion notice.
152 * Returns true on success.
154 * @param array $timestamps Pass an empty array to restore all revisions, otherwise list the ones to undelete.
157 function undelete( $timestamps ) {
158 global $wgParser, $wgDBtype;
160 $fname = "doUndeleteArticle";
161 $restoreAll = empty( $timestamps );
162 $restoreRevisions = count( $timestamps );
164 $dbw =& wfGetDB( DB_MASTER
);
165 extract( $dbw->tableNames( 'page', 'archive' ) );
167 # Does this page already exist? We'll have to update it...
168 $article = new Article( $this->title
);
169 $options = ( $wgDBtype == 'PostgreSQL' )
170 ?
'' // pg doesn't support this?
172 $page = $dbw->selectRow( 'page',
173 array( 'page_id', 'page_latest' ),
174 array( 'page_namespace' => $this->title
->getNamespace(),
175 'page_title' => $this->title
->getDBkey() ),
179 # Page already exists. Import the history, and if necessary
180 # we'll update the latest revision field in the record.
182 $pageId = $page->page_id
;
183 $previousRevId = $page->page_latest
;
185 # Have to create a new article...
186 $newid = $article->insertOn( $dbw );
192 $oldones = '1 = 1'; # All revisions...
194 $oldts = implode( ',',
195 array_map( array( &$dbw, 'addQuotes' ),
196 array_map( array( &$dbw, 'timestamp' ),
199 $oldones = "ar_timestamp IN ( {$oldts} )";
203 * Restore each revision...
205 $result = $dbw->select( 'archive',
217 'ar_namespace' => $this->title
->getNamespace(),
218 'ar_title' => $this->title
->getDBkey(),
222 'ORDER BY' => 'ar_timestamp' )
225 $newRevId = $previousRevId;
227 while( $row = $dbw->fetchObject( $result ) ) {
228 if( $row->ar_text_id
) {
229 // Revision was deleted in 1.5+; text is in
230 // the regular text table, use the reference.
231 // Specify null here so the so the text is
232 // dereferenced for page length info if needed.
235 // Revision was deleted in 1.4 or earlier.
236 // Text is squashed into the archive row, and
237 // a new text table entry will be created for it.
238 $revText = Revision
::getRevisionText( $row, 'ar_' );
240 $revision = new Revision( array(
242 'id' => $row->ar_rev_id
,
244 'comment' => $row->ar_comment
,
245 'user' => $row->ar_user
,
246 'user_text' => $row->ar_user_text
,
247 'timestamp' => $row->ar_timestamp
,
248 'minor_edit' => $row->ar_minor_edit
,
249 'text_id' => $row->ar_text_id
,
251 $newRevId = $revision->insertOn( $dbw );
255 # FIXME: Update latest if newer as well...
257 # FIXME: update article count if changed...
258 $article->updateRevisionOn( $dbw, $revision, $previousRevId );
260 # Finally, clean up the link tables
261 $options = new ParserOptions
;
262 $parserOutput = $wgParser->parse( $revision->getText(), $this->title
, $options,
263 true, true, $newRevId );
264 $u = new LinksUpdate( $this->title
, $parserOutput );
267 #TODO: SearchUpdate, etc.
271 Article
::onArticleCreate( $this->title
);
273 Article
::onArticleEdit( $this->title
);
276 # Something went terribly wrong!
279 # Now that it's safely stored, take it out of the archive
280 $dbw->delete( 'archive',
282 'ar_namespace' => $this->title
->getNamespace(),
283 'ar_title' => $this->title
->getDBkey(),
288 $log = new LogPage( 'delete' );
292 $reason = wfMsgForContent( 'undeletedrevisions', $restoreRevisions );
294 $log->addEntry( 'restore', $this->title
, $reason );
303 * @subpackage SpecialPage
306 var $mAction, $mTarget, $mTimestamp, $mRestore, $mTargetObj;
307 var $mTargetTimestamp, $mAllowed;
309 function UndeleteForm( &$request, $par = "" ) {
311 $this->mAction
= $request->getText( 'action' );
312 $this->mTarget
= $request->getText( 'target' );
313 $this->mTimestamp
= $request->getText( 'timestamp' );
315 $posted = $request->wasPosted() &&
316 $wgUser->matchEditToken( $request->getVal( 'wpEditToken' ) );
317 $this->mRestore
= $request->getCheck( 'restore' ) && $posted;
318 $this->mPreview
= $request->getCheck( 'preview' ) && $posted;
321 $this->mTarget
= $par;
323 if ( $wgUser->isAllowed( 'delete' ) && !$wgUser->isBlocked() ) {
324 $this->mAllowed
= true;
326 $this->mAllowed
= false;
327 $this->mTimestamp
= '';
328 $this->mRestore
= false;
330 if ( $this->mTarget
!== "" ) {
331 $this->mTargetObj
= Title
::newFromURL( $this->mTarget
);
333 $this->mTargetObj
= NULL;
335 if( $this->mRestore
) {
336 $timestamps = array();
337 foreach( $_REQUEST as $key => $val ) {
338 if( preg_match( '/^ts(\d{14})$/', $key, $matches ) ) {
339 array_push( $timestamps, $matches[1] );
342 rsort( $timestamps );
343 $this->mTargetTimestamp
= $timestamps;
349 if( is_null( $this->mTargetObj
) ) {
350 return $this->showList();
352 if( $this->mTimestamp
!== '' ) {
353 return $this->showRevision( $this->mTimestamp
);
355 if( $this->mRestore
&& $this->mAction
== "submit" ) {
356 return $this->undelete();
358 return $this->showHistory();
361 /* private */ function showList() {
362 global $wgLang, $wgContLang, $wgUser, $wgOut;
363 $fname = "UndeleteForm::showList";
365 # List undeletable articles
366 $result = PageArchive
::listAllPages();
368 if ( $this->mAllowed
) {
369 $wgOut->setPagetitle( wfMsg( "undeletepage" ) );
371 $wgOut->setPagetitle( wfMsg( "viewdeletedpage" ) );
373 $wgOut->addWikiText( wfMsg( "undeletepagetext" ) );
375 $sk = $wgUser->getSkin();
376 $undelete =& Title
::makeTitle( NS_SPECIAL
, 'Undelete' );
377 $wgOut->addHTML( "<ul>\n" );
378 while( $row = $result->fetchObject() ) {
379 $n = ($row->ar_namespace ?
380 ($wgContLang->getNsText( $row->ar_namespace
) . ":") : "").
382 $link = $sk->makeKnownLinkObj( $undelete,
383 htmlspecialchars( $n ), "target=" . urlencode( $n ) );
384 $revisions = htmlspecialchars( wfMsg( "undeleterevisions",
385 $wgLang->formatNum( $row->count
) ) );
386 $wgOut->addHTML( "<li>$link $revisions</li>\n" );
389 $wgOut->addHTML( "</ul>\n" );
394 /* private */ function showRevision( $timestamp ) {
395 global $wgLang, $wgUser, $wgOut;
396 $fname = "UndeleteForm::showRevision";
398 if(!preg_match("/[0-9]{14}/",$timestamp)) return 0;
400 $archive =& new PageArchive( $this->mTargetObj
);
401 $text = $archive->getRevisionText( $timestamp );
403 $wgOut->setPagetitle( wfMsg( "undeletepage" ) );
404 $wgOut->addWikiText( "(" . wfMsg( "undeleterevision",
405 $wgLang->date( $timestamp ) ) . ")\n" );
407 if( $this->mPreview
) {
408 $wgOut->addHtml( "<hr />\n" );
409 $wgOut->addWikiText( $text );
412 $self = Title
::makeTitle( NS_SPECIAL
, "Undelete" );
415 wfElement( 'textarea', array(
417 'cols' => intval( $wgUser->getOption( 'cols' ) ),
418 'rows' => intval( $wgUser->getOption( 'rows' ) ) ),
420 wfOpenElement( 'div' ) .
421 wfOpenElement( 'form', array(
423 'action' => $self->getLocalURL( "action=submit" ) ) ) .
424 wfElement( 'input', array(
427 'value' => $this->mTargetObj
->getPrefixedDbKey() ) ) .
428 wfElement( 'input', array(
430 'name' => 'timestamp',
431 'value' => $timestamp ) ) .
432 wfElement( 'input', array(
434 'name' => 'wpEditToken',
435 'value' => $wgUser->editToken() ) ) .
436 wfElement( 'input', array(
440 wfElement( 'input', array(
442 'value' => wfMsg( 'showpreview' ) ) ) .
443 wfCloseElement( 'form' ) .
444 wfCloseElement( 'div' ) );
447 /* private */ function showHistory() {
448 global $wgLang, $wgUser, $wgOut;
450 $sk = $wgUser->getSkin();
451 if ( $this->mAllowed
) {
452 $wgOut->setPagetitle( wfMsg( "undeletepage" ) );
454 $wgOut->setPagetitle( wfMsg( 'viewdeletedpage' ) );
457 $archive = new PageArchive( $this->mTargetObj
);
458 $text = $archive->getLastRevisionText();
459 if( is_null( $text ) ) {
460 $wgOut->addWikiText( wfMsg( "nohistory" ) );
463 if ( $this->mAllowed
) {
464 $wgOut->addWikiText( wfMsg( "undeletehistory" ) );
466 $wgOut->addWikiText( wfMsg( "undeletehistorynoadmin" ) );
469 # List all stored revisions
470 $revisions = $archive->listRevisions();
472 if ( $this->mAllowed
) {
473 $titleObj = Title
::makeTitle( NS_SPECIAL
, "Undelete" );
474 $action = $titleObj->escapeLocalURL( "action=submit" );
475 $encTarget = htmlspecialchars( $this->mTarget
);
476 $button = htmlspecialchars( wfMsg("undeletebtn") );
477 $token = htmlspecialchars( $wgUser->editToken() );
480 <form id=\"undelete\" method=\"post\" action=\"{$action}\">
481 <input type=\"hidden\" name=\"target\" value=\"{$encTarget}\" />
482 <input type=\"submit\" name=\"restore\" value=\"{$button}\" />
483 <input type='hidden' name='wpEditToken' value=\"{$token}\" />
487 # Show relevant lines from the deletion log:
488 $wgOut->addHTML( "<h2>" . htmlspecialchars( LogPage
::logName( 'delete' ) ) . "</h2>\n" );
489 require_once( 'SpecialLog.php' );
490 $logViewer =& new LogViewer(
493 array( 'page' => $this->mTargetObj
->getPrefixedText(),
494 'type' => 'delete' ) ) ) );
495 $logViewer->showList( $wgOut );
497 # The page's stored (deleted) history:
498 $wgOut->addHTML( "<h2>" . htmlspecialchars( wfMsg( "history" ) ) . "</h2>\n" );
499 $wgOut->addHTML("<ul>");
500 $target = urlencode( $this->mTarget
);
501 while( $row = $revisions->fetchObject() ) {
502 $ts = wfTimestamp( TS_MW
, $row->ar_timestamp
);
503 if ( $this->mAllowed
) {
504 $checkBox = "<input type=\"checkbox\" name=\"ts$ts\" value=\"1\" />";
505 $pageLink = $sk->makeKnownLinkObj( $titleObj,
506 $wgLang->timeanddate( $ts, true ),
507 "target=$target×tamp=$ts" );
510 $pageLink = $wgLang->timeanddate( $ts, true );
512 $userLink = htmlspecialchars( $row->ar_user_text
);
513 if( $row->ar_user
) {
514 $userLink = $sk->makeKnownLinkObj(
515 Title
::makeTitle( NS_USER
, $row->ar_user_text
),
518 $userLink = $sk->makeKnownLinkObj(
519 Title
::makeTitle( NS_SPECIAL
, 'Contributions' ),
520 $userLink, 'target=' . $row->ar_user_text
);
522 $comment = $sk->commentBlock( $row->ar_comment
);
523 $wgOut->addHTML( "<li>$checkBox $pageLink . . $userLink $comment</li>\n" );
527 $wgOut->addHTML("</ul>");
528 if ( $this->mAllowed
) {
529 $wgOut->addHTML( "\n</form>" );
535 function undelete() {
537 if( !is_null( $this->mTargetObj
) ) {
538 $archive = new PageArchive( $this->mTargetObj
);
539 if( $archive->undelete( $this->mTargetTimestamp
) ) {
540 $wgOut->addWikiText( wfMsg( "undeletedtext", $this->mTarget
) );
542 if (NS_IMAGE
== $this->mTargetObj
->getNamespace()) {
543 /* refresh image metadata cache */
544 new Image( $this->mTargetObj
);
550 $wgOut->fatalError( wfMsg( "cannotundelete" ) );