Page MenuHomeWickedGov Phorge

fixWrongPasswordPrefixes.php
No OneTemporary

Size
1 KB
Referenced Files
None
Subscribers
None

fixWrongPasswordPrefixes.php

<?php
/**
* @license GPL-2.0-or-later
* @file
* @ingroup Maintenance
*/
use Wikimedia\Rdbms\IExpression;
use Wikimedia\Rdbms\LikeValue;
// @codeCoverageIgnoreStart
require_once __DIR__ . '/Maintenance.php';
// @codeCoverageIgnoreEnd
/**
* An error in a previous version of MediaWiki caused B type passwords to be written with
* an :A: prefix to the database. This script corrects this.
*
* @since 1.44
* @ingroup Maintenance
*/
class FixWrongPasswordPrefixes extends LoggedUpdateMaintenance {
public function __construct() {
parent::__construct();
$this->setBatchSize( 100 );
}
/** @inheritDoc */
protected function getUpdateKey() {
return __CLASS__;
}
/** @inheritDoc */
protected function doDBUpdates() {
$dbw = $this->getPrimaryDB();
$batchSize = $this->getBatchSize();
$minUserId = 0;
while ( true ) {
$res = $dbw->newSelectQueryBuilder()
->select( [ 'user_id', 'user_password' ] )
->from( 'user' )
->where( $dbw->expr( 'user_id', '>', $minUserId ) )
->andWhere(
$dbw->expr( 'user_password', IExpression::LIKE, new LikeValue( ':A:', $dbw->anyString() ) )
)
->orderBy( 'user_id' )
->limit( $batchSize )
->caller( __METHOD__ )
->fetchResultSet();
if ( $res->numRows() === 0 ) {
break;
}
foreach ( $res as $row ) {
$passwordHash = substr( $row->user_password, 3 );
if ( strpos( $passwordHash, ':' ) > 0 ) {
$dbw->newUpdateQueryBuilder()
->update( 'user' )
->set( [ 'user_password' => ':B:' . $passwordHash ] )
->where( [ 'user_id' => $row->user_id ] )
->caller( __METHOD__ )
->execute();
}
$minUserId = $row->user_id;
}
}
$this->output( "Wrongly prefixed user password hashes, if present, have been fixed.\n" );
return true;
}
}
// @codeCoverageIgnoreStart
$maintClass = FixWrongPasswordPrefixes::class;
require_once RUN_MAINTENANCE_IF_MAIN;
// @codeCoverageIgnoreEnd

File Metadata

Mime Type
text/x-php
Expires
Oct 7 2026, 04:33 (6 w, 3 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
b4/45/15c94e2a5e31ca14b29e11750ce7
Default Alt Text
fixWrongPasswordPrefixes.php (1 KB)

Event Timeline