SpecialUnusedImages.php

Go to the documentation of this file.

<?php
use Wikimedia\Rdbms\ILoadBalancer;
 
class SpecialUnusedImages extends ImageQueryPage {
 
    public function __construct( ILoadBalancer $loadBalancer ) {
        parent::__construct( 'Unusedimages' );
        $this->setDBLoadBalancer( $loadBalancer );
    }
 
    public function isExpensive() {
        return true;
    }
 
    protected function sortDescending() {
        return false;
    }
 
    public function isSyndicated() {
        return false;
    }
 
    public function getQueryInfo() {
        $retval = [
            'tables' => [ 'image', 'imagelinks' ],
            'fields' => [
                'namespace' => NS_FILE,
                'title' => 'img_name',
                'value' => 'img_timestamp',
            ],
            'conds' => [ 'il_to IS NULL' ],
            'join_conds' => [ 'imagelinks' => [ 'LEFT JOIN', 'il_to = img_name' ] ]
        ];
 
        if ( $this->getConfig()->get( 'CountCategorizedImagesAsUsed' ) ) {
            // Order is significant
            $retval['tables'] = [ 'image', 'page', 'categorylinks',
                'imagelinks' ];
            $retval['conds']['page_namespace'] = NS_FILE;
            $retval['conds'][] = 'cl_from IS NULL';
            $retval['conds'][] = 'img_name = page_title';
            $retval['join_conds']['categorylinks'] = [
                'LEFT JOIN', 'cl_from = page_id' ];
            $retval['join_conds']['imagelinks'] = [
                'LEFT JOIN', 'il_to = page_title' ];
        }
 
        return $retval;
    }
 
    public function usesTimestamps() {
        return true;
    }
 
    protected function getPageHeader() {
        if ( $this->getConfig()->get( 'CountCategorizedImagesAsUsed' ) ) {
            return $this->msg(
                'unusedimagestext-categorizedimgisused'
            )->parseAsBlock();
        }
        return $this->msg( 'unusedimagestext' )->parseAsBlock();
    }
 
    protected function getGroupName() {
        return 'maintenance';
    }
}