SpecialLonelyPages.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Language\LanguageConverterFactory;
use MediaWiki\Linker\LinksMigration;
use MediaWiki\Page\LinkBatchFactory;
use MediaWiki\SpecialPage\PageQueryPage;
use MediaWiki\Title\NamespaceInfo;
use Wikimedia\Rdbms\IConnectionProvider;
 
class SpecialLonelyPages extends PageQueryPage {
 
    public function __construct(
        private readonly NamespaceInfo $namespaceInfo,
        IConnectionProvider $dbProvider,
        LinkBatchFactory $linkBatchFactory,
        LanguageConverterFactory $languageConverterFactory,
        private readonly LinksMigration $linksMigration,
    ) {
        parent::__construct( 'Lonelypages' );
        $this->setDatabaseProvider( $dbProvider );
        $this->setLinkBatchFactory( $linkBatchFactory );
        $this->setLanguageConverter( $languageConverterFactory->getLanguageConverter( $this->getContentLanguage() ) );
    }
 
    protected function getPageHeader() {
        return $this->msg( 'lonelypagestext' )->parseAsBlock();
    }
 
    protected function sortDescending() {
        return false;
    }
 
    public function isExpensive() {
        return true;
    }
 
    public function isSyndicated() {
        return false;
    }
 
    public function getQueryInfo() {
        $queryInfo = $this->linksMigration->getQueryInfo( 'pagelinks', 'pagelinks', 'LEFT JOIN' );
        $tables = [ 'page', 'linktarget', 'templatelinks', 'pagelinks' ];
        $conds = [
            'pl_from' => null,
            'page_namespace' => $this->namespaceInfo->getContentNamespaces(),
            'page_is_redirect' => 0,
            'tl_from' => null,
        ];
        $joinConds = [
            'templatelinks' => [ 'LEFT JOIN', [ 'tl_target_id=lt_id' ] ],
            'linktarget' => [
                'LEFT JOIN', [
                    "lt_namespace = page_namespace",
                    "lt_title = page_title"
                ]
            ]
        ];
 
        if ( !in_array( 'linktarget', $queryInfo['tables'] ) ) {
            $joinConds['pagelinks'] = [
                'LEFT JOIN', [
                    "pl_namespace = page_namespace",
                    "pl_title = page_title"
                ]
            ];
        }
 
        // Allow extensions to modify the query
        $this->getHookRunner()->onLonelyPagesQuery( $tables, $conds, $joinConds );
 
        return [
            'tables' => $tables,
            'fields' => [
                'namespace' => 'page_namespace',
                'title' => 'page_title',
            ],
            'conds' => $conds,
            'join_conds' => array_merge( $joinConds, $queryInfo['joins'] )
        ];
    }
 
    protected function getOrderFields() {
        // For some crazy reason ordering by a constant
        // causes a filesort in MySQL 5
        if ( count( $this->namespaceInfo->getContentNamespaces() ) > 1 ) {
            return [ 'page_namespace', 'page_title' ];
        } else {
            return [ 'page_title' ];
        }
    }
 
    protected function getGroupName() {
        return 'maintenance';
    }
}
 
class_alias( SpecialLonelyPages::class, 'SpecialLonelyPages' );