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         function isSyndicated() { return false; }
  34
  35         /**
  36          * @return false
  37          */
  38         function sortDescending() {
  39                 return false;
  40         }
  41
  42     /**
  43          * @return string an sqlquery
  44          */
  45         function getSQL() {
  46                 $dbr =& wfGetDB( DB_SLAVE );
  47                 extract( $dbr->tableNames( 'page', 'pagelinks' ) );
  48                 return "SELECT 'Deadendpages' as type, page_namespace AS namespace, page_title as title, page_title AS value " .
  49         "FROM $page LEFT JOIN $pagelinks ON page_id = pl_from " .
  50         "WHERE pl_from IS NULL " .
  51         "AND page_namespace = 0 " .
  52         "AND page_is_redirect = 0";
  53     }
  54 }
  55
  56 /**
  57  * Constructor
  58  */
  59 function wfSpecialDeadendpages() {
  60
  61     list( $limit, $offset ) = wfCheckLimits();
  62
  63     $depp = new DeadendPagesPage();
  64
  65     return $depp->doQuery( $offset, $limit );
  66 }
  67
  68 ?>