cleanupWatchlist.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/cleanupTable.inc';

class WatchlistCleanup extends TableCleanup {
    protected $defaultParams = [
        'table' => 'watchlist',
        'index' => [ 'wl_user', 'wl_namespace', 'wl_title' ],
        'conds' => [],
        'callback' => 'processRow'
    ];

    public function __construct() {
        parent::__construct();
        $this->addDescription( 'Script to remove broken, unparseable titles in the Watchlist' );
        $this->addOption( 'fix', 'Actually remove entries; without will only report.' );
    }

    function execute() {
        if ( !$this->hasOption( 'fix' ) ) {
            $this->output( "Dry run only: use --fix to enable updates\n" );
        }
        parent::execute();
    }

    protected function processRow( $row ) {
        global $wgContLang;
        $current = Title::makeTitle( $row->wl_namespace, $row->wl_title );
        $display = $current->getPrefixedText();
        $verified = $wgContLang->normalize( $display );
        $title = Title::newFromText( $verified );

        if ( $row->wl_user == 0 || is_null( $title ) || !$title->equals( $current ) ) {
            $this->output( "invalid watch by {$row->wl_user} for "
                . "({$row->wl_namespace}, \"{$row->wl_title}\")\n" );
            $updated = $this->removeWatch( $row );
            $this->progress( $updated );

            return;
        }
        $this->progress( 0 );
    }

    private function removeWatch( $row ) {
        if ( !$this->dryrun && $this->hasOption( 'fix' ) ) {
            $dbw = $this->getDB( DB_MASTER );
            $dbw->delete(
                'watchlist', [
                'wl_user' => $row->wl_user,
                'wl_namespace' => $row->wl_namespace,
                'wl_title' => $row->wl_title ],
                __METHOD__
            );

            $this->output( "- removed\n" );

            return 1;
        } else {
            return 0;
        }
    }
}

$maintClass = "WatchlistCleanup";
require_once RUN_MAINTENANCE_IF_MAIN;