SpecialMostImages.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Deferred\LinksUpdate\ImageLinksTable;
use MediaWiki\SpecialPage\ImageQueryPage;
use Wikimedia\Rdbms\IConnectionProvider;
 
class SpecialMostImages extends ImageQueryPage {
 
    public function __construct( IConnectionProvider $dbProvider ) {
        parent::__construct( 'Mostimages' );
        $this->setDatabaseProvider( $dbProvider );
    }
 
    public function isExpensive() {
        return true;
    }
 
    public function isSyndicated() {
        return false;
    }
 
    public function getQueryInfo() {
        return [
            'tables' => [ 'imagelinks', 'linktarget' ],
            'fields' => [
                'namespace' => NS_FILE,
                'title' => 'lt_title',
                'value' => 'COUNT(*)'
            ],
            'join_conds' => [ 'linktarget' => [ 'JOIN', 'il_target_id = lt_id' ] ],
            'options' => [
                'GROUP BY' => 'lt_title',
                'HAVING' => 'COUNT(*) > 1'
            ]
        ];
    }
 
    protected function getCellHtml( $row ) {
        return $this->msg( 'nimagelinks' )->numParams( $row->value )->escaped() . '<br />';
    }
 
    protected function getGroupName() {
        return 'highuse';
    }
 
    protected function getRecacheDB() {
        return $this->getDatabaseProvider()->getReplicaDatabase(
            ImageLinksTable::VIRTUAL_DOMAIN,
            'vslow'
        );
    }
}
 
class_alias( SpecialMostImages::class, 'MostimagesPage' );