resetUserTokens.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/Maintenance.php';

class ResetUserTokens extends Maintenance {
    public function __construct() {
        parent::__construct();
        $this->mDescription = "Reset the user_token of all users on the wiki. Note that this may log some of them out.";
        $this->addOption( 'nowarn', "Hides the 5 seconds warning", false, false );
        $this->addOption( 'nulls', 'Only reset tokens that are currently null (string of \x00\'s)', false, false );
        $this->setBatchSize( 1000 );
    }

    public function execute() {
        $this->nullsOnly = $this->getOption( 'nulls' );

        if ( !$this->getOption( 'nowarn' ) ) {
            if ( $this->nullsOnly ) {
                $this->output( "The script is about to reset the user_token for USERS WITH NULL TOKENS in the database.\n" );
            } else {
                $this->output( "The script is about to reset the user_token for ALL USERS in the database.\n" );
                $this->output( "This may log some of them out and is not necessary unless you believe your\n" );
                $this->output( "user table has been compromised.\n" );
            }
            $this->output( "\n" );
            $this->output( "Abort with control-c in the next five seconds (skip this countdown with --nowarn) ... " );
            wfCountDown( 5 );
        }

        // We list user by user_id from one of the slave database
        $dbr = wfGetDB( DB_SLAVE );

        $where = array();
        if ( $this->nullsOnly ) {
            // Have to build this by hand, because \ is escaped in helper functions
            $where = array( 'user_token = \'' . str_repeat( '\0', 32) . '\'' );
        }

        $maxid = $dbr->selectField( 'user', 'MAX(user_id)', array(), __METHOD__ );

        $min = 0;
        $max = $this->mBatchSize;

        do {
            $result = $dbr->select( 'user',
                array( 'user_id' ),
                array_merge(
                    $where,
                    array( 'user_id > ' . $dbr->addQuotes( $min ),
                        'user_id <= ' . $dbr->addQuotes( $max )
                    )
                ),
                __METHOD__
            );

            foreach ( $result as $user ) {
                $this->updateUser( $user->user_id );
            }

            $min = $max;
            $max = $min + $this->mBatchSize;

            wfWaitForSlaves();

        } while ( $max <= $maxid );

    }

    private function updateUser( $userid ) {
        $user = User::newFromId( $userid );
        $username = $user->getName();
        $this->output( 'Resetting user_token for "' . $username . '": ' );
        // Change value
        $user->setToken();
        $user->saveSettings();
        $this->output( " OK\n" );
    }
}

$maintClass = "ResetUserTokens";
require_once RUN_MAINTENANCE_IF_MAIN;