From cecb985bee3bdd252e1b8dc0bd500b37cd52be01 Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Wed, 16 May 2007 20:58:53 +0000
Subject: Aktualisierung auf MediaWiki 1.10.0 Plugins angepasst und verbessert
 kleine Korrekturen am Design

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

(limited to 'maintenance/updateRestrictions.php')

diff --git a/maintenance/updateRestrictions.php b/maintenance/updateRestrictions.php
new file mode 100644
index 00000000..6c8ffb5e
--- /dev/null
+++ b/maintenance/updateRestrictions.php
@@ -0,0 +1,67 @@
+<?php
+
+/*
+ * Makes the required database updates for Special:ProtectedPages
+ * to show all protected pages, even ones before the page restrictions
+ * schema change. All remaining page_restriction column values are moved
+ * to the new table.
+ */
+
+define( 'BATCH_SIZE', 100 );
+
+require_once 'commandLine.inc';
+	
+$db =& wfGetDB( DB_MASTER );
+if ( !$db->tableExists( 'page_restrictions' ) ) {
+	echo "page_restrictions does not exist\n";
+	exit( 1 );
+}
+
+migrate_page_restrictions( $db );
+
+function migrate_page_restrictions( $db ) {
+	
+	$start = $db->selectField( 'page', 'MIN(page_id)', false, __FUNCTION__ );
+	$end = $db->selectField( 'page', 'MAX(page_id)', false, __FUNCTION__ );
+	$blockStart = $start;
+	$blockEnd = $start + BATCH_SIZE - 1;
+	$encodedExpiry = Block::decodeExpiry('');
+	while ( $blockEnd <= $end ) {
+		$cond = "page_id BETWEEN $blockStart AND $blockEnd AND page_restrictions !=''";
+		$res = $db->select( 'page', array('page_id', 'page_restrictions'), $cond, __FUNCTION__ );
+		$batch = array();
+		while ( $row = $db->fetchObject( $res ) ) {
+			$oldRestrictions = array();
+			foreach( explode( ':', trim( $row->page_restrictions ) ) as $restrict ) {
+				$temp = explode( '=', trim( $restrict ) );
+				if(count($temp) == 1) {
+					// old old format should be treated as edit/move restriction
+					$oldRestrictions["edit"] = trim( $temp[0] );
+					$oldRestrictions["move"] = trim( $temp[0] );
+				} else {
+					$oldRestrictions[$temp[0]] = trim( $temp[1] );
+				}
+			}
+			# Update restrictions table
+			foreach( $oldRestrictions as $action => $restrictions ) {
+				$batch[] = array( 
+					'pr_page' => $row->page_id,
+					'pr_type' => $action,
+					'pr_level' => $restrictions,
+					'pr_cascade' => 0,
+					'pr_expiry' => $encodedExpiry
+				);
+			}
+		}
+		# We use insert() and not replace() as Article.php replaces
+		# page_restrictions with '' when protected in the restrictions table
+		if ( count( $batch ) ) {
+			$db->insert( 'page_restrictions', $batch, __FUNCTION__ );
+		}
+		$blockStart += BATCH_SIZE;
+		$blockEnd += BATCH_SIZE;
+		wfWaitForSlaves( 5 );
+	}
+}
+
+?>
-- 
cgit v1.2.3-54-g00ecf