<?php
+/**
+ *
+ * @addtogroup SpecialPage
+ */
-function wfSpecialCategories()
-{
- global $wgUser, $wgOut , $wgLang;
+function wfSpecialCategories() {
+ global $wgOut;
- $sk = $wgUser->getSkin() ;
- $sc = "Special:Categories" ;
- $r = "" ;
- $r .= "<ol>\n" ;
- $cat = ucfirst ( wfMsg ( "category" ) ) ;
- $sql = "SELECT cur_title FROM cur WHERE cur_namespace=".Namespace::getCategory() ;
- $res = wfQuery ( $sql, DB_READ ) ;
- while ( $x = wfFetchObject ( $res ) )
- {
- $t = explode ( ":" , $x->cur_title , 2 ) ;
- $t = $t[1] ;
- $r .= "<li>" ;
- $r .= $sk->makeKnownLink ( $x->cur_title , $t ) ;
- $r .= "</li>\n" ;
- }
- wfFreeResult ( $res ) ;
- $r .= "</ol>\n" ;
-
- $r .= "<hr />\n" ;
- $sql = "SELECT DISTINCT bl_to FROM brokenlinks WHERE bl_to LIKE \"{$cat}:%\"" ;
- $res = wfQuery ( $sql, DB_READ ) ;
- $r .= "<ol>\n" ;
- while ( $x = wfFetchObject ( $res ) )
- {
- $t = explode ( ":" , $x->bl_to , 2 ) ;
- $t = $t[1] ;
- $r .= "<li>" ;
- $r .= $sk->makeBrokenLink ( $x->bl_to ) ;
- $r .= "</li>\n" ;
- }
- wfFreeResult ( $res ) ;
- $r .= "</ol>\n" ;
+ $cap = new CategoryPager();
+ $wgOut->addHTML(
+ wfMsgExt( 'categoriespagetext', array( 'parse' ) ) .
+ $cap->getNavigationBar()
+ . '<ul>' . $cap->getBody() . '</ul>' .
+ $cap->getNavigationBar()
+ );
+}
- $wgOut->addHTML ( $r ) ;
+/**
+ * @addtogroup SpecialPage
+ * @addtogroup Pager
+ */
+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 getIndexField() {
+ return "cl_to";
+ }
+
+ /* 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 formatRow($result) {
+ global $wgLang;
+ $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";
+ }
}
-?>
+