includes/specials/SpecialWantedfiles.php

   1 <?php
   2 /**
   3  * Implements Special:Wantedfiles
   4  *
   5  * Copyright © 2008 Soxred93
   6  *
   7  * This program is free software; you can redistribute it and/or modify
   8  * it under the terms of the GNU General Public License as published by
   9  * the Free Software Foundation; either version 2 of the License, or
  10  * (at your option) any later version.
  11  *
  12  * This program is distributed in the hope that it will be useful,
  13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  15  * GNU General Public License for more details.
  16  *
  17  * You should have received a copy of the GNU General Public License along
  18  * with this program; if not, write to the Free Software Foundation, Inc.,
  19  * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
  20  * http://www.gnu.org/copyleft/gpl.html
  21  *
  22  * @file
  23  * @ingroup SpecialPage
  24  * @author Soxred93 <soxred93@gmail.com>
  25  */
  26
  27 /**
  28  * Querypage that lists the most wanted files
  29  *
  30  * @ingroup SpecialPage
  31  */
  32 class WantedFilesPage extends WantedQueryPage {
  33
  34         function __construct( $name = 'Wantedfiles' ) {
  35                 parent::__construct( $name );
  36         }
  37
  38         function getPageHeader() {
  39                 # Specifically setting to use "Wanted Files" (NS_MAIN) as title, so as to get what
  40                 # category would be used on main namespace pages, for those tricky wikipedia
  41                 # admins who like to do {{#ifeq:{{NAMESPACE}}|foo|bar|....}}.
  42                 $catMessage = $this->msg( 'broken-file-category' )
  43                         ->title( Title::newFromText( "Wanted Files", NS_MAIN ) )
  44                         ->inContentLanguage();
  45
  46                 if ( !$catMessage->isDisabled() ) {
  47                         $category = Title::makeTitleSafe( NS_CATEGORY, $catMessage->text() );
  48                 } else {
  49                         $category = false;
  50                 }
  51
  52                 if ( $category ) {
  53                         return $this
  54                                 ->msg( 'wantedfiletext-cat' )
  55                                 ->params( $category->getFullText() )
  56                                 ->parseAsBlock();
  57                 } else {
  58                         return $this
  59                                 ->msg( 'wantedfiletext-nocat' )
  60                                 ->parseAsBlock();
  61                 }
  62         }
  63
  64         /**
  65          * KLUGE: The results may contain false positives for files
  66          * that exist e.g. in a shared repo.  Setting this at least
  67          * keeps them from showing up as redlinks in the output, even
  68          * if it doesn't fix the real problem (bug 6220).
  69          * @return bool
  70          */
  71         function forceExistenceCheck() {
  72                 return true;
  73         }
  74
  75         function getQueryInfo() {
  76                 return array(
  77                         'tables' => array(
  78                                 'imagelinks',
  79                                 'page',
  80                                 'redirect',
  81                                 'img1' => 'image',
  82                                 'img2' => 'image',
  83                         ),
  84                         'fields' => array(
  85                                 'namespace' => NS_FILE,
  86                                 'title' => 'il_to',
  87                                 'value' => 'COUNT(*)'
  88                         ),
  89                         'conds' => array(
  90                                 'img1.img_name' => null,
  91                                 // We also need to exclude file redirects
  92                                 'img2.img_name' => null,
  93                          ),
  94                         'options' => array( 'GROUP BY' => 'il_to' ),
  95                         'join_conds' => array(
  96                                 'img1' => array( 'LEFT JOIN',
  97                                         'il_to = img1.img_name'
  98                                 ),
  99                                 'page' => array( 'LEFT JOIN', array(
 100                                         'il_to = page_title',
 101                                         'page_namespace' => NS_FILE,
 102                                 ) ),
 103                                 'redirect' => array( 'LEFT JOIN', array(
 104                                         'page_id = rd_from',
 105                                         'rd_namespace' => NS_FILE,
 106                                         'rd_interwiki' => ''
 107                                 ) ),
 108                                 'img2' => array( 'LEFT JOIN',
 109                                         'rd_title = img2.img_name'
 110                                 )
 111                         )
 112                 );
 113         }
 114
 115         protected function getGroupName() {
 116                 return 'maintenance';
 117         }
 118 }