SpecialWantedfiles.php

Go to the documentation of this file.

<?php
class WantedFilesPage extends WantedQueryPage {
 
    function __construct( $name = 'Wantedfiles' ) {
        parent::__construct( $name );
    }
 
    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' )
            ->title( Title::newFromText( "Wanted Files", NS_MAIN ) )
            ->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 RepoGroup::singleton()->hasForeignRepos();
    }
 
    function forceExistenceCheck() {
        return true;
    }
 
    protected function existenceCheck( Title $title ) {
        return (bool)wfFindFile( $title );
    }
 
    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';
    }
}