X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FSpecialRecentchangeslinked.php;h=2a8ac32d1a9dbbb1e759b0e640b6be9fdae6ea32;hb=0495f90ebb83c0295f67b9da410ddf3b0534ca38;hp=fa86e3a917b5ee3501a36a72cf4acbf95bfdd1f2;hpb=13c17d0cc9cc901c74469ece3c7646f830ca9623;p=lhc%2Fweb%2Fwiklou.git
diff --git a/includes/SpecialRecentchangeslinked.php b/includes/SpecialRecentchangeslinked.php
index fa86e3a917..2a8ac32d1a 100644
--- a/includes/SpecialRecentchangeslinked.php
+++ b/includes/SpecialRecentchangeslinked.php
@@ -1,91 +1,175 @@
-setPagetitle( wfMsg( "recentchanges" ) );
+ $days = $wgRequest->getInt( 'days' );
+ $target = isset($par) ? $par : $wgRequest->getText( 'target' );
+ $hideminor = $wgRequest->getBool( 'hideminor' ) ? 1 : 0;
+
+ $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 );
- $wgOut->setSubtitle( wfMsg( "rclsub", $nt->getPrefixedText() ) );
+ if( !$nt ) {
+ $wgOut->errorpage( 'notargettitle', 'notargettext' );
+ return;
+ }
+ $id = $nt->getArticleId();
+
+ $wgOut->setPageTitle( wfMsg( 'recentchangeslinked-title', $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' );
- if ( ! isset( $hideminor ) ) {
- $hideminor = $wgUser->getOption( "hideminor" );
- }
+ $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 = ""; }
-
- $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='" .
- wfStrencode( $nt->getPrefixedDBkey() ) . "' GROUP BY cur_id " .
- "ORDER BY inverse_timestamp LIMIT {$limit}";
- $res = wfQuery( $sql, DB_READ, $fname );
-
- $note = wfMsg( "rcnote", $limit, $days );
- $wgOut->addHTML( "
\n{$note}\n
" );
-
- $tu = "target=" . $nt->getPrefixedURL();
- $note = rcDayLimitlinks( $days, $limit, "Recentchangeslinked", $tu );
- $wgOut->addHTML( "{$note}\n" );
-
- $s = $sk->beginRecentChangesList();
- $count = wfNumRows( $res );
-
- while ( $limit ) {
- if ( 0 == $count ) { break; }
- $obj = wfFetchObject( $res );
- --$count;
-
- $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 );
-
- $s .= $sk->recentChangesLine( $ts, $u, $ut, $ns, $ttl, $com, $me, $new );
- --$limit;
+ $cmq = 'AND rc_minor=0';
+ } else { $cmq = ''; }
+
+ 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_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("< ".$sk->makeLinkObj($nt, "", "redirect=no" )."
\n");
+ $note = wfMsgExt( "rcnote", array ( 'parseinline' ), $limit, $days, $wgLang->timeAndDate( wfTimestampNow(), true ) );
+ $wgOut->addHTML( "
\n{$note}\n
" );
+
+ $note = rcDayLimitlinks( $days, $limit, "Recentchangeslinked",
+ "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 );
}
-?>
+