MediaWiki  master
cleanupWatchlist.php
Go to the documentation of this file.
1 <?php
33 
34 require_once __DIR__ . '/cleanupTable.inc';
35 
42  protected $defaultParams = [
43  'table' => 'watchlist',
44  'index' => [ 'wl_user', 'wl_namespace', 'wl_title' ],
45  'conds' => [],
46  'callback' => 'processRow'
47  ];
48 
49  public function __construct() {
50  parent::__construct();
51  $this->addDescription( 'Script to remove broken, unparseable titles in the Watchlist' );
52  $this->addOption( 'fix', 'Actually remove entries; without will only report.' );
53  }
54 
55  function execute() {
56  if ( !$this->hasOption( 'fix' ) ) {
57  $this->output( "Dry run only: use --fix to enable updates\n" );
58  }
59  parent::execute();
60  }
61 
62  protected function processRow( $row ) {
63  $current = Title::makeTitle( $row->wl_namespace, $row->wl_title );
64  $display = $current->getPrefixedText();
65  $verified = MediaWikiServices::getInstance()->getContentLanguage()->normalize( $display );
66  $title = Title::newFromText( $verified );
67 
68  if ( $row->wl_user == 0 || is_null( $title ) || !$title->equals( $current ) ) {
69  $this->output( "invalid watch by {$row->wl_user} for "
70  . "({$row->wl_namespace}, \"{$row->wl_title}\")\n" );
71  $updated = $this->removeWatch( $row );
72  $this->progress( $updated );
73 
74  return;
75  }
76  $this->progress( 0 );
77  }
78 
79  private function removeWatch( $row ) {
80  if ( !$this->dryrun && $this->hasOption( 'fix' ) ) {
81  $dbw = $this->getDB( DB_MASTER );
82  $dbw->delete(
83  'watchlist', [
84  'wl_user' => $row->wl_user,
85  'wl_namespace' => $row->wl_namespace,
86  'wl_title' => $row->wl_title ],
87  __METHOD__
88  );
89 
90  $this->output( "- removed\n" );
91 
92  return 1;
93  } else {
94  return 0;
95  }
96  }
97 }
98 
99 $maintClass = CleanupWatchlist::class;
100 require_once RUN_MAINTENANCE_IF_MAIN;
const RUN_MAINTENANCE_IF_MAIN
Definition: Maintenance.php:39
hasOption( $name)
Checks to see if a particular option exists.
const DB_MASTER
Definition: defines.php:26
Generic class to cleanup a database table.
addDescription( $text)
Set the description text.
output( $out, $channel=null)
Throw some output to the user.
static makeTitle( $ns, $title, $fragment='', $interwiki='')
Create a new Title from a namespace index and a DB key.
Definition: Title.php:586
progress( $updated)
$maintClass
addOption( $name, $description, $required=false, $withArg=false, $shortName=false, $multiOccurrence=false)
Add a parameter to the script.
Maintenance script to remove broken, unparseable titles in the watchlist table.
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
static newFromText( $text, $defaultNamespace=NS_MAIN)
Create a new Title from text, such as what one would find in a link.
Definition: Title.php:316