SpecialWantedFiles.php

Go to the documentation of this file.

<?php
namespace MediaWiki\Specials;
 
use MediaWiki\Cache\LinkBatchFactory;
use MediaWiki\Page\PageReferenceValue;
use MediaWiki\SpecialPage\WantedQueryPage;
use MediaWiki\Title\Title;
use RepoGroup;
use Wikimedia\Rdbms\IConnectionProvider;
 
class SpecialWantedFiles extends WantedQueryPage {
 
    private RepoGroup $repoGroup;
 
    public function __construct(
        RepoGroup $repoGroup,
        IConnectionProvider $dbProvider,
        LinkBatchFactory $linkBatchFactory
    ) {
        parent::__construct( 'Wantedfiles' );
        $this->repoGroup = $repoGroup;
        $this->setDatabaseProvider( $dbProvider );
        $this->setLinkBatchFactory( $linkBatchFactory );
    }
 
    protected function getPageHeader() {
        # Specifically setting to use "Wanted Files" (NS_MAIN) as title, so as to get what
        # category would be used on main namespace pages, for those tricky wikipedia
        # admins who like to do {{#ifeq:{{NAMESPACE}}|foo|bar|....}}.
        $catMessage = $this->msg( 'broken-file-category' )
            ->page( PageReferenceValue::localReference( NS_MAIN, "Wanted Files" ) )
            ->inContentLanguage();
 
        if ( !$catMessage->isDisabled() ) {
            $category = Title::makeTitleSafe( NS_CATEGORY, $catMessage->text() );
        } else {
            $category = false;
        }
 
        $noForeign = '';
        if ( !$this->likelyToHaveFalsePositives() ) {
            // Additional messages for grep:
            // wantedfiletext-cat-noforeign, wantedfiletext-nocat-noforeign
            $noForeign = '-noforeign';
        }
 
        if ( $category ) {
            return $this
                ->msg( 'wantedfiletext-cat' . $noForeign )
                ->params( $category->getFullText() )
                ->parseAsBlock();
        } else {
            return $this
                ->msg( 'wantedfiletext-nocat' . $noForeign )
                ->parseAsBlock();
        }
    }
 
    protected function likelyToHaveFalsePositives() {
        return $this->repoGroup->hasForeignRepos();
    }
 
    protected function forceExistenceCheck() {
        return true;
    }
 
    protected function existenceCheck( Title $title ) {
        return (bool)$this->repoGroup->findFile( $title );
    }
 
    public function getQueryInfo() {
        return [
            'tables' => [
                'imagelinks',
                'page',
                'redirect',
                'img1' => 'image',
                'img2' => 'image',
            ],
            'fields' => [
                'namespace' => NS_FILE,
                'title' => 'il_to',
                'value' => 'COUNT(*)'
            ],
            'conds' => [
                'img1.img_name' => null,
                // We also need to exclude file redirects
                'img2.img_name' => null,
            ],
            'options' => [ 'GROUP BY' => 'il_to' ],
            'join_conds' => [
                'img1' => [ 'LEFT JOIN',
                    'il_to = img1.img_name'
                ],
                'page' => [ 'LEFT JOIN', [
                    'il_to = page_title',
                    'page_namespace' => NS_FILE,
                ] ],
                'redirect' => [ 'LEFT JOIN', [
                    'page_id = rd_from',
                    'rd_namespace' => NS_FILE,
                    'rd_interwiki' => ''
                ] ],
                'img2' => [ 'LEFT JOIN',
                    'rd_title = img2.img_name'
                ]
            ]
        ];
    }
 
    protected function getGroupName() {
        return 'maintenance';
    }
}
 
class_alias( SpecialWantedFiles::class, 'WantedFilesPage' );