maintenance/checkBadRedirects.php

   1 <?php
   2 /**
   3  * Check that pages marked as being redirects really are.
   4  *
   5  * This program is free software; you can redistribute it and/or modify
   6  * it under the terms of the GNU General Public License as published by
   7  * the Free Software Foundation; either version 2 of the License, or
   8  * (at your option) any later version.
   9  *
  10  * This program is distributed in the hope that it will be useful,
  11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  13  * GNU General Public License for more details.
  14  *
  15  * You should have received a copy of the GNU General Public License along
  16  * with this program; if not, write to the Free Software Foundation, Inc.,
  17  * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
  18  * http://www.gnu.org/copyleft/gpl.html
  19  *
  20  * @file
  21  * @ingroup Maintenance
  22  */
  23
  24 use MediaWiki\Maintenance\Maintenance;
  25 use MediaWiki\Revision\SlotRecord;
  26 use MediaWiki\Title\Title;
  27
  28 // @codeCoverageIgnoreStart
  29 require_once __DIR__ . '/Maintenance.php';
  30 // @codeCoverageIgnoreEnd
  31
  32 /**
  33  * Maintenance script to check that pages marked as being redirects really are.
  34  *
  35  * @ingroup Maintenance
  36  */
  37 class CheckBadRedirects extends Maintenance {
  38         public function __construct() {
  39                 parent::__construct();
  40                 $this->addDescription( 'Check for bad redirects' );
  41         }
  42
  43         public function execute() {
  44                 $this->output( "Fetching redirects...\n" );
  45                 $dbr = $this->getReplicaDB();
  46                 $result = $dbr->newSelectQueryBuilder()
  47                         ->select( [ 'page_namespace', 'page_title', 'page_latest' ] )
  48                         ->from( 'page' )
  49                         ->where( [ 'page_is_redirect' => 1 ] )
  50                         ->caller( __METHOD__ )
  51                         ->fetchResultSet();
  52
  53                 $count = $result->numRows();
  54                 $this->output( "Found $count redirects.\n" .
  55                         "Checking for bad redirects:\n\n" );
  56
  57                 $revLookup = $this->getServiceContainer()->getRevisionLookup();
  58                 foreach ( $result as $row ) {
  59                         $title = Title::makeTitle( $row->page_namespace, $row->page_title );
  60                         $revRecord = $revLookup->getRevisionById( $row->page_latest );
  61                         if ( $revRecord ) {
  62                                 $target = $revRecord->getContent( SlotRecord::MAIN )->getRedirectTarget();
  63                                 if ( !$target ) {
  64                                         $this->output( $title->getPrefixedText() . "\n" );
  65                                 }
  66                         }
  67                 }
  68                 $this->output( "\nDone.\n" );
  69         }
  70 }
  71
  72 // @codeCoverageIgnoreStart
  73 $maintClass = CheckBadRedirects::class;
  74 require_once RUN_MAINTENANCE_IF_MAIN;
  75 // @codeCoverageIgnoreEnd