<?php
+/**
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
+/**
+ *
+ */
require_once("QueryPage.php");
+/**
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
class CategoriesPage extends QueryPage {
function getName() {
return false;
}
+ function isSyndicated() { return false; }
+
+ function getPageHeader() {
+ return wfMsgWikiHtml('categoriespagetext') . "<br />\n";
+ }
function getSQL() {
$NScat = NS_CATEGORY;
- return "SELECT DISTINCT 'Categories' as type,
+ $dbr =& wfGetDB( DB_SLAVE );
+ $categorylinks = $dbr->tableName( 'categorylinks' );
+ $s= "SELECT 'Categories' as type,
{$NScat} as namespace,
cl_to as title,
- 1 as value
- FROM categorylinks";
+ 1 as value,
+ COUNT(*) as count
+ FROM $categorylinks
+ GROUP BY cl_to";
+ return $s;
}
function sortDescending() {
}
function formatResult( $skin, $result ) {
- global $wgLang;
$title = Title::makeTitle( NS_CATEGORY, $result->title );
- return $skin->makeLinkObj( $title, $title->getText() );
+ $plink = $skin->makeLinkObj( $title, $title->getText() );
+ $nlinks = wfMsg( 'nlinks', $result->count );
+ return "$plink ($nlinks)";
}
}
-function wfSpecialCategories()
-{
+/**
+ *
+ */
+function wfSpecialCategories() {
list( $limit, $offset ) = wfCheckLimits();
$cap = new CategoriesPage();