deleteRevision.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/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;