Do not insert page titles into querycache.qc_value
[lhc/web/wiklou.git] / includes / specials / SpecialUncategorizedPages.php
1 <?php
2 /**
3 * Implements Special:Uncategorizedpages
4 *
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
9 *
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
14 *
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
19 *
20 * @file
21 * @ingroup SpecialPage
22 */
23
24 use MediaWiki\MediaWikiServices;
25
26 /**
27 * A special page looking for page without any category.
28 *
29 * @ingroup SpecialPage
30 * @todo FIXME: Make $requestedNamespace selectable, unify all subclasses into one
31 */
32 class SpecialUncategorizedPages extends PageQueryPage {
33 /** @var int|false */
34 protected $requestedNamespace = false;
35
36 function __construct( $name = 'Uncategorizedpages' ) {
37 parent::__construct( $name );
38 $this->addHelpLink( 'Help:Categories' );
39 }
40
41 function sortDescending() {
42 return false;
43 }
44
45 function isExpensive() {
46 return true;
47 }
48
49 function isSyndicated() {
50 return false;
51 }
52
53 function getQueryInfo() {
54 return [
55 'tables' => [ 'page', 'categorylinks' ],
56 'fields' => [
57 'namespace' => 'page_namespace',
58 'title' => 'page_title',
59 ],
60 // default for page_namespace is all content namespaces (if requestedNamespace is false)
61 // otherwise, page_namespace is requestedNamespace
62 'conds' => [
63 'cl_from IS NULL',
64 'page_namespace' => $this->requestedNamespace !== false
65 ? $this->requestedNamespace
66 : MediaWikiServices::getInstance()->getNamespaceInfo()->
67 getContentNamespaces(),
68 'page_is_redirect' => 0
69 ],
70 'join_conds' => [
71 'categorylinks' => [ 'LEFT JOIN', 'cl_from = page_id' ]
72 ]
73 ];
74 }
75
76 function getOrderFields() {
77 // For some crazy reason ordering by a constant
78 // causes a filesort
79 if ( $this->requestedNamespace === false &&
80 count( MediaWikiServices::getInstance()->getNamespaceInfo()->
81 getContentNamespaces() ) > 1
82 ) {
83 return [ 'page_namespace', 'page_title' ];
84 }
85
86 return [ 'page_title' ];
87 }
88
89 protected function getGroupName() {
90 return 'maintenance';
91 }
92 }