don't use OR on empty variables

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

diff --git a/includes/SpecialDeadendpages.php b/includes/SpecialDeadendpages.php
index 84641a5..a571d68 100644 (file)
--- a/includes/SpecialDeadendpages.php
+++ b/includes/SpecialDeadendpages.php
@@ -4,22 +4,26 @@ require_once( "QueryPage.php" );
 
 class DeadendPagesPage extends PageQueryPage {
 
-    function getName( ) {
-       return "Deadendpages";
-    }
+       function getName( ) {
+               return "Deadendpages";
+       }
 
-    # LEFT JOIN is expensive
+       # LEFT JOIN is expensive
     
-    function isExpensive( ) {
-       return 1;
-    }
+       function isExpensive( ) {
+               return 1;
+       }
+
+       function sortDescending() {
+               return false;
+       }
     
-    function getSQL( $offset, $limit ) {
-       return "SELECT cur_title as title, 0 as value " . 
-         "FROM cur LEFT JOIN links ON cur_id = l_from " .
-         "WHERE l_from IS NULL " .
-         "AND cur_namespace = 0 " .
-         "AND cur_is_redirect = 0";
+       function getSQL() {
+               return "SELECT 'Deadendpages' as type, cur_namespace AS namespace, cur_title as title, cur_title AS value " . 
+       "FROM cur LEFT JOIN links ON cur_id = l_from " .
+       "WHERE l_from IS NULL " .
+       "AND cur_namespace = 0 " .
+       "AND cur_is_redirect = 0";
     }
 }