Localisation updates from http://translatewiki.net.
[mediawiki.git] / maintenance / fixUserRegistration.php
blob097936c9828446ca2f61500ff7e01ca21ccedfe3
1 <?php
2 /**
3 * Fix the user_registration field.
4 * In particular, for values which are NULL, set them to the date of the first edit
6 * This program is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 2 of the License, or
9 * (at your option) any later version.
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
16 * You should have received a copy of the GNU General Public License along
17 * with this program; if not, write to the Free Software Foundation, Inc.,
18 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
19 * http://www.gnu.org/copyleft/gpl.html
21 * @file
22 * @ingroup Maintenance
25 require_once __DIR__ . '/Maintenance.php';
27 /**
28 * Maintenance script that fixes the user_registration field.
30 * @ingroup Maintenance
32 class FixUserRegistration extends Maintenance {
33 public function __construct() {
34 parent::__construct();
35 $this->mDescription = "Fix the user_registration field";
38 public function execute() {
39 $dbr = wfGetDB( DB_SLAVE );
40 $dbw = wfGetDB( DB_MASTER );
42 // Get user IDs which need fixing
43 $res = $dbr->select( 'user', 'user_id', 'user_registration IS NULL', __METHOD__ );
44 foreach ( $res as $row ) {
45 $id = $row->user_id;
46 // Get first edit time
47 $timestamp = $dbr->selectField( 'revision', 'MIN(rev_timestamp)', array( 'rev_user' => $id ), __METHOD__ );
48 // Update
49 if ( !empty( $timestamp ) ) {
50 $dbw->update( 'user', array( 'user_registration' => $timestamp ), array( 'user_id' => $id ), __METHOD__ );
51 $this->output( "$id $timestamp\n" );
52 } else {
53 $this->output( "$id NULL\n" );
56 $this->output( "\n" );
60 $maintClass = "FixUserRegistration";
61 require_once RUN_MAINTENANCE_IF_MAIN;