MediaWiki REL1_30
fixUserRegistration.php
Go to the documentation of this file.
1<?php
25require_once __DIR__ . '/Maintenance.php';
26
33 public function __construct() {
34 parent::__construct();
35 $this->addDescription( 'Fix the user_registration field' );
36 $this->setBatchSize( 1000 );
37 }
38
39 public function execute() {
40 $dbw = $this->getDB( DB_MASTER );
41
42 $lastId = 0;
43 do {
44 // Get user IDs which need fixing
45 $res = $dbw->select(
46 'user',
47 'user_id',
48 [
49 'user_id > ' . $dbw->addQuotes( $lastId ),
50 'user_registration IS NULL'
51 ],
52 __METHOD__,
53 [
54 'LIMIT' => $this->mBatchSize,
55 'ORDER BY' => 'user_id',
56 ]
57 );
58 foreach ( $res as $row ) {
59 $id = $row->user_id;
60 $lastId = $id;
61 // Get first edit time
62 $timestamp = $dbw->selectField(
63 'revision',
64 'MIN(rev_timestamp)',
65 [ 'rev_user' => $id ],
66 __METHOD__
67 );
68 // Update
69 if ( $timestamp !== null ) {
70 $dbw->update(
71 'user',
72 [ 'user_registration' => $timestamp ],
73 [ 'user_id' => $id ],
74 __METHOD__
75 );
76 $user = User::newFromId( $id );
77 $user->invalidateCache();
78 $this->output( "Set registration for #$id to $timestamp\n" );
79 } else {
80 $this->output( "Could not find registration for #$id NULL\n" );
81 }
82 }
83 $this->output( "Waiting for replica DBs..." );
85 $this->output( " done.\n" );
86 } while ( $res->numRows() >= $this->mBatchSize );
87 }
88}
89
90$maintClass = "FixUserRegistration";
91require_once RUN_MAINTENANCE_IF_MAIN;
wfWaitForSlaves( $ifWritesSince=null, $wiki=false, $cluster=false, $timeout=null)
Waits for the replica DBs to catch up to the master position.
Maintenance script that fixes the user_registration field.
__construct()
Default constructor.
execute()
Do the actual work.
Abstract maintenance class for quickly writing and churning out maintenance scripts with minimal effo...
getDB( $db, $groups=[], $wiki=false)
Returns a database to be used by current maintenance script.
addDescription( $text)
Set the description text.
setBatchSize( $s=0)
Set the batch size.
$res
Definition database.txt:21
design txt This is a brief overview of the new design More thorough and up to date information is available on the documentation wiki at etc Handles the details of getting and saving to the user table of the and dealing with sessions and cookies OutputPage Encapsulates the entire HTML page that will be sent in response to any server request It is used by calling its functions to add in any and then calling output() to send it all. It could be easily changed to send incrementally if that becomes useful
require_once RUN_MAINTENANCE_IF_MAIN
const DB_MASTER
Definition defines.php:26