From 2b3a49e4bf813fd14dd2322c4dbcdd5343e49369 Mon Sep 17 00:00:00 2001
From: Brion Vibber <brion@users.mediawiki.org>
Date: Sun, 13 Mar 2005 01:16:21 +0000
Subject: [PATCH] Start on a script to find and clean up orphan revisions

---
 maintenance/orphans.php | 135 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 135 insertions(+)
 create mode 100755 maintenance/orphans.php

diff --git a/maintenance/orphans.php b/maintenance/orphans.php
new file mode 100755
index 0000000000..7532344c98
--- /dev/null
+++ b/maintenance/orphans.php
@@ -0,0 +1,135 @@
+<?php
+# Copyright (C) 2005 Brion Vibber <brion@pobox.com>
+# http://www.mediawiki.org/
+# 
+# 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.,
+# 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+# http://www.gnu.org/copyleft/gpl.html
+
+/**
+ * Look for 'orphan' revisions hooked to pages which don't exist
+ * And 'childless' pages with no revisions.
+ * Then, kill the poor widows and orphans.
+ * Man this is depressing.
+ *
+ * @author <brion@pobox.com>
+ * @package MediaWiki
+ * @subpackage Maintenance
+ */
+
+$options = array( 'fix' );
+
+/** */
+require_once( 'commandLine.inc' );
+$wgTitle = Title::newFromText( 'Orphan revision cleanup script' );
+
+checkOrphans( isset( $options['fix'] ) );
+#checkWidows( isset( $options['fix'] ) );
+
+# ------
+
+function checkOrphans( $fix ) {
+	$dbw =& wfGetDB( DB_MASTER );
+	$page = $dbw->tableName( 'page' );
+	$revision = $dbw->tableName( 'revision' );
+	
+	if( $fix ) {
+		$dbw->query( "LOCK TABLES $page WRITE, $revision WRITE" );
+	}
+	
+	echo "Checking for orphan revision table entries... (this may take a while on a large wiki)\n";
+	$result = $dbw->query( "
+		SELECT *
+		FROM $revision LEFT OUTER JOIN $page ON rev_page=page_id
+		WHERE page_id IS NULL
+	");
+	$orphans = $dbw->numRows( $result );
+	if( $orphans > 0 ) {
+		global $wgContLang;
+		echo "$orphans orphan revisions...\n";
+		printf( "%10s %10s %14s %20s %s\n", 'rev_id', 'rev_page', 'rev_timestamp', 'rev_user_text', 'rev_comment' );
+		while( $row = $dbw->fetchObject( $result ) ) {
+			$comment = ( $row->rev_comment == '' )
+				? ''
+				: '(' . $wgContLang->truncate( $row->rev_comment, 40, '...' ) . ')';
+			printf( "%10d %10d %14s %20s %s\n",
+				$row->rev_id,
+				$row->rev_page,
+				$row->rev_timestamp,
+				$wgContLang->truncate( $row->rev_user_text, 17, '...' ),
+				$comment );
+			if( $fix ) {
+				$dbw->delete( 'revision', array( 'rev_id' => $row->rev_id ) );
+			}
+		}
+		if( !$fix ) {
+			echo "Run again with --fix to remove these entries automatically.\n";
+		}
+	} else {
+		echo "No orphans! Yay!\n";
+	}
+	
+	if( $fix ) {
+		$dbw->query( "UNLOCK TABLES" );
+	}
+}
+
+/**
+ * @todo DON'T USE THIS YET! It will remove entries which have children,
+ *       but which aren't properly attached (eg if page_latest is bogus
+ *       but valid revisions do exist)
+ */
+function checkWidows( $fix ) {
+	$dbw =& wfGetDB( DB_MASTER );
+	$page = $dbw->tableName( 'page' );
+	$revision = $dbw->tableName( 'revision' );
+	
+	if( $fix ) {
+		$dbw->query( "LOCK TABLES $page WRITE, $revision WRITE" );
+	}
+	
+	echo "\nChecking for childless page table entries... (this may take a while on a large wiki)\n";
+	$result = $dbw->query( "
+		SELECT *
+		FROM $page LEFT OUTER JOIN $revision ON page_latest=rev_id
+		WHERE rev_id IS NULL
+	");
+	$widows = $dbw->numRows( $result );
+	if( $widows > 0 ) {
+		global $wgContLang;
+		echo "$widows childless pages...\n";
+		printf( "%10s %11s %2s %s\n", 'page_id', 'page_latest', 'ns', 'page_title' );
+		while( $row = $dbw->fetchObject( $result ) ) {
+			printf( "%10d %11d %2d %s\n",
+				$row->page_id,
+				$row->page_latest,
+				$row->page_namespace,
+				$row->page_title );
+			if( $fix ) {
+				$dbw->delete( 'page', array( 'page_id' => $row->page_id ) );
+			}
+		}
+		if( !$fix ) {
+			echo "Run again with --fix to remove these entries automatically.\n";
+		}
+	} else {
+		echo "No childless pages! Yay!\n";
+	}
+	
+	if( $fix ) {
+		$dbw->query( "UNLOCK TABLES" );
+	}
+}
+
+?>
\ No newline at end of file
-- 
2.20.1