SpecialListDuplicatedFiles.php

Go to the documentation of this file.

<?php
use Wikimedia\Rdbms\ResultWrapper;
use Wikimedia\Rdbms\IDatabase;
 
class ListDuplicatedFilesPage extends QueryPage {
    function __construct( $name = 'ListDuplicatedFiles' ) {
        parent::__construct( $name );
    }
 
    public function isExpensive() {
        return true;
    }
 
    function isSyndicated() {
        return false;
    }
 
    public function getQueryInfo() {
        return [
            'tables' => [ 'image' ],
            'fields' => [
                'namespace' => NS_FILE,
                'title' => 'MIN(img_name)',
                'value' => 'count(*)'
            ],
            'options' => [
                'GROUP BY' => 'img_sha1',
                'HAVING' => 'count(*) > 1',
            ],
        ];
    }
 
    function preprocessResults( $db, $res ) {
        $this->executeLBFromResultWrapper( $res );
    }
 
    function formatResult( $skin, $result ) {
        // Future version might include a list of the first 5 duplicates
        // perhaps separated by an "↔".
        $image1 = Title::makeTitle( $result->namespace, $result->title );
        $dupeSearch = SpecialPage::getTitleFor( 'FileDuplicateSearch', $image1->getDBkey() );
 
        $msg = $this->msg( 'listduplicatedfiles-entry' )
            ->params( $image1->getText() )
            ->numParams( $result->value - 1 )
            ->params( $dupeSearch->getPrefixedDBkey() );
 
        return $msg->parse();
    }
 
    protected function getGroupName() {
        return 'media';
    }
}