tidyUpT39714.php

Go to the documentation of this file.

<?php
 
require_once __DIR__ . '/Maintenance.php';
 
use MediaWiki\MediaWikiServices;
 
class TidyUpT39714 extends Maintenance {
    public function execute() {
        // Search for all log entries which are about changing the visability of other log entries.
        $result = $this->getDB( DB_REPLICA )->select(
            'logging',
            [ 'log_id', 'log_params' ],
            [
                'log_type' => [ 'suppress', 'delete' ],
                'log_action' => 'event',
                'log_namespace' => NS_SPECIAL,
                'log_title' => SpecialPage::getTitleFor( 'Log' )->getText()
            ],
            __METHOD__
        );
 
        $lbFactory = MediaWikiServices::getInstance()->getDBLoadBalancerFactory();
        foreach ( $result as $row ) {
            $ids = explode( ',', explode( "\n", $row->log_params )[0] );
            // Work out what log entries were changed here.
            $result = $this->getDB( DB_REPLICA )->select(
                'logging',
                'log_type',
                [ 'log_id' => $ids ],
                __METHOD__,
                'DISTINCT'
            );
            if ( $result->numRows() === 1 ) {
                // If there's only one type, the target title can be set to include it.
                $logTitle = SpecialPage::getTitleFor( 'Log', $result->current()->log_type )->getText();
                $this->output( 'Set log_title to "' . $logTitle . '" for log entry ' . $row->log_id . ".\n" );
                $this->getDB( DB_MASTER )->update(
                    'logging',
                    [ 'log_title' => $logTitle ],
                    [ 'log_id' => $row->log_id ],
                    __METHOD__
                );
                $lbFactory->waitForReplication();
            }
        }
    }
}
 
$maintClass = TidyUpT39714::class;
require_once RUN_MAINTENANCE_IF_MAIN;