setHeaders(); $this->outputHeader(); $this->getOutput()->allowClickjacking(); $from = $this->getRequest()->getText( 'from', $par ); $cap = new CategoryPager( $this->getContext(), $from ); $cap->doQuery(); $this->getOutput()->addHTML( Html::openElement( 'div', array( 'class' => 'mw-spcontent' ) ) . $this->msg( 'categoriespagetext', $cap->getNumRows() )->parseAsBlock() . $cap->getStartForm( $from ) . $cap->getNavigationBar() . '

' . $cap->getBody() . '

' . $cap->getNavigationBar() . Html::closeElement( 'div' ) ); } } /** * TODO: Allow sorting by count. We need to have a unique index to do this * properly. * * @ingroup SpecialPage Pager */ class CategoryPager extends AlphabeticPager { private $conds = array( 'cat_pages > 0' ); function __construct( IContextSource $context, $from ) { parent::__construct( $context ); $from = str_replace( ' ', '_', $from ); if( $from !== '' ) { $from = Title::capitalize( $from, NS_CATEGORY ); $dbr = wfGetDB( DB_SLAVE ); $this->conds[] = 'cat_title >= ' . $dbr->addQuotes( $from ); $this->setOffset( '' ); } } function getQueryInfo() { return array( 'tables' => array( 'category' ), 'fields' => array( 'cat_title','cat_pages' ), 'conds' => $this->conds, 'options' => array( 'USE INDEX' => 'cat_title' ), ); } function getIndexField() { # return array( 'abc' => 'cat_title', 'count' => 'cat_pages' ); return 'cat_title'; } function getDefaultQuery() { parent::getDefaultQuery(); unset( $this->mDefaultQuery['from'] ); return $this->mDefaultQuery; } # protected function getOrderTypeMessages() { # return array( 'abc' => 'special-categories-sort-abc', # 'count' => 'special-categories-sort-count' ); # } protected function getDefaultDirections() { # return array( 'abc' => false, 'count' => true ); return false; } /* Override getBody to apply LinksBatch on resultset before actually outputting anything. */ public function getBody() { $batch = new LinkBatch; $this->mResult->rewind(); foreach ( $this->mResult as $row ) { $batch->addObj( Title::makeTitleSafe( NS_CATEGORY, $row->cat_title ) ); } $batch->execute(); $this->mResult->rewind(); return parent::getBody(); } function formatRow($result) { $title = Title::makeTitle( NS_CATEGORY, $result->cat_title ); $titleText = Linker::link( $title, htmlspecialchars( $title->getText() ) ); $count = $this->msg( 'nmembers' )->numParams( $result->cat_pages )->escaped(); return Xml::tags( 'li', null, $this->getLanguage()->specialList( $titleText, $count ) ) . "\n"; } public function getStartForm( $from ) { global $wgScript; return Xml::tags( 'form', array( 'method' => 'get', 'action' => $wgScript ), Html::hidden( 'title', $this->getTitle()->getPrefixedText() ) . Xml::fieldset( $this->msg( 'categories' )->text(), Xml::inputLabel( $this->msg( 'categoriesfrom' )->text(), 'from', 'from', 20, $from ) . ' ' . Xml::submitButton( $this->msg( 'allpagessubmit' )->text() ) ) ); } }