maintenance/deleteOrphanedRevisions.php

   1 <?php
   2
   3 /**
   4  * Maintenance script to delete revisions which refer to a nonexisting page
   5  * Sometimes manual deletion done in a rush leaves crap in the database
   6  *
   7  * @addtogroup Maintenance
   8  * @author Rob Church <robchur@gmail.com>
   9  * @todo More efficient cleanup of text records
  10  */
  11
  12 $options = array( 'report', 'help' );
  13 require_once( 'commandLine.inc' );
  14 require_once( 'deleteOrphanedRevisions.inc.php' );
  15 echo( "Delete Orphaned Revisions\n" );
  16
  17 if( isset( $options['help'] ) )
  18         showUsage();
  19
  20 $report = isset( $options['report'] );
  21
  22 $dbw =& wfGetDB( DB_MASTER );
  23 $dbw->immediateBegin();
  24 extract( $dbw->tableNames( 'page', 'revision' ) );
  25
  26 # Find all the orphaned revisions
  27 echo( "Checking for orphaned revisions..." );
  28 $sql = "SELECT rev_id FROM {$revision} LEFT JOIN {$page} ON rev_page = page_id WHERE page_namespace IS NULL";
  29 $res = $dbw->query( $sql, 'deleteOrphanedRevisions' );
  30
  31 # Stash 'em all up for deletion (if needed)
  32 while( $row = $dbw->fetchObject( $res ) )
  33         $revisions[] = $row->rev_id;
  34 $dbw->freeResult( $res );
  35 $count = count( $revisions );
  36 echo( "found {$count}.\n" );
  37
  38 # Nothing to do?
  39 if( $report || $count == 0 ) {
  40         $dbw->immediateCommit();
  41         exit();
  42 }
  43
  44 # Delete each revision
  45 echo( "Deleting..." );
  46 deleteRevisions( $revisions, $dbw );
  47 echo( "done.\n" );
  48
  49 # Close the transaction and call the script to purge unused text records
  50 $dbw->immediateCommit();
  51 require_once( 'purgeOldText.inc' );
  52 PurgeRedundantText( true );
  53
  54 ?>