SpecialMostLinked.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Cache\LinkBatchFactory;
use MediaWiki\Html\Html;
use MediaWiki\Linker\Linker;
use MediaWiki\Linker\LinksMigration;
use MediaWiki\SpecialPage\QueryPage;
use MediaWiki\SpecialPage\SpecialPage;
use MediaWiki\Title\Title;
use Skin;
use stdClass;
use Wikimedia\Rdbms\IConnectionProvider;
use Wikimedia\Rdbms\IDatabase;
use Wikimedia\Rdbms\IResultWrapper;
 
class SpecialMostLinked extends QueryPage {
 
    private LinksMigration $linksMigration;
 
    public function __construct(
        IConnectionProvider $dbProvider,
        LinkBatchFactory $linkBatchFactory,
        LinksMigration $linksMigration
    ) {
        parent::__construct( 'Mostlinked' );
        $this->setDatabaseProvider( $dbProvider );
        $this->setLinkBatchFactory( $linkBatchFactory );
        $this->linksMigration = $linksMigration;
    }
 
    public function isExpensive() {
        return true;
    }
 
    public function isSyndicated() {
        return false;
    }
 
    public function getQueryInfo() {
        $tableFields = $this->linksMigration->getTitleFields( 'pagelinks' );
        $fields = [
            'namespace' => $tableFields[0],
            'title' => $tableFields[1],
        ];
        $queryInfo = $this->linksMigration->getQueryInfo( 'pagelinks' );
        return [
            'tables' => array_merge( $queryInfo['tables'], [ 'page' ] ),
            'fields' => array_merge( [ 'value' => 'COUNT(*)', 'page_namespace' ], $fields ),
            'options' => [
                'HAVING' => 'COUNT(*) > 1',
                'GROUP BY' => array_merge( $tableFields, [ 'page_namespace' ] )
            ],
            'join_conds' => array_merge( $queryInfo['joins'], [
                'page' => [
                    'LEFT JOIN',
                    [
                        'page_namespace = ' . $fields['namespace'],
                        'page_title = ' . $fields['title']
                    ]
                ] ] )
        ];
    }
 
    public function preprocessResults( $db, $res ) {
        $this->executeLBFromResultWrapper( $res );
    }
 
    private function makeWlhLink( $title, $caption ) {
        $wlh = SpecialPage::getTitleFor( 'Whatlinkshere', $title->getPrefixedDBkey() );
 
        $linkRenderer = $this->getLinkRenderer();
        return $linkRenderer->makeKnownLink( $wlh, $caption );
    }
 
    public 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';
    }
}
 
class_alias( SpecialMostLinked::class, 'SpecialMostLinked' );