From 67aa00f957265323ca0d50a709f442735cdc5fb2 Mon Sep 17 00:00:00 2001
From: TyA <tya.wiki@gmail.com>
Date: Wed, 30 May 2012 04:49:17 +0100
Subject: [PATCH] *(bug 30976) Add maintenance script to remove preferences
 from $wgHiddenPrefs

Change-Id: Ie74fab1edeac2c6b275c51e6af3a7924b3aac46b
---
 maintenance/cleanupPreferences.php | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100755 maintenance/cleanupPreferences.php

diff --git a/maintenance/cleanupPreferences.php b/maintenance/cleanupPreferences.php
new file mode 100755
index 0000000000..57a536962a
--- /dev/null
+++ b/maintenance/cleanupPreferences.php
@@ -0,0 +1,29 @@
+<?php
+/**
+ * Description: This script takes $wgHiddenPrefs and removes their preference from the DB. [[bugzilla:30976]]
+ * @author TyA <tya.wiki@gmail.com>
+ * @ingroup Maintenance
+ */
+
+require_once( dirname( __FILE__ ) . '/Maintenance.php' );
+
+class CleanupPreferences extends Maintenance {
+	public function execute() {
+		global $wgHiddenPrefs;
+
+		$dbw = wfGetDB( DB_MASTER );
+		$dbw->begin();
+		foreach( $wgHiddenPrefs as $item ) {
+			$dbw->delete(
+				'user_properties',
+				array( 'up_property' => $item ),
+				__METHOD__
+			);
+		};
+		$dbw->commit();
+		$this->output( "Finished!\n" );
+	}
+}
+
+$maintClass = 'CleanupPreferences'; // Tells it to run the class
+require_once( RUN_MAINTENANCE_IF_MAIN );
-- 
2.20.1