-<?
-include_once( "SpecialRecentchanges.php" );
-include_once( "WatchedItem.php" );
+<?php
+/**
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
-function wfSpecialWatchlist()
-{
- global $wgUser, $wgOut, $wgLang, $wgTitle;
- global $days, $limit, $target; # From query string
- $fname = "wfSpecialWatchlist";
+/**
+ *
+ */
+require_once( 'SpecialRecentchanges.php' );
+require_once( 'WatchedItem.php' );
+
+/**
+ * constructor
+ */
+function wfSpecialWatchlist() {
+ global $wgUser, $wgOut, $wgLang, $wgTitle, $wgMemc, $wgRequest, $wgContLang;;
+ global $wgUseWatchlistCache, $wgWLCacheTimeout, $wgDBname;
+ global $wgEnotif, $wgShowUpdatedMarker, $wgRCShowWatchingUsers;
+ $fname = 'wfSpecialWatchlist';
- $wgOut->setPagetitle( wfMsg( "watchlist" ) );
- $sub = wfMsg( "watchlistsub", $wgUser->getName() );
+ $wgOut->setPagetitle( wfMsg( 'watchlist' ) );
+ $sub = wfMsg( 'watchlistsub', $wgUser->getName() );
$wgOut->setSubtitle( $sub );
- $wgOut->setRobotpolicy( "noindex,nofollow" );
+ $wgOut->setRobotpolicy( 'noindex,nofollow' );
- $uid = $wgUser->getID();
- if( $uid == 0 ) {
- $wgOut->addHTML( wfMsg( "nowatchlist" ) );
+ $specialTitle = Title::makeTitle( NS_SPECIAL, 'Watchlist' );
+
+ if( $wgUser->isAnon() ) {
+ $wgOut->addWikiText( wfMsg( 'nowatchlist' ) );
return;
}
- global $action,$remove,$id;
- if(($action == "submit") && isset($remove) && is_array($id)) {
- $wgOut->addHTML( wfMsg( "removingchecked" ) );
+ # Get query variables
+ $days = $wgRequest->getVal( 'days' );
+ $action = $wgRequest->getVal( 'action' );
+ $remove = $wgRequest->getVal( 'remove' );
+ $hideOwn = $wgRequest->getVal( 'hideOwn' );
+ $id = $wgRequest->getArray( 'id' );
+
+ if( $wgUser->getOption( 'enotifwatchlistpages' ) ) {
+ $wgOut->addHTML( "<div class='enotifinfo'>\n" );
+
+ $wgOut->addWikiText( wfMsg( 'email_notification_infotext' ) );
+
+ $wgOut->addHTML( '<form action="' .
+ $specialTitle->escapeLocalUrl( 'action=submit&magic=yes' ) .
+ '" method="post"><input type="submit" name="dummy" value="' .
+ htmlspecialchars( wfMsg( 'email_notification_reset' ) ) .
+ '" /><input type="hidden" name="reset" value="all" /></form>' .
+ "</div>\n\n" );
+ }
+
+ $uid = $wgUser->getID();
+ if( $wgRequest->getVal( 'reset' ) == 'all' ) {
+ $wgUser->clearAllNotifications( $uid );
+ }
+
+
+ if(($action == 'submit') && isset($remove) && is_array($id)) {
+ $wgOut->addWikiText( wfMsg( 'removingchecked' ) );
+ $wgOut->addHTML( '<p>' );
foreach($id as $one) {
$t = Title::newFromURL( $one );
- if($t->getDBkey() != "") {
+ if($t->getDBkey() != '') {
$wl = WatchedItem::fromUserTitle( $wgUser, $t );
if( $wl->removeWatch() === false ) {
- $wgOut->addHTML( "<br />\n" . wfMsg( "couldntremove", htmlspecialchars($one) ) );
+ $wgOut->addHTML( "<br />\n" . wfMsg( 'couldntremove', htmlspecialchars($one) ) );
} else {
- $wgOut->addHTML( " (" . htmlspecialchars($one) . ")" );
+ $wgOut->addHTML( ' (' . htmlspecialchars($one) . ')' );
}
} else {
- $wgOut->addHTML( "<br />\n" . wfMsg( "iteminvalidname", htmlspecialchars($one) ) );
+ $wgOut->addHTML( "<br />\n" . wfMsg( 'iteminvalidname', htmlspecialchars($one) ) );
}
}
- $wgOut->addHTML( "done.\n<p>" );
+ $wgOut->addHTML( "done.</p>\n" );
+ }
+
+ if ( $wgUseWatchlistCache ) {
+ $memckey = "$wgDBname:watchlist:id:" . $wgUser->getId();
+ $cache_s = @$wgMemc->get( $memckey );
+ if( $cache_s ){
+ $wgOut->addWikiText( wfMsg('wlsaved') );
+ $wgOut->addHTML( $cache_s );
+ return;
+ }
}
- $sql = "SELECT COUNT(*) AS n FROM watchlist WHERE wl_user=$uid";
- $res = wfQuery( $sql, DB_READ );
- $s = wfFetchObject( $res );
+ $dbr =& wfGetDB( DB_SLAVE );
+ extract( $dbr->tableNames( 'page', 'revision', 'watchlist', 'recentchanges' ) );
+
+ $sql = "SELECT COUNT(*) AS n FROM $watchlist WHERE wl_user=$uid";
+ $res = $dbr->query( $sql, $fname );
+ $s = $dbr->fetchObject( $res );
+
+# Patch *** A1 *** (see A2 below)
+# adjust for page X, talk:page X, which are both stored separately, but treated together
+# $nitems = $s->n / 2;
$nitems = $s->n;
-
+
if($nitems == 0) {
- $wgOut->addHTML( wfMsg( "nowatchlist" ) );
+ $wgOut->addWikiText( wfMsg( 'nowatchlist' ) );
return;
}
-
- if ( ! isset( $days ) ) {
- $big = 250;
+
+ if ( is_null( $days ) ) {
+ $big = 1000;
if($nitems > $big) {
# Set default cutoff shorter
- $days = (1.0 / 24.0); # 1 hour...
+ $days = (12.0 / 24.0); # 12 hours...
} else {
- $days = 0; # no time cutoff for shortlisters
+ $days = 3; # longer cutoff for shortlisters
}
} else {
$days = floatval($days);
}
-
+
if ( $days <= 0 ) {
$docutoff = '';
$cutoff = false;
- $npages = wfMsg( "all" );
+ $npages = wfMsg( 'watchlistall1' );
} else {
- $docutoff = "AND cur_timestamp > '" .
- ( $cutoff = wfUnix2Timestamp( time() - intval( $days * 86400 ) ) )
+ $docutoff = "AND rev_timestamp > '" .
+ ( $cutoff = $dbr->timestamp( time() - intval( $days * 86400 ) ) )
. "'";
- $sql = "SELECT COUNT(*) AS n FROM cur WHERE cur_timestamp>'$cutoff'";
- $res = wfQuery( $sql, DB_READ );
- $s = wfFetchObject( $res );
+ $sql = "SELECT COUNT(*) AS n FROM $page, $revision WHERE rev_timestamp>'$cutoff' AND page_id=rev_page";
+ $res = $dbr->query( $sql, $fname );
+ $s = $dbr->fetchObject( $res );
$npages = $s->n;
+
}
-
+ if ( is_null( $hideOwn ) ) {
+ # default is false (don't hide own edits)
+ $hideOwn = 0;
+ }
+
if(isset($_REQUEST['magic'])) {
- $wgOut->addHTML( wfMsg( "watchlistcontains", $nitems ) .
- "<p>" . wfMsg( "watcheditlist" ) . "</p>\n" );
-
- $wgOut->addHTML( "<form action='" .
- wfLocalUrl( $wgLang->specialPage( "Watchlist" ), "action=submit" ) .
+ $wgOut->addWikiText( wfMsg( 'watchlistcontains', $wgLang->formatNum( $nitems ) ) .
+ '<p>' . wfMsg( 'watcheditlist' ) . "</p>\n" );
+
+ $wgOut->addHTML( '<form action=\'' .
+ $specialTitle->escapeLocalUrl( 'action=submit' ) .
"' method='post'>\n" .
"<ul>\n" );
- $sql = "SELECT wl_namespace,wl_title FROM watchlist WHERE wl_user=$uid";
- $res = wfQuery( $sql, DB_READ );
- global $wgUser, $wgLang;
+
+# Patch A2
+# The following was proposed by KTurner 07.11.2004 to T.Gries
+# $sql = "SELECT distinct (wl_namespace & ~1),wl_title FROM $watchlist WHERE wl_user=$uid";
+ $sql = "SELECT wl_namespace,wl_title FROM $watchlist WHERE wl_user=$uid";
+
+ $res = $dbr->query( $sql, $fname );
$sk = $wgUser->getSkin();
- while( $s = wfFetchObject( $res ) ) {
+ while( $s = $dbr->fetchObject( $res ) ) {
$t = Title::makeTitle( $s->wl_namespace, $s->wl_title );
- $t = $t->getPrefixedText();
- $wgOut->addHTML( "<li><input type='checkbox' name='id[]' value=\"" . htmlspecialchars($t) . "\">" .
- $sk->makeKnownLink( $t, $t ) .
- "</li>\n" );
+ if( is_null( $t ) ) {
+ $wgOut->addHTML( '<!-- bad title "' . htmlspecialchars( $s->wl_title ) . '" in namespace ' . IntVal( $s->wl_namespace ) . " -->\n" );
+ } else {
+ $t = $t->getPrefixedText();
+ $wgOut->addHTML( '<li><input type="checkbox" name="id[]" value="' . htmlspecialchars($t) . '" />' .
+ $sk->makeLink( $t, $t ) .
+ "</li>\n" );
+ }
}
$wgOut->addHTML( "</ul>\n" .
- "<input type='submit' name='remove' value='" .
- wfMsg( "removechecked" ) . "'>\n" .
+ "<input type='submit' name='remove' value=\"" .
+ htmlspecialchars( wfMsg( "removechecked" ) ) . "\" />\n" .
"</form>\n" );
-
+
return;
}
-
+
# If the watchlist is relatively short, it's simplest to zip
# down its entirety and then sort the results.
-
+
# If it's relatively long, it may be worth our while to zip
# through the time-sorted page list checking for watched items.
-
+
# Up estimate of watched items by 15% to compensate for talk pages...
if( $cutoff && ( $nitems*1.15 > $npages ) ) {
- $x = "cur_timestamp";
- $y = wfMsg( "watchmethod-recent" );
- $z = "wl_namespace=cur_namespace&65534";
+ $x = 'rev_timestamp';
+ $y = wfMsg( 'watchmethod-recent' );
+ # TG patch: here we do not consider pages and their talk pages equivalent - why should we ?
+ # The change results in talk-pages not automatically included in watchlists, when their parent page is included
+ # $z = "wl_namespace=cur_namespace & ~1";
+ $z = 'wl_namespace=page_namespace';
} else {
- $x = "name_title_timestamp";
- $y = wfMsg( "watchmethod-list" );
- $z = "(wl_namespace=cur_namespace OR wl_namespace+1=cur_namespace)";
+ $x = 'page_timestamp';
+ $y = wfMsg( 'watchmethod-list' );
+ # TG patch: here we do not consider pages and their talk pages equivalent - why should we ?
+ # The change results in talk-pages not automatically included in watchlists, when their parent page is included
+ # $z = "(wl_namespace=cur_namespace OR wl_namespace+1=cur_namespace)";
+ $z = 'wl_namespace=page_namespace';
}
- $wgOut->addHTML( "<i>" . wfMsg( "watchdetails", $nitems, $npages, $y,
- wfLocalUrl( $wgLang->specialPage("Watchlist"),"magic=yes" ) ) . "</i><br>\n" );
-
+ if ( 0 == $hideOwn )
+ $andHideOwn = '';
+ else
+ $andHideOwn = "AND (rev_user <> $uid)";
+
+
+ $wgOut->addHTML( '<i>' . wfMsg( 'watchdetails',
+ $wgLang->formatNum( $nitems ), $wgLang->formatNum( $npages ), $y,
+ $specialTitle->escapeLocalUrl( 'magic=yes' ) ) . "</i><br />\n" );
+ $use_index = $dbr->useIndexClause( $x );
$sql = "SELECT
- cur_namespace,cur_title,cur_comment,
- cur_user,cur_user_text,cur_timestamp,cur_minor_edit,cur_is_new
- FROM watchlist,cur USE INDEX ($x)
+ page_namespace,page_title,rev_comment, page_id,
+ rev_user,rev_user_text,rev_timestamp,rev_minor_edit,page_is_new,wl_notificationtimestamp
+ FROM $watchlist,$page,$revision $use_index
WHERE wl_user=$uid
+ $andHideOwn
AND $z
- AND wl_title=cur_title
+ AND wl_title=page_title
+ AND page_latest=rev_id
$docutoff
- ORDER BY cur_timestamp DESC";
+ ORDER BY rev_timestamp DESC";
- $res = wfQuery( $sql, DB_READ, $fname );
-
+ $res = $dbr->query( $sql, $fname );
+ $numRows = $dbr->numRows( $res );
if($days >= 1)
- $note = wfMsg( "rcnote", $limit, $days );
+ $note = wfMsg( 'rcnote', $wgLang->formatNum( $numRows ), $wgLang->formatNum( $days ) );
elseif($days > 0)
- $note = wfMsg( "wlnote", $limit, round($days*24) );
+ $note = wfMsg( 'wlnote', $wgLang->formatNum( $numRows ), $wgLang->formatNum( round($days*24) ) );
else
- $note = "";
- $wgOut->addHTML( "\n<hr>\n{$note}\n<br>" );
- $note = wlCutoffLinks( $days, $limit );
+ $note = '';
+ $wgOut->addHTML( "\n<hr />\n{$note}\n<br />" );
+ $note = wlCutoffLinks( $days );
$wgOut->addHTML( "{$note}\n" );
-
- if ( wfNumRows( $res ) == 0 ) {
- $wgOut->addHTML( "<p><i>" . wfMsg( "watchnochange" ) . "</i></p>" );
+
+ $sk = $wgUser->getSkin();
+ $s = $sk->makeKnownLink(
+ $wgContLang->specialPage( 'Watchlist' ),
+ (0 == $hideOwn) ? wfMsg( 'wlhide' ) : wfMsg( 'wlshow' ),
+ 'hideOwn=' . $wgLang->formatNum( 1-$hideOwn ) );
+
+ $note = wfMsg( "wlhideshowown", $s );
+ $wgOut->addHTML( "\n<br />{$note}\n<br />" );
+
+ if ( $numRows == 0 ) {
+ $wgOut->addHTML( '<p><i>' . wfMsg( 'watchnochange' ) . '</i></p>' );
return;
}
$sk = $wgUser->getSkin();
- $s = $sk->beginRecentChangesList();
+ $list =& new ChangesList( $sk );
+ $s = $list->beginRecentChangesList();
+ $counter = 1;
+ while ( $obj = $dbr->fetchObject( $res ) ) {
+ # Make fake RC entry
+ $rc = RecentChange::newFromCurRow( $obj );
+ $rc->counter = $counter++;
+
+ if ($wgShowUpdatedMarker && $wgUser->getOption( 'showupdated' )) {
+ $rc->notificationtimestamp = $obj->wl_notificationtimestamp;
+ } else {
+ $rc->notificationtimestamp = false;
+ }
- while ( $obj = wfFetchObject( $res ) ) {
- $ts = $obj->cur_timestamp;
- $u = $obj->cur_user;
- $ut = $obj->cur_user_text;
- $ns = $obj->cur_namespace;
- $ttl = $obj->cur_title;
- $com = $obj->cur_comment;
- $me = ( $obj->cur_minor_edit > 0 );
- $new = ( $obj->cur_is_new > 0 );
- $watched = true;
+ if ($wgRCShowWatchingUsers && $wgUser->getOption( 'shownumberswatching' )) {
+ $sql3 = "SELECT COUNT(*) AS n FROM $watchlist WHERE wl_title='" .wfStrencode($obj->cur_title). "' AND wl_namespace='{$obj->cur_namespace}'" ;
+ $res3 = $dbr->query( $sql3, DB_READ, $fname );
+ $x = $dbr->fetchObject( $res3 );
+ $rc->numberofWatchingusers = $x->n;
+ } else {
+ $rc->numberofWatchingusers = 0;
+ }
- $s .= $sk->recentChangesLine( $ts, $u, $ut, $ns, $ttl, $com, $me, $new, $watched );
+ $s .= $list->recentChangesLine( $rc, true);
}
- $s .= $sk->endRecentChangesList();
+ $s .= $list->endRecentChangesList();
- wfFreeResult( $res );
+ $dbr->freeResult( $res );
$wgOut->addHTML( $s );
+
+ if ( $wgUseWatchlistCache ) {
+ $wgMemc->set( $memckey, $s, $wgWLCacheTimeout);
+ }
+
}
function wlHoursLink( $h, $page ) {
- global $wgUser, $wgLang;
+ global $wgUser, $wgLang, $wgContLang;
$sk = $wgUser->getSkin();
$s = $sk->makeKnownLink(
- $wgLang->specialPage( $page ),
- $h, "days=" . ($h / 24.0) );
+ $wgContLang->specialPage( $page ),
+ $wgLang->formatNum( $h ),
+ 'days=' . ($h / 24.0) );
return $s;
}
function wlDaysLink( $d, $page ) {
- global $wgUser, $wgLang;
+ global $wgUser, $wgLang, $wgContLang;
$sk = $wgUser->getSkin();
$s = $sk->makeKnownLink(
- $wgLang->specialPage( $page ),
- ($d ? $d : wfMsg( "all" ) ), "days=$d" );
+ $wgContLang->specialPage( $page ),
+ ($d ? $wgLang->formatNum( $d ) : wfMsg( 'watchlistall2' ) ), "days=$d" );
return $s;
}
-function wlCutoffLinks( $days, $limit, $page = "Watchlist" )
+function wlCutoffLinks( $days, $page = 'Watchlist' )
{
$hours = array( 1, 2, 6, 12 );
$days = array( 1, 3, 7 );
- $cl = "";
+ $cl = '';
$i = 0;
foreach( $hours as $h ) {
$hours[$i++] = wlHoursLink( $h, $page );
foreach( $days as $d ) {
$days[$i++] = wlDaysLink( $d, $page );
}
- return
- wfMsg ("wlshowlast") .
- implode(" | ", $hours) . wfMsg("wlhours") .
- implode(" | ", $days) . wfMsg("wldays") .
- wlDaysLink( 0, $page );
-# $note = wfMsg( "rclinks", $cl, $dl, $mlink );
+ return wfMsg ('wlshowlast',
+ implode(' | ', $hours),
+ implode(' | ', $days),
+ wlDaysLink( 0, $page ) );
}
?>