<?php
/**
*
- * @package MediaWiki
- * @subpackage SpecialPage
+ * @addtogroup SpecialPage
*/
-/**
- *
- */
-require_once("QueryPage.php");
+function wfSpecialCategories() {
+ global $wgOut;
+
+ $cap = new CategoryPager();
+ $wgOut->addHTML(
+ wfMsgWikiHtml( 'categoriespagetext' ) .
+ $cap->getNavigationBar()
+ . '<ul>' . $cap->getBody() . '</ul>' .
+ $cap->getNavigationBar()
+ );
+}
/**
- *
- * @package MediaWiki
- * @subpackage SpecialPage
+ * @addtogroup SpecialPage
+ * @addtogroup Pager
*/
-class CategoriesPage extends QueryPage {
-
- function getName() {
- return "Categories";
- }
-
- function isExpensive() {
- return false;
- }
-
- function isSyndicated() { return false; }
-
- function getPageHeader() {
- return '<p>'.wfMsg('categoriespagetext')."</p><br />\n";
+class CategoryPager extends AlphabeticPager {
+ function getQueryInfo() {
+ return array(
+ 'tables' => array('categorylinks'),
+ 'fields' => array('cl_to','count(*) AS count'),
+ 'options' => array('GROUP BY' => 'cl_to')
+ );
}
- function getSQL() {
- $NScat = NS_CATEGORY;
- $dbr =& wfGetDB( DB_SLAVE );
- $categorylinks = $dbr->tableName( 'categorylinks' );
- return "SELECT DISTINCT 'Categories' as type,
- {$NScat} as namespace,
- cl_to as title,
- 1 as value
- FROM $categorylinks";
+
+ function getIndexField() {
+ return "cl_to";
}
- function sortDescending() {
- return false;
+ /* Override getBody to apply LinksBatch on resultset before actually outputting anything. */
+ function getBody() {
+ if (!$this->mQueryDone) {
+ $this->doQuery();
+ }
+ $batch = new LinkBatch;
+
+ $this->mResult->rewind();
+
+ while ( $row = $this->mResult->fetchObject() ) {
+ $batch->addObj( Title::makeTitleSafe( NS_CATEGORY, $row->cl_to ) );
+ }
+ $batch->execute();
+ $this->mResult->rewind();
+ return parent::getBody();
}
-
- function formatResult( $skin, $result ) {
+
+ function formatRow($result) {
global $wgLang;
- $title = Title::makeTitle( NS_CATEGORY, $result->title );
- return $skin->makeLinkObj( $title, $title->getText() );
+ $title = Title::makeTitle( NS_CATEGORY, $result->cl_to );
+ $titleText = $this->getSkin()->makeLinkObj( $title, htmlspecialchars( $title->getText() ) );
+ $count = wfMsgExt( 'nmembers', array( 'parsemag', 'escape'),
+ $wgLang->formatNum( $result->count ) );
+ return Xml::tags('li', null, "$titleText ($count)" ) . "\n";
}
}
-/**
- *
- */
-function wfSpecialCategories() {
- list( $limit, $offset ) = wfCheckLimits();
-
- $cap = new CategoriesPage();
-
- return $cap->doQuery( $offset, $limit );
-}
-?>