Localisation updates from http://translatewiki.net.
[mediawiki.git] / maintenance / deleteRevision.php
blob6bc0f7cd01230b0703371979ec87e5836317f420
1 <?php
2 /**
3 * Delete one or more revisions by moving them to the archive table.
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
20 * @file
21 * @ingroup Maintenance
24 require_once __DIR__ . '/Maintenance.php';
26 /**
27 * Maintenance script that deletes one or more revisions by moving them
28 * to the archive table.
30 * @ingroup Maintenance
32 class DeleteRevision extends Maintenance {
34 public function __construct() {
35 parent::__construct();
36 $this->mDescription = "Delete one or more revisions by moving them to the archive table";
39 public function execute() {
40 if ( count( $this->mArgs ) == 0 ) {
41 $this->error( "No revisions specified", true );
44 $this->output( "Deleting revision(s) " . implode( ',', $this->mArgs ) .
45 " from " . wfWikiID() . "...\n" );
46 $dbw = wfGetDB( DB_MASTER );
48 $affected = 0;
49 foreach ( $this->mArgs as $revID ) {
50 $dbw->insertSelect( 'archive', array( 'page', 'revision' ),
51 array(
52 'ar_namespace' => 'page_namespace',
53 'ar_title' => 'page_title',
54 'ar_page_id' => 'page_id',
55 'ar_comment' => 'rev_comment',
56 'ar_user' => 'rev_user',
57 'ar_user_text' => 'rev_user_text',
58 'ar_timestamp' => 'rev_timestamp',
59 'ar_minor_edit' => 'rev_minor_edit',
60 'ar_rev_id' => 'rev_id',
61 'ar_text_id' => 'rev_text_id',
62 'ar_deleted' => 'rev_deleted',
63 'ar_len' => 'rev_len',
64 ), array(
65 'rev_id' => $revID,
66 'page_id = rev_page'
67 ), __METHOD__
69 if ( !$dbw->affectedRows() ) {
70 $this->output( "Revision $revID not found\n" );
71 } else {
72 $affected += $dbw->affectedRows();
73 $pageID = $dbw->selectField( 'revision', 'rev_page', array( 'rev_id' => $revID ), __METHOD__ );
74 $pageLatest = $dbw->selectField( 'page', 'page_latest', array( 'page_id' => $pageID ), __METHOD__ );
75 $dbw->delete( 'revision', array( 'rev_id' => $revID ) );
76 if ( $pageLatest == $revID ) {
77 // Database integrity
78 $newLatest = $dbw->selectField( 'revision', 'rev_id', array( 'rev_page' => $pageID ), __METHOD__, array( 'ORDER BY' => 'rev_timestamp DESC' ) );
79 $dbw->update( 'page', array( 'page_latest' => $newLatest ), array( 'page_id' => $pageID ), __METHOD__ );
83 $this->output( "Deleted $affected revisions\n" );
87 $maintClass = "DeleteRevision";
88 require_once RUN_MAINTENANCE_IF_MAIN;