1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
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;
|
