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         function getPageHeader() {
  20                 return '<p>' . wfMsg('deadendpagestext') . '</p>';
  21         }
  22
  23         /**
  24          * LEFT JOIN is expensive
  25          *
  26          * @return true
  27          */
  28         function isExpensive( ) {
  29                 return 1;
  30         }
  31
  32         function isSyndicated() { return false; }
  33
  34         /**
  35          * @return false
  36          */
  37         function sortDescending() {
  38                 return false;
  39         }
  40
  41     /**
  42          * @return string an sqlquery
  43          */
  44         function getSQL() {
  45                 $dbr =& wfGetDB( DB_SLAVE );
  46                 list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' );
  47                 return "SELECT 'Deadendpages' as type, page_namespace AS namespace, page_title as title, page_title AS value " .
  48         "FROM $page LEFT JOIN $pagelinks ON page_id = pl_from " .
  49         "WHERE pl_from IS NULL " .
  50         "AND page_namespace = 0 " .
  51         "AND page_is_redirect = 0";
  52     }
  53 }
  54
  55 /**
  56  * Constructor
  57  */
  58 function wfSpecialDeadendpages() {
  59
  60     list( $limit, $offset ) = wfCheckLimits();
  61
  62     $depp = new DeadendPagesPage();
  63
  64     return $depp->doQuery( $offset, $limit );
  65 }
  66
  67 ?>