Ð¤Ð°Ð¹Ð»Ð¾Ð²Ñ‹Ð¹ Ð¼ÐµÐ½ÐµÐ´Ð¶ÐµÑ€

Ð¤Ð°Ð¹Ð»Ð¾Ð²Ñ‹Ð¹ Ð¼ÐµÐ½ÐµÐ´Ð¶ÐµÑ€ - Ð ÐµÐ´Ð°ÐºÑ‚Ð¸Ñ€Ð¾Ð²Ð°Ñ‚ÑŒ - /var/www/html/mediawiki-1.43.1/maintenance/checkUsernames.php

ÐÐ°Ð·Ð°Ð´
<?php /** * Check that database usernames are actually valid. * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License along * with this program; if not, write to the Free Software Foundation, Inc., * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. * http://www.gnu.org/copyleft/gpl.html * * @file * @ingroup Maintenance / // @codeCoverageIgnoreStart require_once __DIR__ . '/Maintenance.php'; // @codeCoverageIgnoreEnd /* * Maintenance script to check that database usernames are actually valid. * * An existing usernames can become invalid if UserNameUtils::isValid() * is altered or if we change the $wgMaxNameChars * * @ingroup Maintenance */ class CheckUsernames extends Maintenance { public function __construct() { parent::__construct(); $this->addDescription( 'Verify that database usernames are actually valid' ); $this->setBatchSize( 1000 ); } public function execute() { $dbr = $this->getReplicaDB(); $userNameUtils = $this->getServiceContainer()->getUserNameUtils(); $maxUserId = 0; do { $res = $dbr->newSelectQueryBuilder() ->select( [ 'user_id', 'user_name' ] ) ->from( 'user' ) ->where( $dbr->expr( 'user_id', '>', $maxUserId ) ) ->orderBy( 'user_id' ) ->limit( $this->getBatchSize() ) ->caller( __METHOD__ ) ->fetchResultSet(); foreach ( $res as $row ) { if ( !$userNameUtils->isValid( $row->user_name ) ) { $this->output( sprintf( "Found: %6d: '%s'\n", $row->user_id, $row->user_name ) ); wfDebugLog( 'checkUsernames', $row->user_name ); } } // @phan-suppress-next-line PhanPossiblyUndeclaredVariable $res has at at least one item $maxUserId = $row->user_id; } while ( $res->numRows() ); } } // @codeCoverageIgnoreStart $maintClass = CheckUsernames::class; require_once RUN_MAINTENANCE_IF_MAIN; // @codeCoverageIgnoreEnd

| ver. 1.1 | | . | PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ ÑÑ‚Ñ€Ð°Ð½Ð¸Ñ†Ñ‹: 0 | proxy | phpinfo | ÐÐ°ÑÑ‚Ñ€Ð¾Ð¹ÐºÐ°