maintenance/nukePage.inc

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