Followup for r75314 (bug 23923) -- regression fix for prefix of '0' being ignored...
[lhc/web/wiklou.git] / includes / specials / SpecialUnwatchedpages.php
1 <?php
2 /**
3 * Implements Special:Unwatchedpages
4 *
5 * Copyright © 2005 Ævar Arnfjörð Bjarmason
6 *
7 * This program is free software; you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation; either version 2 of the License, or
10 * (at your option) any later version.
11 *
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License along
18 * with this program; if not, write to the Free Software Foundation, Inc.,
19 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
20 * http://www.gnu.org/copyleft/gpl.html
21 *
22 * @file
23 * @ingroup SpecialPage
24 * @author Ævar Arnfjörð Bjarmason <avarab@gmail.com>
25 */
26
27 /**
28 * A special page that displays a list of pages that are not on anyones watchlist.
29 *
30 * @ingroup SpecialPage
31 */
32 class UnwatchedpagesPage extends QueryPage {
33
34 function getName() { return 'Unwatchedpages'; }
35 function isExpensive() { return true; }
36 function isSyndicated() { return false; }
37
38 function getSQL() {
39 $dbr = wfGetDB( DB_SLAVE );
40 list( $page, $watchlist ) = $dbr->tableNamesN( 'page', 'watchlist' );
41 $mwns = NS_MEDIAWIKI;
42 return
43 "
44 SELECT
45 'Unwatchedpages' as type,
46 page_namespace as namespace,
47 page_title as title,
48 page_namespace as value
49 FROM $page
50 LEFT JOIN $watchlist ON wl_namespace = page_namespace AND page_title = wl_title
51 WHERE wl_title IS NULL AND page_is_redirect = 0 AND page_namespace<>$mwns
52 ";
53 }
54
55 function sortDescending() { return false; }
56
57 function formatResult( $skin, $result ) {
58 global $wgContLang;
59
60 $nt = Title::makeTitle( $result->namespace, $result->title );
61 $text = $wgContLang->convert( $nt->getPrefixedText() );
62
63 $plink = $skin->linkKnown(
64 $nt,
65 htmlspecialchars( $text )
66 );
67 $wlink = $skin->linkKnown(
68 $nt,
69 wfMsgHtml( 'watch' ),
70 array(),
71 array( 'action' => 'watch' )
72 );
73
74 return wfSpecialList( $plink, $wlink );
75 }
76 }
77
78 /**
79 * constructor
80 */
81 function wfSpecialUnwatchedpages() {
82 global $wgUser, $wgOut;
83
84 if ( ! $wgUser->isAllowed( 'unwatchedpages' ) )
85 return $wgOut->permissionRequired( 'unwatchedpages' );
86
87 list( $limit, $offset ) = wfCheckLimits();
88
89 $wpp = new UnwatchedpagesPage();
90
91 $wpp->doQuery( $offset, $limit );
92 }