includes/SpecialContributions.php

   1 <?php
   2 /**
   3  * @package MediaWiki
   4  * @subpackage SpecialPage
   5  */
   6
   7 /** @package MediaWiki */
   8 class contribs_finder {
   9         var $username, $offset, $limit;
  10         var $dbr;
  11
  12         function contribs_finder($username) {
  13                 $this->username = $username;
  14                 $this->dbr =& wfGetDB(DB_SLAVE);
  15         }
  16
  17         function set_limit($limit) {
  18                 $this->limit = $limit;
  19         }
  20
  21         function set_offset($offset) {
  22                 $this->offset = $offset;
  23         }
  24
  25         function get_edit_limit($dir) {
  26                 list($index, $usercond) = $this->get_user_cond();
  27
  28                 $use_index = $this->dbr->useIndexClause($index);
  29                 extract($this->dbr->tableNames('revision', 'page'));
  30                 $sql =  "SELECT rev_timestamp " .
  31                         " FROM $page,$revision $use_index " .
  32                         " WHERE " . $usercond .
  33                         " ORDER BY rev_timestamp $dir LIMIT 1";
  34
  35                 $res = $this->dbr->query($sql, "contribs_finder::get_edit_limit");
  36                 while ($o = $this->dbr->fetchObject($res))
  37                         $row = $o;
  38                 return $row->rev_timestamp;
  39         }
  40
  41         function get_edit_limits() {
  42                 return array(
  43                         $this->get_edit_limit("ASC"),
  44                         $this->get_edit_limit("DESC")
  45                 );
  46         }
  47
  48         function get_user_cond() {
  49                 $condition = "";
  50
  51                 if ($this->username == 'newbies') {
  52                         $max = $this->dbr->selectField('user', 'max(user_id)', false, "make_sql");
  53                         $condition = '>' . (int)($max - $max / 100);
  54                 }
  55
  56                 if ($condition == "") {
  57                         $condition = " rev_user_text=" . $this->dbr->addQuotes($this->username);
  58                         $index = 'usertext_timestamp';
  59                 } else {
  60                         $condition = " rev_user {$condition}";
  61                         $index = 'user_timestamp';
  62                 }
  63                 return array($index, $condition);
  64         }
  65
  66         function get_previous_offset_for_paging() {
  67                 list($index, $usercond) = $this->get_user_cond();
  68                 $use_index = $this->dbr->useIndexClause($index);
  69                 extract($this->dbr->tableNames('page', 'revision'));
  70
  71                 $sql =  "SELECT rev_timestamp FROM $page, $revision $use_index " .
  72                         "WHERE page_id = rev_page AND rev_timestamp > '" . $this->offset . "' AND " .
  73                         "rev_user_text = " . $this->dbr->addQuotes($this->username);
  74                 $sql .= " ORDER BY rev_timestamp ASC LIMIT " . ($this->limit+1);
  75                 $res = $this->dbr->query($sql);
  76                 $rows = array();
  77                 while ($obj = $this->dbr->fetchObject($res))
  78                         $rows[] = $obj;
  79                 $this->dbr->freeResult($res);
  80                 return $rows[count($rows) - 1]->rev_timestamp;
  81         }
  82
  83         function get_first_offset_for_paging() {
  84                 list($index, $usercond) = $this->get_user_cond();
  85                 $use_index = $this->dbr->useIndexClause($index);
  86                 extract($this->dbr->tableNames('page', 'revision'));
  87
  88                 $sql =  "SELECT rev_timestamp FROM $page, $revision $use_index " .
  89                         "WHERE page_id = rev_page AND " .
  90                         "rev_user_text = " . $this->dbr->addQuotes($this->username);
  91                 $sql .= " ORDER BY rev_timestamp ASC LIMIT " . ($this->limit + 1);
  92                 $res = $this->dbr->query($sql);
  93                 $rows = array();
  94                 while ($obj = $this->dbr->fetchObject($res))
  95                         $rows[] = $obj;
  96                 $this->dbr->freeResult($res);
  97                 return $rows[count($rows) - 1]->rev_timestamp;
  98         }
  99
 100         /* private */ function make_sql() {
 101                 $userCond = $condition = $index = $offsetQuery = $limitQuery = "";
 102
 103                 extract($this->dbr->tableNames('page', 'revision'));
 104                 list($index, $userCond) = $this->get_user_cond();
 105
 106                 $limitQuery = "LIMIT {$this->limit}";
 107                 if ($this->offset)
 108                         $offsetQuery = "AND rev_timestamp <= '{$this->offset}'";
 109
 110                 $use_index = $this->dbr->useIndexClause($index);
 111                 $sql = "SELECT
 112                         page_namespace,page_title,page_is_new,page_latest,
 113                         rev_id,rev_timestamp,rev_comment,rev_minor_edit,rev_user_text,
 114                         rev_deleted
 115                         FROM $page,$revision $use_index
 116                         WHERE page_id=rev_page AND $userCond $offsetQuery
 117                         ORDER BY rev_timestamp DESC $limitQuery";
 118                 return $sql;
 119         }
 120
 121         function find() {
 122                 $contribs = array();
 123                 $res = $this->dbr->query($this->make_sql(), "contribs_finder::find");
 124                 while ($c = $this->dbr->fetchObject($res))
 125                         $contribs[] = $c;
 126                 $this->dbr->freeResult($res);
 127                 return $contribs;
 128         }
 129 };
 130
 131 /**
 132  * Special page "user contributions".
 133  * Shows a list of the contributions of a user.
 134  *
 135  * @return      none
 136  * @param       string  $par    (optional) user name of the user for which to show the contributions
 137  */
 138 function wfSpecialContributions( $par = null ) {
 139         global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest, $wgTitle;
 140         $fname = 'wfSpecialContributions';
 141
 142         $target = isset($par) ? $par : $wgRequest->getVal( 'target' );
 143         if (!strlen($target)) {
 144                 $wgOut->errorpage('notargettitle', 'notargettext');
 145                 return;
 146         }
 147
 148         $nt = Title::newFromURL( $target );
 149         if (!$nt) {
 150                 $wgOut->errorpage( 'notargettitle', 'notargettext' );
 151                 return;
 152         }
 153         $nt =& Title::makeTitle(NS_USER, $nt->getDBkey());
 154
 155         $limit = min($wgRequest->getInt('limit', 50), 500);
 156         $offset = $wgRequest->getVal('offset');
 157         /* Offset must be an integral. */
 158         if (!strlen($offset) || !preg_match("/^[0-9]+$/", $offset))
 159                 $offset = 0;
 160
 161         $title = Title::makeTitle(NS_SPECIAL, "Contributions");
 162         $urlbits = "target=" . wfUrlEncode($target);
 163         $myurl = $title->escapeLocalURL($urlbits);
 164
 165         $finder = new contribs_finder(($target == 'newbies') ? 'newbies' : $nt->getText());
 166
 167         $finder->set_limit($limit);
 168         $finder->set_offset($offset);
 169
 170         if ($wgRequest->getText('go') == "prev") {
 171                 $prevts = $finder->get_previous_offset_for_paging();
 172                 $prevurl = $title->getLocalURL($urlbits . "&offset=$prevts&limit=$limit");
 173                 $wgOut->redirect($prevurl);
 174                 return;
 175         }
 176
 177         if ($wgRequest->getText('go') == "first") {
 178                 $prevts = $finder->get_first_offset_for_paging();
 179                 $prevurl = $title->getLocalURL($urlbits . "&offset=$prevts&limit=$limit");
 180                 $wgOut->redirect($prevurl);
 181                 return;
 182         }
 183
 184         $sk = $wgUser->getSkin();
 185
 186         $id = User::idFromName($nt->getText());
 187
 188         if ( 0 == $id ) {
 189                 $ul = $nt->getText();
 190         } else {
 191                 $ul = $sk->makeLinkObj( $nt, htmlspecialchars( $nt->getText() ) );
 192                 $userCond = '=' . $id;
 193         }
 194         $talk = $nt->getTalkPage();
 195         if( $talk ) {
 196                 $ul .= ' (' . $sk->makeLinkObj( $talk, $wgLang->getNsText( NS_TALK ) ) . ')';
 197         }
 198
 199         if ($target == 'newbies') {
 200                 $ul = wfMsg ('newbies');
 201         }
 202
 203         $wgOut->setSubtitle( wfMsgHtml( 'contribsub', $ul ) );
 204
 205         $contribsPage = Title::makeTitle( NS_SPECIAL, 'Contributions' );
 206         $contribs = $finder->find();
 207
 208         if (count($contribs) == 0) {
 209                 $wgOut->addWikiText( wfMsg( "nocontribs" ) );
 210                 return;
 211         }
 212
 213         list($early, $late) = $finder->get_edit_limits();
 214         $lastts = count($contribs) ? $contribs[count($contribs) - 1]->rev_timestamp : 0;
 215         $atstart = (!count($contribs) || $late == $contribs[0]->rev_timestamp);
 216         $atend = (!count($contribs) || $early == $lastts);
 217
 218         $lasturl = $wgTitle->escapeLocalURL("action=history&limit={$limit}");
 219
 220         $firsttext = wfMsgHtml("histfirst");
 221         $lasttext = wfMsgHtml("histlast");
 222
 223         $prevtext = wfMsg("prevn", $limit);
 224         if ($atstart) {
 225                 $lastlink = $lasttext;
 226                 $prevlink = $prevtext;
 227         } else {
 228                 $lastlink = "<a href=\"$myurl&amp;limit=$limit\">$lasttext</a>";
 229                 $prevlink = "<a href=\"$myurl&amp;offset=$offset&amp;limit=$limit&amp;go=prev\">$prevtext</a>";
 230         }
 231
 232         $nexttext = wfMsg("nextn", $limit);
 233         if ($atend) {
 234                 $firstlink = $firsttext;
 235                 $nextlink = $nexttext;
 236         } else {
 237                 $firstlink = "<a href=\"$myurl&amp;limit=$limit&amp;go=first\">$firsttext</a>";
 238                 $nextlink = "<a href=\"$myurl&amp;offset=$lastts&amp;limit=$limit\">$nexttext</a>";
 239         }
 240         $firstlast = "($lastlink | $firstlink)";
 241
 242         $urls = array();
 243         foreach (array(20, 50, 100, 250, 500) as $num)
 244                 $urls[] = "<a href=\"$myurl&amp;offset=$offset&amp;limit={$num}\">".$wgLang->formatNum($num)."</a>";
 245         $bits = implode($urls, ' | ');
 246
 247         $prevnextbits = "$firstlast " . wfMsgHtml("viewprevnext", $prevlink, $nextlink, $bits);
 248
 249         $wgOut->addHTML( "<p>{$prevnextbits}</p>\n");
 250
 251         $wgOut->addHTML( "<ul>\n" );
 252
 253         foreach ($contribs as $contrib)
 254                 $wgOut->addHTML(ucListEdit($sk, $contrib));
 255
 256         $wgOut->addHTML( "</ul>\n" );
 257         $wgOut->addHTML( "<p>{$prevnextbits}</p>\n");
 258 }
 259
 260
 261 /**
 262  * Generates each row in the contributions list.
 263  *
 264  * Contributions which are marked "top" are currently on top of the history.
 265  * For these contributions, a [rollback] link is shown for users with sysop
 266  * privileges. The rollback link restores the most recent version that was not
 267  * written by the target user.
 268  *
 269  * If the contributions page is called with the parameter &bot=1, all rollback
 270  * links also get that parameter. It causes the edit itself and the rollback
 271  * to be marked as "bot" edits. Bot edits are hidden by default from recent
 272  * changes, so this allows sysops to combat a busy vandal without bothering
 273  * other users.
 274  *
 275  * @todo This would probably look a lot nicer in a table.
 276  */
 277 function ucListEdit( $sk, $row ) {
 278         $fname = 'ucListEdit';
 279         wfProfileIn( $fname );
 280
 281         global $wgLang, $wgOut, $wgUser, $wgRequest;
 282         static $messages;
 283         if( !isset( $messages ) ) {
 284                 foreach( explode( ' ', 'uctop diff newarticle rollbacklink diff hist minoreditletter' ) as $msg ) {
 285                         $messages[$msg] = wfMsg( $msg );
 286                 }
 287         }
 288
 289         $page =& Title::makeTitle( $row->page_namespace, $row->page_title );
 290         $link = $sk->makeKnownLinkObj( $page, '' );
 291         $difftext = $topmarktext = '';
 292         if( $row->rev_id == $row->page_latest ) {
 293                 $topmarktext .= '<strong>' . $messages['uctop'] . '</strong>';
 294                 if( !$row->page_is_new ) {
 295                         $difftext .= $sk->makeKnownLinkObj( $page, '(' . $messages['diff'] . ')', 'diff=0' );
 296                 } else {
 297                         $difftext .= $messages['newarticle'];
 298                 }
 299
 300                 if( $wgUser->isAllowed('rollback') ) {
 301                         $extraRollback = $wgRequest->getBool( 'bot' ) ? '&bot=1' : '';
 302                         $extraRollback .= '&token=' . urlencode(
 303                                 $wgUser->editToken( array( $page->getPrefixedText(), $row->rev_user_text ) ) );
 304                         $topmarktext .= ' ['. $sk->makeKnownLinkObj( $page,
 305                                 $messages['rollbacklink'],
 306                                 'action=rollback&from=' . urlencode( $row->rev_user_text ) . $extraRollback ) .']';
 307                 }
 308
 309         }
 310         if( $row->rev_deleted && !$wgUser->isAllowed( 'undelete' ) ) {
 311                 $difftext = '(' . $messages['diff'] . ')';
 312         } else {
 313                 $difftext = $sk->makeKnownLinkObj( $page, '(' . $messages['diff'].')', 'diff=prev&oldid='.$row->rev_id );
 314         }
 315         $histlink='('.$sk->makeKnownLinkObj( $page, $messages['hist'], 'action=history' ) . ')';
 316
 317         $comment = $sk->commentBlock( $row->rev_comment, $page );
 318         $d = $wgLang->timeanddate( $row->rev_timestamp, true );
 319
 320         if( $row->rev_minor_edit ) {
 321                 $mflag = '<span class="minor">' . $messages['minoreditletter'] . '</span> ';
 322         } else {
 323                 $mflag = '';
 324         }
 325
 326         $ret = "{$d} {$histlink} {$difftext} {$mflag} {$link} {$comment} {$topmarktext}";
 327         if( $row->rev_deleted ) {
 328                 $ret = '<span class="deleted">' . $ret . '</span> ' . htmlspecialchars( wfMsg( 'deletedrev' ) );
 329         }
 330         $ret = "<li>$ret</li>\n";
 331         wfProfileOut( $fname );
 332         return $ret;
 333 }
 334
 335 ?>