cleanupWatchlist.php

Go to the documentation of this file.

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

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

    public function __construct() {
        parent::__construct();
        $this->mDescription = "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 = wfGetDB( DB_MASTER );
            $dbw->delete( 'watchlist', array(
                '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;