SpecialMostlinked.php

Go to the documentation of this file.

<?php
class MostlinkedPage extends QueryPage {
    function __construct( $name = 'Mostlinked' ) {
        parent::__construct( $name );
    }

    function isExpensive() {
        return true;
    }

    function isSyndicated() {
        return false;
    }

    function getQueryInfo() {
        return array(
            'tables' => array( 'pagelinks', 'page' ),
            'fields' => array(
                'namespace' => 'pl_namespace',
                'title' => 'pl_title',
                'value' => 'COUNT(*)',
                'page_namespace'
            ),
            'options' => array(
                'HAVING' => 'COUNT(*) > 1',
                'GROUP BY' => array(
                    'pl_namespace', 'pl_title',
                    'page_namespace'
                )
            ),
            'join_conds' => array(
                'page' => array(
                    'LEFT JOIN',
                    array(
                        'page_namespace = pl_namespace',
                        'page_title = pl_title'
                    )
                )
            )
        );
    }

    function preprocessResults( $db, $res ) {
        if ( $res->numRows() > 0 ) {
            $linkBatch = new LinkBatch();

            foreach ( $res as $row ) {
                $linkBatch->add( $row->namespace, $row->title );
            }

            $res->seek( 0 );
            $linkBatch->execute();
        }
    }

    function makeWlhLink( $title, $caption ) {
        $wlh = SpecialPage::getTitleFor( 'Whatlinkshere', $title->getPrefixedDBkey() );

        return Linker::linkKnown( $wlh, $caption );
    }

    function formatResult( $skin, $result ) {
        $title = Title::makeTitleSafe( $result->namespace, $result->title );
        if ( !$title ) {
            return Html::element(
                'span',
                array( 'class' => 'mw-invalidtitle' ),
                Linker::getInvalidTitleDescription(
                    $this->getContext(),
                    $result->namespace,
                    $result->title )
            );
        }

        $link = Linker::link( $title );
        $wlh = $this->makeWlhLink(
            $title,
            $this->msg( 'nlinks' )->numParams( $result->value )->escaped()
        );

        return $this->getLanguage()->specialList( $link, $wlh );
    }

    protected function getGroupName() {
        return 'highuse';
    }
}