Merge "(bug 37181) Removed hard coded parentheses in SpecialMIMEsearch.php"

[lhc/web/wiklou.git] / includes / specials / SpecialLonelypages.php

diff --git a/includes/specials/SpecialLonelypages.php b/includes/specials/SpecialLonelypages.php
index 28a463e..0c86163 100644 (file)
--- a/includes/specials/SpecialLonelypages.php
+++ b/includes/specials/SpecialLonelypages.php
@@ -1,5 +1,6 @@
 <?php
 /**
+ * Implements Special:Lonelypaages
  *
  * This program is free software; you can redistribute it and/or modify
  * it under the terms of the GNU General Public License as published by
@@ -13,11 +14,9 @@
  *
  * You should have received a copy of the GNU General Public License along
  * with this program; if not, write to the Free Software Foundation, Inc.,
- * 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+ * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
  * http://www.gnu.org/copyleft/gpl.html
- */
-
-/**
+ *
  * @file
  * @ingroup SpecialPage
  */
@@ -25,15 +24,17 @@
 /**
  * A special page looking for articles with no article linking to them,
  * thus being lonely.
+ *
  * @ingroup SpecialPage
  */
 class LonelyPagesPage extends PageQueryPage {
 
-       function getName() {
-               return "Lonelypages";
+       function __construct( $name = 'Lonelypages' ) {
+               parent::__construct( $name );
        }
+
        function getPageHeader() {
-               return wfMsgExt( 'lonelypagestext', array( 'parse' ) );
+               return $this->msg( 'lonelypagestext' )->parseAsBlock();
        }
 
        function sortDescending() {
@@ -45,35 +46,36 @@ class LonelyPagesPage extends PageQueryPage {
        }
        function isSyndicated() { return false; }
 
-       function getSQL() {
-               $dbr = wfGetDB( DB_SLAVE );
-               list( $page, $pagelinks, $templatelinks ) = $dbr->tableNamesN( 'page', 'pagelinks', 'templatelinks' );
-
-               return
-                 "SELECT 'Lonelypages'  AS type,
-                         page_namespace AS namespace,
-                         page_title     AS title,
-                         page_title     AS value
-                    FROM $page
-               LEFT JOIN $pagelinks
-                      ON page_namespace=pl_namespace AND page_title=pl_title
-               LEFT JOIN $templatelinks
-                               ON page_namespace=tl_namespace AND page_title=tl_title
-                   WHERE pl_namespace IS NULL
-                     AND page_namespace=".NS_MAIN."
-                     AND page_is_redirect=0
-                         AND tl_namespace IS NULL";
-
+       function getQueryInfo() {
+               return array (
+                       'tables' => array ( 'page', 'pagelinks',
+                                       'templatelinks' ),
+                       'fields' => array ( 'page_namespace AS namespace',
+                                       'page_title AS title',
+                                       'page_title AS value' ),
+                       'conds' => array ( 'pl_namespace IS NULL',
+                                       'page_namespace' => MWNamespace::getContentNamespaces(),
+                                       'page_is_redirect' => 0,
+                                       'tl_namespace IS NULL' ),
+                       'join_conds' => array (
+                                       'pagelinks' => array (
+                                               'LEFT JOIN', array (
+                                               'pl_namespace = page_namespace',
+                                               'pl_title = page_title' ) ),
+                                       'templatelinks' => array (
+                                               'LEFT JOIN', array (
+                                               'tl_namespace = page_namespace',
+                                               'tl_title = page_title' ) ) )
+               );
        }
-}
 
-/**
- * Constructor
- */
-function wfSpecialLonelypages() {
-       list( $limit, $offset ) = wfCheckLimits();
-
-       $lpp = new LonelyPagesPage();
-
-       return $lpp->doQuery( $offset, $limit );
+       function getOrderFields() {
+               // For some crazy reason ordering by a constant
+               // causes a filesort in MySQL 5
+               if( count( MWNamespace::getContentNamespaces() ) > 1 ) {
+                       return array( 'page_namespace', 'page_title' );
+               } else {
+                       return array( 'page_title' );
+               }
+       }
 }