<?php
/**
*
- * @package MediaWiki
- * @subpackage SpecialPage
+ * @addtogroup SpecialPage
*/
-/**
- *
- */
-require_once("QueryPage.php");
+function wfSpecialCategories() {
+ global $wgOut;
+
+ $cap = new CategoryPager();
+ $wgOut->addHTML(
+ wfMsgExt( 'categoriespagetext', array( 'parse' ) ) .
+ $cap->getNavigationBar()
+ . '<ul>' . $cap->getBody() . '</ul>' .
+ $cap->getNavigationBar()
+ );
+}
/**
+ * TODO: Allow sorting by count. We need to have a unique index to do this
+ * properly.
*
- * @package MediaWiki
- * @subpackage SpecialPage
+ * @addtogroup SpecialPage
+ * @addtogroup Pager
*/
-class CategoriesPage extends QueryPage {
-
- function getName() {
- return "Categories";
+class CategoryPager extends AlphabeticPager {
+ function getQueryInfo() {
+ global $wgRequest;
+ return array(
+ 'tables' => array( 'category' ),
+ 'fields' => array( 'cat_title','cat_pages' ),
+ 'conds' => array( 'cat_pages > 0' )
+ );
}
-
- function isExpensive() {
- return false;
+
+ function getIndexField() {
+# return array( 'abc' => 'cat_title', 'count' => 'cat_pages' );
+ return 'cat_title';
}
- function isSyndicated() { return false; }
+# protected function getOrderTypeMessages() {
+# return array( 'abc' => 'special-categories-sort-abc',
+# 'count' => 'special-categories-sort-count' );
+# }
- function getPageHeader() {
- return wfMsgWikiHtml( 'categoriespagetext' );
+ protected function getDefaultDirections() {
+# return array( 'abc' => false, 'count' => true );
+ return false;
}
- function getSQL() {
- $NScat = NS_CATEGORY;
- $dbr =& wfGetDB( DB_SLAVE );
- $categorylinks = $dbr->tableName( 'categorylinks' );
- $s= "SELECT 'Categories' as type,
- {$NScat} as namespace,
- cl_to as title,
- 1 as value,
- COUNT(*) as count
- FROM $categorylinks
- GROUP BY cl_to";
- return $s;
- }
-
- function sortDescending() {
- return false;
+ /* Override getBody to apply LinksBatch on resultset before actually outputting anything. */
+ public 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->cat_title ) );
+ }
+ $batch->execute();
+ $this->mResult->rewind();
+ return parent::getBody();
}
-
- function formatResult( $skin, $result ) {
- $title = Title::makeTitle( NS_CATEGORY, $result->title );
- $plink = $skin->makeLinkObj( $title, $title->getText() );
- $nlinks = wfMsg( 'nlinks', $result->count );
- return wfSpecialList($plink, $nlinks);
+
+ function formatRow($result) {
+ global $wgLang;
+ $title = Title::makeTitle( NS_CATEGORY, $result->cat_title );
+ $titleText = $this->getSkin()->makeLinkObj( $title, htmlspecialchars( $title->getText() ) );
+ $count = wfMsgExt( 'nmembers', array( 'parsemag', 'escape' ),
+ $wgLang->formatNum( $result->cat_pages ) );
+ return Xml::tags('li', null, "$titleText ($count)" ) . "\n";
}
}
-/**
- *
- */
-function wfSpecialCategories() {
- list( $limit, $offset ) = wfCheckLimits();
-
- $cap = new CategoriesPage();
-
- return $cap->doQuery( $offset, $limit );
-}
-?>