[Summary view] [Print] [Text view]

   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
   5   *
   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.
  10   *
  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.
  15   *
  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
  20   *
  21   * @file
  22   * @ingroup Maintenance
  23   */
  24  
  25  require_once  __DIR__ . '/Maintenance.php';
  26  
  27  /**
  28   * Maintenance script that fixes the user_registration field.
  29   *
  30   * @ingroup Maintenance
  31   */
  32  class FixUserRegistration extends Maintenance {
  33  	public function __construct() {
  34          parent::__construct();
  35          $this->mDescription = "Fix the user_registration field";
  36      }
  37  
  38  	public function execute() {
  39          $dbr = wfGetDB( DB_SLAVE );
  40          $dbw = wfGetDB( DB_MASTER );
  41  
  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(
  48                  'revision',
  49                  'MIN(rev_timestamp)',
  50                  array( 'rev_user' => $id ),
  51                  __METHOD__
  52              );
  53              // Update
  54              if ( !empty( $timestamp ) ) {
  55                  $dbw->update(
  56                      'user',
  57                      array( 'user_registration' => $timestamp ),
  58                      array( 'user_id' => $id ),
  59                      __METHOD__
  60                  );
  61                  $this->output( "$id $timestamp\n" );
  62              } else {
  63                  $this->output( "$id NULL\n" );
  64              }
  65          }
  66          $this->output( "\n" );
  67      }
  68  }
  69  
  70  $maintClass = "FixUserRegistration";
  71  require_once RUN_MAINTENANCE_IF_MAIN;