includes/SpecialDeadendpages.php

   1 <?php
   2
   3 require_once( "QueryPage.php" );
   4
   5 class DeadendPagesPage extends PageQueryPage {
   6
   7         function getName( ) {
   8                 return "Deadendpages";
   9         }
  10
  11         # LEFT JOIN is expensive
  12
  13         function isExpensive( ) {
  14                 return 1;
  15         }
  16
  17         function sortDescending() {
  18                 return false;
  19         }
  20
  21         function getSQL() {
  22                 return "SELECT 'Deadendpages' as type, cur_namespace AS namespace, cur_title as title, cur_title AS value " .
  23         "FROM cur LEFT JOIN links ON cur_id = l_from " .
  24         "WHERE l_from IS NULL " .
  25         "AND cur_namespace = 0 " .
  26         "AND cur_is_redirect = 0";
  27     }
  28 }
  29
  30 function wfSpecialDeadendpages() {
  31
  32     list( $limit, $offset ) = wfCheckLimits();
  33
  34     $depp = new DeadendPagesPage();
  35
  36     return $depp->doQuery( $offset, $limit );
  37 }
  38
  39 ?>