deleteRevision.php

Go to the documentation of this file.

<?php
require_once( dirname( __FILE__ ) . '/Maintenance.php' );

class DeleteRevision extends Maintenance {

        public function __construct() {
                parent::__construct();
                $this->mDescription = "Delete one or more revisions by moving them to the archive table";
        }

        public function execute() {
                if ( count( $this->mArgs ) == 0 ) {
                        $this->error( "No revisions specified", true );
                }

                $this->output( "Deleting revision(s) " . implode( ',', $this->mArgs ) .
                                                " from " . wfWikiID() . "...\n" );
                $dbw = wfGetDB( DB_MASTER );

                $affected = 0;
                foreach ( $this->mArgs as $revID ) {
                        $dbw->insertSelect( 'archive', array( 'page', 'revision' ),
                                array(
                                        'ar_namespace'  => 'page_namespace',
                                        'ar_title'      => 'page_title',
                                        'ar_page_id'    => 'page_id',
                                        'ar_comment'    => 'rev_comment',
                                        'ar_user'       => 'rev_user',
                                        'ar_user_text'  => 'rev_user_text',
                                        'ar_timestamp'  => 'rev_timestamp',
                                        'ar_minor_edit' => 'rev_minor_edit',
                                        'ar_rev_id'     => 'rev_id',
                                        'ar_text_id'    => 'rev_text_id',
                                        'ar_deleted'    => 'rev_deleted',
                                        'ar_len'        => 'rev_len',
                                ), array(
                                        'rev_id' => $revID,
                                        'page_id = rev_page'
                                ), __METHOD__
                        );
                        if ( !$dbw->affectedRows() ) {
                                $this->output( "Revision $revID not found\n" );
                        } else {
                                $affected += $dbw->affectedRows();
                                $pageID = $dbw->selectField( 'revision', 'rev_page', array( 'rev_id' => $revID ), __METHOD__ );
                                $pageLatest = $dbw->selectField( 'page', 'page_latest', array( 'page_id' => $pageID ), __METHOD__ );
                                $dbw->delete( 'revision', array( 'rev_id' => $revID ) );
                                if ( $pageLatest == $revID ) {
                                        // Database integrity
                                        $newLatest = $dbw->selectField( 'revision', 'rev_id', array( 'rev_page' => $pageID ), __METHOD__, array( 'ORDER BY' => 'rev_timestamp DESC' ) );
                                        $dbw->update( 'page', array( 'page_latest' => $newLatest ), array( 'page_id' => $pageID ), __METHOD__ );
                                }
                        }
                }
                $this->output( "Deleted $affected revisions\n" );
        }
}

$maintClass = "DeleteRevision";
require_once( RUN_MAINTENANCE_IF_MAIN );