includes/SpecialDeadendpages.php

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