10 protected $mOrigUserText;
12 protected $mMinorEdit;
13 protected $mTimestamp;
23 protected $mContentModelName;
24 protected $mContentFormat;
26 protected $mContentHandler;
28 const DELETED_TEXT
= 1;
29 const DELETED_COMMENT
= 2;
30 const DELETED_USER
= 4;
31 const DELETED_RESTRICTED
= 8;
33 const SUPPRESSED_USER
= 12;
34 // Audience options for Revision::getText()
36 const FOR_THIS_USER
= 2;
40 * Load a page revision from a given revision ID number.
41 * Returns null if no such revision can be found.
44 * @return Revision or null
46 public static function newFromId( $id ) {
47 return Revision
::newFromConds( array( 'rev_id' => intval( $id ) ) );
51 * Load either the current, or a specified, revision
52 * that's attached to a given title. If not attached
53 * to that title, will return null.
56 * @param $id Integer (optional)
57 * @return Revision or null
59 public static function newFromTitle( $title, $id = 0 ) {
61 'page_namespace' => $title->getNamespace(),
62 'page_title' => $title->getDBkey()
65 // Use the specified ID
66 $conds['rev_id'] = $id;
67 } elseif ( wfGetLB()->getServerCount() > 1 ) {
68 // Get the latest revision ID from the master
69 $dbw = wfGetDB( DB_MASTER
);
70 $latest = $dbw->selectField( 'page', 'page_latest', $conds, __METHOD__
);
71 if ( $latest === false ) {
72 return null; // page does not exist
74 $conds['rev_id'] = $latest;
76 // Use a join to get the latest revision
77 $conds[] = 'rev_id=page_latest';
79 return Revision
::newFromConds( $conds );
83 * Load either the current, or a specified, revision
84 * that's attached to a given page ID.
85 * Returns null if no such revision can be found.
87 * @param $revId Integer
88 * @param $pageId Integer (optional)
89 * @return Revision or null
91 public static function newFromPageId( $pageId, $revId = 0 ) {
92 $conds = array( 'page_id' => $pageId );
94 $conds['rev_id'] = $revId;
95 } elseif ( wfGetLB()->getServerCount() > 1 ) {
96 // Get the latest revision ID from the master
97 $dbw = wfGetDB( DB_MASTER
);
98 $latest = $dbw->selectField( 'page', 'page_latest', $conds, __METHOD__
);
99 if ( $latest === false ) {
100 return null; // page does not exist
102 $conds['rev_id'] = $latest;
104 $conds[] = 'rev_id = page_latest';
106 return Revision
::newFromConds( $conds );
110 * Make a fake revision object from an archive table row. This is queried
111 * for permissions or even inserted (as in Special:Undelete)
112 * @todo FIXME: Should be a subclass for RevisionDelete. [TS]
115 * @param $overrides array
119 public static function newFromArchiveRow( $row, $overrides = array() ) {
120 $attribs = $overrides +
array(
121 'page' => isset( $row->ar_page_id
) ?
$row->ar_page_id
: null,
122 'id' => isset( $row->ar_rev_id
) ?
$row->ar_rev_id
: null,
123 'comment' => $row->ar_comment
,
124 'user' => $row->ar_user
,
125 'user_text' => $row->ar_user_text
,
126 'timestamp' => $row->ar_timestamp
,
127 'minor_edit' => $row->ar_minor_edit
,
128 'text_id' => isset( $row->ar_text_id
) ?
$row->ar_text_id
: null,
129 'deleted' => $row->ar_deleted
,
130 'len' => $row->ar_len
,
131 'sha1' => isset( $row->ar_sha1
) ?
$row->ar_sha1
: null,
132 'content_model' => isset( $row->ar_content_model
) ?
$row->ar_content_model
: null,
133 'content_format' => isset( $row->ar_content_format
) ?
$row->ar_content_format
: null,
135 if ( isset( $row->ar_text
) && !$row->ar_text_id
) {
136 // Pre-1.5 ar_text row
137 $attribs['text'] = self
::getRevisionText( $row, 'ar_' );
138 if ( $attribs['text'] === false ) {
139 throw new MWException( 'Unable to load text from archive row (possibly bug 22624)' );
142 return new self( $attribs );
151 public static function newFromRow( $row ) {
152 return new self( $row );
156 * Load a page revision from a given revision ID number.
157 * Returns null if no such revision can be found.
159 * @param $db DatabaseBase
161 * @return Revision or null
163 public static function loadFromId( $db, $id ) {
164 return Revision
::loadFromConds( $db, array( 'rev_id' => intval( $id ) ) );
168 * Load either the current, or a specified, revision
169 * that's attached to a given page. If not attached
170 * to that page, will return null.
172 * @param $db DatabaseBase
173 * @param $pageid Integer
175 * @return Revision or null
177 public static function loadFromPageId( $db, $pageid, $id = 0 ) {
178 $conds = array( 'rev_page' => intval( $pageid ), 'page_id' => intval( $pageid ) );
180 $conds['rev_id'] = intval( $id );
182 $conds[] = 'rev_id=page_latest';
184 return Revision
::loadFromConds( $db, $conds );
188 * Load either the current, or a specified, revision
189 * that's attached to a given page. If not attached
190 * to that page, will return null.
192 * @param $db DatabaseBase
193 * @param $title Title
195 * @return Revision or null
197 public static function loadFromTitle( $db, $title, $id = 0 ) {
199 $matchId = intval( $id );
201 $matchId = 'page_latest';
203 return Revision
::loadFromConds( $db,
204 array( "rev_id=$matchId",
205 'page_namespace' => $title->getNamespace(),
206 'page_title' => $title->getDBkey() )
211 * Load the revision for the given title with the given timestamp.
212 * WARNING: Timestamps may in some circumstances not be unique,
213 * so this isn't the best key to use.
215 * @param $db DatabaseBase
216 * @param $title Title
217 * @param $timestamp String
218 * @return Revision or null
220 public static function loadFromTimestamp( $db, $title, $timestamp ) {
221 return Revision
::loadFromConds( $db,
222 array( 'rev_timestamp' => $db->timestamp( $timestamp ),
223 'page_namespace' => $title->getNamespace(),
224 'page_title' => $title->getDBkey() )
229 * Given a set of conditions, fetch a revision.
231 * @param $conditions Array
232 * @return Revision or null
234 public static function newFromConds( $conditions ) {
235 $db = wfGetDB( DB_SLAVE
);
236 $rev = Revision
::loadFromConds( $db, $conditions );
237 if( is_null( $rev ) && wfGetLB()->getServerCount() > 1 ) {
238 $dbw = wfGetDB( DB_MASTER
);
239 $rev = Revision
::loadFromConds( $dbw, $conditions );
245 * Given a set of conditions, fetch a revision from
246 * the given database connection.
248 * @param $db DatabaseBase
249 * @param $conditions Array
250 * @return Revision or null
252 private static function loadFromConds( $db, $conditions ) {
253 $res = Revision
::fetchFromConds( $db, $conditions );
255 $row = $res->fetchObject();
257 $ret = new Revision( $row );
266 * Return a wrapper for a series of database rows to
267 * fetch all of a given page's revisions in turn.
268 * Each row can be fed to the constructor to get objects.
270 * @param $title Title
271 * @return ResultWrapper
273 public static function fetchRevision( $title ) {
274 return Revision
::fetchFromConds(
276 array( 'rev_id=page_latest',
277 'page_namespace' => $title->getNamespace(),
278 'page_title' => $title->getDBkey() )
283 * Given a set of conditions, return a ResultWrapper
284 * which will return matching database rows with the
285 * fields necessary to build Revision objects.
287 * @param $db DatabaseBase
288 * @param $conditions Array
289 * @return ResultWrapper
291 private static function fetchFromConds( $db, $conditions ) {
292 $fields = array_merge(
293 self
::selectFields(),
294 self
::selectPageFields(),
295 self
::selectUserFields()
298 array( 'revision', 'page', 'user' ),
302 array( 'LIMIT' => 1 ),
303 array( 'page' => self
::pageJoinCond(), 'user' => self
::userJoinCond() )
308 * Return the value of a select() JOIN conds array for the user table.
309 * This will get user table rows for logged-in users.
313 public static function userJoinCond() {
314 return array( 'LEFT JOIN', array( 'rev_user != 0', 'user_id = rev_user' ) );
318 * Return the value of a select() page conds array for the paeg table.
319 * This will assure that the revision(s) are not orphaned from live pages.
323 public static function pageJoinCond() {
324 return array( 'INNER JOIN', array( 'page_id = rev_page' ) );
328 * Return the list of revision fields that should be selected to create
331 public static function selectFields() {
345 'rev_content_format',
351 * Return the list of text fields that should be selected to read the
354 public static function selectTextFields() {
362 * Return the list of page fields that should be selected from page table
364 public static function selectPageFields() {
374 * Return the list of user fields that should be selected from user table
376 public static function selectUserFields() {
377 return array( 'user_name' );
383 * @param $row Mixed: either a database row or an array
386 function __construct( $row ) {
387 if( is_object( $row ) ) {
388 $this->mId
= intval( $row->rev_id
);
389 $this->mPage
= intval( $row->rev_page
);
390 $this->mTextId
= intval( $row->rev_text_id
);
391 $this->mComment
= $row->rev_comment
;
392 $this->mUser
= intval( $row->rev_user
);
393 $this->mMinorEdit
= intval( $row->rev_minor_edit
);
394 $this->mTimestamp
= $row->rev_timestamp
;
395 $this->mDeleted
= intval( $row->rev_deleted
);
397 if( !isset( $row->rev_parent_id
) ) {
398 $this->mParentId
= is_null( $row->rev_parent_id
) ?
null : 0;
400 $this->mParentId
= intval( $row->rev_parent_id
);
403 if( !isset( $row->rev_len
) ||
is_null( $row->rev_len
) ) {
406 $this->mSize
= intval( $row->rev_len
);
409 if ( !isset( $row->rev_sha1
) ) {
412 $this->mSha1
= $row->rev_sha1
;
415 if( isset( $row->page_latest
) ) {
416 $this->mCurrent
= ( $row->rev_id
== $row->page_latest
);
417 $this->mTitle
= Title
::newFromRow( $row );
419 $this->mCurrent
= false;
420 $this->mTitle
= null;
423 if( !isset( $row->rev_content_model
) ||
is_null( $row->rev_content_model
) ) {
424 $this->mContentModelName
= null; # determine on demand if needed
426 $this->mContentModelName
= strval( $row->rev_content_model
);
429 if( !isset( $row->rev_content_format
) ||
is_null( $row->rev_content_format
) ) {
430 $this->mContentFormat
= null; # determine on demand if needed
432 $this->mContentFormat
= strval( $row->rev_content_format
);
435 // Lazy extraction...
437 if( isset( $row->old_text
) ) {
438 $this->mTextRow
= $row;
440 // 'text' table row entry will be lazy-loaded
441 $this->mTextRow
= null;
444 // Use user_name for users and rev_user_text for IPs...
445 $this->mUserText
= null; // lazy load if left null
446 if ( $this->mUser
== 0 ) {
447 $this->mUserText
= $row->rev_user_text
; // IP user
448 } elseif ( isset( $row->user_name
) ) {
449 $this->mUserText
= $row->user_name
; // logged-in user
451 $this->mOrigUserText
= $row->rev_user_text
;
452 } elseif( is_array( $row ) ) {
453 // Build a new revision to be saved...
454 global $wgUser; // ugh
457 # if we have a content object, use it to set the model and type
458 if ( !empty( $row['content'] ) ) {
459 if ( !empty( $row['text_id'] ) ) { #FIXME: when is that set? test with external store setup! check out insertOn()
460 throw new MWException( "Text already stored in external store (id {$row['text_id']}), can't serialize content object" );
463 $row['content_model'] = $row['content']->getModelName();
464 # note: mContentFormat is initializes later accordingly
465 # note: content is serialized later in this method!
466 # also set text to null?
469 $this->mId
= isset( $row['id'] ) ?
intval( $row['id'] ) : null;
470 $this->mPage
= isset( $row['page'] ) ?
intval( $row['page'] ) : null;
471 $this->mTextId
= isset( $row['text_id'] ) ?
intval( $row['text_id'] ) : null;
472 $this->mUserText
= isset( $row['user_text'] ) ?
strval( $row['user_text'] ) : $wgUser->getName();
473 $this->mUser
= isset( $row['user'] ) ?
intval( $row['user'] ) : $wgUser->getId();
474 $this->mMinorEdit
= isset( $row['minor_edit'] ) ?
intval( $row['minor_edit'] ) : 0;
475 $this->mTimestamp
= isset( $row['timestamp'] ) ?
strval( $row['timestamp'] ) : wfTimestampNow();
476 $this->mDeleted
= isset( $row['deleted'] ) ?
intval( $row['deleted'] ) : 0;
477 $this->mSize
= isset( $row['len'] ) ?
intval( $row['len'] ) : null;
478 $this->mParentId
= isset( $row['parent_id'] ) ?
intval( $row['parent_id'] ) : null;
479 $this->mSha1
= isset( $row['sha1'] ) ?
strval( $row['sha1'] ) : null;
481 $this->mContentModelName
= isset( $row['content_model'] ) ?
strval( $row['content_model'] ) : null;
482 $this->mContentFormat
= isset( $row['content_format'] ) ?
strval( $row['content_format'] ) : null;
484 // Enforce spacing trimming on supplied text
485 $this->mComment
= isset( $row['comment'] ) ?
trim( strval( $row['comment'] ) ) : null;
486 $this->mText
= isset( $row['text'] ) ?
rtrim( strval( $row['text'] ) ) : null;
487 $this->mTextRow
= null;
489 $this->mTitle
= null; # Load on demand if needed
490 $this->mCurrent
= false;
491 # If we still have no length, see it we have the text to figure it out
492 if ( !$this->mSize
) {
493 #XXX: my be inconsistent with the notion of "size" use for the present content model
494 $this->mSize
= is_null( $this->mText
) ?
null : strlen( $this->mText
);
497 if ( $this->mSha1
=== null ) {
498 $this->mSha1
= is_null( $this->mText
) ?
null : self
::base36Sha1( $this->mText
);
501 $this->getContentModelName(); # force lazy init
502 $this->getContentFormat(); # force lazy init
504 # if we have a content object, serialize it, overriding mText
505 if ( !empty( $row['content'] ) ) {
506 $handler = $this->getContentHandler();
507 $this->mText
= $handler->serialize( $row['content'], $this->getContentFormat() );
510 throw new MWException( 'Revision constructor passed invalid row format.' );
512 $this->mUnpatrolled
= null;
514 #FIXME: add patch for ar_content_format, ar_content_model, rev_content_format, rev_content_model to installer
515 #FIXME: add support for ar_content_format, ar_content_model, rev_content_format, rev_content_model to API
523 public function getId() {
528 * Set the revision ID
533 public function setId( $id ) {
542 public function getTextId() {
543 return $this->mTextId
;
547 * Get parent revision ID (the original previous page revision)
551 public function getParentId() {
552 return $this->mParentId
;
556 * Returns the length of the text in this revision, or null if unknown.
560 public function getSize() {
565 * Returns the base36 sha1 of the text in this revision, or null if unknown.
569 public function getSha1() {
574 * Returns the title of the page associated with this entry.
578 public function getTitle() {
579 if( isset( $this->mTitle
) ) {
580 return $this->mTitle
;
582 $dbr = wfGetDB( DB_SLAVE
);
583 $row = $dbr->selectRow(
584 array( 'page', 'revision' ),
585 array( 'page_namespace', 'page_title' ),
586 array( 'page_id=rev_page',
587 'rev_id' => $this->mId
),
588 'Revision::getTitle' );
590 $this->mTitle
= Title
::makeTitle( $row->page_namespace
, $row->page_title
);
592 return $this->mTitle
;
596 * Set the title of the revision
598 * @param $title Title
600 public function setTitle( $title ) {
601 $this->mTitle
= $title;
609 public function getPage() {
614 * Fetch revision's user id if it's available to the specified audience.
615 * If the specified audience does not have access to it, zero will be
618 * @param $audience Integer: one of:
619 * Revision::FOR_PUBLIC to be displayed to all users
620 * Revision::FOR_THIS_USER to be displayed to $wgUser
621 * Revision::RAW get the ID regardless of permissions
622 * @param $user User object to check for, only if FOR_THIS_USER is passed
623 * to the $audience parameter
626 public function getUser( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
627 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_USER
) ) {
629 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_USER
, $user ) ) {
637 * Fetch revision's user id without regard for the current user's permissions
641 public function getRawUser() {
646 * Fetch revision's username if it's available to the specified audience.
647 * If the specified audience does not have access to the username, an
648 * empty string will be returned.
650 * @param $audience Integer: one of:
651 * Revision::FOR_PUBLIC to be displayed to all users
652 * Revision::FOR_THIS_USER to be displayed to $wgUser
653 * Revision::RAW get the text regardless of permissions
654 * @param $user User object to check for, only if FOR_THIS_USER is passed
655 * to the $audience parameter
658 public function getUserText( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
659 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_USER
) ) {
661 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_USER
, $user ) ) {
664 return $this->getRawUserText();
669 * Fetch revision's username without regard for view restrictions
673 public function getRawUserText() {
674 if ( $this->mUserText
=== null ) {
675 $this->mUserText
= User
::whoIs( $this->mUser
); // load on demand
676 if ( $this->mUserText
=== false ) {
677 # This shouldn't happen, but it can if the wiki was recovered
678 # via importing revs and there is no user table entry yet.
679 $this->mUserText
= $this->mOrigUserText
;
682 return $this->mUserText
;
686 * Fetch revision comment if it's available to the specified audience.
687 * If the specified audience does not have access to the comment, an
688 * empty string will be returned.
690 * @param $audience Integer: one of:
691 * Revision::FOR_PUBLIC to be displayed to all users
692 * Revision::FOR_THIS_USER to be displayed to $wgUser
693 * Revision::RAW get the text regardless of permissions
694 * @param $user User object to check for, only if FOR_THIS_USER is passed
695 * to the $audience parameter
698 function getComment( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
699 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_COMMENT
) ) {
701 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_COMMENT
, $user ) ) {
704 return $this->mComment
;
709 * Fetch revision comment without regard for the current user's permissions
713 public function getRawComment() {
714 return $this->mComment
;
720 public function isMinor() {
721 return (bool)$this->mMinorEdit
;
725 * @return Integer rcid of the unpatrolled row, zero if there isn't one
727 public function isUnpatrolled() {
728 if( $this->mUnpatrolled
!== null ) {
729 return $this->mUnpatrolled
;
731 $dbr = wfGetDB( DB_SLAVE
);
732 $this->mUnpatrolled
= $dbr->selectField( 'recentchanges',
734 array( // Add redundant user,timestamp condition so we can use the existing index
735 'rc_user_text' => $this->getRawUserText(),
736 'rc_timestamp' => $dbr->timestamp( $this->getTimestamp() ),
737 'rc_this_oldid' => $this->getId(),
742 return (int)$this->mUnpatrolled
;
746 * @param $field int one of DELETED_* bitfield constants
750 public function isDeleted( $field ) {
751 return ( $this->mDeleted
& $field ) == $field;
755 * Get the deletion bitfield of the revision
759 public function getVisibility() {
760 return (int)$this->mDeleted
;
764 * Fetch revision text if it's available to the specified audience.
765 * If the specified audience does not have the ability to view this
766 * revision, an empty string will be returned.
768 * @param $audience Integer: one of:
769 * Revision::FOR_PUBLIC to be displayed to all users
770 * Revision::FOR_THIS_USER to be displayed to $wgUser
771 * Revision::RAW get the text regardless of permissions
772 * @param $user User object to check for, only if FOR_THIS_USER is passed
773 * to the $audience parameter
775 * @deprectaed in 1.20, use getContent() instead
777 public function getText( $audience = self
::FOR_PUBLIC
, User
$user = null ) { #FIXME: deprecated, replace usage! #FIXME: used a LOT!
778 wfDeprecated( __METHOD__
, '1.20' );
780 $content = $this->getContent();
781 return ContentHandler
::getContentText( $content ); # returns the raw content text, if applicable
785 * Fetch revision content if it's available to the specified audience.
786 * If the specified audience does not have the ability to view this
787 * revision, null will be returned.
789 * @param $audience Integer: one of:
790 * Revision::FOR_PUBLIC to be displayed to all users
791 * Revision::FOR_THIS_USER to be displayed to $wgUser
792 * Revision::RAW get the text regardless of permissions
793 * @param $user User object to check for, only if FOR_THIS_USER is passed
794 * to the $audience parameter
797 public function getContent( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
798 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_TEXT
) ) {
800 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_TEXT
, $user ) ) {
803 return $this->getContentInternal();
808 * Alias for getText(Revision::FOR_THIS_USER)
810 * @deprecated since 1.17
813 public function revText() {
814 wfDeprecated( __METHOD__
, '1.17' );
815 return $this->getText( self
::FOR_THIS_USER
);
819 * Fetch revision text without regard for view restrictions
823 public function getRawText() { #FIXME: deprecated, replace usage!
824 return $this->getText( self
::RAW
);
827 protected function getContentInternal() {
828 if( is_null( $this->mContent
) ) {
829 // Revision is immutable. Load on demand:
831 $handler = $this->getContentHandler();
832 $format = $this->getContentFormat();
833 $title = $this->getTitle();
835 if( is_null( $this->mText
) ) {
836 // Load text on demand:
837 $this->mText
= $this->loadText();
840 $this->mContent
= is_null( $this->mText
) ?
null : $handler->unserialize( $this->mText
, $format );
843 return $this->mContent
;
846 public function getContentModelName() {
847 if ( !$this->mContentModelName
) {
848 $title = $this->getTitle();
849 $this->mContentModelName
= ( $title ?
$title->getContentModelName() : CONTENT_MODEL_WIKITEXT
);
852 return $this->mContentModelName
;
855 public function getContentFormat() {
856 if ( !$this->mContentFormat
) {
857 $handler = $this->getContentHandler();
858 $this->mContentFormat
= $handler->getDefaultFormat();
861 return $this->mContentFormat
;
864 public function getContentHandler() {
865 if ( !$this->mContentHandler
) {
866 $title = $this->getTitle();
868 if ( $title ) $model = $title->getContentModelName();
869 else $model = CONTENT_MODEL_WIKITEXT
;
871 $this->mContentHandler
= ContentHandler
::getForModelName( $model );
873 #XXX: do we need to verify that mContentHandler supports mContentFormat?
874 # otherwise, a fixed content format may cause problems on insert.
877 return $this->mContentHandler
;
883 public function getTimestamp() {
884 return wfTimestamp( TS_MW
, $this->mTimestamp
);
890 public function isCurrent() {
891 return $this->mCurrent
;
895 * Get previous revision for this title
897 * @return Revision or null
899 public function getPrevious() {
900 if( $this->getTitle() ) {
901 $prev = $this->getTitle()->getPreviousRevisionID( $this->getId() );
903 return Revision
::newFromTitle( $this->getTitle(), $prev );
910 * Get next revision for this title
912 * @return Revision or null
914 public function getNext() {
915 if( $this->getTitle() ) {
916 $next = $this->getTitle()->getNextRevisionID( $this->getId() );
918 return Revision
::newFromTitle( $this->getTitle(), $next );
925 * Get previous revision Id for this page_id
926 * This is used to populate rev_parent_id on save
928 * @param $db DatabaseBase
931 private function getPreviousRevisionId( $db ) {
932 if( is_null( $this->mPage
) ) {
935 # Use page_latest if ID is not given
937 $prevId = $db->selectField( 'page', 'page_latest',
938 array( 'page_id' => $this->mPage
),
941 $prevId = $db->selectField( 'revision', 'rev_id',
942 array( 'rev_page' => $this->mPage
, 'rev_id < ' . $this->mId
),
944 array( 'ORDER BY' => 'rev_id DESC' ) );
946 return intval( $prevId );
950 * Get revision text associated with an old or archive row
951 * $row is usually an object from wfFetchRow(), both the flags and the text
952 * field must be included
954 * @param $row Object: the text data
955 * @param $prefix String: table prefix (default 'old_')
956 * @return String: text the text requested or false on failure
958 public static function getRevisionText( $row, $prefix = 'old_' ) {
959 wfProfileIn( __METHOD__
);
962 $textField = $prefix . 'text';
963 $flagsField = $prefix . 'flags';
965 if( isset( $row->$flagsField ) ) {
966 $flags = explode( ',', $row->$flagsField );
971 if( isset( $row->$textField ) ) {
972 $text = $row->$textField;
974 wfProfileOut( __METHOD__
);
978 # Use external methods for external objects, text in table is URL-only then
979 if ( in_array( 'external', $flags ) ) {
981 $parts = explode( '://', $url, 2 );
982 if( count( $parts ) == 1 ||
$parts[1] == '' ) {
983 wfProfileOut( __METHOD__
);
986 $text = ExternalStore
::fetchFromURL( $url );
989 // If the text was fetched without an error, convert it
990 if ( $text !== false ) {
991 if( in_array( 'gzip', $flags ) ) {
992 # Deal with optional compression of archived pages.
993 # This can be done periodically via maintenance/compressOld.php, and
994 # as pages are saved if $wgCompressRevisions is set.
995 $text = gzinflate( $text );
998 if( in_array( 'object', $flags ) ) {
999 # Generic compressed storage
1000 $obj = unserialize( $text );
1001 if ( !is_object( $obj ) ) {
1003 wfProfileOut( __METHOD__
);
1006 $text = $obj->getText();
1009 global $wgLegacyEncoding;
1010 if( $text !== false && $wgLegacyEncoding
1011 && !in_array( 'utf-8', $flags ) && !in_array( 'utf8', $flags ) )
1013 # Old revisions kept around in a legacy encoding?
1014 # Upconvert on demand.
1015 # ("utf8" checked for compatibility with some broken
1016 # conversion scripts 2008-12-30)
1018 $text = $wgContLang->iconv( $wgLegacyEncoding, 'UTF-8', $text );
1021 wfProfileOut( __METHOD__
);
1026 * If $wgCompressRevisions is enabled, we will compress data.
1027 * The input string is modified in place.
1028 * Return value is the flags field: contains 'gzip' if the
1029 * data is compressed, and 'utf-8' if we're saving in UTF-8
1032 * @param $text Mixed: reference to a text
1035 public static function compressRevisionText( &$text ) {
1036 global $wgCompressRevisions;
1039 # Revisions not marked this way will be converted
1040 # on load if $wgLegacyCharset is set in the future.
1043 if( $wgCompressRevisions ) {
1044 if( function_exists( 'gzdeflate' ) ) {
1045 $text = gzdeflate( $text );
1048 wfDebug( "Revision::compressRevisionText() -- no zlib support, not compressing\n" );
1051 return implode( ',', $flags );
1055 * Insert a new revision into the database, returning the new revision ID
1056 * number on success and dies horribly on failure.
1058 * @param $dbw DatabaseBase: (master connection)
1061 public function insertOn( $dbw ) {
1062 global $wgDefaultExternalStore;
1064 wfProfileIn( __METHOD__
);
1066 $data = $this->mText
;
1067 $flags = Revision
::compressRevisionText( $data );
1069 # Write to external storage if required
1070 if( $wgDefaultExternalStore ) {
1071 // Store and get the URL
1072 $data = ExternalStore
::insertToDefault( $data );
1074 throw new MWException( "Unable to store text to external storage" );
1079 $flags .= 'external';
1082 # Record the text (or external storage URL) to the text table
1083 if( !isset( $this->mTextId
) ) {
1084 $old_id = $dbw->nextSequenceValue( 'text_old_id_seq' );
1085 $dbw->insert( 'text',
1087 'old_id' => $old_id,
1088 'old_text' => $data,
1089 'old_flags' => $flags,
1092 $this->mTextId
= $dbw->insertId();
1095 if ( $this->mComment
=== null ) $this->mComment
= "";
1097 # Record the edit in revisions
1098 $rev_id = isset( $this->mId
)
1100 : $dbw->nextSequenceValue( 'revision_rev_id_seq' );
1103 'rev_id' => $rev_id,
1104 'rev_page' => $this->mPage
,
1105 'rev_text_id' => $this->mTextId
,
1106 'rev_comment' => $this->mComment
,
1107 'rev_minor_edit' => $this->mMinorEdit ?
1 : 0,
1108 'rev_user' => $this->mUser
,
1109 'rev_user_text' => $this->mUserText
,
1110 'rev_timestamp' => $dbw->timestamp( $this->mTimestamp
),
1111 'rev_deleted' => $this->mDeleted
,
1112 'rev_len' => $this->mSize
,
1113 'rev_parent_id' => is_null( $this->mParentId
)
1114 ?
$this->getPreviousRevisionId( $dbw )
1116 'rev_sha1' => is_null( $this->mSha1
)
1117 ? Revision
::base36Sha1( $this->mText
)
1119 'rev_content_model' => $this->getContentModelName(),
1120 'rev_content_format' => $this->getContentFormat(),
1123 $dbw->insert( 'revision', $row, __METHOD__
);
1125 $this->mId
= !is_null( $rev_id ) ?
$rev_id : $dbw->insertId();
1127 wfRunHooks( 'RevisionInsertComplete', array( &$this, $data, $flags ) );
1129 wfProfileOut( __METHOD__
);
1134 * Get the base 36 SHA-1 value for a string of text
1135 * @param $text String
1138 public static function base36Sha1( $text ) {
1139 return wfBaseConvert( sha1( $text ), 16, 36, 31 );
1143 * Lazy-load the revision's text.
1144 * Currently hardcoded to the 'text' table storage engine.
1148 protected function loadText() {
1149 wfProfileIn( __METHOD__
);
1151 // Caching may be beneficial for massive use of external storage
1152 global $wgRevisionCacheExpiry, $wgMemc;
1153 $textId = $this->getTextId();
1154 $key = wfMemcKey( 'revisiontext', 'textid', $textId );
1155 if( $wgRevisionCacheExpiry ) {
1156 $text = $wgMemc->get( $key );
1157 if( is_string( $text ) ) {
1158 wfDebug( __METHOD__
. ": got id $textId from cache\n" );
1159 wfProfileOut( __METHOD__
);
1164 // If we kept data for lazy extraction, use it now...
1165 if ( isset( $this->mTextRow
) ) {
1166 $row = $this->mTextRow
;
1167 $this->mTextRow
= null;
1173 // Text data is immutable; check slaves first.
1174 $dbr = wfGetDB( DB_SLAVE
);
1175 $row = $dbr->selectRow( 'text',
1176 array( 'old_text', 'old_flags' ),
1177 array( 'old_id' => $this->getTextId() ),
1181 if( !$row && wfGetLB()->getServerCount() > 1 ) {
1182 // Possible slave lag!
1183 $dbw = wfGetDB( DB_MASTER
);
1184 $row = $dbw->selectRow( 'text',
1185 array( 'old_text', 'old_flags' ),
1186 array( 'old_id' => $this->getTextId() ),
1190 $text = self
::getRevisionText( $row );
1192 # No negative caching -- negative hits on text rows may be due to corrupted slave servers
1193 if( $wgRevisionCacheExpiry && $text !== false ) {
1194 $wgMemc->set( $key, $text, $wgRevisionCacheExpiry );
1197 wfProfileOut( __METHOD__
);
1203 * Create a new null-revision for insertion into a page's
1204 * history. This will not re-save the text, but simply refer
1205 * to the text from the previous version.
1207 * Such revisions can for instance identify page rename
1208 * operations and other such meta-modifications.
1210 * @param $dbw DatabaseBase
1211 * @param $pageId Integer: ID number of the page to read from
1212 * @param $summary String: revision's summary
1213 * @param $minor Boolean: whether the revision should be considered as minor
1214 * @return Revision|null on error
1216 public static function newNullRevision( $dbw, $pageId, $summary, $minor ) {
1217 wfProfileIn( __METHOD__
);
1219 $current = $dbw->selectRow(
1220 array( 'page', 'revision' ),
1221 array( 'page_latest', 'rev_text_id', 'rev_len', 'rev_sha1',
1222 'rev_content_model', 'rev_content_format' ),
1224 'page_id' => $pageId,
1225 'page_latest=rev_id',
1230 $revision = new Revision( array(
1232 'comment' => $summary,
1233 'minor_edit' => $minor,
1234 'text_id' => $current->rev_text_id
,
1235 'parent_id' => $current->page_latest
,
1236 'len' => $current->rev_len
,
1237 'sha1' => $current->rev_sha1
,
1238 'content_model' => $current->rev_content_model
,
1239 'content_format' => $current->rev_content_format
1245 wfProfileOut( __METHOD__
);
1250 * Determine if the current user is allowed to view a particular
1251 * field of this revision, if it's marked as deleted.
1253 * @param $field Integer:one of self::DELETED_TEXT,
1254 * self::DELETED_COMMENT,
1255 * self::DELETED_USER
1256 * @param $user User object to check, or null to use $wgUser
1259 public function userCan( $field, User
$user = null ) {
1260 return self
::userCanBitfield( $this->mDeleted
, $field, $user );
1264 * Determine if the current user is allowed to view a particular
1265 * field of this revision, if it's marked as deleted. This is used
1266 * by various classes to avoid duplication.
1268 * @param $bitfield Integer: current field
1269 * @param $field Integer: one of self::DELETED_TEXT = File::DELETED_FILE,
1270 * self::DELETED_COMMENT = File::DELETED_COMMENT,
1271 * self::DELETED_USER = File::DELETED_USER
1272 * @param $user User object to check, or null to use $wgUser
1275 public static function userCanBitfield( $bitfield, $field, User
$user = null ) {
1276 if( $bitfield & $field ) { // aspect is deleted
1277 if ( $bitfield & self
::DELETED_RESTRICTED
) {
1278 $permission = 'suppressrevision';
1279 } elseif ( $field & self
::DELETED_TEXT
) {
1280 $permission = 'deletedtext';
1282 $permission = 'deletedhistory';
1284 wfDebug( "Checking for $permission due to $field match on $bitfield\n" );
1285 if ( $user === null ) {
1289 return $user->isAllowed( $permission );
1296 * Get rev_timestamp from rev_id, without loading the rest of the row
1298 * @param $title Title
1299 * @param $id Integer
1302 static function getTimestampFromId( $title, $id ) {
1303 $dbr = wfGetDB( DB_SLAVE
);
1304 // Casting fix for DB2
1308 $conds = array( 'rev_id' => $id );
1309 $conds['rev_page'] = $title->getArticleId();
1310 $timestamp = $dbr->selectField( 'revision', 'rev_timestamp', $conds, __METHOD__
);
1311 if ( $timestamp === false && wfGetLB()->getServerCount() > 1 ) {
1312 # Not in slave, try master
1313 $dbw = wfGetDB( DB_MASTER
);
1314 $timestamp = $dbw->selectField( 'revision', 'rev_timestamp', $conds, __METHOD__
);
1316 return wfTimestamp( TS_MW
, $timestamp );
1320 * Get count of revisions per page...not very efficient
1322 * @param $db DatabaseBase
1323 * @param $id Integer: page id
1326 static function countByPageId( $db, $id ) {
1327 $row = $db->selectRow( 'revision', 'COUNT(*) AS revCount',
1328 array( 'rev_page' => $id ), __METHOD__
);
1330 return $row->revCount
;
1336 * Get count of revisions per page...not very efficient
1338 * @param $db DatabaseBase
1339 * @param $title Title
1342 static function countByTitle( $db, $title ) {
1343 $id = $title->getArticleId();
1345 return Revision
::countByPageId( $db, $id );