maintenance/nukePage.inc

   1 <?php
   2
   3 /**
   4  * Support functions for the nukeArticle script
   5  *
   6  * @addtogroup Maintenance
   7  * @author Rob Church <robchur@gmail.com>
   8  */
   9
  10 require_once( 'purgeOldText.inc' );
  11
  12 function NukePage( $name, $delete = false ) {
  13
  14         $dbw = wfGetDB( DB_MASTER );
  15         $dbw->begin();
  16
  17         $tbl_pag = $dbw->tableName( 'page' );
  18         $tbl_rec = $dbw->tableName( 'recentchanges' );
  19         $tbl_rev = $dbw->tableName( 'revision' );
  20
  21         # Get page ID
  22         echo( "Searching for \"$name\"..." );
  23         $title = Title::newFromText( $name );
  24         if( $title ) {
  25                 $id   = $title->getArticleID();
  26                 $real = $title->getPrefixedText();
  27                 echo( "found \"$real\" with ID $id.\n" );
  28
  29                 # Get corresponding revisions
  30                 echo( "Searching for revisions..." );
  31                 $res = $dbw->query( "SELECT rev_id FROM $tbl_rev WHERE rev_page = $id" );
  32                 while( $row = $dbw->fetchObject( $res ) ) {
  33                         $revs[] = $row->rev_id;
  34                 }
  35                 $count = count( $revs );
  36                 echo( "found $count.\n" );
  37
  38                 # Delete the page record and associated recent changes entries
  39                 if( $delete ) {
  40                         echo( "Deleting page record..." );
  41                         $dbw->query( "DELETE FROM $tbl_pag WHERE page_id = $id" );
  42                         echo( "done.\n" );
  43                         echo( "Cleaning up recent changes..." );
  44                         $dbw->query( "DELETE FROM $tbl_rec WHERE rc_cur_id = $id" );
  45                         echo( "done.\n" );
  46                 }
  47
  48                 $dbw->commit();
  49
  50                 # Delete revisions as appropriate
  51                 if( $delete && $count ) {
  52                         echo( "Deleting revisions..." );
  53                         DeleteRevisions( $revs );
  54                         echo( "done.\n" );
  55                         PurgeRedundantText( true );
  56                 }
  57
  58         } else {
  59                 echo( "not found in database.\n" );
  60                 $dbw->commit();
  61         }
  62
  63 }
  64
  65 function DeleteRevisions( $ids ) {
  66
  67         $dbw = wfGetDB( DB_MASTER );
  68         $dbw->begin();
  69
  70         $tbl_rev = $dbw->tableName( 'revision' );
  71
  72         $set = implode( ', ', $ids );
  73         $dbw->query( "DELETE FROM $tbl_rev WHERE rev_id IN ( $set )" );
  74
  75         $dbw->commit();
  76
  77         #TODO: see if this is a "good" page, to decrement that as well.
  78         $pages = $dbw->selectField('site_stats', 'ss_total_pages');
  79         $pages--;
  80         $dbw->update( 'site_stats',
  81                       array('ss_total_pages' => $pages ),
  82                       array( 'ss_row_id' => 1),
  83                       __METHOD__ );
  84
  85 }
  86
  87 ?>