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         function getSQL() {
  39                 $dbr = wfGetDB( DB_SLAVE );
  40                 list( $imagelinks, $page ) = $dbr->tableNamesN( 'imagelinks', 'page' );
  41                 $name = $dbr->addQuotes( $this->getName() );
  42                 return
  43                         "
  44                         SELECT
  45                                 $name as type,
  46                                 " . NS_FILE . " as namespace,
  47                                 il_to as title,
  48                                 COUNT(*) as value
  49                         FROM $imagelinks
  50                         LEFT JOIN $page ON il_to = page_title AND page_namespace = ". NS_FILE ."
  51                         WHERE page_title IS NULL
  52                         GROUP BY il_to
  53                         ";
  54         }
  55 }
  56
  57 /**
  58  * constructor
  59  */
  60 function wfSpecialWantedFiles() {
  61         list( $limit, $offset ) = wfCheckLimits();
  62
  63         $wpp = new WantedFilesPage();
  64
  65         $wpp->doQuery( $offset, $limit );
  66 }