maintenance/checkUsernames.php

   1 <?php
   2 error_reporting(E_ALL ^ E_NOTICE);
   3 require_once 'commandLine.inc';
   4
   5 class checkUsernames {
   6         var $stderr, $log;
   7
   8         function checkUsernames() {
   9                 $this->stderr = fopen( 'php://stderr', 'wt' );
  10                 $this->log = fopen( '/home/wikipedia/logs/checkUsernames.log', 'at' );
  11         }
  12         function main() {
  13                 global $wgDBname;
  14                 $fname = 'checkUsernames::main';
  15
  16                 $dbr =& wfGetDB( DB_SLAVE );
  17
  18                 $res = $dbr->select( 'user',
  19                         array( 'user_id', 'user_name' ),
  20                         null,
  21                         $fname
  22                 );
  23
  24                 fwrite( $this->stderr, "Checking $wgDBname\n" );
  25                 while ( $row = $dbr->fetchObject( $res ) ) {
  26                         if ( ! User::isValidUserName( $row->user_name ) ) {
  27                                 $out = sprintf( "%s: %6d: %s\n", $wgDBname, $row->user_id, $row->user_name );
  28                                 fwrite( $this->log, $out );
  29                         }
  30                 }
  31         }
  32 }
  33
  34 $cun = new checkUsernames();
  35 $cun->main();