X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FSpecialRecentchangeslinked.php;h=14508d3a8b6c43559303aaef3b064c57fb19a1a3;hb=72a4abe588a7511ed5a92a5e30f889c60d824c1a;hp=0bc507729b548169cf95e17c8e5c318c6769f806;hpb=d0b4d2cc9ae43f450b525c6addc363b23a33f853;p=lhc%2Fweb%2Fwiklou.git
diff --git a/includes/SpecialRecentchangeslinked.php b/includes/SpecialRecentchangeslinked.php
index 0bc507729b..14508d3a8b 100644
--- a/includes/SpecialRecentchangeslinked.php
+++ b/includes/SpecialRecentchangeslinked.php
@@ -1,8 +1,7 @@
getInt( 'days' );
$target = isset($par) ? $par : $wgRequest->getText( 'target' );
$hideminor = $wgRequest->getBool( 'hideminor' ) ? 1 : 0;
-
+
$wgOut->setPagetitle( wfMsg( 'recentchangeslinked' ) );
$sk = $wgUser->getSkin();
@@ -35,17 +34,15 @@ function wfSpecialRecentchangeslinked( $par = NULL ) {
return;
}
$id = $nt->getArticleId();
-
+
$wgOut->setSubtitle( htmlspecialchars( wfMsg( 'rclsub', $nt->getPrefixedText() ) ) );
if ( ! $days ) {
- $days = $wgUser->getOption( 'rcdays' );
- if ( ! $days ) { $days = 7; }
+ $days = (int)$wgUser->getOption( 'rcdays', 7 );
}
- $days = (int)$days;
- list( $limit, $offset ) = wfCheckLimits( 100, 'rclimit' );
+ list( $limit, /* offset */ ) = wfCheckLimits( 100, 'rclimit' );
- $dbr =& wfGetDB( DB_SLAVE );
+ $dbr = wfGetDB( DB_SLAVE,'recentchangeslinked' );
$cutoff = $dbr->timestamp( time() - ( $days * 86400 ) );
$hideminor = ($hideminor ? 1 : 0);
@@ -59,87 +56,114 @@ function wfSpecialRecentchangeslinked( $par = NULL ) {
"&days={$days}&limit={$limit}&hideminor=1" );
}
if ( $hideminor ) {
- $cmq = 'AND rev_minor_edit=0';
+ $cmq = 'AND rc_minor=0';
} else { $cmq = ''; }
- extract( $dbr->tableNames( 'recentchanges', 'categorylinks', 'pagelinks', 'revision', 'page' ) );
-
+ list($recentchanges, $categorylinks, $pagelinks, $watchlist) =
+ $dbr->tableNamesN( 'recentchanges', 'categorylinks', 'pagelinks', "watchlist" );
+
+ $uid = $wgUser->getID();
+
+ $GROUPBY = "
+ GROUP BY rc_cur_id,rc_namespace,rc_title,
+ rc_user,rc_comment,rc_user_text,rc_timestamp,rc_minor,rc_deleted,
+ rc_new, rc_id, rc_this_oldid, rc_last_oldid, rc_bot, rc_patrolled, rc_type, rc_old_len, rc_new_len
+" . ($uid ? ",wl_user" : "") . "
+ ORDER BY rc_timestamp DESC
+ LIMIT {$limit}";
+
// If target is a Category, use categorylinks and invert from and to
if( $nt->getNamespace() == NS_CATEGORY ) {
$catkey = $dbr->addQuotes( $nt->getDBKey() );
- $sql = "SELECT /* wfSpecialRecentchangeslinked */
- rc_cur_id page_id,
- rc_namespace page_namespace,
- rc_title page_title,
- rc_this_oldid rev_id,
- rc_user rev_user,
- rc_comment rev_comment,
- rc_user_text rev_user_text,
- rc_timestamp rev_timestamp,
- rc_minor rev_minor_edit,
- rc_new page_is_new
- FROM $categorylinks, $recentchanges
- WHERE rc_timestamp > '{$cutoff}'
- {$cmq}
- AND cl_from=rc_cur_id
- AND cl_to=$catkey
- GROUP BY page_id,page_namespace,page_title,
- rev_user,rev_comment,rev_user_text,rev_timestamp,rev_minor_edit,
- page_is_new
- ORDER BY rev_timestamp DESC
- LIMIT {$limit};
+ $sql = "SELECT /* wfSpecialRecentchangeslinked */
+ rc_id,
+ rc_cur_id,
+ rc_namespace,
+ rc_title,
+ rc_this_oldid,
+ rc_last_oldid,
+ rc_user,
+ rc_comment,
+ rc_user_text,
+ rc_timestamp,
+ rc_minor,
+ rc_bot,
+ rc_new,
+ rc_patrolled,
+ rc_type,
+ rc_old_len,
+ rc_new_len,
+ rc_deleted
+" . ($uid ? ",wl_user" : "") . "
+ FROM $categorylinks, $recentchanges
+" . ($uid ? "LEFT OUTER JOIN $watchlist ON wl_user={$uid} AND wl_title=rc_title AND wl_namespace=rc_namespace " : "") . "
+ WHERE rc_timestamp > '{$cutoff}'
+ {$cmq}
+ AND cl_from=rc_cur_id
+ AND cl_to=$catkey
+$GROUPBY
";
} else {
$sql =
-"SELECT /* wfSpecialRecentchangeslinked */
- rc_cur_id page_id,
- rc_namespace page_namespace,
- rc_title page_title,
- rc_user rev_user,
- rc_comment rev_comment,
- rc_user_text rev_user_text,
+"SELECT /* wfSpecialRecentchangeslinked */
+ rc_id,
+ rc_cur_id,
+ rc_namespace,
+ rc_title,
+ rc_user,
+ rc_comment,
+ rc_user_text,
rc_this_oldid,
- rc_timestamp rev_timestamp,
- rc_minor rev_minor_edit,
- rc_new page_is_new
- FROM $pagelinks, $recentchanges
+ rc_last_oldid,
+ rc_timestamp,
+ rc_minor,
+ rc_bot,
+ rc_new,
+ rc_patrolled,
+ rc_type,
+ rc_old_len,
+ rc_new_len,
+ rc_deleted
+" . ($uid ? ",wl_user" : "") . "
+ FROM $pagelinks, $recentchanges
+" . ($uid ? " LEFT OUTER JOIN $watchlist ON wl_user={$uid} AND wl_title=rc_title AND wl_namespace=rc_namespace " : "") . "
WHERE rc_timestamp > '{$cutoff}'
{$cmq}
AND pl_namespace=rc_namespace
AND pl_title=rc_title
AND pl_from=$id
-GROUP BY page_id,page_namespace,page_title,
- rev_user,rev_comment,rev_user_text,rev_timestamp,rev_minor_edit,
- page_is_new
-ORDER BY rev_timestamp DESC
- LIMIT {$limit}";
+$GROUPBY
+";
}
$res = $dbr->query( $sql, $fname );
- $wgOut->addHTML("< ".$sk->makeKnownLinkObj($nt, "", "redirect=no" )."
\n");
- $note = wfMsg( "rcnote", $limit, $days );
+ $wgOut->addHTML("< ".$sk->makeLinkObj($nt, "", "redirect=no" )."
\n");
+ $note = wfMsgExt( "rcnote", array ( 'parseinline' ), $limit, $days, $wgLang->timeAndDate( wfTimestampNow(), true ) );
$wgOut->addHTML( "