includes/SpecialDeadendpages.php

   1 <?php
   2 /**
   3  *
   4  * @package MediaWiki
   5  * @subpackage SpecialPage
   6  */
   7
   8 /**
   9  *
  10  */
  11 require_once( "QueryPage.php" );
  12
  13 /**
  14  *
  15  * @package MediaWiki
  16  * @subpackage SpecialPage
  17  */
  18 class DeadendPagesPage extends PageQueryPage {
  19
  20         function getName( ) {
  21                 return "Deadendpages";
  22         }
  23
  24         /**
  25          * LEFT JOIN is expensive
  26          *
  27          * @return true
  28          */
  29         function isExpensive( ) {
  30                 return 1;
  31         }
  32
  33         /**
  34          * @return false
  35          */
  36         function sortDescending() {
  37                 return false;
  38         }
  39
  40     /**
  41          * @return string an sqlquery
  42          */
  43         function getSQL() {
  44                 $dbr =& wfGetDB( DB_SLAVE );
  45                 extract( $dbr->tableNames( 'cur', 'links' ) );
  46                 return "SELECT 'Deadendpages' as type, cur_namespace AS namespace, cur_title as title, cur_title AS value " .
  47         "FROM $cur LEFT JOIN $links ON cur_id = l_from " .
  48         "WHERE l_from IS NULL " .
  49         "AND cur_namespace = 0 " .
  50         "AND cur_is_redirect = 0";
  51     }
  52 }
  53
  54 /**
  55  * Constructor
  56  */
  57 function wfSpecialDeadendpages() {
  58
  59     list( $limit, $offset ) = wfCheckLimits();
  60
  61     $depp = new DeadendPagesPage();
  62
  63     return $depp->doQuery( $offset, $limit );
  64 }
  65
  66 ?>