3 * Implements Special:Wantedcategories
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
27 * A querypage to list the most wanted categories - implements Special:Wantedcategories
29 * @ingroup SpecialPage
31 class WantedCategoriesPage
extends WantedQueryPage
{
32 private $currentCategoryCounts;
34 function __construct( $name = 'Wantedcategories' ) {
35 parent
::__construct( $name );
38 function getQueryInfo() {
40 'tables' => array( 'categorylinks', 'page' ),
41 'fields' => array( 'namespace' => NS_CATEGORY
,
43 'value' => 'COUNT(*)' ),
44 'conds' => array( 'page_title IS NULL' ),
45 'options' => array( 'GROUP BY' => 'cl_to' ),
46 'join_conds' => array( 'page' => array( 'LEFT JOIN',
47 array( 'page_title = cl_to',
48 'page_namespace' => NS_CATEGORY
) ) )
52 function preprocessResults( $db, $res ) {
53 parent
::preprocessResults( $db, $res );
55 $this->currentCategoryCounts
= array();
57 if ( !$res->numRows() ||
!$this->isCached() ) {
61 // Fetch (hopefully) up-to-date numbers of pages in each category.
62 // This should be fast enough as we limit the list to a reasonable length.
64 $allCategories = array();
65 foreach ( $res as $row ) {
66 $allCategories[] = $row->title
;
69 $categoryRes = $db->select(
71 array( 'cat_title', 'cat_pages' ),
72 array( 'cat_title' => $allCategories ),
75 foreach ( $categoryRes as $row ) {
76 $this->currentCategoryCounts
[ $row->cat_title
] = $row->cat_pages
;
79 // Back to start for display
85 * @param object $result Result row
88 function formatResult( $skin, $result ) {
91 $nt = Title
::makeTitle( $result->namespace, $result->title
);
92 $text = htmlspecialchars( $wgContLang->convert( $nt->getText() ) );
94 if ( !$this->isCached() ) {
95 // We can assume the freshest data
96 $plink = Linker
::link(
103 $nlinks = $this->msg( 'nmembers' )->numParams( $result->value
)->escaped();
105 $plink = Linker
::link( $nt, $text );
107 $currentValue = isset( $this->currentCategoryCounts
[ $result->title
] )
108 ?
$this->currentCategoryCounts
[ $result->title
]
111 // If the category has been created or emptied since the list was refreshed, strike it
112 if ( $nt->isKnown() ||
$currentValue === 0 ) {
113 $plink = "<del>$plink</del>";
116 // Show the current number of category entries if it changed
117 if ( $currentValue !== $result->value
) {
118 $nlinks = $this->msg( 'nmemberschanged' )
119 ->numParams( $result->value
, $currentValue )->escaped();
121 $nlinks = $this->msg( 'nmembers' )->numParams( $result->value
)->escaped();
125 return $this->getLanguage()->specialList( $plink, $nlinks );
128 protected function getGroupName() {
129 return 'maintenance';