One more time... :P shouldn't commit this late at night.

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

diff --git a/includes/SpecialLonelypages.php b/includes/SpecialLonelypages.php
index 1397dbf..64c3e00 100644 (file)
--- a/includes/SpecialLonelypages.php
+++ b/includes/SpecialLonelypages.php
@@ -1,32 +1,53 @@
 <?php
+/**
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
 
-include_once( "QueryPage.php" );
+/**
+ *
+ */
+require_once( "QueryPage.php" );
 
+/**
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
 class LonelyPagesPage extends PageQueryPage {
 
-    function getName() {
-       return "Lonelypages";
-    }
-    
-    function isExpensive() {
-       return 1;
-    }
-    
-    function getSQL( $offset, $limit ) {
+       function getName() {
+               return "Lonelypages";
+       }
+
+       function sortDescending() {
+               return false;
+       }
+
+       function isExpensive() {
+               return true;
+       }
        
-       return "SELECT cur_title FROM cur LEFT JOIN links ON " .
-         "cur_id=l_to WHERE l_to IS NULL AND cur_namespace=0 AND " .
-         "cur_is_redirect=0 ORDER BY cur_title LIMIT {$offset}, {$limit}";
-    }
+       function getSQL() {
+               $dbr =& wfGetDB( DB_SLAVE );
+               extract( $dbr->tableNames( 'cur', 'links' ) );
+
+               return "SELECT 'Lonelypages' as type, cur_namespace AS namespace, cur_title AS title, cur_title AS value " .
+                       "FROM $cur LEFT JOIN $links ON cur_id=l_to ".
+                       "WHERE l_to IS NULL AND cur_namespace=0 AND cur_is_redirect=0";
+       }
 }
 
-function wfSpecialLonelypages()
-{
-    list( $limit, $offset ) = wfCheckLimits();
-    
-    $lpp = new LonelyPagesPage();
-    
-    return $lpp->doQuery( $offset, $limit );
+/**
+ * Constructor
+ */
+function wfSpecialLonelypages() {
+       list( $limit, $offset ) = wfCheckLimits();
+
+       $lpp = new LonelyPagesPage();
+
+       return $lpp->doQuery( $offset, $limit );
 }
 
 ?>