getUserIdentityUtils(), $tempUserConfig ?? $services->getTempUserConfig() ); $this->watchedItemStore = $watchedItemStore ?? $services->getWatchedItemStore(); $this->messageCache = $messageCache ?? $services->getMessageCache(); $this->userOptionsLookup = $userOptionsLookup ?? $services->getUserOptionsLookup(); $this->changeTagsStore = $changeTagsStore ?? $services->getChangeTagsStore(); $this->watchlistFilterGroupDefinition = [ 'name' => 'watchlist', 'title' => 'rcfilters-filtergroup-watchlist', 'class' => ChangesListStringOptionsFilterGroup::class, 'priority' => -9, 'isFullCoverage' => true, 'filters' => [ [ 'name' => 'watched', 'label' => 'rcfilters-filter-watchlist-watched-label', 'description' => 'rcfilters-filter-watchlist-watched-description', 'cssClassSuffix' => 'watched', 'isRowApplicableCallable' => static function ( IContextSource $ctx, RecentChange $rc ) { return $rc->getAttribute( 'wl_user' ); } ], [ 'name' => 'watchednew', 'label' => 'rcfilters-filter-watchlist-watchednew-label', 'description' => 'rcfilters-filter-watchlist-watchednew-description', 'cssClassSuffix' => 'watchednew', 'isRowApplicableCallable' => static function ( IContextSource $ctx, RecentChange $rc ) { return $rc->getAttribute( 'wl_user' ) && $rc->getAttribute( 'rc_timestamp' ) && $rc->getAttribute( 'wl_notificationtimestamp' ) && $rc->getAttribute( 'rc_timestamp' ) >= $rc->getAttribute( 'wl_notificationtimestamp' ); }, ], [ 'name' => 'notwatched', 'label' => 'rcfilters-filter-watchlist-notwatched-label', 'description' => 'rcfilters-filter-watchlist-notwatched-description', 'cssClassSuffix' => 'notwatched', 'isRowApplicableCallable' => static function ( IContextSource $ctx, RecentChange $rc ) { return $rc->getAttribute( 'wl_user' ) === null; }, ] ], 'default' => ChangesListStringOptionsFilterGroup::NONE, 'queryCallable' => function ( string $specialClassName, IContextSource $ctx, IReadableDatabase $dbr, &$tables, &$fields, &$conds, &$query_options, &$join_conds, $selectedValues ) { sort( $selectedValues ); $notwatchedCond = $dbr->expr( 'wl_user', '=', null ); $watchedCond = $dbr->expr( 'wl_user', '!=', null ); if ( $this->getConfig()->get( MainConfigNames::WatchlistExpiry ) ) { // Expired watchlist items stay in the DB after their expiry time until they're purged, // so it's not enough to only check for wl_user. $dbNow = $dbr->timestamp(); $notwatchedCond = $notwatchedCond ->orExpr( $dbr->expr( 'we_expiry', '!=', null )->and( 'we_expiry', '<', $dbNow ) ); $watchedCond = $watchedCond ->andExpr( $dbr->expr( 'we_expiry', '=', null )->or( 'we_expiry', '>=', $dbNow ) ); } $newCond = new RawSQLExpression( 'rc_timestamp >= wl_notificationtimestamp' ); if ( $selectedValues === [ 'notwatched' ] ) { $conds[] = $notwatchedCond; return; } if ( $selectedValues === [ 'watched' ] ) { $conds[] = $watchedCond; return; } if ( $selectedValues === [ 'watchednew' ] ) { $conds[] = $watchedCond ->andExpr( $newCond ); return; } if ( $selectedValues === [ 'notwatched', 'watched' ] ) { // no filters return; } if ( $selectedValues === [ 'notwatched', 'watchednew' ] ) { $conds[] = $notwatchedCond ->orExpr( $watchedCond ->andExpr( $newCond ) ); return; } if ( $selectedValues === [ 'watched', 'watchednew' ] ) { $conds[] = $watchedCond; return; } if ( $selectedValues === [ 'notwatched', 'watched', 'watchednew' ] ) { // no filters return; } } ]; } /** * @param string|null $subpage */ public function execute( $subpage ) { // Backwards-compatibility: redirect to new feed URLs $feedFormat = $this->getRequest()->getVal( 'feed' ); if ( !$this->including() && $feedFormat ) { $query = $this->getFeedQuery(); $query['feedformat'] = $feedFormat === 'atom' ? 'atom' : 'rss'; $this->getOutput()->redirect( wfAppendQuery( wfScript( 'api' ), $query ) ); return; } // 10 seconds server-side caching max $out = $this->getOutput(); $out->setCdnMaxage( 10 ); // Check if the client has a cached version $lastmod = $this->checkLastModified(); if ( $lastmod === false ) { return; } $this->addHelpLink( 'https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Recent_changes', true ); parent::execute( $subpage ); } /** * @inheritDoc */ protected function transformFilterDefinition( array $filterDefinition ) { if ( isset( $filterDefinition['showHideSuffix'] ) ) { $filterDefinition['showHide'] = 'rc' . $filterDefinition['showHideSuffix']; } return $filterDefinition; } /** * Whether or not the current query needs to use watchlist data: check that the current user can * use their watchlist and that this special page isn't being transcluded. * * @return bool */ private function needsWatchlistFeatures(): bool { return !$this->including() && $this->getUser()->isRegistered() && $this->getAuthority()->isAllowed( 'viewmywatchlist' ); } /** * @inheritDoc */ protected function registerFilters() { parent::registerFilters(); if ( $this->needsWatchlistFeatures() ) { $this->registerFiltersFromDefinitions( [ $this->watchlistFilterGroupDefinition ] ); $watchlistGroup = $this->getFilterGroup( 'watchlist' ); $watchlistGroup->getFilter( 'watched' )->setAsSupersetOf( $watchlistGroup->getFilter( 'watchednew' ) ); } $user = $this->getUser(); $significance = $this->getFilterGroup( 'significance' ); /** @var ChangesListBooleanFilter $hideMinor */ $hideMinor = $significance->getFilter( 'hideminor' ); '@phan-var ChangesListBooleanFilter $hideMinor'; $hideMinor->setDefault( $this->userOptionsLookup->getBoolOption( $user, 'hideminor' ) ); $automated = $this->getFilterGroup( 'automated' ); /** @var ChangesListBooleanFilter $hideBots */ $hideBots = $automated->getFilter( 'hidebots' ); '@phan-var ChangesListBooleanFilter $hideBots'; $hideBots->setDefault( true ); /** @var ChangesListStringOptionsFilterGroup|null $reviewStatus */ $reviewStatus = $this->getFilterGroup( 'reviewStatus' ); '@phan-var ChangesListStringOptionsFilterGroup|null $reviewStatus'; if ( $reviewStatus !== null ) { // Conditional on feature being available and rights if ( $this->userOptionsLookup->getBoolOption( $user, 'hidepatrolled' ) ) { $reviewStatus->setDefault( 'unpatrolled' ); $legacyReviewStatus = $this->getFilterGroup( 'legacyReviewStatus' ); /** @var ChangesListBooleanFilter $legacyHidePatrolled */ $legacyHidePatrolled = $legacyReviewStatus->getFilter( 'hidepatrolled' ); '@phan-var ChangesListBooleanFilter $legacyHidePatrolled'; $legacyHidePatrolled->setDefault( true ); } } $changeType = $this->getFilterGroup( 'changeType' ); /** @var ChangesListBooleanFilter $hideCategorization */ $hideCategorization = $changeType->getFilter( 'hidecategorization' ); '@phan-var ChangesListBooleanFilter $hideCategorization'; if ( $hideCategorization !== null ) { // Conditional on feature being available $hideCategorization->setDefault( $this->userOptionsLookup->getBoolOption( $user, 'hidecategorization' ) ); } } /** * Process $par and put options found in $opts. Used when including the page. * * @param string $par * @param FormOptions $opts */ public function parseParameters( $par, FormOptions $opts ) { parent::parseParameters( $par, $opts ); $bits = preg_split( '/\s*,\s*/', trim( $par ) ); foreach ( $bits as $bit ) { if ( is_numeric( $bit ) ) { $opts['limit'] = $bit; } $m = []; if ( preg_match( '/^limit=(\d+)$/', $bit, $m ) ) { $opts['limit'] = $m[1]; } if ( preg_match( '/^days=(\d+(?:\.\d+)?)$/', $bit, $m ) ) { $opts['days'] = $m[1]; } if ( preg_match( '/^namespace=(.*)$/', $bit, $m ) ) { $opts['namespace'] = $m[1]; } if ( preg_match( '/^tagfilter=(.*)$/', $bit, $m ) ) { $opts['tagfilter'] = $m[1]; } } } /** * Add required values to a query's $tables, $fields, $joinConds, and $conds arrays to join to * the watchlist and watchlist_expiry tables where appropriate. * * SpecialRecentChangesLinked should also be updated accordingly when something changed here. * * @param IReadableDatabase $dbr * @param string[] &$tables * @param string[] &$fields * @param mixed[] &$joinConds * @param mixed[] &$conds */ protected function addWatchlistJoins( IReadableDatabase $dbr, &$tables, &$fields, &$joinConds, &$conds ) { if ( !$this->needsWatchlistFeatures() ) { return; } // Join on watchlist table. $tables[] = 'watchlist'; $fields[] = 'wl_user'; $fields[] = 'wl_notificationtimestamp'; $joinConds['watchlist'] = [ 'LEFT JOIN', [ 'wl_user' => $this->getUser()->getId(), 'wl_title=rc_title', 'wl_namespace=rc_namespace' ] ]; // Exclude expired watchlist items. if ( $this->getConfig()->get( MainConfigNames::WatchlistExpiry ) ) { $tables[] = 'watchlist_expiry'; $fields[] = 'we_expiry'; $joinConds['watchlist_expiry'] = [ 'LEFT JOIN', 'wl_id = we_item' ]; } } /** * @inheritDoc */ protected function doMainQuery( $tables, $fields, $conds, $query_options, $join_conds, FormOptions $opts ) { $dbr = $this->getDB(); $rcQuery = RecentChange::getQueryInfo(); $tables = array_merge( $rcQuery['tables'], $tables ); $fields = array_merge( $rcQuery['fields'], $fields ); $join_conds = array_merge( $rcQuery['joins'], $join_conds ); // Join with watchlist and watchlist_expiry tables to highlight watched rows. $this->addWatchlistJoins( $dbr, $tables, $fields, $join_conds, $conds ); // JOIN on page, used for 'last revision' filter highlight $tables[] = 'page'; $fields[] = 'page_latest'; $join_conds['page'] = [ 'LEFT JOIN', 'rc_cur_id=page_id' ]; $tagFilter = $opts['tagfilter'] !== '' ? explode( '|', $opts['tagfilter'] ) : []; $this->changeTagsStore->modifyDisplayQuery( $tables, $fields, $conds, $join_conds, $query_options, $tagFilter, $opts['inverttags'] ); if ( !$this->runMainQueryHook( $tables, $fields, $conds, $query_options, $join_conds, $opts ) ) { return false; } if ( $this->areFiltersInConflict() ) { return false; } $orderByAndLimit = [ 'ORDER BY' => 'rc_timestamp DESC', 'LIMIT' => $opts['limit'] ]; // Workaround for T298225: MySQL's lack of awareness of LIMIT when // choosing the join order. $ctTableName = ChangeTags::DISPLAY_TABLE_ALIAS; if ( isset( $join_conds[$ctTableName] ) && $this->isDenseTagFilter( $conds["$ctTableName.ct_tag_id"] ?? [], $opts['limit'] ) ) { $join_conds[$ctTableName][0] = 'STRAIGHT_JOIN'; } if ( in_array( 'DISTINCT', $query_options ) ) { // ChangeTagsStore::modifyDisplayQuery() adds DISTINCT when filtering on multiple tags. // In order to prevent DISTINCT from causing query performance problems, // we have to GROUP BY the primary key. This in turn requires us to add // the primary key to the end of the ORDER BY, and the old ORDER BY to the // start of the GROUP BY $orderByAndLimit['ORDER BY'] = 'rc_timestamp DESC, rc_id DESC'; $orderByAndLimit['GROUP BY'] = 'rc_timestamp, rc_id'; } // rc_new is not an ENUM, but adding a redundant rc_new IN (0,1) gives mysql enough // knowledge to use an index merge if it wants (it may use some other index though). $conds += [ 'rc_new' => [ 0, 1 ] ]; // array_merge() is used intentionally here so that hooks can, should // they so desire, override the ORDER BY / LIMIT condition(s); prior to // MediaWiki 1.26 this used to use the plus operator instead, which meant // that extensions weren't able to change these conditions $query_options = array_merge( $orderByAndLimit, $query_options ); return $dbr->newSelectQueryBuilder() ->tables( $tables ) ->fields( $fields ) ->conds( $conds ) ->caller( __METHOD__ ) ->options( $query_options ) ->joinConds( $join_conds ) ->setMaxExecutionTime( $this->getConfig()->get( MainConfigNames::MaxExecutionTimeForExpensiveQueries ) ) ->fetchResultSet(); } /** * Determine whether a tag filter matches a high proportion of the rows in * recentchanges. If so, it is more efficient to scan recentchanges, * filtering out non-matching rows, rather than scanning change_tag and * then filesorting on rc_timestamp. MySQL is especially bad at making this * judgement (T298225). * * @param int[] $tagIds * @param int $limit * @return bool */ protected function isDenseTagFilter( $tagIds, $limit ) { $dbr = $this->getDB(); if ( !$tagIds // This is a MySQL-specific hack || $dbr->getType() !== 'mysql' // Unnecessary for small wikis || !$this->getConfig()->get( MainConfigNames::MiserMode ) ) { return false; } $rcInfo = $dbr->newSelectQueryBuilder() ->select( [ 'min_id' => 'MIN(rc_id)', 'max_id' => 'MAX(rc_id)', ] ) ->from( 'recentchanges' ) ->caller( __METHOD__ ) ->fetchRow(); if ( !$rcInfo || $rcInfo->min_id === null ) { return false; } $rcSize = $rcInfo->max_id - $rcInfo->min_id; if ( $rcSize < $this->denseRcSizeThreshold ) { // RC is too small to worry about return false; } $tagCount = $dbr->newSelectQueryBuilder() ->table( 'change_tag' ) ->where( [ $dbr->expr( 'ct_rc_id', '>=', $rcInfo->min_id ), 'ct_tag_id' => $tagIds ] ) ->caller( __METHOD__ ) ->estimateRowCount(); // If we scan recentchanges first, the number of rows examined will be // approximately the limit divided by the proportion of tagged rows, // i.e. $limit / ( $tagCount / $rcSize ). If that's less than $tagCount, // use a straight join. The inequality below is rearranged for // simplicity and to avoid division by zero. $isDense = $limit * $rcSize < $tagCount * $tagCount; wfDebug( __METHOD__ . ": rcSize = $rcSize, tagCount = $tagCount, limit = $limit => " . ( $isDense ? 'dense' : 'sparse' ) ); return $isDense; } public function outputFeedLinks() { $this->addFeedLinks( $this->getFeedQuery() ); } /** * Get URL query parameters for action=feedrecentchanges API feed of current recent changes view. * * @return array */ protected function getFeedQuery() { $query = array_filter( $this->getOptions()->getAllValues(), static function ( $value ) { // API handles empty parameters in a different way return $value !== ''; } ); $query['action'] = 'feedrecentchanges'; $feedLimit = $this->getConfig()->get( MainConfigNames::FeedLimit ); if ( $query['limit'] > $feedLimit ) { $query['limit'] = $feedLimit; } return $query; } /** * Build and output the actual changes list. * * @param IResultWrapper $rows Database rows * @param FormOptions $opts */ public function outputChangesList( $rows, $opts ) { $limit = $opts['limit']; $showWatcherCount = $this->getConfig()->get( MainConfigNames::RCShowWatchingUsers ) && $this->userOptionsLookup->getBoolOption( $this->getUser(), 'shownumberswatching' ); $watcherCache = []; $counter = 1; $list = ChangesList::newFromContext( $this->getContext(), $this->filterGroups ); $list->initChangesListRows( $rows ); $userShowHiddenCats = $this->userOptionsLookup->getBoolOption( $this->getUser(), 'showhiddencats' ); $rclistOutput = $list->beginRecentChangesList(); if ( $this->isStructuredFilterUiEnabled() ) { $rclistOutput .= $this->makeLegend(); } foreach ( $rows as $obj ) { if ( $limit == 0 ) { break; } $rc = RecentChange::newFromRow( $obj ); # Skip CatWatch entries for hidden cats based on user preference if ( $rc->getAttribute( 'rc_type' ) == RC_CATEGORIZE && !$userShowHiddenCats && $rc->getParam( 'hidden-cat' ) ) { continue; } $rc->counter = $counter++; # Check if the page has been updated since the last visit if ( $this->getConfig()->get( MainConfigNames::ShowUpdatedMarker ) && !empty( $obj->wl_notificationtimestamp ) ) { $rc->notificationtimestamp = ( $obj->rc_timestamp >= $obj->wl_notificationtimestamp ); } else { $rc->notificationtimestamp = false; // Default } # Check the number of users watching the page $rc->numberofWatchingusers = 0; // Default if ( $showWatcherCount && $obj->rc_namespace >= 0 ) { if ( !isset( $watcherCache[$obj->rc_namespace][$obj->rc_title] ) ) { $watcherCache[$obj->rc_namespace][$obj->rc_title] = $this->watchedItemStore->countWatchers( new TitleValue( (int)$obj->rc_namespace, $obj->rc_title ) ); } $rc->numberofWatchingusers = $watcherCache[$obj->rc_namespace][$obj->rc_title]; } $watched = !empty( $obj->wl_user ); if ( $watched && $this->getConfig()->get( MainConfigNames::WatchlistExpiry ) ) { $notExpired = $obj->we_expiry === null || MWTimestamp::convert( TS_UNIX, $obj->we_expiry ) > wfTimestamp(); $watched = $watched && $notExpired; } $changeLine = $list->recentChangesLine( $rc, $watched, $counter ); if ( $changeLine !== false ) { $rclistOutput .= $changeLine; --$limit; } } $rclistOutput .= $list->endRecentChangesList(); if ( $rows->numRows() === 0 ) { $this->outputNoResults(); if ( !$this->including() ) { $this->getOutput()->setStatusCode( 404 ); } } else { $this->getOutput()->addHTML( $rclistOutput ); } } /** * Set the text to be displayed above the changes * * @param FormOptions $opts * @param int $numRows Number of rows in the result to show after this header */ public function doHeader( $opts, $numRows ) { $this->setTopText( $opts ); $defaults = $opts->getAllValues(); $nondefaults = $opts->getChangedValues(); $panel = []; if ( !$this->isStructuredFilterUiEnabled() ) { $panel[] = $this->makeLegend(); } $panel[] = $this->optionsPanel( $defaults, $nondefaults, $numRows ); $panel[] = '