includes/specials/SpecialMostimages.php

   1 <?php
   2 /**
   3  * Implements Special:Mostimages
   4  *
   5  * Copyright © 2005 Ævar Arnfjörð Bjarmason
   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 Ævar Arnfjörð Bjarmason <avarab@gmail.com>
  25  */
  26
  27 /**
  28  * A special page page that list most used images
  29  *
  30  * @ingroup SpecialPage
  31  */
  32 class MostimagesPage extends ImageQueryPage {
  33
  34         function getName() { return 'Mostimages'; }
  35         function isExpensive() { return true; }
  36         function isSyndicated() { return false; }
  37
  38         function getSQL() {
  39                 $dbr = wfGetDB( DB_SLAVE );
  40                 $imagelinks = $dbr->tableName( 'imagelinks' );
  41                 return
  42                         "
  43                         SELECT
  44                                 'Mostimages' as type,
  45                                 " . NS_FILE . " as namespace,
  46                                 il_to as title,
  47                                 COUNT(*) as value
  48                         FROM $imagelinks
  49                         GROUP BY il_to
  50                         HAVING COUNT(*) > 1
  51                         ";
  52         }
  53
  54         function getCellHtml( $row ) {
  55                 global $wgLang;
  56                 return wfMsgExt( 'nlinks',  array( 'parsemag', 'escape' ),
  57                         $wgLang->formatNum( $row->value ) ) . '<br />';
  58         }
  59
  60 }
  61
  62 /**
  63  * Constructor
  64  */
  65 function wfSpecialMostimages() {
  66         list( $limit, $offset ) = wfCheckLimits();
  67
  68         $wpp = new MostimagesPage();
  69
  70         $wpp->doQuery( $offset, $limit );
  71 }