* Updated the list from version 4.1.8 of MySQL

[lhc/web/wiklou.git] / includes / SpecialRecentchangeslinked.php

diff --git a/includes/SpecialRecentchangeslinked.php b/includes/SpecialRecentchangeslinked.php
index 53bb972..37516fc 100644 (file)
--- a/includes/SpecialRecentchangeslinked.php
+++ b/includes/SpecialRecentchangeslinked.php
@@ -1,10 +1,22 @@
 <?php
-require_once( "SpecialRecentchanges.php" );
+/**
+ * This is to display changes made to all articles linked in an article.
+ * @package MediaWiki
+ * @subpackage 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, $wgTitle, $wgRequest;
+       $fname = 'wfSpecialRecentchangeslinked';
 
        $days = $wgRequest->getInt( 'days' );
        $target = $wgRequest->getText( 'target' );
@@ -16,48 +28,60 @@ function wfSpecialRecentchangeslinked( $par = NULL )
        if( $par ) {
                $target = $par;
        }
-       if ( "" == $target ) {
-               $wgOut->errorpage( "notargettitle", "notargettext" );
+       if ( $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( wfMsg( 'rclsub', $nt->getPrefixedText() ) );
 
        if ( ! $days ) {
-               $days = $wgUser->getOption( "rcdays" );
+               $days = $wgUser->getOption( 'rcdays' );
                if ( ! $days ) { $days = 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 );
+       $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 = ""; }
-
-       $dbr =& wfGetDB( DB_SLAVE );
-       extract( $dbr->tableNames( 'cur', 'links' ) );
+               $cmq = 'AND rev_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=$id " .
-      "GROUP BY cur_id ORDER BY inverse_timestamp LIMIT {$limit}";
+       extract( $dbr->tableNames( 'categorylinks', 'links', '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 ORDER BY rev_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 ORDER BY rev_timestamp DESC LIMIT {$limit}";
+       }
        $res = $dbr->query( $sql, $fname );
 
        $wgOut->addHTML("&lt; ".$sk->makeKnownLinkObj($nt, "", "redirect=no" )."<br />\n");
@@ -68,9 +92,10 @@ function wfSpecialRecentchangeslinked( $par = NULL )
                                  "target=" . $nt->getPrefixedURL() . "&hideminor={$hideminor}",
                                  false, $mlink );
 
-       $wgOut->addHTML( "{$note}\n" );
+       $wgOut->addHTML( $note."\n" );
 
-       $s = $sk->beginRecentChangesList();
+       $list =& new ChangesList( $sk );
+       $s = $list->beginRecentChangesList();
        $count = $dbr->numRows( $res );
        
        $counter = 1;
@@ -81,10 +106,10 @@ function wfSpecialRecentchangeslinked( $par = NULL )
 
                $rc = RecentChange::newFromCurRow( $obj );
                $rc->counter = $counter++;
-               $s .= $sk->recentChangesLine( $rc );
+               $s .= $list->recentChangesLine( $rc );
                --$limit;
        }
-       $s .= $sk->endRecentChangesList();
+       $s .= $list->endRecentChangesList();
 
        $dbr->freeResult( $res );
        $wgOut->addHTML( $s );