maintenance/deleteRevision.php

   1 <?php
   2 require_once( 'commandLine.inc' );
   3
   4 $dbw = wfGetDB( DB_MASTER );
   5
   6 if ( count( $args ) == 0 ) {
   7         echo "Usage: php deleteRevision.php <revid> [<revid> ...]\n";
   8         exit(1);
   9 }
  10
  11 echo "Deleting revision(s) " . implode( ',', $args ) . " from ".wfWikiID()."...\n";
  12
  13 $affected = 0;
  14 foreach ( $args as $revID ) {
  15         $dbw->insertSelect( 'archive', array( 'page', 'revision' ),
  16                 array(
  17                         'ar_namespace'  => 'page_namespace',
  18                         'ar_title'      => 'page_title',
  19                         'ar_comment'    => 'rev_comment',
  20                         'ar_user'       => 'rev_user',
  21                         'ar_user_text'  => 'rev_user_text',
  22                         'ar_timestamp'  => 'rev_timestamp',
  23                         'ar_minor_edit' => 'rev_minor_edit',
  24                         'ar_rev_id'     => 'rev_id',
  25                         'ar_text_id'    => 'rev_text_id',
  26                 ), array(
  27                         'rev_id' => $revID,
  28                         'page_id = rev_page'
  29                 ), $fname
  30         );
  31         if ( !$dbw->affectedRows() ) {
  32                 echo "Revision $revID not found\n";
  33         } else {
  34                 $affected += $dbw->affectedRows();
  35                 $dbw->delete( 'revision', array( 'rev_id' => $revID ) );
  36         }
  37 }
  38
  39 print "Deleted $affected revisions\n";
  40