* Normalize titles in Special:Randomincategory

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

diff --git a/includes/SpecialWantedcategories.php b/includes/SpecialWantedcategories.php
index 6f603d9..f3e8966 100644 (file)
--- a/includes/SpecialWantedcategories.php
+++ b/includes/SpecialWantedcategories.php
@@ -1,22 +1,13 @@
 <?php
 /**
- * A querypage to list the most wanted categories
+ * A querypage to list the most wanted categories - implements Special:Wantedcategories
  *
- * @package MediaWiki
- * @subpackage SpecialPage
+ * @addtogroup SpecialPage
  *
  * @author Ævar Arnfjörð Bjarmason <avarab@gmail.com>
  * @copyright Copyright © 2005, Ævar Arnfjörð Bjarmason
  * @license http://www.gnu.org/copyleft/gpl.html GNU General Public License 2.0 or later
  */
-
-/* */
-require_once 'QueryPage.php';
-
-/**
- * @package MediaWiki
- * @subpackage SpecialPage
- */
 class WantedCategoriesPage extends QueryPage {
 
        function getName() { return 'Wantedcategories'; }
@@ -24,8 +15,8 @@ class WantedCategoriesPage extends QueryPage {
        function isSyndicated() { return false; }
 
        function getSQL() {
-               $dbr =& wfGetDB( DB_SLAVE );
-               extract( $dbr->tableNames( 'categorylinks', 'page' ) );
+               $dbr = wfGetDB( DB_SLAVE );
+               list( $categorylinks, $page ) = $dbr->tableNamesN( 'categorylinks', 'page' );
                $name = $dbr->addQuotes( $this->getName() );
                return
                        "
@@ -37,7 +28,7 @@ class WantedCategoriesPage extends QueryPage {
                        FROM $categorylinks
                        LEFT JOIN $page ON cl_to = page_title AND page_namespace = ". NS_CATEGORY ."
                        WHERE page_title IS NULL
-                       GROUP BY cl_to
+                       GROUP BY 1,2,3
                        ";
        }
 
@@ -85,4 +76,4 @@ function wfSpecialWantedCategories() {
        $wpp->doQuery( $offset, $limit );
 }
 
-?>
+