Файловый менеджер - Редактировать - /var/www/html/mediawiki-1.43.1/extensions/CheckUser/maintenance/populateCulActor.php
Ðазад
<?php /** * 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 */ namespace MediaWiki\CheckUser\Maintenance; use LoggedUpdateMaintenance; use MediaWiki\MediaWikiServices; $IP = getenv( 'MW_INSTALL_PATH' ); if ( $IP === false ) { $IP = __DIR__ . '/../../..'; } require_once "$IP/maintenance/Maintenance.php"; /** * Maintenance script for filling up cul_actor. * * @author Zabe */ class PopulateCulActor extends LoggedUpdateMaintenance { public function __construct() { parent::__construct(); $this->requireExtension( 'CheckUser' ); $this->addDescription( 'Populate the cul_actor column.' ); $this->addOption( 'sleep', 'Sleep time (in seconds) between every batch. Default: 0', false, true ); } /** * @inheritDoc */ protected function getUpdateKey() { return 'PopulateCulActor-2'; } /** * @inheritDoc */ protected function doDBUpdates() { $services = MediaWikiServices::getInstance(); $actorStore = $services->getActorStore(); $dbr = $services->getDBLoadBalancerFactory()->getReplicaDatabase( false, 'vslow' ); $dbw = $services->getDBLoadBalancerFactory()->getPrimaryDatabase(); $batchSize = $this->getBatchSize(); $prevId = 0; $curId = $prevId + $batchSize; $maxId = (int)$dbr->newSelectQueryBuilder() ->field( 'MAX(cul_id)' ) ->table( 'cu_log' ) ->caller( __METHOD__ ) ->fetchField(); if ( !$maxId ) { $this->output( "The cu_log table seems to be empty.\n" ); return true; } $diff = $maxId - $prevId; $failed = 0; $sleep = (int)$this->getOption( 'sleep', 0 ); do { $res = $dbr->newSelectQueryBuilder() ->fields( [ 'cul_id', 'cul_user' ] ) ->table( 'cu_log' ) ->conds( [ 'cul_actor' => 0, $dbr->expr( 'cul_id', '>=', $prevId ), $dbr->expr( 'cul_id', '<=', $curId ), ] ) ->caller( __METHOD__ ) ->fetchResultSet(); foreach ( $res as $row ) { $name = $actorStore->getUserIdentityByUserId( $row->cul_user )->getName(); $actor = $actorStore->findActorIdByName( $name, $dbr ); if ( !$actor ) { $failed++; continue; } $dbw->newUpdateQueryBuilder() ->update( 'cu_log' ) ->set( [ 'cul_actor' => $actor ] ) ->where( [ 'cul_id' => $row->cul_id ] ) ->caller( __METHOD__ ) ->execute(); } $this->waitForReplication(); if ( $sleep > 0 ) { sleep( $sleep ); } $this->output( "Processed $batchSize rows out of $diff.\n" ); $prevId = $curId; $curId += $batchSize; } while ( $prevId <= $maxId ); $this->output( "Done. Migration failed for $failed row(s).\n" ); return true; } } $maintClass = PopulateCulActor::class; require_once RUN_MAINTENANCE_IF_MAIN;
| ver. 1.1 | |
.
| PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка