Woops, fix bug with last commit when the number of rows <= 2.

[lhc/web/wiklou.git] / includes / SpecialCategories.php

diff --git a/includes/SpecialCategories.php b/includes/SpecialCategories.php
index 1a3efca..efe65a7 100644 (file)
--- a/includes/SpecialCategories.php
+++ b/includes/SpecialCategories.php
@@ -1,45 +1,63 @@
 <?php
+/**
+ *
+ * @addtogroup SpecialPage
+ */
 
-function wfSpecialCategories()
-{
-       global $wgUser, $wgOut , $wgLang;
+function wfSpecialCategories() {
+       global $wgOut;
 
-       $sk = $wgUser->getSkin() ;
-       $sc = "Special:Categories" ;
-
-       # List all existant categories.
-       # Note: this list could become *very large*
-       $r = "<ol>\n" ;
-       $sql = "SELECT cur_title FROM cur WHERE cur_namespace=".Namespace::getCategory() ;
-       $res = wfQuery ( $sql, DB_READ ) ;
-       while ( $x = wfFetchObject ( $res ) ) {
-               $title =& Title::makeTitle( NS_CATEGORY, $x->cur_title );
-           $r .= "<li>" ;
-           $r .= $sk->makeKnownLinkObj ( $title, $title->getText() ) ;
-           $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()
+               );
+}
 
-       $r .= "<hr />\n" ;
+/**
+ * @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')
+                       );
+       }
        
-       # Links to category pages that haven't been created.
-       # FIXME: This could be slow if there are a lot, but the title index should
-       # make it reasonably snappy since we're using an index.
-       $cat = wfStrencode( $wgLang->getNsText( NS_CATEGORY ) );
-       $sql = "SELECT DISTINCT bl_to FROM brokenlinks WHERE bl_to LIKE \"{$cat}:%\"" ;
-       $res = wfQuery ( $sql, DB_READ ) ;
-       $r .= "<ol>\n" ;
-       while ( $x = wfFetchObject ( $res ) ) {
-               $title = Title::newFromDBkey( $x->bl_to );
-           $r .= "<li>" ;
-           $r .= $sk->makeBrokenLinkObj( $title, $title->getText() ) ;
-           $r .= "</li>\n" ;
-         }
-       wfFreeResult ( $res ) ;
-       $r .= "</ol>\n" ;
-
-       $wgOut->addHTML ( $r ) ;
+       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";
+       }
 }
 
-?>
+