SpecialWantedPages.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Cache\LinkBatchFactory;
use MediaWiki\MainConfigNames;
use MediaWiki\SpecialPage\WantedQueryPage;
use Wikimedia\Rdbms\IConnectionProvider;
 
class SpecialWantedPages extends WantedQueryPage {
 
    public function __construct(
        IConnectionProvider $dbProvider,
        LinkBatchFactory $linkBatchFactory
    ) {
        parent::__construct( 'Wantedpages' );
        $this->setDatabaseProvider( $dbProvider );
        $this->setLinkBatchFactory( $linkBatchFactory );
    }
 
    public function isIncludable() {
        return true;
    }
 
    public function execute( $par ) {
        $inc = $this->including();
 
        if ( $inc ) {
            $this->limit = (int)$par;
            $this->offset = 0;
        }
        $this->shownavigation = !$inc;
        parent::execute( $par );
    }
 
    public function getQueryInfo() {
        $dbr = $this->getDatabaseProvider()->getReplicaDatabase();
        $count = $this->getConfig()->get( MainConfigNames::WantedPagesThreshold ) - 1;
        $query = [
            'tables' => [
                'pagelinks',
                'pg1' => 'page',
                'pg2' => 'page'
            ],
            'fields' => [
                'namespace' => 'pl_namespace',
                'title' => 'pl_title',
                'value' => 'COUNT(*)'
            ],
            'conds' => [
                'pg1.page_namespace' => null,
                'pl_namespace NOT IN (' . $dbr->makeList( [ NS_USER, NS_USER_TALK ] ) . ')',
                'pg2.page_namespace != ' . $dbr->addQuotes( NS_MEDIAWIKI ),
            ],
            'options' => [
                'HAVING' => [
                    'COUNT(*) > ' . $dbr->addQuotes( $count ),
                    'COUNT(*) > SUM(pg2.page_is_redirect)'
                ],
                'GROUP BY' => [ 'pl_namespace', 'pl_title' ]
            ],
            'join_conds' => [
                'pg1' => [
                    'LEFT JOIN', [
                        'pg1.page_namespace = pl_namespace',
                        'pg1.page_title = pl_title'
                    ]
                ],
                'pg2' => [ 'LEFT JOIN', 'pg2.page_id = pl_from' ]
            ]
        ];
        // Replacement for the WantedPages::getSQL hook
        $this->getHookRunner()->onWantedPages__getQueryInfo( $this, $query );
 
        return $query;
    }
 
    protected function getGroupName() {
        return 'maintenance';
    }
}
 
class_alias( SpecialWantedPages::class, 'WantedPagesPage' );