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->stderr, $out );
  29                                 fwrite( $this->log, $out );
  30                         }
  31                 }
  32         }
  33 }
  34
  35 $cun = new checkUsernames();
  36 $cun->main();
  37 ?>