3a5c90e1ae11c038f50efacd0e3ca347957e5757
4 * @subpackage SpecialPage
7 /** @package MediaWiki */
8 class contribs_finder
{
9 var $username, $offset, $limit;
12 function contribs_finder($username) {
13 $this->username
= $username;
14 $this->dbr
=& wfGetDB(DB_SLAVE
);
17 function set_limit($limit) {
18 $this->limit
= $limit;
21 function set_offset($offset) {
22 $this->offset
= $offset;
25 function get_edit_limit($dir) {
26 list($index, $usercond) = $this->get_user_cond();
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";
35 $res = $this->dbr
->query($sql, "contribs_finder::get_edit_limit");
36 while ($o = $this->dbr
->fetchObject($res))
38 return $row->rev_timestamp
;
41 function get_edit_limits() {
43 $this->get_edit_limit("ASC"),
44 $this->get_edit_limit("DESC")
48 function get_user_cond() {
51 if ($this->username
== 'newbies') {
52 $max = $this->dbr
->selectField('user', 'max(user_id)', false, "make_sql");
53 $condition = '>' . (int)($max - $max / 100);
56 if ($condition == "") {
57 $condition = " rev_user_text=" . $this->dbr
->addQuotes($this->username
);
58 $index = 'usertext_timestamp';
60 $condition = " rev_user {$condition}";
61 $index = 'user_timestamp';
63 return array($index, $condition);
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'));
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);
77 while ($obj = $this->dbr
->fetchObject($res))
79 $this->dbr
->freeResult($res);
80 return $rows[count($rows) - 1]->rev_timestamp
;
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'));
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);
94 while ($obj = $this->dbr
->fetchObject($res))
96 $this->dbr
->freeResult($res);
97 return $rows[count($rows) - 1]->rev_timestamp
;
100 /* private */ function make_sql() {
101 $userCond = $condition = $index = $offsetQuery = $limitQuery = "";
103 extract($this->dbr
->tableNames('page', 'revision'));
104 list($index, $userCond) = $this->get_user_cond();
106 $limitQuery = "LIMIT {$this->limit}";
108 $offsetQuery = "AND rev_timestamp <= '{$this->offset}'";
110 $use_index = $this->dbr
->useIndexClause($index);
112 page_namespace,page_title,page_is_new,page_latest,
113 rev_id,rev_timestamp,rev_comment,rev_minor_edit,rev_user_text,
115 FROM $page,$revision $use_index
116 WHERE page_id=rev_page AND $userCond $offsetQuery
117 ORDER BY rev_timestamp DESC $limitQuery";
123 $res = $this->dbr
->query($this->make_sql(), "contribs_finder::find");
124 while ($c = $this->dbr
->fetchObject($res))
126 $this->dbr
->freeResult($res);
132 * Special page "user contributions".
133 * Shows a list of the contributions of a user.
136 * @param string $par (optional) user name of the user for which to show the contributions
138 function wfSpecialContributions( $par = null ) {
139 global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest, $wgTitle;
140 $fname = 'wfSpecialContributions';
142 $target = isset($par) ?
$par : $wgRequest->getVal( 'target' );
143 if (!strlen($target)) {
144 $wgOut->errorpage('notargettitle', 'notargettext');
148 $nt = Title
::newFromURL( $target );
150 $wgOut->errorpage( 'notargettitle', 'notargettext' );
153 $nt =& Title
::makeTitle(NS_USER
, $nt->getDBkey());
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))
161 $title = Title
::makeTitle(NS_SPECIAL
, "Contributions");
162 $urlbits = "target=" . wfUrlEncode($target);
163 $myurl = $title->escapeLocalURL($urlbits);
165 $finder = new contribs_finder(($target == 'newbies') ?
'newbies' : $nt->getText());
167 $finder->set_limit($limit);
168 $finder->set_offset($offset);
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);
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);
184 $sk = $wgUser->getSkin();
186 $id = User
::idFromName($nt->getText());
189 $ul = $nt->getText();
191 $ul = $sk->makeLinkObj( $nt, htmlspecialchars( $nt->getText() ) );
192 $userCond = '=' . $id;
194 $talk = $nt->getTalkPage();
196 $ul .= ' (' . $sk->makeLinkObj( $talk, $wgLang->getNsText( NS_TALK
) ) . ')';
199 if ($target == 'newbies') {
200 $ul = wfMsg ('newbies');
203 $wgOut->setSubtitle( wfMsgHtml( 'contribsub', $ul ) );
205 $contribsPage = Title
::makeTitle( NS_SPECIAL
, 'Contributions' );
206 $contribs = $finder->find();
208 if (count($contribs) == 0) {
209 $wgOut->addWikiText( wfMsg( "nocontribs" ) );
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);
218 $lasturl = $wgTitle->escapeLocalURL("action=history&limit={$limit}");
220 $firsttext = wfMsgHtml("histfirst");
221 $lasttext = wfMsgHtml("histlast");
223 $prevtext = wfMsg("prevn", $limit);
225 $lastlink = $lasttext;
226 $prevlink = $prevtext;
228 $lastlink = "<a href=\"$myurl&limit=$limit\">$lasttext</a>";
229 $prevlink = "<a href=\"$myurl&offset=$offset&limit=$limit&go=prev\">$prevtext</a>";
232 $nexttext = wfMsg("nextn", $limit);
234 $firstlink = $firsttext;
235 $nextlink = $nexttext;
237 $firstlink = "<a href=\"$myurl&limit=$limit&go=first\">$firsttext</a>";
238 $nextlink = "<a href=\"$myurl&offset=$lastts&limit=$limit\">$nexttext</a>";
240 $firstlast = "($lastlink | $firstlink)";
243 foreach (array(20, 50, 100, 250, 500) as $num)
244 $urls[] = "<a href=\"$myurl&offset=$offset&limit={$num}\">".$wgLang->formatNum($num)."</a>";
245 $bits = implode($urls, ' | ');
247 $prevnextbits = "$firstlast " . wfMsgHtml("viewprevnext", $prevlink, $nextlink, $bits);
249 $wgOut->addHTML( "<p>{$prevnextbits}</p>\n");
251 $wgOut->addHTML( "<ul>\n" );
253 foreach ($contribs as $contrib)
254 $wgOut->addHTML(ucListEdit($sk, $contrib));
256 $wgOut->addHTML( "</ul>\n" );
257 $wgOut->addHTML( "<p>{$prevnextbits}</p>\n");
262 * Generates each row in the contributions list.
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.
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
275 * @todo This would probably look a lot nicer in a table.
277 function ucListEdit( $sk, $row ) {
278 $fname = 'ucListEdit';
279 wfProfileIn( $fname );
281 global $wgLang, $wgOut, $wgUser, $wgRequest;
283 if( !isset( $messages ) ) {
284 foreach( explode( ' ', 'uctop diff newarticle rollbacklink diff hist minoreditletter' ) as $msg ) {
285 $messages[$msg] = wfMsg( $msg );
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' );
297 $difftext .= $messages['newarticle'];
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 ) .']';
310 if( $row->rev_deleted
&& !$wgUser->isAllowed( 'undelete' ) ) {
311 $difftext = '(' . $messages['diff'] . ')';
313 $difftext = $sk->makeKnownLinkObj( $page, '(' . $messages['diff'].')', 'diff=prev&oldid='.$row->rev_id
);
315 $histlink='('.$sk->makeKnownLinkObj( $page, $messages['hist'], 'action=history' ) . ')';
317 $comment = $sk->commentBlock( $row->rev_comment
, $page );
318 $d = $wgLang->timeanddate( $row->rev_timestamp
, true );
320 if( $row->rev_minor_edit
) {
321 $mflag = '<span class="minor">' . $messages['minoreditletter'] . '</span> ';
326 $ret = "{$d} {$histlink} {$difftext} {$mflag} {$link} {$comment} {$topmarktext}";
327 if( $row->rev_deleted
) {
328 $ret = '<span class="deleted">' . $ret . '</span> ' . htmlspecialchars( wfMsg( 'deletedrev' ) );
330 $ret = "<li>$ret</li>\n";
331 wfProfileOut( $fname );