1 files changed, 121 insertions, 0 deletions
diff --git a/www/wiki/extensions/UniversalLanguageSelector/maintenance/ULSCompactLinksDisablePref.php b/www/wiki/extensions/UniversalLanguageSelector/maintenance/ULSCompactLinksDisablePref.php
new file mode 100644
index 00000000..99a68392
--- /dev/null
+++ b/www/wiki/extensions/UniversalLanguageSelector/maintenance/ULSCompactLinksDisablePref.php
@@ -0,0 +1,121 @@
+<?php
+/**
+ * Disables the UniversalLanguageSelector compact-language-links
+ * preference for appropriate users
+ *
+ * @copyright 2017 Wikimedia Language team and others; see AUTHORS.txt
+ * @license GPL-2.0-or-later
+ * @author Niklas Laxström
+ * @author Amir E. Aharoni
+ * Based on autodisablePref.php from the VisualEditor repository by Alex Monk
+ * @file
+ * @ingroup Extensions
+ * @ingroup Maintenance
+ */
+
+require_once getenv( 'MW_INSTALL_PATH' ) !== false
+	? getenv( 'MW_INSTALL_PATH' ) . '/maintenance/Maintenance.php'
+	: __DIR__ . '/../../../maintenance/Maintenance.php';
+
+class ULSCompactLinksDisablePref extends Maintenance {
+	public function __construct() {
+		parent::__construct();
+		$this->requireExtension( 'UniversalLanguageSelector' );
+		$this->mDescription = 'Disables the UniversalLanguageSelector compact-language-links ' .
+			'preference for appropriate users.';
+		$this->setBatchSize( 100 );
+
+		$this->addOption( 'really', 'Really change the preferences' );
+
+		$this->addOption( 'continue', 'Continue running from this user ID', false, true );
+	}
+
+	public function execute() {
+		$dbr = wfGetDB( DB_REPLICA, 'vslow' );
+
+		$really = $this->hasOption( 'really' );
+
+		$lastUserId = $this->getOption( 'continue', 0 );
+
+		if ( class_exists( ActorMigration::class ) ) {
+			$actorQuery = ActorMigration::newMigration()->getJoin( 'rev_user' );
+			$revUser = $actorQuery['fields']['rev_user'];
+		} else {
+			$actorQuery = [
+				'tables' => [],
+				'joins' => [],
+			];
+			$revUser = 'rev_user';
+		}
+
+		do {
+			$tables = array_merge(
+				[ 'revision' ],
+				$actorQuery['tables'],
+				[ 'user_properties', 'user_groups' ]
+			);
+			$fields = [
+				'user' => $revUser,
+				'isbot' => 'ug_group',
+				'hasbeta' => 'up_value'
+			];
+			$conds = [
+				'rev_timestamp > ' . $dbr->timestamp( 20170101000000 ),
+				"$revUser > $lastUserId"
+			];
+			$options = [
+				'GROUP BY' => $revUser,
+				'ORDER BY' => 'user',
+				'LIMIT' => $this->mBatchSize,
+			];
+			$joins = [
+				'user_properties' => [
+					'LEFT OUTER JOIN',
+					"$revUser = up_user AND up_property = 'uls-compact-links' AND up_value = 1"
+				],
+				'user_groups' => [
+					'LEFT OUTER JOIN',
+					"$revUser = ug_user AND ug_group = 'bot'"
+				]
+			] + $actorQuery['joins'];
+
+			if ( !$really ) {
+				echo "\n\n" .
+					$dbr->selectSqlText( $tables, $fields, $conds, __METHOD__, $options, $joins ) .
+					"\n";
+			}
+
+			$results = $dbr->select( $tables, $fields, $conds, __METHOD__, $options, $joins );
+
+			$disabled = 0;
+
+			foreach ( $results as $row ) {
+				$lastUserId = $row->user;
+				if ( $row->isbot === 'bot' || $row->hasbeta !== null ) {
+					continue;
+				}
+
+				$user = User::newFromId( $lastUserId );
+				$user->load( User::READ_LATEST );
+
+				if ( $really ) {
+					$user->setOption( 'compact-language-links', 0 );
+
+					$user->saveSettings();
+				}
+
+				$disabled++;
+				// If we ever need to revert, print the affected user ids
+				$this->output( $row->user . " ", 'userids' );
+			}
+
+			$this->output( "Disabled compact-language-links for $disabled users.\n" );
+			wfWaitForSlaves();
+		} while ( $results->numRows() === $this->mBatchSize );
+
+		$this->output( "done.\n" );
+	}
+}
+
+$maintClass = ULSCompactLinksDisablePref::class;
+require_once RUN_MAINTENANCE_IF_MAIN;