SpecialMostLinked.php

Go to the documentation of this file.

<?php
use Wikimedia\Rdbms\IResultWrapper;
use Wikimedia\Rdbms\IDatabase;
 
class SpecialMostLinked extends QueryPage {
    function __construct( $name = 'Mostlinked' ) {
        parent::__construct( $name );
    }
 
    public function isExpensive() {
        return true;
    }
 
    function isSyndicated() {
        return false;
    }
 
    public function getQueryInfo() {
        return [
            'tables' => [ 'pagelinks', 'page' ],
            'fields' => [
                'namespace' => 'pl_namespace',
                'title' => 'pl_title',
                'value' => 'COUNT(*)',
                'page_namespace'
            ],
            'options' => [
                'HAVING' => 'COUNT(*) > 1',
                'GROUP BY' => [
                    'pl_namespace', 'pl_title',
                    'page_namespace'
                ]
            ],
            'join_conds' => [
                'page' => [
                    'LEFT JOIN',
                    [
                        'page_namespace = pl_namespace',
                        'page_title = pl_title'
                    ]
                ]
            ]
        ];
    }
 
    function preprocessResults( $db, $res ) {
        $this->executeLBFromResultWrapper( $res );
    }
 
    function makeWlhLink( $title, $caption ) {
        $wlh = SpecialPage::getTitleFor( 'Whatlinkshere', $title->getPrefixedDBkey() );
 
        $linkRenderer = $this->getLinkRenderer();
        return $linkRenderer->makeKnownLink( $wlh, $caption );
    }
 
    function formatResult( $skin, $result ) {
        $title = Title::makeTitleSafe( $result->namespace, $result->title );
        if ( !$title ) {
            return Html::element(
                'span',
                [ 'class' => 'mw-invalidtitle' ],
                Linker::getInvalidTitleDescription(
                    $this->getContext(),
                    $result->namespace,
                    $result->title )
            );
        }
 
        $linkRenderer = $this->getLinkRenderer();
        $link = $linkRenderer->makeLink( $title );
        $wlh = $this->makeWlhLink(
            $title,
            $this->msg( 'nlinks' )->numParams( $result->value )->text()
        );
 
        return $this->getLanguage()->specialList( $link, $wlh );
    }
 
    protected function getGroupName() {
        return 'highuse';
    }
}