SpecialLonelyPages.php

Go to the documentation of this file.

<?php
use MediaWiki\MediaWikiServices;
 
class SpecialLonelyPages extends PageQueryPage {
    public function __construct( $name = 'Lonelypages' ) {
        parent::__construct( $name );
    }
 
    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() {
        $tables = [ 'page', 'pagelinks', 'templatelinks' ];
        $conds = [
            'pl_namespace IS NULL',
            'page_namespace' => MediaWikiServices::getInstance()->getNamespaceInfo()->
                getContentNamespaces(),
            'page_is_redirect' => 0,
            'tl_namespace IS NULL'
        ];
        $joinConds = [
            'pagelinks' => [
                'LEFT JOIN', [
                    'pl_namespace = page_namespace',
                    'pl_title = page_title'
                ]
            ],
            'templatelinks' => [
                'LEFT JOIN', [
                    'tl_namespace = page_namespace',
                    'tl_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' => $joinConds
        ];
    }
 
    protected function getOrderFields() {
        // For some crazy reason ordering by a constant
        // causes a filesort in MySQL 5
        if ( count( MediaWikiServices::getInstance()->getNamespaceInfo()->
            getContentNamespaces() ) > 1
        ) {
            return [ 'page_namespace', 'page_title' ];
        } else {
            return [ 'page_title' ];
        }
    }
 
    protected function getGroupName() {
        return 'maintenance';
    }
}