X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2FnukePage.php;h=1870273eb798515eb0d714b29b6c33bbaed014ae;hb=0f5ddf4d1e217519e236b1df44e8bccb62858edc;hp=f1ebe73416c72ca661feb9a68566900efe766200;hpb=a15c419b3d130248f2556b9d00643ba9666a4189;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/nukePage.php b/maintenance/nukePage.php
index f1ebe73416..1870273eb7 100644
--- a/maintenance/nukePage.php
+++ b/maintenance/nukePage.php
@@ -1,28 +1,120 @@
 <?php
-
 /**
  * Erase a page record from the database
  * Irreversible (can't use standard undelete) and does not update link tables
  *
- * @addtogroup Maintenance
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License along
+ * with this program; if not, write to the Free Software Foundation, Inc.,
+ * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
+ * http://www.gnu.org/copyleft/gpl.html
+ *
+ * @file
+ * @ingroup Maintenance
  * @author Rob Church <robchur@gmail.com>
  */
 
-require_once( 'commandLine.inc' );
-require_once( 'nukePage.inc' );
+require_once __DIR__ . '/Maintenance.php';
+
+/**
+ * Maintenance script that erases a page record from the database.
+ *
+ * @ingroup Maintenance
+ */
+class NukePage extends Maintenance {
+	public function __construct() {
+		parent::__construct();
+		$this->mDescription = "Remove a page record from the database";
+		$this->addOption( 'delete', "Actually delete the page" );
+		$this->addArg( 'title', 'Title to delete' );
+	}
+
+	public function execute() {
 
-echo( "Erase Page Record\n\n" );
+		$name = $this->getArg();
+		$delete = $this->getOption( 'delete', false );
 
-if( isset( $args[0] ) ) {
-	NukePage( $args[0], true );
-} else {
-	ShowUsage();
-}
+		$dbw = wfGetDB( DB_MASTER );
+		$dbw->begin( __METHOD__ );
+
+		$tbl_pag = $dbw->tableName( 'page' );
+		$tbl_rec = $dbw->tableName( 'recentchanges' );
+		$tbl_rev = $dbw->tableName( 'revision' );
+
+		# Get page ID
+		$this->output( "Searching for \"$name\"..." );
+		$title = Title::newFromText( $name );
+		if ( $title ) {
+			$id = $title->getArticleID();
+			$real = $title->getPrefixedText();
+			$isGoodArticle = $title->isContentPage();
+			$this->output( "found \"$real\" with ID $id.\n" );
+
+			# Get corresponding revisions
+			$this->output( "Searching for revisions..." );
+			$res = $dbw->query( "SELECT rev_id FROM $tbl_rev WHERE rev_page = $id" );
+			$revs = array();
+			foreach ( $res as $row ) {
+				$revs[] = $row->rev_id;
+			}
+			$count = count( $revs );
+			$this->output( "found $count.\n" );
+
+			# Delete the page record and associated recent changes entries
+			if ( $delete ) {
+				$this->output( "Deleting page record..." );
+				$dbw->query( "DELETE FROM $tbl_pag WHERE page_id = $id" );
+				$this->output( "done.\n" );
+				$this->output( "Cleaning up recent changes..." );
+				$dbw->query( "DELETE FROM $tbl_rec WHERE rc_cur_id = $id" );
+				$this->output( "done.\n" );
+			}
+
+			$dbw->commit( __METHOD__ );
+
+			# Delete revisions as appropriate
+			if ( $delete && $count ) {
+				$this->output( "Deleting revisions..." );
+				$this->deleteRevisions( $revs );
+				$this->output( "done.\n" );
+				$this->purgeRedundantText( true );
+			}
+
+			# Update stats as appropriate
+			if ( $delete ) {
+				$this->output( "Updating site stats..." );
+				$ga = $isGoodArticle ? -1 : 0; // if it was good, decrement that too
+				$stats = new SiteStatsUpdate( 0, -$count, $ga, -1 );
+				$stats->doUpdate();
+				$this->output( "done.\n" );
+			}
+		} else {
+			$this->output( "not found in database.\n" );
+			$dbw->commit( __METHOD__ );
+		}
+	}
+
+	public function deleteRevisions( $ids ) {
+		$dbw = wfGetDB( DB_MASTER );
+		$dbw->begin( __METHOD__ );
+
+		$tbl_rev = $dbw->tableName( 'revision' );
+
+		$set = implode( ', ', $ids );
+		$dbw->query( "DELETE FROM $tbl_rev WHERE rev_id IN ( $set )" );
 
-/** Show script usage information */
-function ShowUsage() {
-	echo( "Remove a page record from the database.\n\n" );
-	echo( "Usage: php nukePage.php <title>\n\n" );
-	echo( "	<title> : Page title; spaces escaped with underscores\n\n" );
+		$dbw->commit( __METHOD__ );
+	}
 }
 
+$maintClass = "NukePage";
+require_once RUN_MAINTENANCE_IF_MAIN;