SpecialLonelyPages.php

Go to the documentation of this file.

<?php
use MediaWiki\MediaWikiServices;

class SpecialLonelyPages extends PageQueryPage {
    function __construct( $name = 'Lonelypages' ) {
        parent::__construct( $name );
    }

    function getPageHeader() {
        return $this->msg( 'lonelypagestext' )->parseAsBlock();
    }

    function sortDescending() {
        return false;
    }

    function isExpensive() {
        return true;
    }

    function isSyndicated() {
        return false;
    }

    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
        Hooks::run( 'LonelyPagesQuery', [ &$tables, &$conds, &$joinConds ] );

        return [
            'tables' => $tables,
            'fields' => [
                'namespace' => 'page_namespace',
                'title' => 'page_title',
                'value' => 'page_title'
            ],
            'conds' => $conds,
            'join_conds' => $joinConds
        ];
    }

    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';
    }
}