From 183851b06bd6c52f3cae5375f433da720d410447 Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Wed, 11 Oct 2006 18:12:39 +0000
Subject: MediaWiki 1.7.1 wiederhergestellt

---
 maintenance/deleteRevision.php | 40 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 maintenance/deleteRevision.php

(limited to 'maintenance/deleteRevision.php')

diff --git a/maintenance/deleteRevision.php b/maintenance/deleteRevision.php
new file mode 100644
index 00000000..e7d005b6
--- /dev/null
+++ b/maintenance/deleteRevision.php
@@ -0,0 +1,40 @@
+<?php
+require_once( 'commandLine.inc' );
+
+$dbw =& wfGetDB( DB_MASTER );
+
+if ( count( $args ) == 0 ) {
+	echo "Usage: php deleteRevision.php <revid> [<revid> ...]\n";
+	exit(1);
+}
+
+echo "Deleting revision(s) " . implode( ',', $args ) . " from $wgDBname...\n";
+
+$affected = 0;
+foreach ( $args as $revID ) {
+	$dbw->insertSelect( 'archive', array( 'page', 'revision' ),
+		array(
+			'ar_namespace'  => 'page_namespace',
+			'ar_title'      => 'page_title',
+			'ar_comment'    => 'rev_comment',
+			'ar_user'       => 'rev_user',
+			'ar_user_text'  => 'rev_user_text',
+			'ar_timestamp'  => 'rev_timestamp',
+			'ar_minor_edit' => 'rev_minor_edit',
+			'ar_rev_id'     => 'rev_id',
+			'ar_text_id'    => 'rev_text_id',
+		), array(
+			'rev_id' => $revID,
+			'page_id = rev_page'
+		), $fname
+	);
+	if ( !$dbw->affectedRows() ) {
+		echo "Revision $revID not found\n";
+	} else {
+		$affected += $dbw->affectedRows();
+		$dbw->delete( 'revision', array( 'rev_id' => $revID ) );
+	}
+}
+
+print "Deleted $affected revisions\n";
+?>
-- 
cgit v1.2.2