cleanupWatchlist.php

Go to the documentation of this file.

<?php
require_once( dirname( __FILE__ ) . '/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 );