elaborate fix for bug 1156: Block log: missing expiry time. Changed schema for loggin...
[mediawiki.git] / includes / SpecialUncategorizedpages.php
blobd35a889ecc838583a0ffb7af70cab480dc1e4f39
1 <?php
2 /**
4 * @package MediaWiki
5 * @subpackage SpecialPage
6 */
8 /**
11 require_once( "QueryPage.php" );
13 /**
15 * @package MediaWiki
16 * @subpackage SpecialPage
18 class UncategorizedPagesPage extends PageQueryPage {
19 var $requestedNamespace = 0;
21 function getName() {
22 return "Uncategorizedpages";
25 function sortDescending() {
26 return false;
29 function isExpensive() {
30 return true;
32 function isSyndicated() { return false; }
34 function getSQL() {
35 $dbr =& wfGetDB( DB_SLAVE );
36 extract( $dbr->tableNames( 'page', 'categorylinks' ) );
38 return "SELECT 'Uncategorizedpages' as type, page_namespace AS namespace, page_title AS title, page_title AS value " .
39 "FROM $page LEFT JOIN $categorylinks ON page_id=cl_from ".
40 "WHERE cl_from IS NULL AND page_namespace=$this->requestedNamespace AND page_is_redirect=0";
44 /**
45 * constructor
47 function wfSpecialUncategorizedpages() {
48 list( $limit, $offset ) = wfCheckLimits();
50 $lpp = new UncategorizedPagesPage();
52 return $lpp->doQuery( $offset, $limit );