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 ( 'pl_namespace AS namespace',
                                        'pl_title AS title',
                                        'COUNT(*) AS value',
                                        'page_namespace' ),
                        'options' => array ( 'HAVING' => 'COUNT(*) > 1',
                                'GROUP BY' => '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( $db->numRows( $res ) > 0 ) {
                        $linkBatch = new LinkBatch();
                        foreach ( $res as $row ) {
                                $linkBatch->add( $row->namespace, $row->title );
                        }
                        $db->dataSeek( $res, 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 '<!-- ' . htmlspecialchars( "Invalid title: [[$title]]" ) . ' -->';
                }
                $link = Linker::link( $title );
                $wlh = $this->makeWlhLink( $title,
                        $this->msg( 'nlinks' )->numParams( $result->value )->escaped() );
                return $this->getLanguage()->specialList( $link, $wlh );
        }
}