includes/SpecialDeadendpages.php

   1 <?php
   2
   3 include_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 getSQL( $offset, $limit ) {
  18         return "SELECT cur_title " .
  19           "FROM cur LEFT JOIN links ON cur_title = l_from " .
  20           "WHERE l_from IS NULL " .
  21           "AND cur_namespace = 0 " .
  22           "ORDER BY cur_title " .
  23           "LIMIT {$offset}, {$limit}";
  24     }
  25 }
  26
  27 function wfSpecialDeadendpages() {
  28
  29     list( $limit, $offset ) = wfCheckLimits();
  30
  31     $depp = new DeadendPagesPage();
  32
  33     return $depp->doQuery( $offset, $limit );
  34 }
  35
  36 ?>