X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FSpecialRecentchangeslinked.php;h=14508d3a8b6c43559303aaef3b064c57fb19a1a3;hb=72a4abe588a7511ed5a92a5e30f889c60d824c1a;hp=ffe169e7d8a7881a33c24eec69b074da27d803cb;hpb=a6d18de13c73cc5953258351481eaf0186d85f62;p=lhc%2Fweb%2Fwiklou.git

diff --git a/includes/SpecialRecentchangeslinked.php b/includes/SpecialRecentchangeslinked.php
index ffe169e7d8..14508d3a8b 100644
--- a/includes/SpecialRecentchangeslinked.php
+++ b/includes/SpecialRecentchangeslinked.php
@@ -1,88 +1,173 @@
 <?php
-include_once( "SpecialRecentchanges.php" );
+/**
+ * This is to display changes made to all articles linked in an article.
+ * @addtogroup SpecialPage
+ */
 
-function wfSpecialRecentchangeslinked( $par = NULL )
-{
-	global $wgUser, $wgOut, $wgLang, $wgTitle, $wgRequest;
-	$fname = "wfSpecialRecentchangeslinked";
+/**
+ *
+ */
+require_once( 'SpecialRecentchanges.php' );
+
+/**
+ * Entrypoint
+ * @param string $par parent page we will look at
+ */
+function wfSpecialRecentchangeslinked( $par = NULL ) {
+	global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest;
+	$fname = 'wfSpecialRecentchangeslinked';
 
 	$days = $wgRequest->getInt( 'days' );
-	$target = $wgRequest->getText( 'target' );
+	$target = isset($par) ? $par : $wgRequest->getText( 'target' );
 	$hideminor = $wgRequest->getBool( 'hideminor' ) ? 1 : 0;
-	
-	$wgOut->setPagetitle( wfMsg( "recentchanges" ) );
+
+	$wgOut->setPagetitle( wfMsg( 'recentchangeslinked' ) );
 	$sk = $wgUser->getSkin();
 
-	if( $par ) {
-		$target = $par;
-	}
-	if ( "" == $target ) {
-		$wgOut->errorpage( "notargettitle", "notargettext" );
+	if (is_null($target)) {
+		$wgOut->errorpage( 'notargettitle', 'notargettext' );
 		return;
 	}
 	$nt = Title::newFromURL( $target );
 	if( !$nt ) {
-		$wgOut->errorpage( "notargettitle", "notargettext" );
+		$wgOut->errorpage( 'notargettitle', 'notargettext' );
 		return;
 	}
 	$id = $nt->getArticleId();
-	
-	$wgOut->setSubtitle( wfMsg( "rclsub", $nt->getPrefixedText() ) );
+
+	$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" );
-	$cutoff = wfUnix2Timestamp( time() - ( $days * 86400 ) );
+	list( $limit, /* offset */ ) = wfCheckLimits( 100, 'rclimit' );
+
+	$dbr = wfGetDB( DB_SLAVE,'recentchangeslinked' );
+	$cutoff = $dbr->timestamp( time() - ( $days * 86400 ) );
 
 	$hideminor = ($hideminor ? 1 : 0);
 	if ( $hideminor ) {
-		$mlink = $sk->makeKnownLink( $wgLang->specialPage( "Recentchangeslinked" ),
-	  	  WfMsg( "show" ), "target=" . wfEscapeHTML( $nt->getPrefixedURL() ) .
+		$mlink = $sk->makeKnownLink( $wgContLang->specialPage( 'Recentchangeslinked' ),
+	  	  wfMsg( 'show' ), 'target=' . htmlspecialchars( $nt->getPrefixedURL() ) .
 		  "&days={$days}&limit={$limit}&hideminor=0" );
 	} else {
-		$mlink = $sk->makeKnownLink( $wgLang->specialPage( "Recentchangeslinked" ),
-	  	  WfMsg( "hide" ), "target=" . wfEscapeHTML( $nt->getPrefixedURL() ) .
+		$mlink = $sk->makeKnownLink( $wgContLang->specialPage( "Recentchangeslinked" ),
+	  	  wfMsg( "hide" ), "target=" . htmlspecialchars( $nt->getPrefixedURL() ) .
 		  "&days={$days}&limit={$limit}&hideminor=1" );
 	}
 	if ( $hideminor ) {
-		$cmq = "AND cur_minor_edit=0";
-	} else { $cmq = ""; }
+		$cmq = 'AND rc_minor=0';
+	} else { $cmq = ''; }
+
+	list($recentchanges, $categorylinks, $pagelinks, $watchlist) = 
+	    $dbr->tableNamesN( 'recentchanges', 'categorylinks', 'pagelinks', "watchlist" );
+
+	$uid = $wgUser->getID();
 
-	$sql = "SELECT cur_id,cur_namespace,cur_title,cur_user,cur_comment," .
-	  "cur_user_text,cur_timestamp,cur_minor_edit,cur_is_new FROM links, cur " .
-	  "WHERE cur_timestamp > '{$cutoff}' {$cmq} AND l_to=cur_id AND l_from=$id " .
-      "GROUP BY cur_id ORDER BY inverse_timestamp LIMIT {$limit}";
-	$res = wfQuery( $sql, DB_READ, $fname );
+	$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}";
 
-	$note = wfMsg( "rcnote", $limit, $days );
+	// 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_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_id,
+			rc_cur_id,
+			rc_namespace,
+			rc_title,
+			rc_user,
+			rc_comment,
+			rc_user_text,
+			rc_this_oldid,
+			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
+$GROUPBY
+";
+	}
+	$res = $dbr->query( $sql, $fname );
+
+	$wgOut->addHTML("&lt; ".$sk->makeLinkObj($nt, "", "redirect=no" )."<br />\n");
+	$note = wfMsgExt( "rcnote", array ( 'parseinline' ), $limit, $days, $wgLang->timeAndDate( wfTimestampNow(), true ) );
 	$wgOut->addHTML( "<hr />\n{$note}\n<br />" );
 
 	$note = rcDayLimitlinks( $days, $limit, "Recentchangeslinked",
-                                 "target=" . $nt->getPrefixedURL() . "&hideminor={$hideminor}",
-                                 false, $mlink );
-
-	$wgOut->addHTML( "{$note}\n" );
-
-	$s = $sk->beginRecentChangesList();
-	$count = wfNumRows( $res );
-	
-	$counter = 1;
-	while ( $limit ) {
-		if ( 0 == $count ) { break; }
-		$obj = wfFetchObject( $res );
-		--$count;
-
-		$rc = RecentChange::newFromCurRow( $obj );
-		$rc->counter = $counter++;
-		$s .= $sk->recentChangesLine( $rc );
-		--$limit;
+				 "target=" . $nt->getPrefixedURL() . "&hideminor={$hideminor}",
+				 false, $mlink );
+
+	$wgOut->addHTML( $note."\n" );
+
+	$list = ChangesList::newFromUser( $wgUser );
+	$s = $list->beginRecentChangesList();
+	$count = $dbr->numRows( $res );
+
+	if ( $count ) {
+		$counter = 1;
+		while ( $limit ) {
+			if ( 0 == $count ) { break; }
+			$obj = $dbr->fetchObject( $res );
+			--$count;
+			$rc = RecentChange::newFromRow( $obj );
+			$rc->counter = $counter++;
+			$s .= $list->recentChangesLine( $rc , !empty( $obj->wl_user) );
+			--$limit;
+		}
+	} else {
+		$wgOut->addWikiText( wfMsg('recentchangeslinked-noresult') );
 	}
-	$s .= $sk->endRecentChangesList();
+	$s .= $list->endRecentChangesList();
 
-	wfFreeResult( $res );
+	$dbr->freeResult( $res );
 	$wgOut->addHTML( $s );
 }