X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=includes%2FSpecialContributions.php;h=00864da5e53924187edbfa67333cfdcce10d75ba;hb=71e75ac5ead653914ec3ae100e26d186375a306e;hp=9a97865780b5187ff70e82832962b3ca2a394013;hpb=332a0cf2684024869536a2af1ef83990efcb7b3c;p=lhc%2Fweb%2Fwiklou.git diff --git a/includes/SpecialContributions.php b/includes/SpecialContributions.php index 9a97865780..00864da5e5 100644 --- a/includes/SpecialContributions.php +++ b/includes/SpecialContributions.php @@ -1,10 +1,152 @@ username = $username; + $this->namespace = false; + $this->dbr =& wfGetDB(DB_SLAVE); + } + + function set_namespace($ns) { + $this->namespace = $ns; + } + + function set_limit($limit) { + $this->limit = $limit; + } + + function set_offset($offset) { + $this->offset = $offset; + } + + function get_edit_limit($dir) { + list($index, $usercond) = $this->get_user_cond(); + $nscond = $this->get_namespace_cond(); + $use_index = $this->dbr->useIndexClause($index); + extract($this->dbr->tableNames('revision', 'page')); + $sql = "SELECT rev_timestamp " . + " FROM $page,$revision $use_index " . + " WHERE rev_page=page_id AND $usercond $nscond" . + " ORDER BY rev_timestamp $dir LIMIT 1"; + + $res = $this->dbr->query($sql, "contribs_finder::get_edit_limit"); + while ($o = $this->dbr->fetchObject($res)) + $row = $o; + return $row->rev_timestamp; + } + + function get_edit_limits() { + return array( + $this->get_edit_limit("ASC"), + $this->get_edit_limit("DESC") + ); + } + + function get_user_cond() { + $condition = ''; + + if ($this->username == 'newbies') { + $max = $this->dbr->selectField('user', 'max(user_id)', false, 'make_sql'); + $condition = '>' . (int)($max - $max / 100); + } + + if ($condition == '') { + $condition = ' rev_user_text=' . $this->dbr->addQuotes($this->username); + $index = 'usertext_timestamp'; + } else { + $condition = ' rev_user '.$condition ; + $index = 'user_timestamp'; + } + return array($index, $condition); + } + + function get_namespace_cond() { + if ($this->namespace !== false) + return ' AND page_namespace = ' . (int)$this->namespace; + return ''; + } + + function get_previous_offset_for_paging() { + list($index, $usercond) = $this->get_user_cond(); + $nscond = $this->get_namespace_cond(); + + $use_index = $this->dbr->useIndexClause($index); + extract($this->dbr->tableNames('page', 'revision')); + + $sql = "SELECT rev_timestamp FROM $page, $revision $use_index " . + "WHERE page_id = rev_page AND rev_timestamp > '" . $this->offset . "' AND " . + "rev_user_text = " . $this->dbr->addQuotes($this->username) + . $nscond; + $sql .= " ORDER BY rev_timestamp ASC"; + $sql = $this->dbr->limitResult($sql, $this->limit, 0); + $res = $this->dbr->query($sql); + $rows = array(); + while ($obj = $this->dbr->fetchObject($res)) + $rows[] = $obj; + $this->dbr->freeResult($res); + return $rows[count($rows) - 1]->rev_timestamp; + } + + function get_first_offset_for_paging() { + list($index, $usercond) = $this->get_user_cond(); + $use_index = $this->dbr->useIndexClause($index); + extract($this->dbr->tableNames('page', 'revision')); + $nscond = $this->get_namespace_cond(); + $sql = "SELECT rev_timestamp FROM $page, $revision $use_index " . + "WHERE page_id = rev_page AND " . + "rev_user_text = " . $this->dbr->addQuotes($this->username) + . $nscond; + $sql .= " ORDER BY rev_timestamp ASC"; + $sql = $this->dbr->limitResult($sql, $this->limit, 0); + $res = $this->dbr->query($sql); + $rows = array(); + while ($obj = $this->dbr->fetchObject($res)) + $rows[] = $obj; + $this->dbr->freeResult($res); + return $rows[count($rows) - 1]->rev_timestamp; + } + + /* private */ function make_sql() { + $userCond = $condition = $index = $offsetQuery = $limitQuery = ""; + + extract($this->dbr->tableNames('page', 'revision')); + list($index, $userCond) = $this->get_user_cond(); + + $limitQuery = 'LIMIT '.$this->limit; + if ($this->offset) + $offsetQuery = "AND rev_timestamp <= '{$this->offset}'"; + + $nscond = $this->get_namespace_cond(); + $use_index = $this->dbr->useIndexClause($index); + $sql = "SELECT + page_namespace,page_title,page_is_new,page_latest, + rev_id,rev_timestamp,rev_comment,rev_minor_edit,rev_user_text, + rev_deleted + FROM $page,$revision $use_index + WHERE page_id=rev_page AND $userCond $nscond $offsetQuery + ORDER BY rev_timestamp DESC"; + $sql = $this->dbr->limitResult($sql, $this->limit, 0); + return $sql; + } + + function find() { + $contribs = array(); + $res = $this->dbr->query($this->make_sql(), 'contribs_finder::find'); + while ($c = $this->dbr->fetchObject($res)) + $contribs[] = $c; + $this->dbr->freeResult($res); + return $contribs; + } +}; + /** * Special page "user contributions". * Shows a list of the contributions of a user. @@ -12,161 +154,174 @@ * @return none * @param string $par (optional) user name of the user for which to show the contributions */ -function wfSpecialContributions( $par = '' ) { - global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest; - $fname = "wfSpecialContributions"; - - if( $par ) - $target = $par; - else - $target = $wgRequest->getVal( 'target' ); +function wfSpecialContributions( $par = null ) { + global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest, $wgTitle, + $wgScript; + $fname = 'wfSpecialContributions'; + + $target = isset($par) ? $par : $wgRequest->getVal( 'target' ); + if (!strlen($target)) { + $wgOut->errorpage('notargettitle', 'notargettext'); + return; + } - if ( "" == $target ) { - $wgOut->errorpage( "notargettitle", "notargettext" ); + $nt = Title::newFromURL( $target ); + if (!$nt) { + $wgOut->errorpage( 'notargettitle', 'notargettext' ); return; } + $nt =& Title::makeTitle(NS_USER, $nt->getDBkey()); - # FIXME: Change from numeric offsets to date offsets - list( $limit, $offset ) = wfCheckLimits( 50, "" ); - $offlimit = $limit + $offset; - $querylimit = $offlimit + 1; - $hideminor = ($wgRequest->getVal( 'hideminor' ) ? 1 : 0); - $sk = $wgUser->getSkin(); - $dbr =& wfGetDB( DB_SLAVE ); - $userCond = ""; + list( $limit, $offset) = wfCheckLimits(); + $offset = $wgRequest->getVal('offset'); + /* Offset must be an integral. */ + if (!strlen($offset) || !preg_match('/^[0-9]+$/', $offset)) + $offset = 0; - $nt = Title::newFromURL( $target ); - if ( !$nt ) { - $wgOut->errorpage( "notargettitle", "notargettext" ); + $title = Title::makeTitle(NS_SPECIAL, 'Contributions'); + $urlbits = 'target=' . wfUrlEncode($target); + $myurl = $title->escapeLocalURL($urlbits); + + $finder = new contribs_finder(($target == 'newbies') ? 'newbies' : $nt->getText()); + + $finder->set_limit($limit); + $finder->set_offset($offset); + + $nsurl = $xnsurl = ''; + if (($ns = $wgRequest->getVal('namespace', null)) !== null && $ns !== '') { + $nsurl = '&namespace='.$ns; + $xnsurl = htmlspecialchars($nsurl); + $finder->set_namespace($ns); + } + + $boturl = ''; + if ($wgUser->isAllowed('rollback') && $wgRequest->getBool( 'bot' )) + $boturl = '&bot=1'; + + if ($wgRequest->getText('go') == 'prev') { + $prevts = $finder->get_previous_offset_for_paging(); + $prevurl = $title->getLocalURL($urlbits . "&offset=$prevts&limit=$limit$nsurl$boturl"); + $wgOut->redirect($prevurl); + return; + } + + if ($wgRequest->getText('go') == 'first' && $target != 'newbies') { + $prevts = $finder->get_first_offset_for_paging(); + $prevurl = $title->getLocalURL($urlbits . "&offset=$prevts&limit=$limit$nsurl$boturl"); + $wgOut->redirect($prevurl); return; } - $nt->setNamespace( Namespace::getUser() ); - $id = User::idFromName( $nt->getText() ); + $sk = $wgUser->getSkin(); + + $id = User::idFromName($nt->getText()); if ( 0 == $id ) { $ul = $nt->getText(); } else { $ul = $sk->makeLinkObj( $nt, htmlspecialchars( $nt->getText() ) ); - $userCond = "=" . $id; + $userCond = '=' . $id; } $talk = $nt->getTalkPage(); if( $talk ) { - $ul .= " (" . $sk->makeLinkObj( $talk, $wgLang->getNsText(Namespace::getTalk(0)) ) . ")"; + $ul .= ' (' . $sk->makeLinkObj( $talk, $wgLang->getNsText( NS_TALK ) ) . ')'; } + if ($target == 'newbies') { + $ul = wfMsg ('newbies'); + } - if ( $target == 'newbies' ) { - # View the contributions of all recently created accounts - $max = $dbr->selectField( 'user', 'max(user_id)', false, $fname ); - $userCond = ">" . ($max - $max / 100); - $ul = wfMsg ( 'newbies' ); - $id = 0; + $wgOut->setSubtitle( wfMsgHtml( 'contribsub', $ul ) ); + + wfRunHooks('SpecialContributionsBeforeMainOutput', $id ); + + $arr = $wgContLang->getFormattedNamespaces(); + $nsform = "
\n"; + $nsform .= wfElement('input', array( + 'name' => 'title', + 'type' => 'hidden', + 'value' => $wgTitle->getPrefixedText())); + $nsform .= wfElement('input', array( + 'name' => 'offset', + 'type' => 'hidden', + 'value' => $offset)); + $nsform .= wfElement('input', array( + 'name' => 'limit', + 'type' => 'hidden', + 'value' => $limit)); + $nsform .= wfElement('input', array( + 'name' => 'target', + 'type' => 'hidden', + 'value' => $target)); + $nsform .= '

'; + $nsform .= wfMsgHtml('namespace'); + + $nsform .= HTMLnamespaceselector( $ns, '' ); + + $nsform .= wfElement('input', array( + 'type' => 'submit', + 'value' => wfMsg('allpagessubmit'))); + $nsform .= "

\n"; + + $wgOut->addHTML($nsform); + + $contribsPage = Title::makeTitle( NS_SPECIAL, 'Contributions' ); + $contribs = $finder->find(); + + if (count($contribs) == 0) { + $wgOut->addWikiText( wfMsg( 'nocontribs' ) ); + return; } - $wgOut->setSubtitle( wfMsg( "contribsub", $ul ) ); + list($early, $late) = $finder->get_edit_limits(); + $lastts = count($contribs) ? $contribs[count($contribs) - 1]->rev_timestamp : 0; + $atstart = (!count($contribs) || $late == $contribs[0]->rev_timestamp); + $atend = (!count($contribs) || $early == $lastts); - if ( $hideminor ) { - $cmq = "AND cur_minor_edit=0"; - $omq = "AND old_minor_edit=0"; - $mlink = $sk->makeKnownLink( $wgContLang->specialPage( "Contributions" ), - WfMsg( "show" ), "target=" . htmlspecialchars( $nt->getPrefixedURL() ) . - "&offset={$offset}&limit={$limit}&hideminor=0" ); + $lasturl = $wgTitle->escapeLocalURL("action=history&limit={$limit}"); + + $firsttext = wfMsgHtml('histfirst'); + $lasttext = wfMsgHtml('histlast'); + + $prevtext = wfMsg('prevn', $limit); + if ($atstart) { + $lastlink = $lasttext; + $prevlink = $prevtext; } else { - $cmq = $omq = ""; - $mlink = $sk->makeKnownLink( $wgContLang->specialPage( "Contributions" ), - WfMsg( "hide" ), "target=" . htmlspecialchars( $nt->getPrefixedURL() ) . - "&offset={$offset}&limit={$limit}&hideminor=1" ); + $lastlink = "$lasttext"; + $prevlink = "$prevtext"; } - extract( $dbr->tableNames( 'old', 'cur' ) ); - if ( $userCond == "" ) { - $sql = "SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_minor_edit,cur_is_new,cur_user_text FROM $cur " . - "WHERE cur_user_text='" . $dbr->strencode( $nt->getText() ) . "' {$cmq} " . - "ORDER BY inverse_timestamp LIMIT {$querylimit}"; - $res1 = $dbr->query( $sql, $fname ); - - $sql = "SELECT old_namespace,old_title,old_timestamp,old_comment,old_minor_edit,old_user_text,old_id FROM $old " . - "WHERE old_user_text='" . $dbr->strencode( $nt->getText() ) . "' {$omq} " . - "ORDER BY inverse_timestamp LIMIT {$querylimit}"; - $res2 = $dbr->query( $sql, $fname ); + $nexttext = wfMsg('nextn', $limit); + if ($atend) { + $firstlink = $firsttext; + $nextlink = $nexttext; } else { - $sql = "SELECT cur_namespace,cur_title,cur_timestamp,cur_comment,cur_minor_edit,cur_is_new,cur_user_text FROM $cur " . - "WHERE cur_user {$userCond} {$cmq} ORDER BY inverse_timestamp LIMIT {$querylimit}"; - $res1 = $dbr->query( $sql, $fname ); - - $sql = "SELECT old_namespace,old_title,old_timestamp,old_comment,old_minor_edit,old_user_text,old_id FROM $old " . - "WHERE old_user {$userCond} {$omq} ORDER BY inverse_timestamp LIMIT {$querylimit}"; - $res2 = $dbr->query( $sql, $fname ); + $firstlink = "$firsttext"; + $nextlink = "$nexttext"; } - $nCur = $dbr->numRows( $res1 ); - $nOld = $dbr->numRows( $res2 ); + if ($target == 'newbies') { + $firstlast ="($lastlink)"; + } else { + $firstlast = "($lastlink | $firstlink)"; + } - $top = wfShowingResults( $offset, $limit ); - $wgOut->addHTML( "

{$top}\n" ); + $urls = array(); + foreach (array(20, 50, 100, 250, 500) as $num) + $urls[] = "".$wgLang->formatNum($num).""; + $bits = implode($urls, ' | '); - $sl = wfViewPrevNext( $offset, $limit, - $wgContLang->specialpage( "Contributions" ), - "hideminor={$hideminor}&target=" . wfUrlEncode( $target ), - ($nCur + $nOld) <= $offlimit); + $prevnextbits = $firstlast .' '. wfMsgHtml('viewprevnext', $prevlink, $nextlink, $bits); - $shm = wfMsg( "showhideminor", $mlink ); - $wgOut->addHTML( "
{$sl} ($shm)

\n"); + $wgOut->addHTML( "

{$prevnextbits}

\n"); + $wgOut->addHTML( "