MediaWiki  master
checkUsernames.php
Go to the documentation of this file.
1 <?php
24 require_once __DIR__ . '/Maintenance.php';
25 
34 class CheckUsernames extends Maintenance {
35 
36  public function __construct() {
37  parent::__construct();
38  $this->addDescription( 'Verify that database usernames are actually valid' );
39  $this->setBatchSize( 1000 );
40  }
41 
42  public function execute() {
43  $dbr = $this->getDB( DB_REPLICA );
44 
45  $maxUserId = 0;
46  do {
47  $res = $dbr->select( 'user',
48  [ 'user_id', 'user_name' ],
49  [ 'user_id > ' . $maxUserId ],
50  __METHOD__,
51  [
52  'ORDER BY' => 'user_id',
53  'LIMIT' => $this->getBatchSize(),
54  ]
55  );
56 
57  foreach ( $res as $row ) {
58  if ( !User::isValidUserName( $row->user_name ) ) {
59  $this->output( sprintf( "Found: %6d: '%s'\n", $row->user_id, $row->user_name ) );
60  wfDebugLog( 'checkUsernames', $row->user_name );
61  }
62  }
63  $maxUserId = $row->user_id;
64  } while ( $res->numRows() );
65  }
66 }
67 
68 $maintClass = CheckUsernames::class;
69 require_once RUN_MAINTENANCE_IF_MAIN;
const RUN_MAINTENANCE_IF_MAIN
Definition: Maintenance.php:39
Abstract maintenance class for quickly writing and churning out maintenance scripts with minimal effo...
Definition: Maintenance.php:86
setBatchSize( $s=0)
Set the batch size.
addDescription( $text)
Set the description text.
output( $out, $channel=null)
Throw some output to the user.
$maintClass
static isValidUserName( $name)
Is the input a valid username?
Definition: User.php:917
wfDebugLog( $logGroup, $text, $dest='all', array $context=[])
Send a line to a supplementary debug log file, if configured, or main debug log if not...
getBatchSize()
Returns batch size.
const DB_REPLICA
Definition: defines.php:25
Maintenance script to check that database usernames are actually valid.
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.