$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 == '') {
+ if (is_null($target)) {
$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' );
$hideminor = ($hideminor ? 1 : 0);
if ( $hideminor ) {
$mlink = $sk->makeKnownLink( $wgContLang->specialPage( 'Recentchangeslinked' ),
- WfMsg( 'show' ), 'target=' . htmlspecialchars( $nt->getPrefixedURL() ) .
+ wfMsg( 'show' ), 'target=' . htmlspecialchars( $nt->getPrefixedURL() ) .
"&days={$days}&limit={$limit}&hideminor=0" );
} else {
$mlink = $sk->makeKnownLink( $wgContLang->specialPage( "Recentchangeslinked" ),
- WfMsg( "hide" ), "target=" . htmlspecialchars( $nt->getPrefixedURL() ) .
+ wfMsg( "hide" ), "target=" . htmlspecialchars( $nt->getPrefixedURL() ) .
"&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' ) );
+
// If target is a Category, use categorylinks and invert from and to
if( $nt->getNamespace() == NS_CATEGORY ) {
$catkey = $dbr->addQuotes( $nt->getDBKey() );
- $sql = "SELECT page_id,page_namespace,page_title,rev_user,rev_comment," .
- "rev_user_text,rev_timestamp,rev_minor_edit,page_is_new FROM $categorylinks, $revision, $page " .
- "WHERE rev_timestamp > '{$cutoff}' {$cmq} AND cl_from=page_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,inverse_timestamp ORDER BY inverse_timestamp 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_new,
+ rc_patrolled,
+ rc_type
+ FROM $categorylinks, $recentchanges
+ WHERE rc_timestamp > '{$cutoff}'
+ {$cmq}
+ AND cl_from=rc_cur_id
+ AND cl_to=$catkey
+ GROUP BY rc_cur_id,rc_namespace,rc_title,
+ rc_user,rc_comment,rc_user_text,rc_timestamp,rc_minor,
+ rc_new
+ ORDER BY rc_timestamp DESC
+ LIMIT {$limit};
+ ";
} else {
- $sql = "SELECT page_id,page_namespace,page_title,rev_user,rev_comment," .
- "rev_user_text,rev_timestamp,rev_minor_edit,page_is_new FROM $links, $revision, $page " .
- "WHERE rev_timestamp > '{$cutoff}' {$cmq} AND l_to=page_id AND l_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,inverse_timestamp ORDER BY inverse_timestamp LIMIT {$limit}";
+ $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_new,
+ rc_patrolled,
+ rc_type
+ FROM $pagelinks, $recentchanges
+ WHERE rc_timestamp > '{$cutoff}'
+ {$cmq}
+ AND pl_namespace=rc_namespace
+ AND pl_title=rc_title
+ AND pl_from=$id
+GROUP BY rc_cur_id,rc_namespace,rc_title,
+ rc_user,rc_comment,rc_user_text,rc_timestamp,rc_minor,
+ rc_new
+ORDER BY rc_timestamp DESC
+ LIMIT {$limit}";
}
$res = $dbr->query( $sql, $fname );
$wgOut->addHTML( $note."\n" );
- $list =& new ChangesList( $sk );
+ $list = ChangesList::newFromUser( $wgUser );
$s = $list->beginRecentChangesList();
$count = $dbr->numRows( $res );
$obj = $dbr->fetchObject( $res );
--$count;
- $rc = RecentChange::newFromCurRow( $obj );
+ $rc = RecentChange::newFromRow( $obj );
$rc->counter = $counter++;
$s .= $list->recentChangesLine( $rc );
--$limit;