Bug 6031 (feature request for __NOGALLERY__ on category pages) fixed
[lhc/web/wiklou.git] / includes / SpecialRecentchangeslinked.php
index 1e7ba21..aab5e49 100644 (file)
@@ -15,27 +15,32 @@ require_once( 'SpecialRecentchanges.php' );
  * @param string $par parent page we will look at
  */
 function wfSpecialRecentchangeslinked( $par = NULL ) {
-       global $wgUser, $wgOut, $wgLang, $wgContLang, $wgTitle, $wgRequest;
+       global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest;
        $fname = 'wfSpecialRecentchangeslinked';
 
        $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 (is_null($target)) {
-               $wgOut->errorpage( 'notargettitle', 'notargettext' );
+       # Validate the title
+       $nt = Title::newFromURL( $target );
+       if( !is_object( $nt ) ) {
+               $wgOut->errorPage( 'notargettitle', 'notargettext' );
                return;
        }
-       $nt = Title::newFromURL( $target );
-       if( !$nt ) {
-               $wgOut->errorpage( 'notargettitle', 'notargettext' );
+       
+       # Check for existence
+       # Do a quiet redirect back to the page itself if it doesn't
+       if( !$nt->exists() ) {
+               $wgOut->redirect( $nt->getLocalUrl() );
                return;
        }
+
        $id = $nt->getArticleId();
-       
+
        $wgOut->setSubtitle( htmlspecialchars( wfMsg( 'rclsub', $nt->getPrefixedText() ) ) );
 
        if ( ! $days ) {
@@ -59,79 +64,102 @@ 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' ) );
-       
+       extract( $dbr->tableNames( 'recentchanges', 'categorylinks', 'pagelinks', 'revision', 'page' , "watchlist" ) );
+
+       $uid = $wgUser->getID();
+
        // 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_id,rev_user,rev_comment,
-         rev_user_text,rev_timestamp,rev_minor_edit,
-         page_is_new
-    FROM $categorylinks, $revision, $page
-   WHERE rev_timestamp > '{$cutoff}' AND page_touched > '{$cutoff}'
-         {$cmq}
-     AND rev_page=page_id
-     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}";
+               $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
+" . ($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
+       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 /* 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_new,
+                       rc_patrolled,
+                       rc_type
+" . ($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
+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("&lt; ".$sk->makeKnownLinkObj($nt, "", "redirect=no" )."<br />\n");
-       $note = wfMsg( "rcnote", $limit, $days );
+       $note = wfMsg( "rcnote", $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 );
+                                "target=" . $nt->getPrefixedURL() . "&hideminor={$hideminor}",
+                                false, $mlink );
 
        $wgOut->addHTML( $note."\n" );
 
        $list = ChangesList::newFromUser( $wgUser );
        $s = $list->beginRecentChangesList();
        $count = $dbr->numRows( $res );
-       
+
        $counter = 1;
        while ( $limit ) {
                if ( 0 == $count ) { break; }
                $obj = $dbr->fetchObject( $res );
                --$count;
+#              print_r ( $obj ) ;
+#              print "<br/>\n" ;
 
-               $rc = RecentChange::newFromCurRow( $obj );
+               $rc = RecentChange::newFromRow( $obj );
                $rc->counter = $counter++;
-               $s .= $list->recentChangesLine( $rc );
+               $s .= $list->recentChangesLine( $rc , !empty( $obj->wl_user) );
                --$limit;
        }
        $s .= $list->endRecentChangesList();