Added iterator interface to ResultWrapper. No support in Oracle yet. Updated document...

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

diff --git a/includes/SpecialMostrevisions.php b/includes/SpecialMostrevisions.php
index 09561ff..9479a58 100644 (file)
--- a/includes/SpecialMostrevisions.php
+++ b/includes/SpecialMostrevisions.php
@@ -2,20 +2,15 @@
 /**
  * A special page to show pages in the
  *
- * @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
+ * @addtogroup SpecialPage
  */
 class MostrevisionsPage extends QueryPage {
 
@@ -24,8 +19,8 @@ class MostrevisionsPage extends QueryPage {
        function isSyndicated() { return false; }
 
        function getSQL() {
-               $dbr =& wfGetDB( DB_SLAVE );
-               extract( $dbr->tableNames( 'revision', 'page' ) );
+               $dbr = wfGetDB( DB_SLAVE );
+               list( $revision, $page ) = $dbr->tableNamesN( 'revision', 'page' );
                return
                        "
                        SELECT
@@ -34,9 +29,9 @@ class MostrevisionsPage extends QueryPage {
                                page_title as title,
                                COUNT(*) as value
                        FROM $revision
-                       LEFT JOIN $page ON page_id = rev_page
+                       JOIN $page ON page_id = rev_page
                        WHERE page_namespace = " . NS_MAIN . "
-                       GROUP BY rev_page
+                       GROUP BY 1,2,3
                        HAVING COUNT(*) > 1
                        ";
        }
@@ -68,4 +63,4 @@ function wfSpecialMostrevisions() {
        $wpp->doQuery( $offset, $limit );
 }
 
-?>
+