X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FSpecialUndelete.php;h=7c9b119111cadbb45824610bc5e4ec6429cf6ea8;hb=d1d393295415f9711ea36bd60e2b72047489cabe;hp=9f2f8e2963e6b2e446199cbfd7a55d5a835f6f0b;hpb=549d49951e615b45e143e71909c44a08ed170338;p=lhc%2Fweb%2Fwiklou.git diff --git a/includes/SpecialUndelete.php b/includes/SpecialUndelete.php index 9f2f8e2963..7c9b119111 100644 --- a/includes/SpecialUndelete.php +++ b/includes/SpecialUndelete.php @@ -1,243 +1,767 @@ execute(); } +/** + * + * @package MediaWiki + * @subpackage SpecialPage + */ +class PageArchive { + var $title; + + function PageArchive( &$title ) { + if( is_null( $title ) ) { + throw new MWException( 'Archiver() given a null title.'); + } + $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' ); + + $sql = "SELECT ar_namespace,ar_title, COUNT(*) AS count FROM $archive " . + "GROUP BY ar_namespace,ar_title ORDER BY ar_namespace,ar_title"; + + 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 ); + $res = $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' ) ); + $ret = $dbr->resultObject( $res ); + return $ret; + } + + /** + * List the deleted file revisions for this page, if it's a file page. + * Returns a result wrapper with various filearchive fields, or null + * if not a file page. + * + * @return ResultWrapper + * @fixme Does this belong in Image for fuller encapsulation? + */ + function listFiles() { + if( $this->title->getNamespace() == NS_IMAGE ) { + $dbr =& wfGetDB( DB_SLAVE ); + $res = $dbr->select( 'filearchive', + array( + 'fa_id', + 'fa_name', + 'fa_storage_key', + 'fa_size', + 'fa_width', + 'fa_height', + 'fa_description', + 'fa_user', + 'fa_user_text', + 'fa_timestamp' ), + array( 'fa_name' => $this->title->getDbKey() ), + __METHOD__, + array( 'ORDER BY' => 'fa_timestamp DESC' ) ); + $ret = $dbr->resultObject( $res ); + return $ret; + } + return null; + } + + /** + * Fetch (and decompress if necessary) the stored text for the deleted + * revision of the page with the given timestamp. + * + * @return string + * @deprecated Use getRevision() for more flexible information + */ + function getRevisionText( $timestamp ) { + $rev = $this->getRevision( $timestamp ); + return $rev ? $rev->getText() : null; + } + + /** + * Return a Revision object containing data for the deleted revision. + * Note that the result *may* or *may not* have a null page ID. + * @param string $timestamp + * @return Revision + */ + function getRevision( $timestamp ) { + $dbr =& wfGetDB( DB_SLAVE ); + $row = $dbr->selectRow( 'archive', + array( + 'ar_rev_id', + 'ar_text', + 'ar_comment', + 'ar_user', + 'ar_user_text', + 'ar_timestamp', + 'ar_minor_edit', + 'ar_flags', + 'ar_text_id' ), + array( 'ar_namespace' => $this->title->getNamespace(), + 'ar_title' => $this->title->getDbkey(), + 'ar_timestamp' => $dbr->timestamp( $timestamp ) ), + __METHOD__ ); + if( $row ) { + return new Revision( array( + 'page' => $this->title->getArticleId(), + 'id' => $row->ar_rev_id, + 'text' => ($row->ar_text_id + ? null + : Revision::getRevisionText( $row, 'ar_' ) ), + 'comment' => $row->ar_comment, + 'user' => $row->ar_user, + 'user_text' => $row->ar_user_text, + 'timestamp' => $row->ar_timestamp, + 'minor_edit' => $row->ar_minor_edit, + 'text_id' => $row->ar_text_id ) ); + } else { + return null; + } + } + + /** + * Get the text from an archive row containing ar_text, ar_flags and ar_text_id + */ + function getTextFromRow( $row ) { + if( is_null( $row->ar_text_id ) ) { + // An old row from MediaWiki 1.4 or previous. + // Text is embedded in this row in classic compression format. + return Revision::getRevisionText( $row, "ar_" ); + } else { + // New-style: keyed to the text storage backend. + $dbr =& wfGetDB( DB_SLAVE ); + $text = $dbr->selectRow( 'text', + array( 'old_text', 'old_flags' ), + array( 'old_id' => $row->ar_text_id ), + __METHOD__ ); + return Revision::getRevisionText( $text ); + } + } + + + /** + * 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 ); + $row = $dbr->selectRow( 'archive', + array( 'ar_text', 'ar_flags', 'ar_text_id' ), + array( 'ar_namespace' => $this->title->getNamespace(), + 'ar_title' => $this->title->getDBkey() ), + 'PageArchive::getLastRevisionText', + array( 'ORDER BY' => 'ar_timestamp DESC' ) ); + if( $row ) { + return $this->getTextFromRow( $row ); + } else { + return NULL; + } + } + + /** + * 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)', + array( 'ar_namespace' => $this->title->getNamespace(), + 'ar_title' => $this->title->getDBkey() ) ); + return ($n > 0); + } + + /** + * Restore the given (or all) text and file revisions for the page. + * Once restored, the items will be removed from the archive tables. + * The deletion log will be updated with an undeletion notice. + * + * @param array $timestamps Pass an empty array to restore all revisions, otherwise list the ones to undelete. + * @param string $comment + * @param array $fileVersions + * + * @return true on success. + */ + function undelete( $timestamps, $comment = '', $fileVersions = array() ) { + // If both the set of text revisions and file revisions are empty, + // restore everything. Otherwise, just restore the requested items. + $restoreAll = empty( $timestamps ) && empty( $fileVersions ); + + $restoreText = $restoreAll || !empty( $timestamps ); + $restoreFiles = $restoreAll || !empty( $fileVersions ); + + if( $restoreFiles && $this->title->getNamespace() == NS_IMAGE ) { + $img = new Image( $this->title ); + $filesRestored = $img->restore( $fileVersions ); + } else { + $filesRestored = 0; + } + + if( $restoreText ) { + $textRestored = $this->undeleteRevisions( $timestamps ); + } else { + $textRestored = 0; + } + + // Touch the log! + global $wgContLang; + $log = new LogPage( 'delete' ); + + if( $textRestored && $filesRestored ) { + $reason = wfMsgForContent( 'undeletedrevisions-files', + $wgContLang->formatNum( $textRestored ), + $wgContLang->formatNum( $filesRestored ) ); + } elseif( $textRestored ) { + $reason = wfMsgForContent( 'undeletedrevisions', + $wgContLang->formatNum( $textRestored ) ); + } elseif( $filesRestored ) { + $reason = wfMsgForContent( 'undeletedfiles', + $wgContLang->formatNum( $filesRestored ) ); + } else { + wfDebug( "Undelete: nothing undeleted...\n" ); + return false; + } + + if( trim( $comment ) != '' ) + $reason .= ": {$comment}"; + $log->addEntry( 'restore', $this->title, $reason ); + + return true; + } + + /** + * 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. + * + * @param array $timestamps Pass an empty array to restore all revisions, otherwise list the ones to undelete. + * @param string $comment + * @param array $fileVersions + * + * @return int number of revisions restored + */ + private function undeleteRevisions( $timestamps ) { + global $wgDBtype; + + $restoreAll = empty( $timestamps ); + + $dbw =& wfGetDB( DB_MASTER ); + $page = $dbw->tableName( 'archive' ); + + # Does this page already exist? We'll have to update it... + $article = new Article( $this->title ); + $options = ( $wgDBtype == 'postgres' ) + ? '' // pg doesn't support this? + : 'FOR UPDATE'; + $page = $dbw->selectRow( 'page', + array( 'page_id', 'page_latest' ), + array( 'page_namespace' => $this->title->getNamespace(), + 'page_title' => $this->title->getDBkey() ), + __METHOD__, + $options ); + if( $page ) { + # Page already exists. Import the history, and if necessary + # we'll update the latest revision field in the record. + $newid = 0; + $pageId = $page->page_id; + $previousRevId = $page->page_latest; + } else { + # Have to create a new article... + $newid = $article->insertOn( $dbw ); + $pageId = $newid; + $previousRevId = 0; + } + + if( $restoreAll ) { + $oldones = '1 = 1'; # All revisions... + } else { + $oldts = implode( ',', + array_map( array( &$dbw, 'addQuotes' ), + array_map( array( &$dbw, 'timestamp' ), + $timestamps ) ) ); + + $oldones = "ar_timestamp IN ( {$oldts} )"; + } + + /** + * Restore each revision... + */ + $result = $dbw->select( 'archive', + /* fields */ array( + 'ar_rev_id', + 'ar_text', + 'ar_comment', + 'ar_user', + 'ar_user_text', + 'ar_timestamp', + 'ar_minor_edit', + 'ar_flags', + 'ar_text_id' ), + /* WHERE */ array( + 'ar_namespace' => $this->title->getNamespace(), + 'ar_title' => $this->title->getDBkey(), + $oldones ), + __METHOD__, + /* options */ array( + 'ORDER BY' => 'ar_timestamp' ) + ); + if( $dbw->numRows( $result ) < count( $timestamps ) ) { + wfDebug( __METHOD__.": couldn't find all requested rows\n" ); + return false; + } + + $revision = null; + $restored = 0; + + while( $row = $dbw->fetchObject( $result ) ) { + if( $row->ar_text_id ) { + // Revision was deleted in 1.5+; text is in + // the regular text table, use the reference. + // Specify null here so the so the text is + // dereferenced for page length info if needed. + $revText = null; + } else { + // Revision was deleted in 1.4 or earlier. + // Text is squashed into the archive row, and + // a new text table entry will be created for it. + $revText = Revision::getRevisionText( $row, 'ar_' ); + } + $revision = new Revision( array( + 'page' => $pageId, + 'id' => $row->ar_rev_id, + 'text' => $revText, + 'comment' => $row->ar_comment, + 'user' => $row->ar_user, + 'user_text' => $row->ar_user_text, + 'timestamp' => $row->ar_timestamp, + 'minor_edit' => $row->ar_minor_edit, + 'text_id' => $row->ar_text_id, + ) ); + $revision->insertOn( $dbw ); + $restored++; + } + + if( $revision ) { + # FIXME: Update latest if newer as well... + if( $newid ) { + // Attach the latest revision to the page... + $article->updateRevisionOn( $dbw, $revision, $previousRevId ); + + // Update site stats, link tables, etc + $article->createUpdates( $revision ); + } + + if( $newid ) { + Article::onArticleCreate( $this->title ); + } else { + Article::onArticleEdit( $this->title ); + } + } else { + # Something went terribly wrong! + } + + # Now that it's safely stored, take it out of the archive + $dbw->delete( 'archive', + /* WHERE */ array( + 'ar_namespace' => $this->title->getNamespace(), + 'ar_title' => $this->title->getDBkey(), + $oldones ), + __METHOD__ ); + + return $restored; + } + +} + +/** + * + * @package MediaWiki + * @subpackage SpecialPage + */ class UndeleteForm { var $mAction, $mTarget, $mTimestamp, $mRestore, $mTargetObj; + var $mTargetTimestamp, $mAllowed, $mComment; function UndeleteForm( &$request, $par = "" ) { - $this->mAction = $request->getText( 'action' ); - $this->mTarget = $request->getText( 'target' ); - $this->mTimestamp = $request->getText( 'timestamp' ); - $this->mRestore = $request->getCheck( 'restore' ); + global $wgUser; + $this->mAction = $request->getVal( 'action' ); + $this->mTarget = $request->getVal( 'target' ); + $time = $request->getVal( 'timestamp' ); + $this->mTimestamp = $time ? wfTimestamp( TS_MW, $time ) : ''; + $this->mFile = $request->getVal( 'file' ); + + $posted = $request->wasPosted() && + $wgUser->matchEditToken( $request->getVal( 'wpEditToken' ) ); + $this->mRestore = $request->getCheck( 'restore' ) && $posted; + $this->mPreview = $request->getCheck( 'preview' ) && $posted; + $this->mComment = $request->getText( 'wpComment' ); + if( $par != "" ) { $this->mTarget = $par; } + if ( $wgUser->isAllowed( 'delete' ) && !$wgUser->isBlocked() ) { + $this->mAllowed = true; + } else { + $this->mAllowed = false; + $this->mTimestamp = ''; + $this->mRestore = false; + } if ( $this->mTarget !== "" ) { $this->mTargetObj = Title::newFromURL( $this->mTarget ); } else { $this->mTargetObj = NULL; } + if( $this->mRestore ) { + $timestamps = array(); + $this->mFileVersions = array(); + foreach( $_REQUEST as $key => $val ) { + $matches = array(); + if( preg_match( '/^ts(\d{14})$/', $key, $matches ) ) { + array_push( $timestamps, $matches[1] ); + } + + if( preg_match( '/^fileid(\d+)$/', $key, $matches ) ) { + $this->mFileVersions[] = intval( $matches[1] ); + } + } + rsort( $timestamps ); + $this->mTargetTimestamp = $timestamps; + } } function execute() { - if( !is_null( $this->mTargetObj ) ) { - $title = $this->mTargetObj->mDbkeyform; - $namespace = $this->mTargetObj->mNamespace; - if( $this->mTimestamp !== "" ) { - return $this->showRevision( $namespace, $title, $this->mTimestamp ); - } - if( $this->mRestore and $this->mAction == "submit" ) { - return $this->undelete( $namespace, $title ); - } - return $this->showHistory( $namespace, $title ); - } else { + + if( is_null( $this->mTargetObj ) ) { return $this->showList(); } + if( $this->mTimestamp !== '' ) { + return $this->showRevision( $this->mTimestamp ); + } + if( $this->mFile !== null ) { + return $this->showFile( $this->mFile ); + } + if( $this->mRestore && $this->mAction == "submit" ) { + return $this->undelete(); + } + return $this->showHistory(); } /* private */ function showList() { - global $wgLang, $wgUser, $wgOut; - $fname = "UndeleteForm::showList"; - - # List undeletable articles - $sql = "SELECT ar_namespace,ar_title, COUNT(*) AS count FROM archive " . - "GROUP BY ar_namespace,ar_title ORDER BY ar_namespace,ar_title"; - $res = wfQuery( $sql, DB_READ, $fname ); - - $wgOut->setPagetitle( wfMsg( "undeletepage" ) ); + global $wgLang, $wgContLang, $wgUser, $wgOut; + + # List undeletable articles + $result = PageArchive::listAllPages(); + + if ( $this->mAllowed ) { + $wgOut->setPagetitle( wfMsg( "undeletepage" ) ); + } else { + $wgOut->setPagetitle( wfMsg( "viewdeletedpage" ) ); + } $wgOut->addWikiText( wfMsg( "undeletepagetext" ) ); - $special = $wgLang->getNsText( Namespace::getSpecial() ); $sk = $wgUser->getSkin(); + $undelete = SpecialPage::getTitleFor( 'Undelete' ); $wgOut->addHTML( "
-
"); + # Batch existence check on user and talk pages + if( $haveRevisions ) { + $batch = new LinkBatch(); + while( $row = $revisions->fetchObject() ) { + $batch->addObj( Title::makeTitleSafe( NS_USER, $row->ar_user_text ) ); + $batch->addObj( Title::makeTitleSafe( NS_USER_TALK, $row->ar_user_text ) ); + } + $batch->execute(); + $revisions->seek( 0 ); + } + if( $haveFiles ) { + $batch = new LinkBatch(); + while( $row = $files->fetchObject() ) { + $batch->addObj( Title::makeTitleSafe( NS_USER, $row->fa_user_text ) ); + $batch->addObj( Title::makeTitleSafe( NS_USER_TALK, $row->fa_user_text ) ); + } + $batch->execute(); + $files->seek( 0 ); + } - $log = wfGetSQL("cur", "cur_text", "cur_namespace=4 AND cur_title=\"".wfMsg("dellogpage")."\"" ); - if(preg_match("/^(.*". - preg_quote( ($namespace ? ($wgLang->getNsText($namespace) . ":") : "") - . str_replace("_", " ", $title), "/" ).".*)$/m", $log, $m)) { - $wgOut->addWikiText( $m[1] ); + if ( $this->mAllowed ) { + $titleObj = SpecialPage::getTitleFor( "Undelete" ); + $action = $titleObj->getLocalURL( "action=submit" ); + # Start the form here + $top = wfOpenElement( 'form', array( 'method' => 'post', 'action' => $action, 'id' => 'undelete' ) ); + $wgOut->addHtml( $top ); } - - $special = $wgLang->getNsText( Namespace::getSpecial() ); - $wgOut->addHTML("