* A maintenance script to check the validity of user names
[lhc/web/wiklou.git] / maintenance / checkUsernames.php
1 <?php
2 error_reporting(E_ALL ^ E_NOTICE);
3 require_once 'commandLine.inc';
4
5 class checkUsernames {
6 var $stderr;
7
8 function checkUsernames() {
9 $this->stderr = fopen( 'php://stderr', 'wt' );
10 }
11 function main() {
12 global $wgDBname;
13 $fname = 'checkUsernames::main';
14
15 $dbr =& wfGetDB( DB_SLAVE );
16
17 $res = $dbr->select( 'user',
18 array( 'user_id', 'user_name' ),
19 null,
20 $fname
21 );
22
23 fwrite( $this->stderr, "Checking $wgDBname\n" );
24 while ( $row = $dbr->fetchObject( $res ) ) {
25 if ( ! User::isValidUserName( $row->user_name ) )
26 printf( "%s: %6d: %s\n", $wgDBname, $row->user_id, $row->user_name );
27 }
28 }
29 }
30
31 $cun = new checkUsernames;
32 $cun->main();