SpecialMostImages.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Deferred\LinksUpdate\ImageLinksTable;
use MediaWiki\MainConfigNames;
use MediaWiki\SpecialPage\ImageQueryPage;
use Wikimedia\Rdbms\IConnectionProvider;
 
class SpecialMostImages extends ImageQueryPage {
 
    private int $imageLinksMigrationStage;
 
    public function __construct( IConnectionProvider $dbProvider ) {
        parent::__construct( 'Mostimages' );
        $this->setDatabaseProvider( $dbProvider );
        $this->imageLinksMigrationStage = $this->getConfig()->get( MainConfigNames::ImageLinksSchemaMigrationStage );
    }
 
    public function isExpensive() {
        return true;
    }
 
    public function isSyndicated() {
        return false;
    }
 
    public function getQueryInfo() {
        if ( $this->imageLinksMigrationStage & SCHEMA_COMPAT_READ_OLD ) {
            $linksTables = [ 'imagelinks' ];
            $titleField = 'il_to';
            $joinConds = [];
        } else {
            $linksTables = [ 'imagelinks', 'linktarget' ];
            $titleField = 'lt_title';
            $joinConds = [ 'linktarget' => [ 'JOIN', 'il_target_id = lt_id' ] ];
        }
 
        return [
            'tables' => $linksTables,
            'fields' => [
                'namespace' => NS_FILE,
                'title' => $titleField,
                'value' => 'COUNT(*)'
            ],
            'join_conds' => $joinConds,
            'options' => [
                'GROUP BY' => $titleField,
                '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' );