includes/SpecialContributions.php

   1 <?php
   2 /**
   3  * @addtogroup SpecialPage
   4  */
   5
   6 class ContribsFinder {
   7         var $username, $offset, $limit, $namespace;
   8         var $dbr;
   9
  10         /**
  11          * Constructor
  12          * @param $username Username as a string
  13         */
  14         function ContribsFinder( $username ) {
  15                 $this->username = $username;
  16                 $this->namespace = false;
  17                 $this->dbr = wfGetDB( DB_SLAVE, 'contributions' );
  18         }
  19
  20         function setNamespace( $ns ) {
  21                 $this->namespace = $ns;
  22         }
  23
  24         function setLimit( $limit ) {
  25                 $this->limit = $limit;
  26         }
  27
  28         function setOffset( $offset ) {
  29                 $this->offset = $offset;
  30         }
  31
  32         /**
  33          * Get timestamp of either first or last contribution made by the user.
  34          * @todo Maybe it should be private ?
  35          * @param $dir string 'ASC' or 'DESC'.
  36          * @return Revision timestamp (rev_timestamp).
  37         */
  38         function getEditLimit( $dir ) {
  39                 list( $index, $usercond ) = $this->getUserCond();
  40                 $nscond = $this->getNamespaceCond();
  41                 $use_index = $this->dbr->useIndexClause( $index );
  42                 list( $revision, $page) = $this->dbr->tableNamesN( 'revision', 'page' );
  43                 $sql =  "SELECT rev_timestamp " .
  44                         " FROM $page,$revision $use_index " .
  45                         " WHERE rev_page=page_id AND $usercond $nscond" .
  46                         " ORDER BY rev_timestamp $dir LIMIT 1";
  47
  48                 $res = $this->dbr->query( $sql, __METHOD__ );
  49                 $row = $this->dbr->fetchObject( $res );
  50                 if ( $row ) {
  51                         return wfTimestamp( TS_MW, $row->rev_timestamp );
  52                 } else {
  53                         return false;
  54                 }
  55         }
  56
  57         /**
  58          * Get timestamps of first and last contributions made by the user.
  59          * @return Array containing first rev_timestamp and last rev_timestamp.
  60         */
  61         function getEditLimits() {
  62                 return array(
  63                         $this->getEditLimit( "ASC" ),
  64                         $this->getEditLimit( "DESC" )
  65                 );
  66         }
  67
  68         function getUserCond() {
  69                 $condition = '';
  70
  71                 if ( $this->username == 'newbies' ) {
  72                         $max = $this->dbr->selectField( 'user', 'max(user_id)', false, 'make_sql' );
  73                         $condition = '>' . (int)($max - $max / 100);
  74                 }
  75
  76                 if ( $condition == '' ) {
  77                         $condition = ' rev_user_text=' . $this->dbr->addQuotes( $this->username );
  78                         $index = 'usertext_timestamp';
  79                 } else {
  80                         $condition = ' rev_user '.$condition ;
  81                         $index = 'user_timestamp';
  82                 }
  83                 return array( $index, $condition );
  84         }
  85
  86         function getNamespaceCond() {
  87                 if ( $this->namespace !== false )
  88                         return ' AND page_namespace = ' . (int)$this->namespace;
  89                 return '';
  90         }
  91
  92         /**
  93          * @return Timestamp of first entry in previous page.
  94         */
  95         function getPreviousOffsetForPaging() {
  96                 list( $index, $usercond ) = $this->getUserCond();
  97                 $nscond = $this->getNamespaceCond();
  98
  99                 $use_index = $this->dbr->useIndexClause( $index );
 100                 list( $page, $revision ) = $this->dbr->tableNamesN( 'page', 'revision' );
 101
 102                 $sql =  "SELECT rev_timestamp FROM $page, $revision $use_index " .
 103                         "WHERE page_id = rev_page AND rev_timestamp > '" . $this->dbr->timestamp( $this->offset ) . "' AND " .
 104                         $usercond . $nscond;
 105                 $sql .= " ORDER BY rev_timestamp ASC";
 106                 $sql = $this->dbr->limitResult( $sql, $this->limit, 0 );
 107                 $res = $this->dbr->query( $sql );
 108
 109                 $numRows = $this->dbr->numRows( $res );
 110                 if ( $numRows ) {
 111                         $this->dbr->dataSeek( $res, $numRows - 1 );
 112                         $row = $this->dbr->fetchObject( $res );
 113                         $offset = wfTimestamp( TS_MW, $row->rev_timestamp );
 114                 } else {
 115                         $offset = false;
 116                 }
 117                 $this->dbr->freeResult( $res );
 118                 return $offset;
 119         }
 120
 121         /**
 122          * @return Timestamp of first entry in next page.
 123         */
 124         function getFirstOffsetForPaging() {
 125                 list( $index, $usercond ) = $this->getUserCond();
 126                 $use_index = $this->dbr->useIndexClause( $index );
 127                 list( $page, $revision ) = $this->dbr->tableNamesN( 'page', 'revision' );
 128                 $nscond = $this->getNamespaceCond();
 129                 $sql =  "SELECT rev_timestamp FROM $page, $revision $use_index " .
 130                         "WHERE page_id = rev_page AND " .
 131                         $usercond . $nscond;
 132                 $sql .= " ORDER BY rev_timestamp ASC";
 133                 $sql = $this->dbr->limitResult( $sql, $this->limit, 0 );
 134                 $res = $this->dbr->query( $sql );
 135
 136                 $numRows = $this->dbr->numRows( $res );
 137                 if ( $numRows ) {
 138                         $this->dbr->dataSeek( $res, $numRows - 1 );
 139                         $row = $this->dbr->fetchObject( $res );
 140                         $offset = wfTimestamp( TS_MW, $row->rev_timestamp );
 141                 } else {
 142                         $offset = false;
 143                 }
 144                 $this->dbr->freeResult( $res );
 145                 return $offset;
 146         }
 147
 148         /* private */ function makeSql() {
 149                 $offsetQuery = '';
 150
 151                 list( $page, $revision ) = $this->dbr->tableNamesN( 'page', 'revision' );
 152                 list( $index, $userCond ) = $this->getUserCond();
 153
 154                 if ( $this->offset )
 155                         $offsetQuery = "AND rev_timestamp < '" . $this->dbr->timestamp($this->offset) . "'";
 156
 157                 $nscond = $this->getNamespaceCond();
 158                 $use_index = $this->dbr->useIndexClause( $index );
 159                 $sql = 'SELECT ' .
 160                         'page_namespace,page_title,page_is_new,page_latest,'.
 161                         join(',', Revision::selectFields()) .
 162                         " FROM $page,$revision $use_index " .
 163                         "WHERE page_id=rev_page AND $userCond $nscond $offsetQuery " .
 164                         'ORDER BY rev_timestamp DESC';
 165                 $sql = $this->dbr->limitResult( $sql, $this->limit, 0 );
 166                 return $sql;
 167         }
 168
 169         /**
 170          * This do the search for the user given when creating the object.
 171          * It should probably be the only public function in this class.
 172          * @return Array of contributions.
 173         */
 174         function find() {
 175                 $contribs = array();
 176                 $res = $this->dbr->query( $this->makeSql(), __METHOD__ );
 177                 while ( $c = $this->dbr->fetchObject( $res ) )
 178                         $contribs[] = $c;
 179                 $this->dbr->freeResult( $res );
 180                 return $contribs;
 181         }
 182 };
 183
 184 /**
 185  * Special page "user contributions".
 186  * Shows a list of the contributions of a user.
 187  *
 188  * @return      none
 189  * @param       $par    String: (optional) user name of the user for which to show the contributions
 190  */
 191 function wfSpecialContributions( $par = null ) {
 192         global $wgUser, $wgOut, $wgLang, $wgRequest;
 193
 194         $target = isset( $par ) ? $par : $wgRequest->getVal( 'target' );
 195         if ( !strlen( $target ) ) {
 196                 $wgOut->showErrorPage( 'notargettitle', 'notargettext' );
 197                 return;
 198         }
 199
 200         $nt = Title::newFromURL( $target );
 201         if ( !$nt ) {
 202                 $wgOut->showErrorPage( 'notargettitle', 'notargettext' );
 203                 return;
 204         }
 205
 206         $options = array();
 207
 208         list( $options['limit'], $options['offset']) = wfCheckLimits();
 209         $options['offset'] = $wgRequest->getVal( 'offset' );
 210         /* Offset must be an integral. */
 211         if ( !strlen( $options['offset'] ) || !preg_match( '/^[0-9]+$/', $options['offset'] ) )
 212                 $options['offset'] = '';
 213
 214         $title = SpecialPage::getTitleFor( 'Contributions' );
 215         $options['target'] = $target;
 216
 217         $nt =& Title::makeTitle( NS_USER, $nt->getDBkey() );
 218         $finder = new ContribsFinder( ( $target == 'newbies' ) ? 'newbies' : $nt->getText() );
 219         $finder->setLimit( $options['limit'] );
 220         $finder->setOffset( $options['offset'] );
 221
 222         if ( ( $ns = $wgRequest->getVal( 'namespace', null ) ) !== null && $ns !== '' ) {
 223                 $options['namespace'] = intval( $ns );
 224                 $finder->setNamespace( $options['namespace'] );
 225         } else {
 226                 $options['namespace'] = '';
 227         }
 228
 229         if ( $wgUser->isAllowed( 'rollback' ) && $wgRequest->getBool( 'bot' ) ) {
 230                 $options['bot'] = '1';
 231         }
 232
 233         if ( $wgRequest->getText( 'go' ) == 'prev' ) {
 234                 $offset = $finder->getPreviousOffsetForPaging();
 235                 if ( $offset !== false ) {
 236                         $options['offset'] = $offset;
 237                         $prevurl = $title->getLocalURL( wfArrayToCGI( $options ) );
 238                         $wgOut->redirect( $prevurl );
 239                         return;
 240                 }
 241         }
 242
 243         if ( $wgRequest->getText( 'go' ) == 'first' && $target != 'newbies') {
 244                 $offset = $finder->getFirstOffsetForPaging();
 245                 if ( $offset !== false ) {
 246                         $options['offset'] = $offset;
 247                         $prevurl = $title->getLocalURL( wfArrayToCGI( $options ) );
 248                         $wgOut->redirect( $prevurl );
 249                         return;
 250                 }
 251         }
 252
 253         if ( $target == 'newbies' ) {
 254                 $wgOut->setSubtitle( wfMsgHtml( 'sp-contributions-newbies-sub') );
 255         } else {
 256                 $wgOut->setSubtitle( wfMsgHtml( 'contribsub', contributionsSub( $nt ) ) );
 257         }
 258
 259         $id = User::idFromName( $nt->getText() );
 260         wfRunHooks( 'SpecialContributionsBeforeMainOutput', $id );
 261
 262         $wgOut->addHTML( contributionsForm( $options) );
 263
 264         $contribs = $finder->find();
 265
 266         if ( count( $contribs ) == 0) {
 267                 $wgOut->addWikiText( wfMsg( 'nocontribs' ) );
 268                 return;
 269         }
 270
 271         list( $early, $late ) = $finder->getEditLimits();
 272         $lastts = count( $contribs ) ? wfTimestamp( TS_MW, $contribs[count( $contribs ) - 1]->rev_timestamp ) : 0;
 273         $atstart = ( !count( $contribs ) || $late == wfTimestamp( TS_MW, $contribs[0]->rev_timestamp ) );
 274         $atend = ( !count( $contribs ) || $early == $lastts );
 275
 276         // These four are defaults
 277         $newestlink = wfMsgHtml( 'sp-contributions-newest' );
 278         $oldestlink = wfMsgHtml( 'sp-contributions-oldest' );
 279         $newerlink  = wfMsgHtml( 'sp-contributions-newer', $options['limit'] );
 280         $olderlink  = wfMsgHtml( 'sp-contributions-older', $options['limit'] );
 281
 282         if ( !$atstart ) {
 283                 $stuff = $title->escapeLocalURL( wfArrayToCGI( array( 'offset' => '' ), $options ) );
 284                 $newestlink = "<a href=\"$stuff\">$newestlink</a>";
 285                 $stuff = $title->escapeLocalURL( wfArrayToCGI( array( 'go' => 'prev' ), $options ) );
 286                 $newerlink = "<a href=\"$stuff\">$newerlink</a>";
 287         }
 288
 289         if ( !$atend ) {
 290                 $stuff = $title->escapeLocalURL( wfArrayToCGI( array( 'go' => 'first' ), $options ) );
 291                 $oldestlink = "<a href=\"$stuff\">$oldestlink</a>";
 292                 $stuff = $title->escapeLocalURL( wfArrayToCGI( array( 'offset' => $lastts ), $options ) );
 293                 $olderlink = "<a href=\"$stuff\">$olderlink</a>";
 294         }
 295
 296         if ( $target == 'newbies' ) {
 297                 $firstlast ="($newestlink)";
 298         } else {
 299                 $firstlast = "($newestlink | $oldestlink)";
 300         }
 301
 302         $urls = array();
 303         foreach ( array( 20, 50, 100, 250, 500 ) as $num ) {
 304                 $stuff = $title->escapeLocalURL( wfArrayToCGI( array( 'limit' => $num ), $options ) );
 305                 $urls[] = "<a href=\"$stuff\">".$wgLang->formatNum( $num )."</a>";
 306         }
 307         $bits = implode( $urls, ' | ' );
 308
 309         $prevnextbits = $firstlast .' '. wfMsgHtml( 'viewprevnext', $newerlink, $olderlink, $bits );
 310
 311         $wgOut->addHTML( "<p>{$prevnextbits}</p>\n" );
 312
 313         $wgOut->addHTML( "<ul>\n" );
 314
 315         $sk = $wgUser->getSkin();
 316         foreach ( $contribs as $contrib )
 317                 $wgOut->addHTML( ucListEdit( $sk, $contrib ) );
 318
 319         $wgOut->addHTML( "</ul>\n" );
 320         $wgOut->addHTML( "<p>{$prevnextbits}</p>\n" );
 321
 322         # If there were contributions, and it was a valid user or IP, show
 323         # the appropriate "footer" message - WHOIS tools, etc.
 324         if( count( $contribs ) > 0 && $target != 'newbies' && $nt instanceof Title ) {
 325                 $message = IP::isIPAddress( $target )
 326                         ? 'sp-contributions-footer-anon'
 327                         : 'sp-contributions-footer';
 328                 $text = wfMsg( $message, $target );
 329                 if( !wfEmptyMsg( $message, $text ) && $text != '-' ) {
 330                         $wgOut->addHtml( '<div class="mw-contributions-footer">' );
 331                         $wgOut->addWikiText( wfMsg( $message, $target ) );
 332                         $wgOut->addHtml( '</div>' );
 333                 }
 334         }
 335
 336 }
 337
 338 /**
 339  * Generates the subheading with links
 340  * @param $nt @see Title object for the target
 341  */
 342 function contributionsSub( $nt ) {
 343         global $wgSysopUserBans, $wgLang, $wgUser;
 344
 345         $sk = $wgUser->getSkin();
 346         $id = User::idFromName( $nt->getText() );
 347
 348         if ( 0 == $id ) {
 349                 $ul = $nt->getText();
 350         } else {
 351                 $ul = $sk->makeLinkObj( $nt, htmlspecialchars( $nt->getText() ) );
 352         }
 353         $talk = $nt->getTalkPage();
 354         if( $talk ) {
 355                 # Talk page link
 356                 $tools[] = $sk->makeLinkObj( $talk, $wgLang->getNsText( NS_TALK ) );
 357                 if( ( $id != 0 && $wgSysopUserBans ) || ( $id == 0 && User::isIP( $nt->getText() ) ) ) {
 358                         # Block link
 359                         if( $wgUser->isAllowed( 'block' ) )
 360                                 $tools[] = $sk->makeKnownLinkObj( SpecialPage::getTitleFor( 'Blockip', $nt->getDBkey() ), wfMsgHtml( 'blocklink' ) );
 361                         # Block log link
 362                         $tools[] = $sk->makeKnownLinkObj( SpecialPage::getTitleFor( 'Log' ), wfMsgHtml( 'sp-contributions-blocklog' ), 'type=block&page=' . $nt->getPrefixedUrl() );
 363                 }
 364                 # Other logs link
 365                 $tools[] = $sk->makeKnownLinkObj( SpecialPage::getTitleFor( 'Log' ), wfMsgHtml( 'log' ), 'user=' . $nt->getPartialUrl() );
 366                 $ul .= ' (' . implode( ' | ', $tools ) . ')';
 367         }
 368         return $ul;
 369 }
 370
 371 /**
 372  * Generates the namespace selector form with hidden attributes.
 373  * @param $options Array: the options to be included.
 374  */
 375 function contributionsForm( $options ) {
 376         global $wgScript, $wgTitle;
 377
 378         $options['title'] = $wgTitle->getPrefixedText();
 379
 380         $f = "<form method='get' action=\"$wgScript\">\n";
 381         foreach ( $options as $name => $value ) {
 382                 if( $name === 'namespace') continue;
 383                 $f .= "\t" . wfElement( 'input', array(
 384                         'name' => $name,
 385                         'type' => 'hidden',
 386                         'value' => $value ) ) . "\n";
 387         }
 388
 389         $f .= '<p>' . wfMsgHtml( 'namespace' ) . ' ' .
 390         HTMLnamespaceselector( $options['namespace'], '' ) .
 391         wfElement( 'input', array(
 392                         'type' => 'submit',
 393                         'value' => wfMsg( 'allpagessubmit' ) )
 394         ) .
 395         "</p></form>\n";
 396
 397         return $f;
 398 }
 399
 400 /**
 401  * Generates each row in the contributions list.
 402  *
 403  * Contributions which are marked "top" are currently on top of the history.
 404  * For these contributions, a [rollback] link is shown for users with sysop
 405  * privileges. The rollback link restores the most recent version that was not
 406  * written by the target user.
 407  *
 408  * @todo This would probably look a lot nicer in a table.
 409  */
 410 function ucListEdit( $sk, $row ) {
 411         $fname = 'ucListEdit';
 412         wfProfileIn( $fname );
 413
 414         global $wgLang, $wgUser, $wgRequest;
 415         static $messages;
 416         if( !isset( $messages ) ) {
 417                 foreach( explode( ' ', 'uctop diff newarticle rollbacklink diff hist minoreditletter' ) as $msg ) {
 418                         $messages[$msg] = wfMsgExt( $msg, array( 'escape') );
 419                 }
 420         }
 421
 422         $rev = new Revision( $row );
 423
 424         $page = Title::makeTitle( $row->page_namespace, $row->page_title );
 425         $link = $sk->makeKnownLinkObj( $page );
 426         $difftext = $topmarktext = '';
 427         if( $row->rev_id == $row->page_latest ) {
 428                 $topmarktext .= '<strong>' . $messages['uctop'] . '</strong>';
 429                 if( !$row->page_is_new ) {
 430                         $difftext .= '(' . $sk->makeKnownLinkObj( $page, $messages['diff'], 'diff=0' ) . ')';
 431                 } else {
 432                         $difftext .= $messages['newarticle'];
 433                 }
 434
 435                 if( $wgUser->isAllowed( 'rollback' ) ) {
 436                         $topmarktext .= ' '.$sk->generateRollback( $rev );
 437                 }
 438
 439         }
 440         if( $rev->userCan( Revision::DELETED_TEXT ) ) {
 441                 $difftext = '(' . $sk->makeKnownLinkObj( $page, $messages['diff'], 'diff=prev&oldid='.$row->rev_id ) . ')';
 442         } else {
 443                 $difftext = '(' . $messages['diff'] . ')';
 444         }
 445         $histlink='('.$sk->makeKnownLinkObj( $page, $messages['hist'], 'action=history' ) . ')';
 446
 447         $comment = $sk->revComment( $rev );
 448         $d = $wgLang->timeanddate( wfTimestamp( TS_MW, $row->rev_timestamp ), true );
 449
 450         if( $rev->isDeleted( Revision::DELETED_TEXT ) ) {
 451                 $d = '<span class="history-deleted">' . $d . '</span>';
 452         }
 453
 454         if( $row->rev_minor_edit ) {
 455                 $mflag = '<span class="minor">' . $messages['minoreditletter'] . '</span> ';
 456         } else {
 457                 $mflag = '';
 458         }
 459
 460         $ret = "{$d} {$histlink} {$difftext} {$mflag} {$link} {$comment} {$topmarktext}";
 461         if( $rev->isDeleted( Revision::DELETED_TEXT ) ) {
 462                 $ret .= ' ' . wfMsgHtml( 'deletedrev' );
 463         }
 464         $ret = "<li>$ret</li>\n";
 465         wfProfileOut( $fname );
 466         return $ret;
 467 }
 468
 469 ?>