4 * @subpackage SpecialPage
7 /** @package MediaWiki */
8 class contribs_finder
{
9 var $username, $offset, $limit, $namespace;
12 function contribs_finder($username) {
13 $this->username
= $username;
14 $this->namespace = false;
15 $this->dbr
=& wfGetDB(DB_SLAVE
);
18 function set_namespace($ns) {
19 $this->namespace = $ns;
22 function set_limit($limit) {
23 $this->limit
= $limit;
26 function set_offset($offset) {
27 $this->offset
= $offset;
30 function get_edit_limit($dir) {
31 list($index, $usercond) = $this->get_user_cond();
32 $nscond = $this->get_namespace_cond();
33 $use_index = $this->dbr
->useIndexClause($index);
34 extract($this->dbr
->tableNames('revision', 'page'));
35 $sql = "SELECT rev_timestamp " .
36 " FROM $page,$revision $use_index " .
37 " WHERE rev_page=page_id AND $usercond $nscond" .
38 " ORDER BY rev_timestamp $dir LIMIT 1";
40 $res = $this->dbr
->query($sql, "contribs_finder::get_edit_limit");
41 while ($o = $this->dbr
->fetchObject($res))
43 return $row->rev_timestamp
;
46 function get_edit_limits() {
48 $this->get_edit_limit("ASC"),
49 $this->get_edit_limit("DESC")
53 function get_user_cond() {
56 if ($this->username
== 'newbies') {
57 $max = $this->dbr
->selectField('user', 'max(user_id)', false, 'make_sql');
58 $condition = '>' . (int)($max - $max / 100);
61 if ($condition == '') {
62 $condition = ' rev_user_text=' . $this->dbr
->addQuotes($this->username
);
63 $index = 'usertext_timestamp';
65 $condition = ' rev_user '.$condition ;
66 $index = 'user_timestamp';
68 return array($index, $condition);
71 function get_namespace_cond() {
72 if ($this->namespace !== false)
73 return ' AND page_namespace = ' . (int)$this->namespace;
77 function get_previous_offset_for_paging() {
78 list($index, $usercond) = $this->get_user_cond();
79 $nscond = $this->get_namespace_cond();
81 $use_index = $this->dbr
->useIndexClause($index);
82 extract($this->dbr
->tableNames('page', 'revision'));
84 $sql = "SELECT rev_timestamp FROM $page, $revision $use_index " .
85 "WHERE page_id = rev_page AND rev_timestamp > '" . $this->offset
. "' AND " .
86 "rev_user_text = " . $this->dbr
->addQuotes($this->username
)
88 $sql .= " ORDER BY rev_timestamp ASC";
89 $sql = $this->dbr
->limitResult($sql, $this->limit
, 0);
90 $res = $this->dbr
->query($sql);
92 while ($obj = $this->dbr
->fetchObject($res))
94 $this->dbr
->freeResult($res);
95 return $rows[count($rows) - 1]->rev_timestamp
;
98 function get_first_offset_for_paging() {
99 list($index, $usercond) = $this->get_user_cond();
100 $use_index = $this->dbr
->useIndexClause($index);
101 extract($this->dbr
->tableNames('page', 'revision'));
102 $nscond = $this->get_namespace_cond();
103 $sql = "SELECT rev_timestamp FROM $page, $revision $use_index " .
104 "WHERE page_id = rev_page AND " .
105 "rev_user_text = " . $this->dbr
->addQuotes($this->username
)
107 $sql .= " ORDER BY rev_timestamp ASC";
108 $sql = $this->dbr
->limitResult($sql, $this->limit
, 0);
109 $res = $this->dbr
->query($sql);
111 while ($obj = $this->dbr
->fetchObject($res))
113 $this->dbr
->freeResult($res);
114 return $rows[count($rows) - 1]->rev_timestamp
;
117 /* private */ function make_sql() {
118 $userCond = $condition = $index = $offsetQuery = $limitQuery = "";
120 extract($this->dbr
->tableNames('page', 'revision'));
121 list($index, $userCond) = $this->get_user_cond();
123 $limitQuery = 'LIMIT '.$this->limit
;
125 $offsetQuery = "AND rev_timestamp <= '{$this->offset}'";
127 $nscond = $this->get_namespace_cond();
128 $use_index = $this->dbr
->useIndexClause($index);
130 page_namespace,page_title,page_is_new,page_latest,
131 rev_id,rev_timestamp,rev_comment,rev_minor_edit,rev_user_text,
133 FROM $page,$revision $use_index
134 WHERE page_id=rev_page AND $userCond $nscond $offsetQuery
135 ORDER BY rev_timestamp DESC";
136 $sql = $this->dbr
->limitResult($sql, $this->limit
, 0);
142 $res = $this->dbr
->query($this->make_sql(), 'contribs_finder::find');
143 while ($c = $this->dbr
->fetchObject($res))
145 $this->dbr
->freeResult($res);
151 * Special page "user contributions".
152 * Shows a list of the contributions of a user.
155 * @param string $par (optional) user name of the user for which to show the contributions
157 function wfSpecialContributions( $par = null ) {
158 global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest, $wgTitle, $wgScript;
159 $fname = 'wfSpecialContributions';
161 $target = isset($par) ?
$par : $wgRequest->getVal( 'target' );
162 if (!strlen($target)) {
163 $wgOut->errorpage('notargettitle', 'notargettext');
167 $nt = Title
::newFromURL( $target );
169 $wgOut->errorpage( 'notargettitle', 'notargettext' );
172 $nt =& Title
::makeTitle(NS_USER
, $nt->getDBkey());
174 list( $limit, $offset) = wfCheckLimits();
175 $offset = $wgRequest->getVal('offset');
176 /* Offset must be an integral. */
177 if (!strlen($offset) ||
!preg_match('/^[0-9]+$/', $offset))
180 $title = Title
::makeTitle(NS_SPECIAL
, 'Contributions');
181 $urlbits = 'target=' . wfUrlEncode($target);
182 $myurl = $title->escapeLocalURL($urlbits);
184 $finder = new contribs_finder(($target == 'newbies') ?
'newbies' : $nt->getText());
186 $finder->set_limit($limit);
187 $finder->set_offset($offset);
189 $nsurl = $xnsurl = '';
190 if (($ns = $wgRequest->getVal('namespace', null)) !== null && $ns !== '') {
191 $nsurl = '&namespace='.$ns;
192 $xnsurl = htmlspecialchars($nsurl);
193 $finder->set_namespace($ns);
197 if ($wgUser->isAllowed('rollback') && $wgRequest->getBool( 'bot' ))
198 $boturl = '&bot=1';
200 if ($wgRequest->getText('go') == 'prev') {
201 $prevts = $finder->get_previous_offset_for_paging();
202 $prevurl = $title->getLocalURL($urlbits . "&offset=$prevts&limit=$limit$nsurl$boturl");
203 $wgOut->redirect($prevurl);
207 if ($wgRequest->getText('go') == 'first' && $target != 'newbies') {
208 $prevts = $finder->get_first_offset_for_paging();
209 $prevurl = $title->getLocalURL($urlbits . "&offset=$prevts&limit=$limit$nsurl$boturl");
210 $wgOut->redirect($prevurl);
214 $sk = $wgUser->getSkin();
216 $id = User
::idFromName($nt->getText());
219 $ul = $nt->getText();
221 $ul = $sk->makeLinkObj( $nt, htmlspecialchars( $nt->getText() ) );
222 $userCond = '=' . $id;
224 $talk = $nt->getTalkPage();
226 $ul .= ' (' . $sk->makeLinkObj( $talk, $wgLang->getNsText( NS_TALK
) );
227 if( ( $id != 0 ) ||
( $id == 0 && User
::isIP( $nt->getText() ) ) ) {
228 if( $wgUser->isAllowed( 'block' ) ) {
229 $ul .= ' | ' . $sk->makeLinkObj( Title
::makeTitle( NS_SPECIAL
, 'Blockip/' . $nt->getText() ), wfMsgHtml( 'blocklink' ) );
231 $ul .= ' | ' . $sk->makeLinkObj( Title
::makeTitle( NS_SPECIAL
, 'Log' ), LogPage
::logName( 'block' ), 'type=block&page=' . urlencode( $nt->getPrefixedText() ) );
236 if ($target == 'newbies') {
237 $ul = wfMsg ('newbies');
240 $wgOut->setSubtitle( wfMsgHtml( 'contribsub', $ul ) );
242 wfRunHooks('SpecialContributionsBeforeMainOutput', $id );
244 $arr = $wgContLang->getFormattedNamespaces();
245 $nsform = "<form method='get' action=\"$wgScript\">\n";
246 $nsform .= wfElement('input', array(
249 'value' => $wgTitle->getPrefixedText()));
250 $nsform .= wfElement('input', array(
253 'value' => $offset));
254 $nsform .= wfElement('input', array(
258 $nsform .= wfElement('input', array(
261 'value' => $target));
263 $nsform .= wfMsgHtml('namespace');
266 $nsform .= HTMLnamespaceselector( $ns, '' );
268 $nsform .= wfElement('input', array(
270 'value' => wfMsg('allpagessubmit')));
271 $nsform .= "</p></form>\n";
273 $wgOut->addHTML($nsform);
275 $contribsPage = Title
::makeTitle( NS_SPECIAL
, 'Contributions' );
276 $contribs = $finder->find();
278 if (count($contribs) == 0) {
279 $wgOut->addWikiText( wfMsg( 'nocontribs' ) );
283 list($early, $late) = $finder->get_edit_limits();
284 $lastts = count($contribs) ?
$contribs[count($contribs) - 1]->rev_timestamp
: 0;
285 $atstart = (!count($contribs) ||
$late == $contribs[0]->rev_timestamp
);
286 $atend = (!count($contribs) ||
$early == $lastts);
288 $firsttext = wfMsgHtml('histfirst');
289 $lasttext = wfMsgHtml('histlast');
291 $prevtext = wfMsg('prevn', $limit);
293 $lastlink = $lasttext;
294 $prevlink = $prevtext;
296 $lastlink = "<a href=\"$myurl&limit=$limit$xnsurl$boturl\">$lasttext</a>";
297 $prevlink = "<a href=\"$myurl&offset=$offset&limit=$limit$xnsurl$boturl&go=prev\">$prevtext</a>";
300 $nexttext = wfMsg('nextn', $limit);
302 $firstlink = $firsttext;
303 $nextlink = $nexttext;
305 $firstlink = "<a href=\"$myurl&limit=$limit$xnsurl$boturl&go=first\">$firsttext</a>";
306 $nextlink = "<a href=\"$myurl&offset=$lastts&limit=$limit$xnsurl$boturl\">$nexttext</a>";
308 if ($target == 'newbies') {
309 $firstlast ="($lastlink)";
311 $firstlast = "($lastlink | $firstlink)";
315 foreach (array(20, 50, 100, 250, 500) as $num)
316 $urls[] = "<a href=\"$myurl&offset=$offset&limit={$num}$xnsurl$boturl\">".$wgLang->formatNum($num)."</a>";
317 $bits = implode($urls, ' | ');
319 $prevnextbits = $firstlast .' '. wfMsgHtml('viewprevnext', $prevlink, $nextlink, $bits);
321 $wgOut->addHTML( "<p>{$prevnextbits}</p>\n");
323 $wgOut->addHTML( "<ul>\n" );
325 foreach ($contribs as $contrib)
326 $wgOut->addHTML(ucListEdit($sk, $contrib));
328 $wgOut->addHTML( "</ul>\n" );
329 $wgOut->addHTML( "<p>{$prevnextbits}</p>\n");
334 * Generates each row in the contributions list.
336 * Contributions which are marked "top" are currently on top of the history.
337 * For these contributions, a [rollback] link is shown for users with sysop
338 * privileges. The rollback link restores the most recent version that was not
339 * written by the target user.
341 * If the contributions page is called with the parameter &bot=1, all rollback
342 * links also get that parameter. It causes the edit itself and the rollback
343 * to be marked as "bot" edits. Bot edits are hidden by default from recent
344 * changes, so this allows sysops to combat a busy vandal without bothering
347 * @todo This would probably look a lot nicer in a table.
349 function ucListEdit( $sk, $row ) {
350 $fname = 'ucListEdit';
351 wfProfileIn( $fname );
353 global $wgLang, $wgUser, $wgRequest;
355 if( !isset( $messages ) ) {
356 foreach( explode( ' ', 'uctop diff newarticle rollbacklink diff hist minoreditletter' ) as $msg ) {
357 $messages[$msg] = wfMsg( $msg );
361 $page =& Title
::makeTitle( $row->page_namespace
, $row->page_title
);
362 $link = $sk->makeKnownLinkObj( $page, '' );
363 $difftext = $topmarktext = '';
364 if( $row->rev_id
== $row->page_latest
) {
365 $topmarktext .= '<strong>' . $messages['uctop'] . '</strong>';
366 if( !$row->page_is_new
) {
367 $difftext .= '(' . $sk->makeKnownLinkObj( $page, $messages['diff'], 'diff=0' ) . ')';
369 $difftext .= $messages['newarticle'];
372 if( $wgUser->isAllowed('rollback') ) {
373 $extraRollback = $wgRequest->getBool( 'bot' ) ?
'&bot=1' : '';
374 $extraRollback .= '&token=' . urlencode(
375 $wgUser->editToken( array( $page->getPrefixedText(), $row->rev_user_text
) ) );
376 $topmarktext .= ' ['. $sk->makeKnownLinkObj( $page,
377 $messages['rollbacklink'],
378 'action=rollback&from=' . urlencode( $row->rev_user_text
) . $extraRollback ) .']';
382 if( $row->rev_deleted
&& !$wgUser->isAllowed( 'delete' ) ) {
383 $difftext = '(' . $messages['diff'] . ')';
385 $difftext = '(' . $sk->makeKnownLinkObj( $page, $messages['diff'], 'diff=prev&oldid='.$row->rev_id
) . ')';
387 $histlink='('.$sk->makeKnownLinkObj( $page, $messages['hist'], 'action=history' ) . ')';
389 $comment = $sk->commentBlock( $row->rev_comment
, $page, (bool)$row->rev_deleted
);
390 $d = $wgLang->timeanddate( wfTimestamp(TS_MW
, $row->rev_timestamp
), true );
392 if( $row->rev_minor_edit
) {
393 $mflag = '<span class="minor">' . $messages['minoreditletter'] . '</span> ';
398 $ret = "{$d} {$histlink} {$difftext} {$mflag} {$link} {$comment} {$topmarktext}";
399 if( $row->rev_deleted
) {
400 $ret = "<span class='deleted'>$ret</span>";
402 $ret = "<li>$ret</li>\n";
403 wfProfileOut( $fname );