includes/SpecialDeadendpages.php

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