From 50af25f5b3fca169ada0568133939a95bd8f8d7c Mon Sep 17 00:00:00 2001
From: Alex Monk <krenair@gmail.com>
Date: Sun, 6 Jan 2013 13:06:44 +0000
Subject: [PATCH] Tidy up log deletion rows which didn't get subpages

Bug: 37714

Change-Id: I904988c864d777d039b2aae956aef7b19092cf83
---
 maintenance/tidyUpBug37714.php | 49 ++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100644 maintenance/tidyUpBug37714.php

diff --git a/maintenance/tidyUpBug37714.php b/maintenance/tidyUpBug37714.php
new file mode 100644
index 0000000000..1ad9c7ee25
--- /dev/null
+++ b/maintenance/tidyUpBug37714.php
@@ -0,0 +1,49 @@
+<?php
+require_once __DIR__ . '/Maintenance.php';
+
+/**
+ * Fixes all rows affected by https://bugzilla.wikimedia.org/show_bug.cgi?id=37714
+ */
+class TidyUpBug37714 extends Maintenance {
+	public function execute() {
+		// Search for all log entries which are about changing the visability of other log entries.
+		$result = wfGetDB( DB_SLAVE )->select(
+			'logging',
+			array( 'log_id', 'log_params' ),
+			array(
+				'log_type' => array( 'suppress', 'delete' ),
+				'log_action' => 'event',
+				'log_namespace' => NS_SPECIAL,
+				'log_title' => SpecialPage::getTitleFor( 'Log' )->getText()
+			),
+			__METHOD__
+		);
+
+		foreach ( $result as $row ) {
+			$paramLines = explode( "\n", $row->log_params );
+			$ids = explode( ',', $paramLines[0] ); // Array dereferencing is PHP >= 5.4 :(
+			$result = wfGetDB( DB_SLAVE )->select( // Work out what log entries were changed here.
+				'logging',
+				'log_type',
+				array( 'log_id' => $ids ),
+				__METHOD__,
+				'DISTINCT'
+			);
+			if ( $result->numRows() === 1 ) {
+				// If there's only one type, the target title can be set to include it.
+				$logTitle = SpecialPage::getTitleFor( 'Log', $result->current()->log_type )->getText();
+				$this->output( 'Set log_title to "' . $logTitle . '" for log entry ' . $row->log_id . ".\n" );
+				wfGetDB( DB_MASTER )->update(
+					'logging',
+					array( 'log_title' => $logTitle ),
+					array( 'log_id' => $row->log_id ),
+					__METHOD__
+				);
+				wfWaitForSlaves();
+			}
+		}
+	}
+}
+
+$maintClass = 'TidyUpBug37714';
+require_once RUN_MAINTENANCE_IF_MAIN;
-- 
2.20.1