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 getName() {
  35                 return 'Wantedfiles';
  36         }
  37
  38         /**
  39          * KLUGE: The results may contain false positives for files
  40          * that exist e.g. in a shared repo.  Setting this at least
  41          * keeps them from showing up as redlinks in the output, even
  42          * if it doesn't fix the real problem (bug 6220).
  43          */
  44         function forceExistenceCheck() {
  45                 return true;
  46         }
  47
  48         function getSQL() {
  49                 $dbr = wfGetDB( DB_SLAVE );
  50                 list( $imagelinks, $image ) = $dbr->tableNamesN( 'imagelinks', 'image' );
  51                 $name = $dbr->addQuotes( $this->getName() );
  52                 return
  53                         "
  54                         SELECT
  55                                 $name as type,
  56                                 " . NS_FILE . " as namespace,
  57                                 il_to as title,
  58                                 COUNT(*) as value
  59                         FROM $imagelinks
  60                         LEFT JOIN $image ON il_to = img_name
  61                         WHERE img_name IS NULL
  62                         GROUP BY il_to
  63                         ";
  64         }
  65 }
  66
  67 /**
  68  * constructor
  69  */
  70 function wfSpecialWantedFiles() {
  71         list( $limit, $offset ) = wfCheckLimits();
  72
  73         $wpp = new WantedFilesPage();
  74
  75         $wpp->doQuery( $offset, $limit );
  76 }