3 * Representation of a page version.
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
22 use MediaWiki\Linker\LinkTarget
;
27 class Revision
implements IDBAccessObject
{
35 protected $mOrigUserText;
37 protected $mMinorEdit;
38 protected $mTimestamp;
57 protected $mContentModel;
58 protected $mContentFormat;
61 * @var Content|null|bool
66 * @var null|ContentHandler
68 protected $mContentHandler;
73 protected $mQueryFlags = 0;
75 // Revision deletion constants
76 const DELETED_TEXT
= 1;
77 const DELETED_COMMENT
= 2;
78 const DELETED_USER
= 4;
79 const DELETED_RESTRICTED
= 8;
80 const SUPPRESSED_USER
= 12; // convenience
82 // Audience options for accessors
84 const FOR_THIS_USER
= 2;
88 * Load a page revision from a given revision ID number.
89 * Returns null if no such revision can be found.
92 * Revision::READ_LATEST : Select the data from the master
93 * Revision::READ_LOCKING : Select & lock the data from the master
96 * @param int $flags (optional)
97 * @return Revision|null
99 public static function newFromId( $id, $flags = 0 ) {
100 return self
::newFromConds( [ 'rev_id' => intval( $id ) ], $flags );
104 * Load either the current, or a specified, revision
105 * that's attached to a given link target. If not attached
106 * to that link target, will return null.
109 * Revision::READ_LATEST : Select the data from the master
110 * Revision::READ_LOCKING : Select & lock the data from the master
112 * @param LinkTarget $linkTarget
113 * @param int $id (optional)
114 * @param int $flags Bitfield (optional)
115 * @return Revision|null
117 public static function newFromTitle( LinkTarget
$linkTarget, $id = 0, $flags = 0 ) {
119 'page_namespace' => $linkTarget->getNamespace(),
120 'page_title' => $linkTarget->getDBkey()
123 // Use the specified ID
124 $conds['rev_id'] = $id;
125 return self
::newFromConds( $conds, $flags );
127 // Use a join to get the latest revision
128 $conds[] = 'rev_id=page_latest';
129 $db = wfGetDB( ( $flags & self
::READ_LATEST
) ? DB_MASTER
: DB_SLAVE
);
130 return self
::loadFromConds( $db, $conds, $flags );
135 * Load either the current, or a specified, revision
136 * that's attached to a given page ID.
137 * Returns null if no such revision can be found.
140 * Revision::READ_LATEST : Select the data from the master (since 1.20)
141 * Revision::READ_LOCKING : Select & lock the data from the master
144 * @param int $revId (optional)
145 * @param int $flags Bitfield (optional)
146 * @return Revision|null
148 public static function newFromPageId( $pageId, $revId = 0, $flags = 0 ) {
149 $conds = [ 'page_id' => $pageId ];
151 $conds['rev_id'] = $revId;
152 return self
::newFromConds( $conds, $flags );
154 // Use a join to get the latest revision
155 $conds[] = 'rev_id = page_latest';
156 $db = wfGetDB( ( $flags & self
::READ_LATEST
) ? DB_MASTER
: DB_SLAVE
);
157 return self
::loadFromConds( $db, $conds, $flags );
162 * Make a fake revision object from an archive table row. This is queried
163 * for permissions or even inserted (as in Special:Undelete)
164 * @todo FIXME: Should be a subclass for RevisionDelete. [TS]
167 * @param array $overrides
169 * @throws MWException
172 public static function newFromArchiveRow( $row, $overrides = [] ) {
173 global $wgContentHandlerUseDB;
175 $attribs = $overrides +
[
176 'page' => isset( $row->ar_page_id
) ?
$row->ar_page_id
: null,
177 'id' => isset( $row->ar_rev_id
) ?
$row->ar_rev_id
: null,
178 'comment' => $row->ar_comment
,
179 'user' => $row->ar_user
,
180 'user_text' => $row->ar_user_text
,
181 'timestamp' => $row->ar_timestamp
,
182 'minor_edit' => $row->ar_minor_edit
,
183 'text_id' => isset( $row->ar_text_id
) ?
$row->ar_text_id
: null,
184 'deleted' => $row->ar_deleted
,
185 'len' => $row->ar_len
,
186 'sha1' => isset( $row->ar_sha1
) ?
$row->ar_sha1
: null,
187 'content_model' => isset( $row->ar_content_model
) ?
$row->ar_content_model
: null,
188 'content_format' => isset( $row->ar_content_format
) ?
$row->ar_content_format
: null,
191 if ( !$wgContentHandlerUseDB ) {
192 unset( $attribs['content_model'] );
193 unset( $attribs['content_format'] );
196 if ( !isset( $attribs['title'] )
197 && isset( $row->ar_namespace
)
198 && isset( $row->ar_title
)
200 $attribs['title'] = Title
::makeTitle( $row->ar_namespace
, $row->ar_title
);
203 if ( isset( $row->ar_text
) && !$row->ar_text_id
) {
204 // Pre-1.5 ar_text row
205 $attribs['text'] = self
::getRevisionText( $row, 'ar_' );
206 if ( $attribs['text'] === false ) {
207 throw new MWException( 'Unable to load text from archive row (possibly bug 22624)' );
210 return new self( $attribs );
219 public static function newFromRow( $row ) {
220 return new self( $row );
224 * Load a page revision from a given revision ID number.
225 * Returns null if no such revision can be found.
227 * @param IDatabase $db
229 * @return Revision|null
231 public static function loadFromId( $db, $id ) {
232 return self
::loadFromConds( $db, [ 'rev_id' => intval( $id ) ] );
236 * Load either the current, or a specified, revision
237 * that's attached to a given page. If not attached
238 * to that page, will return null.
240 * @param IDatabase $db
243 * @return Revision|null
245 public static function loadFromPageId( $db, $pageid, $id = 0 ) {
246 $conds = [ 'rev_page' => intval( $pageid ), 'page_id' => intval( $pageid ) ];
248 $conds['rev_id'] = intval( $id );
250 $conds[] = 'rev_id=page_latest';
252 return self
::loadFromConds( $db, $conds );
256 * Load either the current, or a specified, revision
257 * that's attached to a given page. If not attached
258 * to that page, will return null.
260 * @param IDatabase $db
261 * @param Title $title
263 * @return Revision|null
265 public static function loadFromTitle( $db, $title, $id = 0 ) {
267 $matchId = intval( $id );
269 $matchId = 'page_latest';
271 return self
::loadFromConds( $db,
274 'page_namespace' => $title->getNamespace(),
275 'page_title' => $title->getDBkey()
281 * Load the revision for the given title with the given timestamp.
282 * WARNING: Timestamps may in some circumstances not be unique,
283 * so this isn't the best key to use.
285 * @param IDatabase $db
286 * @param Title $title
287 * @param string $timestamp
288 * @return Revision|null
290 public static function loadFromTimestamp( $db, $title, $timestamp ) {
291 return self
::loadFromConds( $db,
293 'rev_timestamp' => $db->timestamp( $timestamp ),
294 'page_namespace' => $title->getNamespace(),
295 'page_title' => $title->getDBkey()
301 * Given a set of conditions, fetch a revision
303 * This method is used then a revision ID is qualified and
304 * will incorporate some basic slave/master fallback logic
306 * @param array $conditions
307 * @param int $flags (optional)
308 * @return Revision|null
310 private static function newFromConds( $conditions, $flags = 0 ) {
311 $db = wfGetDB( ( $flags & self
::READ_LATEST
) ? DB_MASTER
: DB_SLAVE
);
313 $rev = self
::loadFromConds( $db, $conditions, $flags );
314 // Make sure new pending/committed revision are visibile later on
315 // within web requests to certain avoid bugs like T93866 and T94407.
317 && !( $flags & self
::READ_LATEST
)
318 && wfGetLB()->getServerCount() > 1
319 && wfGetLB()->hasOrMadeRecentMasterChanges()
321 $flags = self
::READ_LATEST
;
322 $db = wfGetDB( DB_MASTER
);
323 $rev = self
::loadFromConds( $db, $conditions, $flags );
327 $rev->mQueryFlags
= $flags;
334 * Given a set of conditions, fetch a revision from
335 * the given database connection.
337 * @param IDatabase $db
338 * @param array $conditions
339 * @param int $flags (optional)
340 * @return Revision|null
342 private static function loadFromConds( $db, $conditions, $flags = 0 ) {
343 $row = self
::fetchFromConds( $db, $conditions, $flags );
345 return $row ?
new Revision( $row ) : null;
349 * Return a wrapper for a series of database rows to
350 * fetch all of a given page's revisions in turn.
351 * Each row can be fed to the constructor to get objects.
353 * @param LinkTarget $title
354 * @return ResultWrapper
355 * @deprecated Since 1.28
357 public static function fetchRevision( LinkTarget
$title ) {
358 $row = self
::fetchFromConds(
361 'rev_id=page_latest',
362 'page_namespace' => $title->getNamespace(),
363 'page_title' => $title->getDBkey()
367 return new FakeResultWrapper( $row ?
[ $row ] : [] );
371 * Given a set of conditions, return a ResultWrapper
372 * which will return matching database rows with the
373 * fields necessary to build Revision objects.
375 * @param IDatabase $db
376 * @param array $conditions
377 * @param int $flags (optional)
380 private static function fetchFromConds( $db, $conditions, $flags = 0 ) {
381 $fields = array_merge(
382 self
::selectFields(),
383 self
::selectPageFields(),
384 self
::selectUserFields()
387 if ( ( $flags & self
::READ_LOCKING
) == self
::READ_LOCKING
) {
388 $options[] = 'FOR UPDATE';
390 return $db->selectRow(
391 [ 'revision', 'page', 'user' ],
396 [ 'page' => self
::pageJoinCond(), 'user' => self
::userJoinCond() ]
401 * Return the value of a select() JOIN conds array for the user table.
402 * This will get user table rows for logged-in users.
406 public static function userJoinCond() {
407 return [ 'LEFT JOIN', [ 'rev_user != 0', 'user_id = rev_user' ] ];
411 * Return the value of a select() page conds array for the page table.
412 * This will assure that the revision(s) are not orphaned from live pages.
416 public static function pageJoinCond() {
417 return [ 'INNER JOIN', [ 'page_id = rev_page' ] ];
421 * Return the list of revision fields that should be selected to create
425 public static function selectFields() {
426 global $wgContentHandlerUseDB;
443 if ( $wgContentHandlerUseDB ) {
444 $fields[] = 'rev_content_format';
445 $fields[] = 'rev_content_model';
452 * Return the list of revision fields that should be selected to create
453 * a new revision from an archive row.
456 public static function selectArchiveFields() {
457 global $wgContentHandlerUseDB;
475 if ( $wgContentHandlerUseDB ) {
476 $fields[] = 'ar_content_format';
477 $fields[] = 'ar_content_model';
483 * Return the list of text fields that should be selected to read the
487 public static function selectTextFields() {
495 * Return the list of page fields that should be selected from page table
498 public static function selectPageFields() {
510 * Return the list of user fields that should be selected from user table
513 public static function selectUserFields() {
514 return [ 'user_name' ];
518 * Do a batched query to get the parent revision lengths
519 * @param IDatabase $db
520 * @param array $revIds
523 public static function getParentLengths( $db, array $revIds ) {
526 return $revLens; // empty
528 $res = $db->select( 'revision',
529 [ 'rev_id', 'rev_len' ],
530 [ 'rev_id' => $revIds ],
532 foreach ( $res as $row ) {
533 $revLens[$row->rev_id
] = $row->rev_len
;
541 * @param object|array $row Either a database row or an array
542 * @throws MWException
545 function __construct( $row ) {
546 if ( is_object( $row ) ) {
547 $this->mId
= intval( $row->rev_id
);
548 $this->mPage
= intval( $row->rev_page
);
549 $this->mTextId
= intval( $row->rev_text_id
);
550 $this->mComment
= $row->rev_comment
;
551 $this->mUser
= intval( $row->rev_user
);
552 $this->mMinorEdit
= intval( $row->rev_minor_edit
);
553 $this->mTimestamp
= $row->rev_timestamp
;
554 $this->mDeleted
= intval( $row->rev_deleted
);
556 if ( !isset( $row->rev_parent_id
) ) {
557 $this->mParentId
= null;
559 $this->mParentId
= intval( $row->rev_parent_id
);
562 if ( !isset( $row->rev_len
) ) {
565 $this->mSize
= intval( $row->rev_len
);
568 if ( !isset( $row->rev_sha1
) ) {
571 $this->mSha1
= $row->rev_sha1
;
574 if ( isset( $row->page_latest
) ) {
575 $this->mCurrent
= ( $row->rev_id
== $row->page_latest
);
576 $this->mTitle
= Title
::newFromRow( $row );
578 $this->mCurrent
= false;
579 $this->mTitle
= null;
582 if ( !isset( $row->rev_content_model
) ) {
583 $this->mContentModel
= null; # determine on demand if needed
585 $this->mContentModel
= strval( $row->rev_content_model
);
588 if ( !isset( $row->rev_content_format
) ) {
589 $this->mContentFormat
= null; # determine on demand if needed
591 $this->mContentFormat
= strval( $row->rev_content_format
);
594 // Lazy extraction...
596 if ( isset( $row->old_text
) ) {
597 $this->mTextRow
= $row;
599 // 'text' table row entry will be lazy-loaded
600 $this->mTextRow
= null;
603 // Use user_name for users and rev_user_text for IPs...
604 $this->mUserText
= null; // lazy load if left null
605 if ( $this->mUser
== 0 ) {
606 $this->mUserText
= $row->rev_user_text
; // IP user
607 } elseif ( isset( $row->user_name
) ) {
608 $this->mUserText
= $row->user_name
; // logged-in user
610 $this->mOrigUserText
= $row->rev_user_text
;
611 } elseif ( is_array( $row ) ) {
612 // Build a new revision to be saved...
613 global $wgUser; // ugh
615 # if we have a content object, use it to set the model and type
616 if ( !empty( $row['content'] ) ) {
617 // @todo when is that set? test with external store setup! check out insertOn() [dk]
618 if ( !empty( $row['text_id'] ) ) {
619 throw new MWException( "Text already stored in external store (id {$row['text_id']}), " .
620 "can't serialize content object" );
623 $row['content_model'] = $row['content']->getModel();
624 # note: mContentFormat is initializes later accordingly
625 # note: content is serialized later in this method!
626 # also set text to null?
629 $this->mId
= isset( $row['id'] ) ?
intval( $row['id'] ) : null;
630 $this->mPage
= isset( $row['page'] ) ?
intval( $row['page'] ) : null;
631 $this->mTextId
= isset( $row['text_id'] ) ?
intval( $row['text_id'] ) : null;
632 $this->mUserText
= isset( $row['user_text'] )
633 ?
strval( $row['user_text'] ) : $wgUser->getName();
634 $this->mUser
= isset( $row['user'] ) ?
intval( $row['user'] ) : $wgUser->getId();
635 $this->mMinorEdit
= isset( $row['minor_edit'] ) ?
intval( $row['minor_edit'] ) : 0;
636 $this->mTimestamp
= isset( $row['timestamp'] )
637 ?
strval( $row['timestamp'] ) : wfTimestampNow();
638 $this->mDeleted
= isset( $row['deleted'] ) ?
intval( $row['deleted'] ) : 0;
639 $this->mSize
= isset( $row['len'] ) ?
intval( $row['len'] ) : null;
640 $this->mParentId
= isset( $row['parent_id'] ) ?
intval( $row['parent_id'] ) : null;
641 $this->mSha1
= isset( $row['sha1'] ) ?
strval( $row['sha1'] ) : null;
643 $this->mContentModel
= isset( $row['content_model'] )
644 ?
strval( $row['content_model'] ) : null;
645 $this->mContentFormat
= isset( $row['content_format'] )
646 ?
strval( $row['content_format'] ) : null;
648 // Enforce spacing trimming on supplied text
649 $this->mComment
= isset( $row['comment'] ) ?
trim( strval( $row['comment'] ) ) : null;
650 $this->mText
= isset( $row['text'] ) ?
rtrim( strval( $row['text'] ) ) : null;
651 $this->mTextRow
= null;
653 $this->mTitle
= isset( $row['title'] ) ?
$row['title'] : null;
655 // if we have a Content object, override mText and mContentModel
656 if ( !empty( $row['content'] ) ) {
657 if ( !( $row['content'] instanceof Content
) ) {
658 throw new MWException( '`content` field must contain a Content object.' );
661 $handler = $this->getContentHandler();
662 $this->mContent
= $row['content'];
664 $this->mContentModel
= $this->mContent
->getModel();
665 $this->mContentHandler
= null;
667 $this->mText
= $handler->serializeContent( $row['content'], $this->getContentFormat() );
668 } elseif ( $this->mText
!== null ) {
669 $handler = $this->getContentHandler();
670 $this->mContent
= $handler->unserializeContent( $this->mText
);
673 // If we have a Title object, make sure it is consistent with mPage.
674 if ( $this->mTitle
&& $this->mTitle
->exists() ) {
675 if ( $this->mPage
=== null ) {
676 // if the page ID wasn't known, set it now
677 $this->mPage
= $this->mTitle
->getArticleID();
678 } elseif ( $this->mTitle
->getArticleID() !== $this->mPage
) {
679 // Got different page IDs. This may be legit (e.g. during undeletion),
680 // but it seems worth mentioning it in the log.
681 wfDebug( "Page ID " . $this->mPage
. " mismatches the ID " .
682 $this->mTitle
->getArticleID() . " provided by the Title object." );
686 $this->mCurrent
= false;
688 // If we still have no length, see it we have the text to figure it out
689 if ( !$this->mSize
&& $this->mContent
!== null ) {
690 $this->mSize
= $this->mContent
->getSize();
694 if ( $this->mSha1
=== null ) {
695 $this->mSha1
= $this->mText
=== null ?
null : self
::base36Sha1( $this->mText
);
699 $this->getContentModel();
700 $this->getContentFormat();
702 throw new MWException( 'Revision constructor passed invalid row format.' );
704 $this->mUnpatrolled
= null;
712 public function getId() {
717 * Set the revision ID
719 * This should only be used for proposed revisions that turn out to be null edits
724 public function setId( $id ) {
725 $this->mId
= (int)$id;
729 * Set the user ID/name
731 * This should only be used for proposed revisions that turn out to be null edits
734 * @param integer $id User ID
735 * @param string $name User name
737 public function setUserIdAndName( $id, $name ) {
738 $this->mUser
= (int)$id;
739 $this->mUserText
= $name;
740 $this->mOrigUserText
= $name;
748 public function getTextId() {
749 return $this->mTextId
;
753 * Get parent revision ID (the original previous page revision)
757 public function getParentId() {
758 return $this->mParentId
;
762 * Returns the length of the text in this revision, or null if unknown.
766 public function getSize() {
771 * Returns the base36 sha1 of the text in this revision, or null if unknown.
773 * @return string|null
775 public function getSha1() {
780 * Returns the title of the page associated with this entry or null.
782 * Will do a query, when title is not set and id is given.
786 public function getTitle() {
787 if ( $this->mTitle
!== null ) {
788 return $this->mTitle
;
790 // rev_id is defined as NOT NULL, but this revision may not yet have been inserted.
791 if ( $this->mId
!== null ) {
792 $dbr = wfGetDB( DB_SLAVE
);
793 $row = $dbr->selectRow(
794 [ 'page', 'revision' ],
795 self
::selectPageFields(),
796 [ 'page_id=rev_page',
797 'rev_id' => $this->mId
],
800 $this->mTitle
= Title
::newFromRow( $row );
804 if ( !$this->mTitle
&& $this->mPage
!== null && $this->mPage
> 0 ) {
805 $this->mTitle
= Title
::newFromID( $this->mPage
);
808 return $this->mTitle
;
812 * Set the title of the revision
814 * @param Title $title
816 public function setTitle( $title ) {
817 $this->mTitle
= $title;
825 public function getPage() {
830 * Fetch revision's user id if it's available to the specified audience.
831 * If the specified audience does not have access to it, zero will be
834 * @param int $audience One of:
835 * Revision::FOR_PUBLIC to be displayed to all users
836 * Revision::FOR_THIS_USER to be displayed to the given user
837 * Revision::RAW get the ID regardless of permissions
838 * @param User $user User object to check for, only if FOR_THIS_USER is passed
839 * to the $audience parameter
842 public function getUser( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
843 if ( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_USER
) ) {
845 } elseif ( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_USER
, $user ) ) {
853 * Fetch revision's user id without regard for the current user's permissions
856 * @deprecated since 1.25, use getUser( Revision::RAW )
858 public function getRawUser() {
859 wfDeprecated( __METHOD__
, '1.25' );
860 return $this->getUser( self
::RAW
);
864 * Fetch revision's username if it's available to the specified audience.
865 * If the specified audience does not have access to the username, an
866 * empty string will be returned.
868 * @param int $audience One of:
869 * Revision::FOR_PUBLIC to be displayed to all users
870 * Revision::FOR_THIS_USER to be displayed to the given user
871 * Revision::RAW get the text regardless of permissions
872 * @param User $user User object to check for, only if FOR_THIS_USER is passed
873 * to the $audience parameter
876 public function getUserText( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
877 if ( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_USER
) ) {
879 } elseif ( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_USER
, $user ) ) {
882 if ( $this->mUserText
=== null ) {
883 $this->mUserText
= User
::whoIs( $this->mUser
); // load on demand
884 if ( $this->mUserText
=== false ) {
885 # This shouldn't happen, but it can if the wiki was recovered
886 # via importing revs and there is no user table entry yet.
887 $this->mUserText
= $this->mOrigUserText
;
890 return $this->mUserText
;
895 * Fetch revision's username without regard for view restrictions
898 * @deprecated since 1.25, use getUserText( Revision::RAW )
900 public function getRawUserText() {
901 wfDeprecated( __METHOD__
, '1.25' );
902 return $this->getUserText( self
::RAW
);
906 * Fetch revision comment if it's available to the specified audience.
907 * If the specified audience does not have access to the comment, an
908 * empty string will be returned.
910 * @param int $audience One of:
911 * Revision::FOR_PUBLIC to be displayed to all users
912 * Revision::FOR_THIS_USER to be displayed to the given user
913 * Revision::RAW get the text regardless of permissions
914 * @param User $user User object to check for, only if FOR_THIS_USER is passed
915 * to the $audience parameter
918 function getComment( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
919 if ( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_COMMENT
) ) {
921 } elseif ( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_COMMENT
, $user ) ) {
924 return $this->mComment
;
929 * Fetch revision comment without regard for the current user's permissions
932 * @deprecated since 1.25, use getComment( Revision::RAW )
934 public function getRawComment() {
935 wfDeprecated( __METHOD__
, '1.25' );
936 return $this->getComment( self
::RAW
);
942 public function isMinor() {
943 return (bool)$this->mMinorEdit
;
947 * @return int Rcid of the unpatrolled row, zero if there isn't one
949 public function isUnpatrolled() {
950 if ( $this->mUnpatrolled
!== null ) {
951 return $this->mUnpatrolled
;
953 $rc = $this->getRecentChange();
954 if ( $rc && $rc->getAttribute( 'rc_patrolled' ) == 0 ) {
955 $this->mUnpatrolled
= $rc->getAttribute( 'rc_id' );
957 $this->mUnpatrolled
= 0;
959 return $this->mUnpatrolled
;
963 * Get the RC object belonging to the current revision, if there's one
965 * @param int $flags (optional) $flags include:
966 * Revision::READ_LATEST : Select the data from the master
969 * @return RecentChange|null
971 public function getRecentChange( $flags = 0 ) {
972 $dbr = wfGetDB( DB_SLAVE
);
974 list( $dbType, ) = DBAccessObjectUtils
::getDBOptions( $flags );
976 return RecentChange
::newFromConds(
978 'rc_user_text' => $this->getUserText( Revision
::RAW
),
979 'rc_timestamp' => $dbr->timestamp( $this->getTimestamp() ),
980 'rc_this_oldid' => $this->getId()
988 * @param int $field One of DELETED_* bitfield constants
992 public function isDeleted( $field ) {
993 return ( $this->mDeleted
& $field ) == $field;
997 * Get the deletion bitfield of the revision
1001 public function getVisibility() {
1002 return (int)$this->mDeleted
;
1006 * Fetch revision text if it's available to the specified audience.
1007 * If the specified audience does not have the ability to view this
1008 * revision, an empty string will be returned.
1010 * @param int $audience One of:
1011 * Revision::FOR_PUBLIC to be displayed to all users
1012 * Revision::FOR_THIS_USER to be displayed to the given user
1013 * Revision::RAW get the text regardless of permissions
1014 * @param User $user User object to check for, only if FOR_THIS_USER is passed
1015 * to the $audience parameter
1017 * @deprecated since 1.21, use getContent() instead
1018 * @todo Replace usage in core
1021 public function getText( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
1022 ContentHandler
::deprecated( __METHOD__
, '1.21' );
1024 $content = $this->getContent( $audience, $user );
1025 return ContentHandler
::getContentText( $content ); # returns the raw content text, if applicable
1029 * Fetch revision content if it's available to the specified audience.
1030 * If the specified audience does not have the ability to view this
1031 * revision, null will be returned.
1033 * @param int $audience One of:
1034 * Revision::FOR_PUBLIC to be displayed to all users
1035 * Revision::FOR_THIS_USER to be displayed to $wgUser
1036 * Revision::RAW get the text regardless of permissions
1037 * @param User $user User object to check for, only if FOR_THIS_USER is passed
1038 * to the $audience parameter
1040 * @return Content|null
1042 public function getContent( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
1043 if ( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_TEXT
) ) {
1045 } elseif ( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_TEXT
, $user ) ) {
1048 return $this->getContentInternal();
1053 * Fetch original serialized data without regard for view restrictions
1058 public function getSerializedData() {
1059 if ( $this->mText
=== null ) {
1060 $this->mText
= $this->loadText();
1063 return $this->mText
;
1067 * Gets the content object for the revision (or null on failure).
1069 * Note that for mutable Content objects, each call to this method will return a
1073 * @return Content|null The Revision's content, or null on failure.
1075 protected function getContentInternal() {
1076 if ( $this->mContent
=== null ) {
1077 // Revision is immutable. Load on demand:
1078 if ( $this->mText
=== null ) {
1079 $this->mText
= $this->loadText();
1082 if ( $this->mText
!== null && $this->mText
!== false ) {
1083 // Unserialize content
1084 $handler = $this->getContentHandler();
1085 $format = $this->getContentFormat();
1087 $this->mContent
= $handler->unserializeContent( $this->mText
, $format );
1091 // NOTE: copy() will return $this for immutable content objects
1092 return $this->mContent ?
$this->mContent
->copy() : null;
1096 * Returns the content model for this revision.
1098 * If no content model was stored in the database, the default content model for the title is
1099 * used to determine the content model to use. If no title is know, CONTENT_MODEL_WIKITEXT
1100 * is used as a last resort.
1102 * @return string The content model id associated with this revision,
1103 * see the CONTENT_MODEL_XXX constants.
1105 public function getContentModel() {
1106 if ( !$this->mContentModel
) {
1107 $title = $this->getTitle();
1109 $this->mContentModel
= ContentHandler
::getDefaultModelFor( $title );
1111 $this->mContentModel
= CONTENT_MODEL_WIKITEXT
;
1114 assert( !empty( $this->mContentModel
) );
1117 return $this->mContentModel
;
1121 * Returns the content format for this revision.
1123 * If no content format was stored in the database, the default format for this
1124 * revision's content model is returned.
1126 * @return string The content format id associated with this revision,
1127 * see the CONTENT_FORMAT_XXX constants.
1129 public function getContentFormat() {
1130 if ( !$this->mContentFormat
) {
1131 $handler = $this->getContentHandler();
1132 $this->mContentFormat
= $handler->getDefaultFormat();
1134 assert( !empty( $this->mContentFormat
) );
1137 return $this->mContentFormat
;
1141 * Returns the content handler appropriate for this revision's content model.
1143 * @throws MWException
1144 * @return ContentHandler
1146 public function getContentHandler() {
1147 if ( !$this->mContentHandler
) {
1148 $model = $this->getContentModel();
1149 $this->mContentHandler
= ContentHandler
::getForModelID( $model );
1151 $format = $this->getContentFormat();
1153 if ( !$this->mContentHandler
->isSupportedFormat( $format ) ) {
1154 throw new MWException( "Oops, the content format $format is not supported for "
1155 . "this content model, $model" );
1159 return $this->mContentHandler
;
1165 public function getTimestamp() {
1166 return wfTimestamp( TS_MW
, $this->mTimestamp
);
1172 public function isCurrent() {
1173 return $this->mCurrent
;
1177 * Get previous revision for this title
1179 * @return Revision|null
1181 public function getPrevious() {
1182 if ( $this->getTitle() ) {
1183 $prev = $this->getTitle()->getPreviousRevisionID( $this->getId() );
1185 return self
::newFromTitle( $this->getTitle(), $prev );
1192 * Get next revision for this title
1194 * @return Revision|null
1196 public function getNext() {
1197 if ( $this->getTitle() ) {
1198 $next = $this->getTitle()->getNextRevisionID( $this->getId() );
1200 return self
::newFromTitle( $this->getTitle(), $next );
1207 * Get previous revision Id for this page_id
1208 * This is used to populate rev_parent_id on save
1210 * @param IDatabase $db
1213 private function getPreviousRevisionId( $db ) {
1214 if ( $this->mPage
=== null ) {
1217 # Use page_latest if ID is not given
1218 if ( !$this->mId
) {
1219 $prevId = $db->selectField( 'page', 'page_latest',
1220 [ 'page_id' => $this->mPage
],
1223 $prevId = $db->selectField( 'revision', 'rev_id',
1224 [ 'rev_page' => $this->mPage
, 'rev_id < ' . $this->mId
],
1226 [ 'ORDER BY' => 'rev_id DESC' ] );
1228 return intval( $prevId );
1232 * Get revision text associated with an old or archive row
1233 * $row is usually an object from wfFetchRow(), both the flags and the text
1234 * field must be included.
1236 * @param stdClass $row The text data
1237 * @param string $prefix Table prefix (default 'old_')
1238 * @param string|bool $wiki The name of the wiki to load the revision text from
1239 * (same as the the wiki $row was loaded from) or false to indicate the local
1240 * wiki (this is the default). Otherwise, it must be a symbolic wiki database
1241 * identifier as understood by the LoadBalancer class.
1242 * @return string Text the text requested or false on failure
1244 public static function getRevisionText( $row, $prefix = 'old_', $wiki = false ) {
1247 $textField = $prefix . 'text';
1248 $flagsField = $prefix . 'flags';
1250 if ( isset( $row->$flagsField ) ) {
1251 $flags = explode( ',', $row->$flagsField );
1256 if ( isset( $row->$textField ) ) {
1257 $text = $row->$textField;
1262 # Use external methods for external objects, text in table is URL-only then
1263 if ( in_array( 'external', $flags ) ) {
1265 $parts = explode( '://', $url, 2 );
1266 if ( count( $parts ) == 1 ||
$parts[1] == '' ) {
1269 $text = ExternalStore
::fetchFromURL( $url, [ 'wiki' => $wiki ] );
1272 // If the text was fetched without an error, convert it
1273 if ( $text !== false ) {
1274 $text = self
::decompressRevisionText( $text, $flags );
1280 * If $wgCompressRevisions is enabled, we will compress data.
1281 * The input string is modified in place.
1282 * Return value is the flags field: contains 'gzip' if the
1283 * data is compressed, and 'utf-8' if we're saving in UTF-8
1286 * @param mixed $text Reference to a text
1289 public static function compressRevisionText( &$text ) {
1290 global $wgCompressRevisions;
1293 # Revisions not marked this way will be converted
1294 # on load if $wgLegacyCharset is set in the future.
1297 if ( $wgCompressRevisions ) {
1298 if ( function_exists( 'gzdeflate' ) ) {
1299 $deflated = gzdeflate( $text );
1301 if ( $deflated === false ) {
1302 wfLogWarning( __METHOD__
. ': gzdeflate() failed' );
1308 wfDebug( __METHOD__
. " -- no zlib support, not compressing\n" );
1311 return implode( ',', $flags );
1315 * Re-converts revision text according to it's flags.
1317 * @param mixed $text Reference to a text
1318 * @param array $flags Compression flags
1319 * @return string|bool Decompressed text, or false on failure
1321 public static function decompressRevisionText( $text, $flags ) {
1322 if ( in_array( 'gzip', $flags ) ) {
1323 # Deal with optional compression of archived pages.
1324 # This can be done periodically via maintenance/compressOld.php, and
1325 # as pages are saved if $wgCompressRevisions is set.
1326 $text = gzinflate( $text );
1328 if ( $text === false ) {
1329 wfLogWarning( __METHOD__
. ': gzinflate() failed' );
1334 if ( in_array( 'object', $flags ) ) {
1335 # Generic compressed storage
1336 $obj = unserialize( $text );
1337 if ( !is_object( $obj ) ) {
1341 $text = $obj->getText();
1344 global $wgLegacyEncoding;
1345 if ( $text !== false && $wgLegacyEncoding
1346 && !in_array( 'utf-8', $flags ) && !in_array( 'utf8', $flags )
1348 # Old revisions kept around in a legacy encoding?
1349 # Upconvert on demand.
1350 # ("utf8" checked for compatibility with some broken
1351 # conversion scripts 2008-12-30)
1353 $text = $wgContLang->iconv( $wgLegacyEncoding, 'UTF-8', $text );
1360 * Insert a new revision into the database, returning the new revision ID
1361 * number on success and dies horribly on failure.
1363 * @param IDatabase $dbw (master connection)
1364 * @throws MWException
1367 public function insertOn( $dbw ) {
1368 global $wgDefaultExternalStore, $wgContentHandlerUseDB;
1370 // Not allowed to have rev_page equal to 0, false, etc.
1371 if ( !$this->mPage
) {
1372 $title = $this->getTitle();
1373 if ( $title instanceof Title
) {
1374 $titleText = ' for page ' . $title->getPrefixedText();
1378 throw new MWException( "Cannot insert revision$titleText: page ID must be nonzero" );
1381 $this->checkContentModel();
1383 $data = $this->mText
;
1384 $flags = self
::compressRevisionText( $data );
1386 # Write to external storage if required
1387 if ( $wgDefaultExternalStore ) {
1388 // Store and get the URL
1389 $data = ExternalStore
::insertToDefault( $data );
1391 throw new MWException( "Unable to store text to external storage" );
1396 $flags .= 'external';
1399 # Record the text (or external storage URL) to the text table
1400 if ( $this->mTextId
=== null ) {
1401 $old_id = $dbw->nextSequenceValue( 'text_old_id_seq' );
1402 $dbw->insert( 'text',
1404 'old_id' => $old_id,
1405 'old_text' => $data,
1406 'old_flags' => $flags,
1409 $this->mTextId
= $dbw->insertId();
1412 if ( $this->mComment
=== null ) {
1413 $this->mComment
= "";
1416 # Record the edit in revisions
1417 $rev_id = $this->mId
!== null
1419 : $dbw->nextSequenceValue( 'revision_rev_id_seq' );
1421 'rev_id' => $rev_id,
1422 'rev_page' => $this->mPage
,
1423 'rev_text_id' => $this->mTextId
,
1424 'rev_comment' => $this->mComment
,
1425 'rev_minor_edit' => $this->mMinorEdit ?
1 : 0,
1426 'rev_user' => $this->mUser
,
1427 'rev_user_text' => $this->mUserText
,
1428 'rev_timestamp' => $dbw->timestamp( $this->mTimestamp
),
1429 'rev_deleted' => $this->mDeleted
,
1430 'rev_len' => $this->mSize
,
1431 'rev_parent_id' => $this->mParentId
=== null
1432 ?
$this->getPreviousRevisionId( $dbw )
1434 'rev_sha1' => $this->mSha1
=== null
1435 ? Revision
::base36Sha1( $this->mText
)
1439 if ( $wgContentHandlerUseDB ) {
1440 // NOTE: Store null for the default model and format, to save space.
1441 // XXX: Makes the DB sensitive to changed defaults.
1442 // Make this behavior optional? Only in miser mode?
1444 $model = $this->getContentModel();
1445 $format = $this->getContentFormat();
1447 $title = $this->getTitle();
1449 if ( $title === null ) {
1450 throw new MWException( "Insufficient information to determine the title of the "
1451 . "revision's page!" );
1454 $defaultModel = ContentHandler
::getDefaultModelFor( $title );
1455 $defaultFormat = ContentHandler
::getForModelID( $defaultModel )->getDefaultFormat();
1457 $row['rev_content_model'] = ( $model === $defaultModel ) ?
null : $model;
1458 $row['rev_content_format'] = ( $format === $defaultFormat ) ?
null : $format;
1461 $dbw->insert( 'revision', $row, __METHOD__
);
1463 $this->mId
= $rev_id !== null ?
$rev_id : $dbw->insertId();
1465 // Assertion to try to catch T92046
1466 if ( (int)$this->mId
=== 0 ) {
1467 throw new UnexpectedValueException(
1468 'After insert, Revision mId is ' . var_export( $this->mId
, 1 ) . ': ' .
1469 var_export( $row, 1 )
1473 Hooks
::run( 'RevisionInsertComplete', [ &$this, $data, $flags ] );
1478 protected function checkContentModel() {
1479 global $wgContentHandlerUseDB;
1481 // Note: may return null for revisions that have not yet been inserted
1482 $title = $this->getTitle();
1484 $model = $this->getContentModel();
1485 $format = $this->getContentFormat();
1486 $handler = $this->getContentHandler();
1488 if ( !$handler->isSupportedFormat( $format ) ) {
1489 $t = $title->getPrefixedDBkey();
1491 throw new MWException( "Can't use format $format with content model $model on $t" );
1494 if ( !$wgContentHandlerUseDB && $title ) {
1495 // if $wgContentHandlerUseDB is not set,
1496 // all revisions must use the default content model and format.
1498 $defaultModel = ContentHandler
::getDefaultModelFor( $title );
1499 $defaultHandler = ContentHandler
::getForModelID( $defaultModel );
1500 $defaultFormat = $defaultHandler->getDefaultFormat();
1502 if ( $this->getContentModel() != $defaultModel ) {
1503 $t = $title->getPrefixedDBkey();
1505 throw new MWException( "Can't save non-default content model with "
1506 . "\$wgContentHandlerUseDB disabled: model is $model, "
1507 . "default for $t is $defaultModel" );
1510 if ( $this->getContentFormat() != $defaultFormat ) {
1511 $t = $title->getPrefixedDBkey();
1513 throw new MWException( "Can't use non-default content format with "
1514 . "\$wgContentHandlerUseDB disabled: format is $format, "
1515 . "default for $t is $defaultFormat" );
1519 $content = $this->getContent( Revision
::RAW
);
1520 $prefixedDBkey = $title->getPrefixedDBkey();
1521 $revId = $this->mId
;
1524 throw new MWException(
1525 "Content of revision $revId ($prefixedDBkey) could not be loaded for validation!"
1528 if ( !$content->isValid() ) {
1529 throw new MWException(
1530 "Content of revision $revId ($prefixedDBkey) is not valid! Content model is $model"
1536 * Get the base 36 SHA-1 value for a string of text
1537 * @param string $text
1540 public static function base36Sha1( $text ) {
1541 return Wikimedia\base_convert
( sha1( $text ), 16, 36, 31 );
1545 * Lazy-load the revision's text.
1546 * Currently hardcoded to the 'text' table storage engine.
1548 * @return string|bool The revision's text, or false on failure
1550 protected function loadText() {
1551 // Caching may be beneficial for massive use of external storage
1552 global $wgRevisionCacheExpiry;
1553 static $processCache = null;
1555 if ( !$processCache ) {
1556 $processCache = new MapCacheLRU( 10 );
1559 $cache = ObjectCache
::getMainWANInstance();
1560 $textId = $this->getTextId();
1561 $key = wfMemcKey( 'revisiontext', 'textid', $textId );
1563 if ( $wgRevisionCacheExpiry ) {
1564 if ( $processCache->has( $key ) ) {
1565 return $processCache->get( $key );
1567 $text = $cache->get( $key );
1568 if ( is_string( $text ) ) {
1569 $processCache->set( $key, $text );
1574 // If we kept data for lazy extraction, use it now...
1575 if ( $this->mTextRow
!== null ) {
1576 $row = $this->mTextRow
;
1577 $this->mTextRow
= null;
1583 // Text data is immutable; check slaves first.
1584 $dbr = wfGetDB( DB_SLAVE
);
1585 $row = $dbr->selectRow( 'text',
1586 [ 'old_text', 'old_flags' ],
1587 [ 'old_id' => $textId ],
1591 // Fallback to the master in case of slave lag. Also use FOR UPDATE if it was
1592 // used to fetch this revision to avoid missing the row due to REPEATABLE-READ.
1593 $forUpdate = ( $this->mQueryFlags
& self
::READ_LOCKING
== self
::READ_LOCKING
);
1594 if ( !$row && ( $forUpdate ||
wfGetLB()->getServerCount() > 1 ) ) {
1595 $dbw = wfGetDB( DB_MASTER
);
1596 $row = $dbw->selectRow( 'text',
1597 [ 'old_text', 'old_flags' ],
1598 [ 'old_id' => $textId ],
1600 $forUpdate ?
[ 'FOR UPDATE' ] : [] );
1604 wfDebugLog( 'Revision', "No text row with ID '$textId' (revision {$this->getId()})." );
1607 $text = self
::getRevisionText( $row );
1608 if ( $row && $text === false ) {
1609 wfDebugLog( 'Revision', "No blob for text row '$textId' (revision {$this->getId()})." );
1612 # No negative caching -- negative hits on text rows may be due to corrupted slave servers
1613 if ( $wgRevisionCacheExpiry && $text !== false ) {
1614 $processCache->set( $key, $text );
1615 $cache->set( $key, $text, $wgRevisionCacheExpiry );
1622 * Create a new null-revision for insertion into a page's
1623 * history. This will not re-save the text, but simply refer
1624 * to the text from the previous version.
1626 * Such revisions can for instance identify page rename
1627 * operations and other such meta-modifications.
1629 * @param IDatabase $dbw
1630 * @param int $pageId ID number of the page to read from
1631 * @param string $summary Revision's summary
1632 * @param bool $minor Whether the revision should be considered as minor
1633 * @param User|null $user User object to use or null for $wgUser
1634 * @return Revision|null Revision or null on error
1636 public static function newNullRevision( $dbw, $pageId, $summary, $minor, $user = null ) {
1637 global $wgContentHandlerUseDB, $wgContLang;
1639 $fields = [ 'page_latest', 'page_namespace', 'page_title',
1640 'rev_text_id', 'rev_len', 'rev_sha1' ];
1642 if ( $wgContentHandlerUseDB ) {
1643 $fields[] = 'rev_content_model';
1644 $fields[] = 'rev_content_format';
1647 $current = $dbw->selectRow(
1648 [ 'page', 'revision' ],
1651 'page_id' => $pageId,
1652 'page_latest=rev_id',
1655 [ 'FOR UPDATE' ] // T51581
1664 // Truncate for whole multibyte characters
1665 $summary = $wgContLang->truncate( $summary, 255 );
1669 'user_text' => $user->getName(),
1670 'user' => $user->getId(),
1671 'comment' => $summary,
1672 'minor_edit' => $minor,
1673 'text_id' => $current->rev_text_id
,
1674 'parent_id' => $current->page_latest
,
1675 'len' => $current->rev_len
,
1676 'sha1' => $current->rev_sha1
1679 if ( $wgContentHandlerUseDB ) {
1680 $row['content_model'] = $current->rev_content_model
;
1681 $row['content_format'] = $current->rev_content_format
;
1684 $row['title'] = Title
::makeTitle( $current->page_namespace
, $current->page_title
);
1686 $revision = new Revision( $row );
1695 * Determine if the current user is allowed to view a particular
1696 * field of this revision, if it's marked as deleted.
1698 * @param int $field One of self::DELETED_TEXT,
1699 * self::DELETED_COMMENT,
1700 * self::DELETED_USER
1701 * @param User|null $user User object to check, or null to use $wgUser
1704 public function userCan( $field, User
$user = null ) {
1705 return self
::userCanBitfield( $this->mDeleted
, $field, $user );
1709 * Determine if the current user is allowed to view a particular
1710 * field of this revision, if it's marked as deleted. This is used
1711 * by various classes to avoid duplication.
1713 * @param int $bitfield Current field
1714 * @param int $field One of self::DELETED_TEXT = File::DELETED_FILE,
1715 * self::DELETED_COMMENT = File::DELETED_COMMENT,
1716 * self::DELETED_USER = File::DELETED_USER
1717 * @param User|null $user User object to check, or null to use $wgUser
1718 * @param Title|null $title A Title object to check for per-page restrictions on,
1719 * instead of just plain userrights
1722 public static function userCanBitfield( $bitfield, $field, User
$user = null,
1725 if ( $bitfield & $field ) { // aspect is deleted
1726 if ( $user === null ) {
1730 if ( $bitfield & self
::DELETED_RESTRICTED
) {
1731 $permissions = [ 'suppressrevision', 'viewsuppressed' ];
1732 } elseif ( $field & self
::DELETED_TEXT
) {
1733 $permissions = [ 'deletedtext' ];
1735 $permissions = [ 'deletedhistory' ];
1737 $permissionlist = implode( ', ', $permissions );
1738 if ( $title === null ) {
1739 wfDebug( "Checking for $permissionlist due to $field match on $bitfield\n" );
1740 return call_user_func_array( [ $user, 'isAllowedAny' ], $permissions );
1742 $text = $title->getPrefixedText();
1743 wfDebug( "Checking for $permissionlist on $text due to $field match on $bitfield\n" );
1744 foreach ( $permissions as $perm ) {
1745 if ( $title->userCan( $perm, $user ) ) {
1757 * Get rev_timestamp from rev_id, without loading the rest of the row
1759 * @param Title $title
1761 * @return string|bool False if not found
1763 static function getTimestampFromId( $title, $id, $flags = 0 ) {
1764 $db = ( $flags & self
::READ_LATEST
)
1765 ?
wfGetDB( DB_MASTER
)
1766 : wfGetDB( DB_SLAVE
);
1767 // Casting fix for databases that can't take '' for rev_id
1771 $conds = [ 'rev_id' => $id ];
1772 $conds['rev_page'] = $title->getArticleID();
1773 $timestamp = $db->selectField( 'revision', 'rev_timestamp', $conds, __METHOD__
);
1775 return ( $timestamp !== false ) ?
wfTimestamp( TS_MW
, $timestamp ) : false;
1779 * Get count of revisions per page...not very efficient
1781 * @param IDatabase $db
1782 * @param int $id Page id
1785 static function countByPageId( $db, $id ) {
1786 $row = $db->selectRow( 'revision', [ 'revCount' => 'COUNT(*)' ],
1787 [ 'rev_page' => $id ], __METHOD__
);
1789 return $row->revCount
;
1795 * Get count of revisions per page...not very efficient
1797 * @param IDatabase $db
1798 * @param Title $title
1801 static function countByTitle( $db, $title ) {
1802 $id = $title->getArticleID();
1804 return self
::countByPageId( $db, $id );
1810 * Check if no edits were made by other users since
1811 * the time a user started editing the page. Limit to
1812 * 50 revisions for the sake of performance.
1815 * @deprecated since 1.24
1817 * @param IDatabase|int $db The Database to perform the check on. May be given as a
1818 * Database object or a database identifier usable with wfGetDB.
1819 * @param int $pageId The ID of the page in question
1820 * @param int $userId The ID of the user in question
1821 * @param string $since Look at edits since this time
1823 * @return bool True if the given user was the only one to edit since the given timestamp
1825 public static function userWasLastToEdit( $db, $pageId, $userId, $since ) {
1830 if ( is_int( $db ) ) {
1831 $db = wfGetDB( $db );
1834 $res = $db->select( 'revision',
1837 'rev_page' => $pageId,
1838 'rev_timestamp > ' . $db->addQuotes( $db->timestamp( $since ) )
1841 [ 'ORDER BY' => 'rev_timestamp ASC', 'LIMIT' => 50 ] );
1842 foreach ( $res as $row ) {
1843 if ( $row->rev_user
!= $userId ) {