SpecialUnusedimages.php

Go to the documentation of this file.

<?php
class UnusedimagesPage extends ImageQueryPage {
        function __construct( $name = 'Unusedimages' ) {
                parent::__construct( $name );
        }

        function isExpensive() {
                return true;
        }

        function sortDescending() {
                return false;
        }

        function isSyndicated() {
                return false;
        }

        function getQueryInfo() {
                global $wgCountCategorizedImagesAsUsed;
                $retval = array (
                        'tables' => array ( 'image', 'imagelinks' ),
                        'fields' => array ( "'" . NS_FILE . "' AS namespace",
                                        'img_name AS title',
                                        'img_timestamp AS value',
                                        'img_user', 'img_user_text',
                                        'img_description' ),
                        'conds' => array ( 'il_to IS NULL' ),
                        'join_conds' => array ( 'imagelinks' => array (
                                        'LEFT JOIN', 'il_to = img_name' ) )
                );

                if ( $wgCountCategorizedImagesAsUsed ) {
                        // Order is significant
                        $retval['tables'] = array ( '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'] = array (
                                        'LEFT JOIN', 'cl_from = page_id' );
                        $retval['join_conds']['imagelinks'] = array (
                                        'LEFT JOIN', 'il_to = page_title' );
                }
                return $retval;
        }

        function usesTimestamps() {
                return true;
        }

        function getPageHeader() {
                return wfMsgExt( 'unusedimagestext', array( 'parse' ) );
        }

}