includes/specials/SpecialContributions.php

   1 <?php
   2 /**
   3  * Implements Special:Contributions
   4  *
   5  * This program is free software; you can redistribute it and/or modify
   6  * it under the terms of the GNU General Public License as published by
   7  * the Free Software Foundation; either version 2 of the License, or
   8  * (at your option) any later version.
   9  *
  10  * This program is distributed in the hope that it will be useful,
  11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  13  * GNU General Public License for more details.
  14  *
  15  * You should have received a copy of the GNU General Public License along
  16  * with this program; if not, write to the Free Software Foundation, Inc.,
  17  * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
  18  * http://www.gnu.org/copyleft/gpl.html
  19  *
  20  * @file
  21  * @ingroup SpecialPage
  22  */
  23
  24 /**
  25  * Special:Contributions, show user contributions in a paged list
  26  *
  27  * @ingroup SpecialPage
  28  */
  29
  30 class SpecialContributions extends SpecialPage {
  31
  32         protected $opts;
  33
  34         public function __construct() {
  35                 parent::__construct( 'Contributions' );
  36         }
  37
  38         public function execute( $par ) {
  39                 $this->setHeaders();
  40                 $this->outputHeader();
  41                 $out = $this->getOutput();
  42                 $out->addModuleStyles( 'mediawiki.special' );
  43
  44                 $this->opts = array();
  45                 $request = $this->getRequest();
  46
  47                 if ( $par !== null ) {
  48                         $target = $par;
  49                 } else {
  50                         $target = $request->getVal( 'target' );
  51                 }
  52
  53                 // check for radiobox
  54                 if ( $request->getVal( 'contribs' ) == 'newbie' ) {
  55                         $target = 'newbies';
  56                         $this->opts['contribs'] = 'newbie';
  57                 } else {
  58                         $this->opts['contribs'] = 'user';
  59                 }
  60
  61                 $this->opts['deletedOnly'] = $request->getBool( 'deletedOnly' );
  62
  63                 if ( !strlen( $target ) ) {
  64                         $out->addHTML( $this->getForm() );
  65                         return;
  66                 }
  67
  68                 $user = $this->getUser();
  69
  70                 $this->opts['limit'] = $request->getInt( 'limit', $user->getOption( 'rclimit' ) );
  71                 $this->opts['target'] = $target;
  72                 $this->opts['topOnly'] = $request->getBool( 'topOnly' );
  73
  74                 $userObj = User::newFromName( $target, false );
  75                 if ( !$userObj ) {
  76                         $out->addHTML( $this->getForm() );
  77                         return;
  78                 }
  79                 $nt = $userObj->getUserPage();
  80                 $id = $userObj->getID();
  81
  82                 if ( $this->opts['contribs'] != 'newbie' ) {
  83                         $target = $nt->getText();
  84                         $out->addSubtitle( $this->contributionsSub( $userObj ) );
  85                         $out->setHTMLTitle( $this->msg( 'pagetitle', $this->msg( 'contributions-title', $target )->plain() ) );
  86                         $this->getSkin()->setRelevantUser( $userObj );
  87                 } else {
  88                         $out->addSubtitle( $this->msg( 'sp-contributions-newbies-sub' ) );
  89                         $out->setHTMLTitle( $this->msg( 'pagetitle', $this->msg( 'sp-contributions-newbies-title' )->plain() ) );
  90                 }
  91
  92                 if ( ( $ns = $request->getVal( 'namespace', null ) ) !== null && $ns !== '' ) {
  93                         $this->opts['namespace'] = intval( $ns );
  94                 } else {
  95                         $this->opts['namespace'] = '';
  96                 }
  97
  98                 $this->opts['associated'] = $request->getBool( 'associated' );
  99
 100                 $this->opts['nsInvert'] = (bool) $request->getVal( 'nsInvert' );
 101
 102                 $this->opts['tagfilter'] = (string) $request->getVal( 'tagfilter' );
 103
 104                 // Allows reverts to have the bot flag in recent changes. It is just here to
 105                 // be passed in the form at the top of the page
 106                 if ( $user->isAllowed( 'markbotedits' ) && $request->getBool( 'bot' ) ) {
 107                         $this->opts['bot'] = '1';
 108                 }
 109
 110                 $skip = $request->getText( 'offset' ) || $request->getText( 'dir' ) == 'prev';
 111                 # Offset overrides year/month selection
 112                 if ( $skip ) {
 113                         $this->opts['year'] = '';
 114                         $this->opts['month'] = '';
 115                 } else {
 116                         $this->opts['year'] = $request->getIntOrNull( 'year' );
 117                         $this->opts['month'] = $request->getIntOrNull( 'month' );
 118                 }
 119
 120                 $feedType = $request->getVal( 'feed' );
 121                 if ( $feedType ) {
 122                         // Maintain some level of backwards compatability
 123                         // If people request feeds using the old parameters, redirect to API
 124                         $apiParams = array(
 125                                 'action' => 'feedcontributions',
 126                                 'feedformat' => $feedType,
 127                                 'user' => $target,
 128                         );
 129                         if ( $this->opts['topOnly'] ) {
 130                                 $apiParams['toponly'] = true;
 131                         }
 132                         if ( $this->opts['deletedOnly'] ) {
 133                                 $apiParams['deletedonly'] = true;
 134                         }
 135                         if ( $this->opts['tagfilter'] !== '' ) {
 136                                 $apiParams['tagfilter'] = $this->opts['tagfilter'];
 137                         }
 138                         if ( $this->opts['namespace'] !== '' ) {
 139                                 $apiParams['namespace'] = $this->opts['namespace'];
 140                         }
 141                         if ( $this->opts['year'] !== null ) {
 142                                 $apiParams['year'] = $this->opts['year'];
 143                         }
 144                         if ( $this->opts['month'] !== null ) {
 145                                 $apiParams['month'] = $this->opts['month'];
 146                         }
 147
 148                         $url = wfScript( 'api' ) . '?' . wfArrayToCGI( $apiParams );
 149
 150                         $out->redirect( $url, '301' );
 151                         return;
 152                 }
 153
 154                 // Add RSS/atom links
 155                 $this->addFeedLinks( array( 'action' => 'feedcontributions', 'user' => $target ) );
 156
 157                 if ( wfRunHooks( 'SpecialContributionsBeforeMainOutput', array( $id ) ) ) {
 158
 159                         $out->addHTML( $this->getForm() );
 160
 161                         $pager = new ContribsPager( $this->getContext(), array(
 162                                 'target' => $target,
 163                                 'contribs' => $this->opts['contribs'],
 164                                 'namespace' => $this->opts['namespace'],
 165                                 'year' => $this->opts['year'],
 166                                 'month' => $this->opts['month'],
 167                                 'deletedOnly' => $this->opts['deletedOnly'],
 168                                 'topOnly' => $this->opts['topOnly'],
 169                                 'nsInvert' => $this->opts['nsInvert'],
 170                                 'associated' => $this->opts['associated'],
 171                         ) );
 172                         if ( !$pager->getNumRows() ) {
 173                                 $out->addWikiMsg( 'nocontribs', $target );
 174                         } else {
 175                                 # Show a message about slave lag, if applicable
 176                                 $lag = wfGetLB()->safeGetLag( $pager->getDatabase() );
 177                                 if ( $lag > 0 )
 178                                         $out->showLagWarning( $lag );
 179
 180                                 $out->addHTML(
 181                                         '<p>' . $pager->getNavigationBar() . '</p>' .
 182                                         $pager->getBody() .
 183                                         '<p>' . $pager->getNavigationBar() . '</p>'
 184                                 );
 185                         }
 186                         $out->preventClickjacking( $pager->getPreventClickjacking() );
 187
 188                         # Show the appropriate "footer" message - WHOIS tools, etc.
 189                         if ( $this->opts['contribs'] != 'newbie' ) {
 190                                 $message = 'sp-contributions-footer';
 191                                 if ( IP::isIPAddress( $target ) ) {
 192                                         $message = 'sp-contributions-footer-anon';
 193                                 } else {
 194                                         if ( $userObj->isAnon() ) {
 195                                                 // No message for non-existing users
 196                                                 return;
 197                                         }
 198                                 }
 199
 200                                 if ( !$this->msg( $message, $target )->isDisabled() ) {
 201                                         $out->wrapWikiMsg(
 202                                                 "<div class='mw-contributions-footer'>\n$1\n</div>",
 203                                                 array( $message, $target ) );
 204                                 }
 205                         }
 206                 }
 207         }
 208
 209         /**
 210          * Generates the subheading with links
 211          * @param $userObj User object for the target
 212          * @return String: appropriately-escaped HTML to be output literally
 213          * @todo FIXME: Almost the same as getSubTitle in SpecialDeletedContributions.php. Could be combined.
 214          */
 215         protected function contributionsSub( $userObj ) {
 216                 if ( $userObj->isAnon() ) {
 217                         $user = htmlspecialchars( $userObj->getName() );
 218                 } else {
 219                         $user = Linker::link( $userObj->getUserPage(), htmlspecialchars( $userObj->getName() ) );
 220                 }
 221                 $nt = $userObj->getUserPage();
 222                 $talk = $userObj->getTalkPage();
 223                 if ( $talk ) {
 224                         $tools = $this->getUserLinks( $nt, $talk, $userObj );
 225                         $links = $this->getLanguage()->pipeList( $tools );
 226
 227                         // Show a note if the user is blocked and display the last block log entry.
 228                         if ( $userObj->isBlocked() ) {
 229                                 $out = $this->getOutput(); // showLogExtract() wants first parameter by reference
 230                                 LogEventsList::showLogExtract(
 231                                         $out,
 232                                         'block',
 233                                         $nt,
 234                                         '',
 235                                         array(
 236                                                 'lim' => 1,
 237                                                 'showIfEmpty' => false,
 238                                                 'msgKey' => array(
 239                                                         $userObj->isAnon() ?
 240                                                                 'sp-contributions-blocked-notice-anon' :
 241                                                                 'sp-contributions-blocked-notice',
 242                                                         $userObj->getName() # Support GENDER in 'sp-contributions-blocked-notice'
 243                                                 ),
 244                                                 'offset' => '' # don't use WebRequest parameter offset
 245                                         )
 246                                 );
 247                         }
 248                 }
 249
 250                 // Old message 'contribsub' had one parameter, but that doesn't work for
 251                 // languages that want to put the "for" bit right after $user but before
 252                 // $links.  If 'contribsub' is around, use it for reverse compatibility,
 253                 // otherwise use 'contribsub2'.
 254                 // @todo Should this be removed at some point?
 255                 $oldMsg = $this->msg( 'contribsub' );
 256                 if ( $oldMsg->exists() ) {
 257                         $linksWithParentheses = $this->msg( 'parentheses' )->rawParams( $links )->escaped();
 258                         return $oldMsg->rawParams( "$user $linksWithParentheses" );
 259                 } else {
 260                         return $this->msg( 'contribsub2' )->rawParams( $user, $links );
 261                 }
 262         }
 263
 264         /**
 265          * Links to different places.
 266          * @param $userpage Title: Target user page
 267          * @param $talkpage Title: Talk page
 268          * @param $target User: Target user object
 269          * @return array
 270          */
 271         public function getUserLinks( Title $userpage, Title $talkpage, User $target ) {
 272
 273                 $id = $target->getId();
 274                 $username = $target->getName();
 275
 276                 $tools[] = Linker::link( $talkpage, $this->msg( 'sp-contributions-talk' )->escaped() );
 277
 278                 if ( ( $id !== null ) || ( $id === null && IP::isIPAddress( $username ) ) ) {
 279                         if ( $this->getUser()->isAllowed( 'block' ) ) { # Block / Change block / Unblock links
 280                                 if ( $target->isBlocked() ) {
 281                                         $tools[] = Linker::linkKnown( # Change block link
 282                                                 SpecialPage::getTitleFor( 'Block', $username ),
 283                                                 $this->msg( 'change-blocklink' )->escaped()
 284                                         );
 285                                         $tools[] = Linker::linkKnown( # Unblock link
 286                                                 SpecialPage::getTitleFor( 'Unblock', $username ),
 287                                                 $this->msg( 'unblocklink' )->escaped()
 288                                         );
 289                                 } else { # User is not blocked
 290                                         $tools[] = Linker::linkKnown( # Block link
 291                                                 SpecialPage::getTitleFor( 'Block', $username ),
 292                                                 $this->msg( 'blocklink' )->escaped()
 293                                         );
 294                                 }
 295                         }
 296                         # Block log link
 297                         $tools[] = Linker::linkKnown(
 298                                 SpecialPage::getTitleFor( 'Log', 'block' ),
 299                                 $this->msg( 'sp-contributions-blocklog' )->escaped(),
 300                                 array(),
 301                                 array(
 302                                         'page' => $userpage->getPrefixedText()
 303                                 )
 304                         );
 305                 }
 306                 # Uploads
 307                 $tools[] = Linker::linkKnown(
 308                         SpecialPage::getTitleFor( 'Listfiles', $username ),
 309                         $this->msg( 'sp-contributions-uploads' )->escaped()
 310                 );
 311
 312                 # Other logs link
 313                 $tools[] = Linker::linkKnown(
 314                         SpecialPage::getTitleFor( 'Log', $username ),
 315                         $this->msg( 'sp-contributions-logs' )->escaped()
 316                 );
 317
 318                 # Add link to deleted user contributions for priviledged users
 319                 if ( $this->getUser()->isAllowed( 'deletedhistory' ) ) {
 320                         $tools[] = Linker::linkKnown(
 321                                 SpecialPage::getTitleFor( 'DeletedContributions', $username ),
 322                                 $this->msg( 'sp-contributions-deleted' )->escaped()
 323                         );
 324                 }
 325
 326                 # Add a link to change user rights for privileged users
 327                 $userrightsPage = new UserrightsPage();
 328                 $userrightsPage->setContext( $this->getContext() );
 329                 if ( $id !== null && $userrightsPage->userCanChangeRights( $target ) ) {
 330                         $tools[] = Linker::linkKnown(
 331                                 SpecialPage::getTitleFor( 'Userrights', $username ),
 332                                 $this->msg( 'sp-contributions-userrights' )->escaped()
 333                         );
 334                 }
 335
 336                 wfRunHooks( 'ContributionsToolLinks', array( $id, $userpage, &$tools ) );
 337                 return $tools;
 338         }
 339
 340         /**
 341          * Generates the namespace selector form with hidden attributes.
 342          * @return String: HTML fragment
 343          */
 344         protected function getForm() {
 345                 global $wgScript;
 346
 347                 $this->opts['title'] = $this->getTitle()->getPrefixedText();
 348                 if ( !isset( $this->opts['target'] ) ) {
 349                         $this->opts['target'] = '';
 350                 } else {
 351                         $this->opts['target'] = str_replace( '_' , ' ' , $this->opts['target'] );
 352                 }
 353
 354                 if ( !isset( $this->opts['namespace'] ) ) {
 355                         $this->opts['namespace'] = '';
 356                 }
 357
 358                 if ( !isset( $this->opts['nsInvert'] ) ) {
 359                         $this->opts['nsInvert'] = '';
 360                 }
 361
 362                 if ( !isset( $this->opts['associated'] ) ) {
 363                         $this->opts['associated'] = false;
 364                 }
 365
 366                 if ( !isset( $this->opts['contribs'] ) ) {
 367                         $this->opts['contribs'] = 'user';
 368                 }
 369
 370                 if ( !isset( $this->opts['year'] ) ) {
 371                         $this->opts['year'] = '';
 372                 }
 373
 374                 if ( !isset( $this->opts['month'] ) ) {
 375                         $this->opts['month'] = '';
 376                 }
 377
 378                 if ( $this->opts['contribs'] == 'newbie' ) {
 379                         $this->opts['target'] = '';
 380                 }
 381
 382                 if ( !isset( $this->opts['tagfilter'] ) ) {
 383                         $this->opts['tagfilter'] = '';
 384                 }
 385
 386                 if ( !isset( $this->opts['topOnly'] ) ) {
 387                         $this->opts['topOnly'] = false;
 388                 }
 389
 390                 $form = Xml::openElement( 'form', array( 'method' => 'get', 'action' => $wgScript, 'class' => 'mw-contributions-form' ) );
 391
 392                 # Add hidden params for tracking except for parameters in $skipParameters
 393                 $skipParameters = array( 'namespace', 'nsInvert', 'deletedOnly', 'target', 'contribs', 'year', 'month', 'topOnly', 'associated' );
 394                 foreach ( $this->opts as $name => $value ) {
 395                         if ( in_array( $name, $skipParameters ) ) {
 396                                 continue;
 397                         }
 398                         $form .= "\t" . Html::hidden( $name, $value ) . "\n";
 399                 }
 400
 401                 $tagFilter = ChangeTags::buildTagFilterSelector( $this->opts['tagfilter'] );
 402
 403                 if ( $tagFilter ) {
 404                         $filterSelection =
 405                                 Xml::tags( 'td', array( 'class' => 'mw-label' ), array_shift( $tagFilter ) ) .
 406                                 Xml::tags( 'td', array( 'class' => 'mw-input' ), implode( '&#160', $tagFilter ) );
 407                 } else {
 408                         $filterSelection = Xml::tags( 'td', array( 'colspan' => 2 ), '' );
 409                 }
 410
 411                 $targetSelection = Xml::tags( 'td', array( 'colspan' => 2 ),
 412                         Xml::radioLabel(
 413                                 $this->msg( 'sp-contributions-newbies' )->text(),
 414                                 'contribs',
 415                                 'newbie' ,
 416                                 'newbie',
 417                                 $this->opts['contribs'] == 'newbie',
 418                                 array( 'class' => 'mw-input' )
 419                         ) . '<br />' .
 420                         Xml::radioLabel(
 421                                 $this->msg( 'sp-contributions-username' )->text(),
 422                                 'contribs',
 423                                 'user',
 424                                 'user',
 425                                 $this->opts['contribs'] == 'user',
 426                                 array( 'class' => 'mw-input' )
 427                         ) . ' ' .
 428                         Html::input(
 429                                 'target',
 430                                 $this->opts['target'],
 431                                 'text',
 432                                 array( 'size' => '20', 'required' => '', 'class' => 'mw-input' ) +
 433                                         ( $this->opts['target'] ? array() : array( 'autofocus' )
 434                                 )
 435                         ) . ' '
 436                 ) ;
 437
 438                 $namespaceSelection =
 439                         Xml::tags( 'td', array( 'class' => 'mw-label' ),
 440                                 Xml::label(
 441                                         $this->msg( 'namespace' )->text(),
 442                                         'namespace',
 443                                         ''
 444                                 )
 445                         ) .
 446                         Xml::tags( 'td', null,
 447                                 Html::namespaceSelector( array(
 448                                         'selected' => $this->opts['namespace'],
 449                                         'all'      => '',
 450                                         'label'    => null,
 451                                 ), array(
 452                                         'name'  => 'namespace',
 453                                         'id'    => 'namespace',
 454                                         'class' => 'namespaceselector',
 455                                 ) ) .
 456                                 '&#160;' .
 457                                 Html::rawElement( 'span', array( 'style' => 'white-space: nowrap' ),
 458                                         Xml::checkLabel(
 459                                                 $this->msg( 'invert' )->text(),
 460                                                 'nsInvert',
 461                                                 'nsInvert',
 462                                                 $this->opts['nsInvert'],
 463                                                 array( 'title' => $this->msg( 'tooltip-invert' )->text(), 'class' => 'mw-input' )
 464                                         ) . '&#160;'
 465                                 ) .
 466                                 Html::rawElement( 'span', array( 'style' => 'white-space: nowrap' ),
 467                                         Xml::checkLabel(
 468                                                 $this->msg( 'namespace_association' )->text(),
 469                                                 'associated',
 470                                                 'associated',
 471                                                 $this->opts['associated'],
 472                                                 array( 'title' => $this->msg( 'tooltip-namespace_association' )->text(), 'class' => 'mw-input' )
 473                                         ) . '&#160;'
 474                                 )
 475                         ) ;
 476
 477                 $extraOptions = Xml::tags( 'td', array( 'colspan' => 2 ),
 478                         Html::rawElement( 'span', array( 'style' => 'white-space: nowrap' ),
 479                                 Xml::checkLabel(
 480                                         $this->msg( 'history-show-deleted' )->text(),
 481                                         'deletedOnly',
 482                                         'mw-show-deleted-only',
 483                                         $this->opts['deletedOnly'],
 484                                         array( 'class' => 'mw-input' )
 485                                 )
 486                         ) .
 487                         Html::rawElement( 'span', array( 'style' => 'white-space: nowrap' ),
 488                                 Xml::checkLabel(
 489                                         $this->msg( 'sp-contributions-toponly' )->text(),
 490                                         'topOnly',
 491                                         'mw-show-top-only',
 492                                         $this->opts['topOnly'],
 493                                         array( 'class' => 'mw-input' )
 494                                 )
 495                         )
 496                 ) ;
 497
 498                 $dateSelectionAndSubmit = Xml::tags( 'td', array( 'colspan' => 2 ),
 499                         Xml::dateMenu(
 500                                 $this->opts['year'],
 501                                 $this->opts['month']
 502                         ) . ' ' .
 503                         Xml::submitButton(
 504                                 $this->msg( 'sp-contributions-submit' )->text(),
 505                                 array( 'class' => 'mw-submit' )
 506                         )
 507                 ) ;
 508
 509                 $form .=
 510                         Xml::fieldset( $this->msg( 'sp-contributions-search' )->text() ) .
 511                         Xml::openElement( 'table', array( 'class' => 'mw-contributions-table' ) ) .
 512                                 Xml::openElement( 'tr' ) .
 513                                         $targetSelection .
 514                                 Xml::closeElement( 'tr' ) .
 515                                 Xml::openElement( 'tr' ) .
 516                                         $namespaceSelection .
 517                                 Xml::closeElement( 'tr' ) .
 518                                 Xml::openElement( 'tr' ) .
 519                                         $filterSelection .
 520                                 Xml::closeElement( 'tr' ) .
 521                                 Xml::openElement( 'tr' ) .
 522                                         $extraOptions .
 523                                 Xml::closeElement( 'tr' ) .
 524                                 Xml::openElement( 'tr' ) .
 525                                         $dateSelectionAndSubmit .
 526                                 Xml::closeElement( 'tr' ) .
 527                         Xml::closeElement( 'table' );
 528
 529                 $explain = $this->msg( 'sp-contributions-explain' );
 530                 if ( $explain->exists() ) {
 531                         $form .= "<p id='mw-sp-contributions-explain'>{$explain}</p>";
 532                 }
 533                 $form .= Xml::closeElement( 'fieldset' ) .
 534                         Xml::closeElement( 'form' );
 535                 return $form;
 536         }
 537 }
 538
 539 /**
 540  * Pager for Special:Contributions
 541  * @ingroup SpecialPage Pager
 542  */
 543 class ContribsPager extends ReverseChronologicalPager {
 544         public $mDefaultDirection = true;
 545         var $messages, $target;
 546         var $namespace = '', $mDb;
 547         var $preventClickjacking = false;
 548
 549         function __construct( IContextSource $context, array $options ) {
 550                 parent::__construct( $context );
 551
 552                 $msgs = array( 'uctop', 'diff', 'newarticle', 'rollbacklink', 'diff', 'hist', 'rev-delundel', 'pipe-separator' );
 553
 554                 foreach ( $msgs as $msg ) {
 555                         $this->messages[$msg] = $this->msg( $msg )->escaped();
 556                 }
 557
 558                 $this->target = isset( $options['target'] ) ? $options['target'] : '';
 559                 $this->contribs = isset( $options['contribs'] ) ? $options['contribs'] : 'users';
 560                 $this->namespace = isset( $options['namespace'] ) ? $options['namespace'] : '';
 561                 $this->tagFilter = isset( $options['tagfilter'] ) ? $options['tagfilter'] : false;
 562                 $this->nsInvert = isset( $options['nsInvert'] ) ? $options['nsInvert'] : false;
 563                 $this->associated = isset( $options['associated'] ) ? $options['associated'] : false;
 564
 565                 $this->deletedOnly = !empty( $options['deletedOnly'] );
 566                 $this->topOnly = !empty( $options['topOnly'] );
 567
 568                 $year = isset( $options['year'] ) ? $options['year'] : false;
 569                 $month = isset( $options['month'] ) ? $options['month'] : false;
 570                 $this->getDateCond( $year, $month );
 571
 572                 $this->mDb = wfGetDB( DB_SLAVE, 'contributions' );
 573         }
 574
 575         function getDefaultQuery() {
 576                 $query = parent::getDefaultQuery();
 577                 $query['target'] = $this->target;
 578                 return $query;
 579         }
 580
 581         function getQueryInfo() {
 582                 list( $tables, $index, $userCond, $join_cond ) = $this->getUserCond();
 583
 584                 $user = $this->getUser();
 585                 $conds = array_merge( $userCond, $this->getNamespaceCond() );
 586
 587                 // Paranoia: avoid brute force searches (bug 17342)
 588                 if ( !$user->isAllowed( 'deletedhistory' ) ) {
 589                         $conds[] = $this->mDb->bitAnd( 'rev_deleted', Revision::DELETED_USER ) . ' = 0';
 590                 } elseif ( !$user->isAllowed( 'suppressrevision' ) ) {
 591                         $conds[] = $this->mDb->bitAnd( 'rev_deleted', Revision::SUPPRESSED_USER ) .
 592                                 ' != ' . Revision::SUPPRESSED_USER;
 593                 }
 594
 595                 # Don't include orphaned revisions
 596                 $join_cond['page'] = Revision::pageJoinCond();
 597                 # Get the current user name for accounts
 598                 $join_cond['user'] = Revision::userJoinCond();
 599
 600                 $queryInfo = array(
 601                         'tables'     => $tables,
 602                         'fields'     => array_merge(
 603                                 Revision::selectFields(),
 604                                 Revision::selectUserFields(),
 605                                 array( 'page_namespace', 'page_title', 'page_is_new',
 606                                         'page_latest', 'page_is_redirect', 'page_len' )
 607                         ),
 608                         'conds'      => $conds,
 609                         'options'    => array( 'USE INDEX' => array( 'revision' => $index ) ),
 610                         'join_conds' => $join_cond
 611                 );
 612
 613                 ChangeTags::modifyDisplayQuery(
 614                         $queryInfo['tables'],
 615                         $queryInfo['fields'],
 616                         $queryInfo['conds'],
 617                         $queryInfo['join_conds'],
 618                         $queryInfo['options'],
 619                         $this->tagFilter
 620                 );
 621
 622                 wfRunHooks( 'ContribsPager::getQueryInfo', array( &$this, &$queryInfo ) );
 623                 return $queryInfo;
 624         }
 625
 626         function getUserCond() {
 627                 $condition = array();
 628                 $join_conds = array();
 629                 $tables = array( 'revision', 'page', 'user' );
 630                 if ( $this->contribs == 'newbie' ) {
 631                         $tables[] = 'user_groups';
 632                         $max = $this->mDb->selectField( 'user', 'max(user_id)', false, __METHOD__ );
 633                         $condition[] = 'rev_user >' . (int)( $max - $max / 100 );
 634                         $condition[] = 'ug_group IS NULL';
 635                         $index = 'user_timestamp';
 636                         # @todo FIXME: Other groups may have 'bot' rights
 637                         $join_conds['user_groups'] = array( 'LEFT JOIN', "ug_user = rev_user AND ug_group = 'bot'" );
 638                 } else {
 639                         $uid = User::idFromName( $this->target );
 640                         if ( $uid ) {
 641                                 $condition['rev_user'] = $uid;
 642                                 $index = 'user_timestamp';
 643                         } else {
 644                                 $condition['rev_user_text'] = $this->target;
 645                                 $index = 'usertext_timestamp';
 646                         }
 647                 }
 648                 if ( $this->deletedOnly ) {
 649                         $condition[] = "rev_deleted != '0'";
 650                 }
 651                 if ( $this->topOnly ) {
 652                         $condition[] = "rev_id = page_latest";
 653                 }
 654                 return array( $tables, $index, $condition, $join_conds );
 655         }
 656
 657         function getNamespaceCond() {
 658                 if ( $this->namespace !== '' ) {
 659                         $selectedNS = $this->mDb->addQuotes( $this->namespace );
 660                         $eq_op = $this->nsInvert ? '!=' : '=';
 661                         $bool_op = $this->nsInvert ? 'AND' : 'OR';
 662
 663                         if ( !$this->associated ) {
 664                                 return array( "page_namespace $eq_op $selectedNS" );
 665                         } else {
 666                                 $associatedNS = $this->mDb->addQuotes (
 667                                         MWNamespace::getAssociated( $this->namespace )
 668                                 );
 669                                 return array(
 670                                         "page_namespace $eq_op $selectedNS " .
 671                                         $bool_op .
 672                                         " page_namespace $eq_op $associatedNS"
 673                                 );
 674                         }
 675
 676                 } else {
 677                         return array();
 678                 }
 679         }
 680
 681         function getIndexField() {
 682                 return 'rev_timestamp';
 683         }
 684
 685         function doBatchLookups() {
 686                 $this->mResult->rewind();
 687                 $revIds = array();
 688                 foreach ( $this->mResult as $row ) {
 689                         if( $row->rev_parent_id ) {
 690                                 $revIds[] = $row->rev_parent_id;
 691                         }
 692                 }
 693                 $this->mParentLens = $this->getParentLengths( $revIds );
 694                 $this->mResult->rewind(); // reset
 695
 696                 # Do a link batch query
 697                 $this->mResult->seek( 0 );
 698                 $batch = new LinkBatch();
 699                 # Give some pointers to make (last) links
 700                 foreach ( $this->mResult as $row ) {
 701                         if ( $this->contribs === 'newbie' ) { // multiple users
 702                                 $batch->add( NS_USER, $row->user_name );
 703                                 $batch->add( NS_USER_TALK, $row->user_name );
 704                         }
 705                         $batch->add( $row->page_namespace, $row->page_title );
 706                 }
 707                 $batch->execute();
 708                 $this->mResult->seek( 0 );
 709         }
 710
 711         /**
 712          * Do a batched query to get the parent revision lengths
 713          * @return array
 714          */
 715         private function getParentLengths( array $revIds ) {
 716                 $revLens = array();
 717                 if ( !$revIds ) {
 718                         return $revLens; // empty
 719                 }
 720                 wfProfileIn( __METHOD__ );
 721                 $res = $this->getDatabase()->select( 'revision',
 722                         array( 'rev_id', 'rev_len' ),
 723                         array( 'rev_id' => $revIds ),
 724                         __METHOD__ );
 725                 foreach ( $res as $row ) {
 726                         $revLens[$row->rev_id] = $row->rev_len;
 727                 }
 728                 wfProfileOut( __METHOD__ );
 729                 return $revLens;
 730         }
 731
 732         /**
 733          * @return string
 734          */
 735         function getStartBody() {
 736                 return "<ul>\n";
 737         }
 738
 739         /**
 740          * @return string
 741          */
 742         function getEndBody() {
 743                 return "</ul>\n";
 744         }
 745
 746         /**
 747          * Generates each row in the contributions list.
 748          *
 749          * Contributions which are marked "top" are currently on top of the history.
 750          * For these contributions, a [rollback] link is shown for users with roll-
 751          * back privileges. The rollback link restores the most recent version that
 752          * was not written by the target user.
 753          *
 754          * @todo This would probably look a lot nicer in a table.
 755          * @return string
 756          */
 757         function formatRow( $row ) {
 758                 wfProfileIn( __METHOD__ );
 759
 760                 $rev = new Revision( $row );
 761                 $classes = array();
 762
 763                 $page = Title::newFromRow( $row );
 764                 $link = Linker::link(
 765                         $page,
 766                         htmlspecialchars( $page->getPrefixedText() ),
 767                         array(),
 768                         $page->isRedirect() ? array( 'redirect' => 'no' ) : array()
 769                 );
 770                 # Mark current revisions
 771                 $topmarktext = '';
 772                 if ( $row->rev_id == $row->page_latest ) {
 773                         $topmarktext .= '<span class="mw-uctop">' . $this->messages['uctop'] . '</span>';
 774                         # Add rollback link
 775                         if ( !$row->page_is_new && $page->quickUserCan( 'rollback' )
 776                                 && $page->quickUserCan( 'edit' ) )
 777                         {
 778                                 $this->preventClickjacking();
 779                                 $topmarktext .= ' ' . Linker::generateRollback( $rev );
 780                         }
 781                 }
 782                 $user = $this->getUser();
 783                 # Is there a visible previous revision?
 784                 if ( $rev->userCan( Revision::DELETED_TEXT, $user ) && $rev->getParentId() !== 0 ) {
 785                         $difftext = Linker::linkKnown(
 786                                 $page,
 787                                 $this->messages['diff'],
 788                                 array(),
 789                                 array(
 790                                         'diff' => 'prev',
 791                                         'oldid' => $row->rev_id
 792                                 )
 793                         );
 794                 } else {
 795                         $difftext = $this->messages['diff'];
 796                 }
 797                 $histlink = Linker::linkKnown(
 798                         $page,
 799                         $this->messages['hist'],
 800                         array(),
 801                         array( 'action' => 'history' )
 802                 );
 803
 804                 if ( $row->rev_parent_id === null ) {
 805                         // For some reason rev_parent_id isn't populated for this row.
 806                         // Its rumoured this is true on wikipedia for some revisions (bug 34922).
 807                         // Next best thing is to have the total number of bytes.
 808                         $chardiff = ' . . ' . Linker::formatRevisionSize( $row->rev_len ) . ' . . ';
 809                 } else {
 810                         $parentLen = isset( $this->mParentLens[$row->rev_parent_id] ) ? $this->mParentLens[$row->rev_parent_id] : 0;
 811                         $chardiff = ' . . ' . ChangesList::showCharacterDifference(
 812                                         $parentLen, $row->rev_len ) . ' . . ';
 813                 }
 814
 815                 $lang = $this->getLanguage();
 816                 $comment = $lang->getDirMark() . Linker::revComment( $rev, false, true );
 817                 $date = $lang->userTimeAndDate( $row->rev_timestamp, $user );
 818                 if ( $rev->userCan( Revision::DELETED_TEXT, $user ) ) {
 819                         $d = Linker::linkKnown(
 820                                 $page,
 821                                 htmlspecialchars( $date ),
 822                                 array(),
 823                                 array( 'oldid' => intval( $row->rev_id ) )
 824                         );
 825                 } else {
 826                         $d = htmlspecialchars( $date );
 827                 }
 828                 if ( $rev->isDeleted( Revision::DELETED_TEXT ) ) {
 829                         $d = '<span class="history-deleted">' . $d . '</span>';
 830                 }
 831
 832                 # Show user names for /newbies as there may be different users.
 833                 # Note that we already excluded rows with hidden user names.
 834                 if ( $this->contribs == 'newbie' ) {
 835                         $userlink = ' . . ' . Linker::userLink( $rev->getUser(), $rev->getUserText() );
 836                         $userlink .= ' ' . $this->msg( 'parentheses' )->rawParams(
 837                                 Linker::userTalkLink( $rev->getUser(), $rev->getUserText() ) )->escaped() . ' ';
 838                 } else {
 839                         $userlink = '';
 840                 }
 841
 842                 if ( $rev->getParentId() === 0 ) {
 843                         $nflag = ChangesList::flag( 'newpage' );
 844                 } else {
 845                         $nflag = '';
 846                 }
 847
 848                 if ( $rev->isMinor() ) {
 849                         $mflag = ChangesList::flag( 'minor' );
 850                 } else {
 851                         $mflag = '';
 852                 }
 853
 854                 $del = Linker::getRevDeleteLink( $user, $rev, $page );
 855                 if ( $del !== '' ) {
 856                         $del .= ' ';
 857                 }
 858
 859                 $diffHistLinks = $this->msg( 'parentheses' )->rawParams( $difftext . $this->messages['pipe-separator'] . $histlink )->escaped();
 860                 $ret = "{$del}{$d} {$diffHistLinks}{$chardiff}{$nflag}{$mflag} {$link}{$userlink} {$comment} {$topmarktext}";
 861
 862                 # Denote if username is redacted for this edit
 863                 if ( $rev->isDeleted( Revision::DELETED_USER ) ) {
 864                         $ret .= " <strong>" . $this->msg( 'rev-deleted-user-contribs' )->escaped() . "</strong>";
 865                 }
 866
 867                 # Tags, if any.
 868                 list( $tagSummary, $newClasses ) = ChangeTags::formatSummaryRow( $row->ts_tags, 'contributions' );
 869                 $classes = array_merge( $classes, $newClasses );
 870                 $ret .= " $tagSummary";
 871
 872                 // Let extensions add data
 873                 wfRunHooks( 'ContributionsLineEnding', array( &$this, &$ret, $row ) );
 874
 875                 $classes = implode( ' ', $classes );
 876                 $ret = "<li class=\"$classes\">$ret</li>\n";
 877                 wfProfileOut( __METHOD__ );
 878                 return $ret;
 879         }
 880
 881         /**
 882          * Get the Database object in use
 883          *
 884          * @return DatabaseBase
 885          */
 886         public function getDatabase() {
 887                 return $this->mDb;
 888         }
 889
 890         /**
 891          * Overwrite Pager function and return a helpful comment
 892          * @return string
 893          */
 894         function getSqlComment() {
 895                 if ( $this->namespace || $this->deletedOnly ) {
 896                         return 'contributions page filtered for namespace or RevisionDeleted edits'; // potentially slow, see CR r58153
 897                 } else {
 898                         return 'contributions page unfiltered';
 899                 }
 900         }
 901
 902         protected function preventClickjacking() {
 903                 $this->preventClickjacking = true;
 904         }
 905
 906         public function getPreventClickjacking() {
 907                 return $this->preventClickjacking;
 908         }
 909 }