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