includes/SpecialUncategorizedpages.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 UncategorizedPagesPage extends PageQueryPage {
  19         var $requestedNamespace = NS_MAIN;
  20
  21         function getName() {
  22                 return "Uncategorizedpages";
  23         }
  24
  25         function sortDescending() {
  26                 return false;
  27         }
  28
  29         function isExpensive() {
  30                 return true;
  31         }
  32         function isSyndicated() { return false; }
  33
  34         function getSQL() {
  35                 $dbr =& wfGetDB( DB_SLAVE );
  36                 extract( $dbr->tableNames( 'page', 'categorylinks' ) );
  37                 $name = $dbr->addQuotes( $this->getName() );
  38
  39                 return
  40                         "
  41                         SELECT
  42                                 $name as type,
  43                                 page_namespace AS namespace,
  44                                 page_title AS title,
  45                                 page_title AS value
  46                         FROM $page
  47                         LEFT JOIN $categorylinks ON page_id=cl_from
  48                         WHERE cl_from IS NULL AND page_namespace={$this->requestedNamespace} AND page_is_redirect=0
  49                         ";
  50         }
  51 }
  52
  53 /**
  54  * constructor
  55  */
  56 function wfSpecialUncategorizedpages() {
  57         list( $limit, $offset ) = wfCheckLimits();
  58
  59         $lpp = new UncategorizedPagesPage();
  60
  61         return $lpp->doQuery( $offset, $limit );
  62 }
  63
  64 ?>