* Linktrail
[mediawiki.git] / includes / SpecialUnwatchedpages.php
blob8cc0802809d0492f07ec9fe2803d5e92dc9137c6
1 <?php
2 /**
3 * A special page that displays a list of pages that are not on anyones watchlist
5 * @package MediaWiki
6 * @subpackage SpecialPage
8 * @author Ævar Arnfjörð Bjarmason <avarab@gmail.com>
9 * @copyright Copyright © 2005, Ævar Arnfjörð Bjarmason
10 * @license http://www.gnu.org/copyleft/gpl.html GNU General Public License 2.0 or later
13 /* */
14 require_once 'QueryPage.php';
16 /**
17 * @package MediaWiki
18 * @subpackage SpecialPage
20 class UnwatchedpagesPage extends QueryPage {
22 function getName() { return 'Unwatchedpages'; }
23 function isExpensive() { return true; }
24 function isSyndicated() { return false; }
26 function getSQL() {
27 $dbr =& wfGetDB( DB_SLAVE );
28 extract( $dbr->tableNames( 'page', 'watchlist' ) );
29 $mwns = NS_MEDIAWIKI;
30 return
32 SELECT
33 'Unwatchedpages' as type,
34 page_namespace as namespace,
35 page_title as title,
36 page_namespace as value
37 FROM $page
38 LEFT JOIN $watchlist ON wl_namespace = page_namespace AND page_title = wl_title
39 WHERE wl_title IS NULL AND page_is_redirect = 0 AND page_namespace<>$mwns
43 function sortDescending() { return false; }
45 function formatResult( $skin, $result ) {
46 global $wgContLang;
48 $nt = Title::makeTitle( $result->namespace, $result->title );
49 $text = $wgContLang->convert( $nt->getPrefixedText() );
51 $plink = $skin->makeKnownLinkObj( $nt, htmlspecialchars( $text ) );
52 $wlink = $skin->makeKnownLinkObj( $nt, wfMsgHtml( 'watch' ), 'action=watch' );
54 return wfSpecialList( $plink, $wlink );
58 /**
59 * constructor
61 function wfSpecialUnwatchedpages() {
62 global $wgUser, $wgOut;
64 if ( ! $wgUser->isAllowed( 'unwatchedpages' ) )
65 return $wgOut->permissionRequired( 'unwatchedpages' );
67 list( $limit, $offset ) = wfCheckLimits();
69 $wpp = new UnwatchedpagesPage();
71 $wpp->doQuery( $offset, $limit );