3 * Implements Special:Mostlinkedcategories
5 * Copyright © 2005, Ævar Arnfjörð Bjarmason
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.
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.
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
23 * @ingroup SpecialPage
24 * @author Ævar Arnfjörð Bjarmason <avarab@gmail.com>
28 * A querypage to show categories ordered in descending order by the pages in them
30 * @ingroup SpecialPage
32 class MostlinkedCategoriesPage
extends QueryPage
{
34 function __construct( $name = 'Mostlinkedcategories' ) {
35 parent
::__construct( $name );
38 function isExpensive() { return true; }
39 function isSyndicated() { return false; }
41 function getQueryInfo() {
43 'tables' => array ( 'categorylinks' ),
44 'fields' => array ( 'cl_to AS title',
45 NS_CATEGORY
. ' AS namespace',
46 'COUNT(*) AS value' ),
47 'options' => array ( 'GROUP BY' => 'cl_to' )
51 function sortDescending() { return true; }
54 * Fetch user page links and cache their existence
56 * @param $db DatabaseBase
58 function preprocessResults( $db, $res ) {
59 $batch = new LinkBatch
;
60 foreach ( $res as $row ) {
61 $batch->add( NS_CATEGORY
, $row->title
);
65 // Back to start for display
66 if ( $db->numRows( $res ) > 0 ) {
67 // If there are no rows we get an error seeking.
68 $db->dataSeek( $res, 0 );
77 function formatResult( $skin, $result ) {
78 global $wgLang, $wgContLang;
80 $nt = Title
::makeTitle( NS_CATEGORY
, $result->title
);
81 $text = $wgContLang->convert( $nt->getText() );
83 $plink = $skin->link( $nt, htmlspecialchars( $text ) );
85 $nlinks = wfMsgExt( 'nmembers', array( 'parsemag', 'escape' ),
86 $wgLang->formatNum( $result->value
) );
87 return wfSpecialList( $plink, $nlinks );