includes/SpecialUnwatchedpages.php

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