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                 $dbr =& wfGetDB( DB_SLAVE );
  23                 extract( $dbr->tableNames( 'cur', 'links' ) );
  24                 return "SELECT 'Deadendpages' as type, cur_namespace AS namespace, cur_title as title, cur_title AS value " .
  25         "FROM $cur LEFT JOIN $links ON cur_id = l_from " .
  26         "WHERE l_from IS NULL " .
  27         "AND cur_namespace = 0 " .
  28         "AND cur_is_redirect = 0";
  29     }
  30 }
  31
  32 function wfSpecialDeadendpages() {
  33
  34     list( $limit, $offset ) = wfCheckLimits();
  35
  36     $depp = new DeadendPagesPage();
  37
  38     return $depp->doQuery( $offset, $limit );
  39 }
  40
  41 ?>