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
30 protected $mOrigUserText;
32 protected $mMinorEdit;
33 protected $mTimestamp;
44 const DELETED_TEXT
= 1;
45 const DELETED_COMMENT
= 2;
46 const DELETED_USER
= 4;
47 const DELETED_RESTRICTED
= 8;
49 const SUPPRESSED_USER
= 12;
50 // Audience options for Revision::getText()
52 const FOR_THIS_USER
= 2;
56 * Load a page revision from a given revision ID number.
57 * Returns null if no such revision can be found.
60 * @return Revision or null
62 public static function newFromId( $id ) {
63 return Revision
::newFromConds( array( 'rev_id' => intval( $id ) ) );
67 * Load either the current, or a specified, revision
68 * that's attached to a given title. If not attached
69 * to that title, will return null.
72 * @param $id Integer (optional)
73 * @return Revision or null
75 public static function newFromTitle( $title, $id = 0 ) {
77 'page_namespace' => $title->getNamespace(),
78 'page_title' => $title->getDBkey()
81 // Use the specified ID
82 $conds['rev_id'] = $id;
83 } elseif ( wfGetLB()->getServerCount() > 1 ) {
84 // Get the latest revision ID from the master
85 $dbw = wfGetDB( DB_MASTER
);
86 $latest = $dbw->selectField( 'page', 'page_latest', $conds, __METHOD__
);
87 if ( $latest === false ) {
88 return null; // page does not exist
90 $conds['rev_id'] = $latest;
92 // Use a join to get the latest revision
93 $conds[] = 'rev_id=page_latest';
95 return Revision
::newFromConds( $conds );
99 * Load either the current, or a specified, revision
100 * that's attached to a given page ID.
101 * Returns null if no such revision can be found.
103 * @param $revId Integer
104 * @param $pageId Integer (optional)
105 * @return Revision or null
107 public static function newFromPageId( $pageId, $revId = 0 ) {
108 $conds = array( 'page_id' => $pageId );
110 $conds['rev_id'] = $revId;
111 } elseif ( wfGetLB()->getServerCount() > 1 ) {
112 // Get the latest revision ID from the master
113 $dbw = wfGetDB( DB_MASTER
);
114 $latest = $dbw->selectField( 'page', 'page_latest', $conds, __METHOD__
);
115 if ( $latest === false ) {
116 return null; // page does not exist
118 $conds['rev_id'] = $latest;
120 $conds[] = 'rev_id = page_latest';
122 return Revision
::newFromConds( $conds );
126 * Make a fake revision object from an archive table row. This is queried
127 * for permissions or even inserted (as in Special:Undelete)
128 * @todo FIXME: Should be a subclass for RevisionDelete. [TS]
131 * @param $overrides array
135 public static function newFromArchiveRow( $row, $overrides = array() ) {
136 $attribs = $overrides +
array(
137 'page' => isset( $row->ar_page_id
) ?
$row->ar_page_id
: null,
138 'id' => isset( $row->ar_rev_id
) ?
$row->ar_rev_id
: null,
139 'comment' => $row->ar_comment
,
140 'user' => $row->ar_user
,
141 'user_text' => $row->ar_user_text
,
142 'timestamp' => $row->ar_timestamp
,
143 'minor_edit' => $row->ar_minor_edit
,
144 'text_id' => isset( $row->ar_text_id
) ?
$row->ar_text_id
: null,
145 'deleted' => $row->ar_deleted
,
146 'len' => $row->ar_len
,
147 'sha1' => isset( $row->ar_sha1
) ?
$row->ar_sha1
: null,
149 if ( isset( $row->ar_text
) && !$row->ar_text_id
) {
150 // Pre-1.5 ar_text row
151 $attribs['text'] = self
::getRevisionText( $row, 'ar_' );
152 if ( $attribs['text'] === false ) {
153 throw new MWException( 'Unable to load text from archive row (possibly bug 22624)' );
156 return new self( $attribs );
165 public static function newFromRow( $row ) {
166 return new self( $row );
170 * Load a page revision from a given revision ID number.
171 * Returns null if no such revision can be found.
173 * @param $db DatabaseBase
175 * @return Revision or null
177 public static function loadFromId( $db, $id ) {
178 return Revision
::loadFromConds( $db, array( 'rev_id' => intval( $id ) ) );
182 * Load either the current, or a specified, revision
183 * that's attached to a given page. If not attached
184 * to that page, will return null.
186 * @param $db DatabaseBase
187 * @param $pageid Integer
189 * @return Revision or null
191 public static function loadFromPageId( $db, $pageid, $id = 0 ) {
192 $conds = array( 'rev_page' => intval( $pageid ), 'page_id' => intval( $pageid ) );
194 $conds['rev_id'] = intval( $id );
196 $conds[] = 'rev_id=page_latest';
198 return Revision
::loadFromConds( $db, $conds );
202 * Load either the current, or a specified, revision
203 * that's attached to a given page. If not attached
204 * to that page, will return null.
206 * @param $db DatabaseBase
207 * @param $title Title
209 * @return Revision or null
211 public static function loadFromTitle( $db, $title, $id = 0 ) {
213 $matchId = intval( $id );
215 $matchId = 'page_latest';
217 return Revision
::loadFromConds( $db,
218 array( "rev_id=$matchId",
219 'page_namespace' => $title->getNamespace(),
220 'page_title' => $title->getDBkey() )
225 * Load the revision for the given title with the given timestamp.
226 * WARNING: Timestamps may in some circumstances not be unique,
227 * so this isn't the best key to use.
229 * @param $db DatabaseBase
230 * @param $title Title
231 * @param $timestamp String
232 * @return Revision or null
234 public static function loadFromTimestamp( $db, $title, $timestamp ) {
235 return Revision
::loadFromConds( $db,
236 array( 'rev_timestamp' => $db->timestamp( $timestamp ),
237 'page_namespace' => $title->getNamespace(),
238 'page_title' => $title->getDBkey() )
243 * Given a set of conditions, fetch a revision.
245 * @param $conditions Array
246 * @return Revision or null
248 public static function newFromConds( $conditions ) {
249 $db = wfGetDB( DB_SLAVE
);
250 $rev = Revision
::loadFromConds( $db, $conditions );
251 if( is_null( $rev ) && wfGetLB()->getServerCount() > 1 ) {
252 $dbw = wfGetDB( DB_MASTER
);
253 $rev = Revision
::loadFromConds( $dbw, $conditions );
259 * Given a set of conditions, fetch a revision from
260 * the given database connection.
262 * @param $db DatabaseBase
263 * @param $conditions Array
264 * @return Revision or null
266 private static function loadFromConds( $db, $conditions ) {
267 $res = Revision
::fetchFromConds( $db, $conditions );
269 $row = $res->fetchObject();
271 $ret = new Revision( $row );
280 * Return a wrapper for a series of database rows to
281 * fetch all of a given page's revisions in turn.
282 * Each row can be fed to the constructor to get objects.
284 * @param $title Title
285 * @return ResultWrapper
287 public static function fetchRevision( $title ) {
288 return Revision
::fetchFromConds(
290 array( 'rev_id=page_latest',
291 'page_namespace' => $title->getNamespace(),
292 'page_title' => $title->getDBkey() )
297 * Given a set of conditions, return a ResultWrapper
298 * which will return matching database rows with the
299 * fields necessary to build Revision objects.
301 * @param $db DatabaseBase
302 * @param $conditions Array
303 * @return ResultWrapper
305 private static function fetchFromConds( $db, $conditions ) {
306 $fields = array_merge(
307 self
::selectFields(),
308 self
::selectPageFields(),
309 self
::selectUserFields()
312 array( 'revision', 'page', 'user' ),
316 array( 'LIMIT' => 1 ),
317 array( 'page' => self
::pageJoinCond(), 'user' => self
::userJoinCond() )
322 * Return the value of a select() JOIN conds array for the user table.
323 * This will get user table rows for logged-in users.
327 public static function userJoinCond() {
328 return array( 'LEFT JOIN', array( 'rev_user != 0', 'user_id = rev_user' ) );
332 * Return the value of a select() page conds array for the paeg table.
333 * This will assure that the revision(s) are not orphaned from live pages.
337 public static function pageJoinCond() {
338 return array( 'INNER JOIN', array( 'page_id = rev_page' ) );
342 * Return the list of revision fields that should be selected to create
346 public static function selectFields() {
364 * Return the list of text fields that should be selected to read the
368 public static function selectTextFields() {
376 * Return the list of page fields that should be selected from page table
379 public static function selectPageFields() {
389 * Return the list of user fields that should be selected from user table
392 public static function selectUserFields() {
393 return array( 'user_name' );
399 * @param $row Mixed: either a database row or an array
402 function __construct( $row ) {
403 if( is_object( $row ) ) {
404 $this->mId
= intval( $row->rev_id
);
405 $this->mPage
= intval( $row->rev_page
);
406 $this->mTextId
= intval( $row->rev_text_id
);
407 $this->mComment
= $row->rev_comment
;
408 $this->mUser
= intval( $row->rev_user
);
409 $this->mMinorEdit
= intval( $row->rev_minor_edit
);
410 $this->mTimestamp
= $row->rev_timestamp
;
411 $this->mDeleted
= intval( $row->rev_deleted
);
413 if( !isset( $row->rev_parent_id
) ) {
414 $this->mParentId
= is_null( $row->rev_parent_id
) ?
null : 0;
416 $this->mParentId
= intval( $row->rev_parent_id
);
419 if( !isset( $row->rev_len
) ||
is_null( $row->rev_len
) ) {
422 $this->mSize
= intval( $row->rev_len
);
425 if ( !isset( $row->rev_sha1
) ) {
428 $this->mSha1
= $row->rev_sha1
;
431 if( isset( $row->page_latest
) ) {
432 $this->mCurrent
= ( $row->rev_id
== $row->page_latest
);
433 $this->mTitle
= Title
::newFromRow( $row );
435 $this->mCurrent
= false;
436 $this->mTitle
= null;
439 // Lazy extraction...
441 if( isset( $row->old_text
) ) {
442 $this->mTextRow
= $row;
444 // 'text' table row entry will be lazy-loaded
445 $this->mTextRow
= null;
448 // Use user_name for users and rev_user_text for IPs...
449 $this->mUserText
= null; // lazy load if left null
450 if ( $this->mUser
== 0 ) {
451 $this->mUserText
= $row->rev_user_text
; // IP user
452 } elseif ( isset( $row->user_name
) ) {
453 $this->mUserText
= $row->user_name
; // logged-in user
455 $this->mOrigUserText
= $row->rev_user_text
;
456 } elseif( is_array( $row ) ) {
457 // Build a new revision to be saved...
458 global $wgUser; // ugh
460 $this->mId
= isset( $row['id'] ) ?
intval( $row['id'] ) : null;
461 $this->mPage
= isset( $row['page'] ) ?
intval( $row['page'] ) : null;
462 $this->mTextId
= isset( $row['text_id'] ) ?
intval( $row['text_id'] ) : null;
463 $this->mUserText
= isset( $row['user_text'] ) ?
strval( $row['user_text'] ) : $wgUser->getName();
464 $this->mUser
= isset( $row['user'] ) ?
intval( $row['user'] ) : $wgUser->getId();
465 $this->mMinorEdit
= isset( $row['minor_edit'] ) ?
intval( $row['minor_edit'] ) : 0;
466 $this->mTimestamp
= isset( $row['timestamp'] ) ?
strval( $row['timestamp'] ) : wfTimestampNow();
467 $this->mDeleted
= isset( $row['deleted'] ) ?
intval( $row['deleted'] ) : 0;
468 $this->mSize
= isset( $row['len'] ) ?
intval( $row['len'] ) : null;
469 $this->mParentId
= isset( $row['parent_id'] ) ?
intval( $row['parent_id'] ) : null;
470 $this->mSha1
= isset( $row['sha1'] ) ?
strval( $row['sha1'] ) : null;
472 // Enforce spacing trimming on supplied text
473 $this->mComment
= isset( $row['comment'] ) ?
trim( strval( $row['comment'] ) ) : null;
474 $this->mText
= isset( $row['text'] ) ?
rtrim( strval( $row['text'] ) ) : null;
475 $this->mTextRow
= null;
477 $this->mTitle
= null; # Load on demand if needed
478 $this->mCurrent
= false;
479 # If we still have no length, see it we have the text to figure it out
480 if ( !$this->mSize
) {
481 $this->mSize
= is_null( $this->mText
) ?
null : strlen( $this->mText
);
484 if ( $this->mSha1
=== null ) {
485 $this->mSha1
= is_null( $this->mText
) ?
null : self
::base36Sha1( $this->mText
);
488 throw new MWException( 'Revision constructor passed invalid row format.' );
490 $this->mUnpatrolled
= null;
498 public function getId() {
503 * Set the revision ID
508 public function setId( $id ) {
517 public function getTextId() {
518 return $this->mTextId
;
522 * Get parent revision ID (the original previous page revision)
524 * @return Integer|null
526 public function getParentId() {
527 return $this->mParentId
;
531 * Returns the length of the text in this revision, or null if unknown.
535 public function getSize() {
540 * Returns the base36 sha1 of the text in this revision, or null if unknown.
544 public function getSha1() {
549 * Returns the title of the page associated with this entry.
553 public function getTitle() {
554 if( isset( $this->mTitle
) ) {
555 return $this->mTitle
;
557 $dbr = wfGetDB( DB_SLAVE
);
558 $row = $dbr->selectRow(
559 array( 'page', 'revision' ),
560 self
::selectPageFields(),
561 array( 'page_id=rev_page',
562 'rev_id' => $this->mId
),
565 $this->mTitle
= Title
::newFromRow( $row );
567 return $this->mTitle
;
571 * Set the title of the revision
573 * @param $title Title
575 public function setTitle( $title ) {
576 $this->mTitle
= $title;
584 public function getPage() {
589 * Fetch revision's user id if it's available to the specified audience.
590 * If the specified audience does not have access to it, zero will be
593 * @param $audience Integer: one of:
594 * Revision::FOR_PUBLIC to be displayed to all users
595 * Revision::FOR_THIS_USER to be displayed to $wgUser
596 * Revision::RAW get the ID regardless of permissions
597 * @param $user User object to check for, only if FOR_THIS_USER is passed
598 * to the $audience parameter
601 public function getUser( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
602 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_USER
) ) {
604 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_USER
, $user ) ) {
612 * Fetch revision's user id without regard for the current user's permissions
616 public function getRawUser() {
621 * Fetch revision's username if it's available to the specified audience.
622 * If the specified audience does not have access to the username, an
623 * empty string will be returned.
625 * @param $audience Integer: one of:
626 * Revision::FOR_PUBLIC to be displayed to all users
627 * Revision::FOR_THIS_USER to be displayed to $wgUser
628 * Revision::RAW get the text regardless of permissions
629 * @param $user User object to check for, only if FOR_THIS_USER is passed
630 * to the $audience parameter
633 public function getUserText( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
634 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_USER
) ) {
636 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_USER
, $user ) ) {
639 return $this->getRawUserText();
644 * Fetch revision's username without regard for view restrictions
648 public function getRawUserText() {
649 if ( $this->mUserText
=== null ) {
650 $this->mUserText
= User
::whoIs( $this->mUser
); // load on demand
651 if ( $this->mUserText
=== false ) {
652 # This shouldn't happen, but it can if the wiki was recovered
653 # via importing revs and there is no user table entry yet.
654 $this->mUserText
= $this->mOrigUserText
;
657 return $this->mUserText
;
661 * Fetch revision comment if it's available to the specified audience.
662 * If the specified audience does not have access to the comment, an
663 * empty string will be returned.
665 * @param $audience Integer: one of:
666 * Revision::FOR_PUBLIC to be displayed to all users
667 * Revision::FOR_THIS_USER to be displayed to $wgUser
668 * Revision::RAW get the text regardless of permissions
669 * @param $user User object to check for, only if FOR_THIS_USER is passed
670 * to the $audience parameter
673 function getComment( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
674 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_COMMENT
) ) {
676 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_COMMENT
, $user ) ) {
679 return $this->mComment
;
684 * Fetch revision comment without regard for the current user's permissions
688 public function getRawComment() {
689 return $this->mComment
;
695 public function isMinor() {
696 return (bool)$this->mMinorEdit
;
700 * @return Integer rcid of the unpatrolled row, zero if there isn't one
702 public function isUnpatrolled() {
703 if( $this->mUnpatrolled
!== null ) {
704 return $this->mUnpatrolled
;
706 $dbr = wfGetDB( DB_SLAVE
);
707 $this->mUnpatrolled
= $dbr->selectField( 'recentchanges',
709 array( // Add redundant user,timestamp condition so we can use the existing index
710 'rc_user_text' => $this->getRawUserText(),
711 'rc_timestamp' => $dbr->timestamp( $this->getTimestamp() ),
712 'rc_this_oldid' => $this->getId(),
717 return (int)$this->mUnpatrolled
;
721 * @param $field int one of DELETED_* bitfield constants
725 public function isDeleted( $field ) {
726 return ( $this->mDeleted
& $field ) == $field;
730 * Get the deletion bitfield of the revision
734 public function getVisibility() {
735 return (int)$this->mDeleted
;
739 * Fetch revision text if it's available to the specified audience.
740 * If the specified audience does not have the ability to view this
741 * revision, an empty string will be returned.
743 * @param $audience Integer: one of:
744 * Revision::FOR_PUBLIC to be displayed to all users
745 * Revision::FOR_THIS_USER to be displayed to $wgUser
746 * Revision::RAW get the text regardless of permissions
747 * @param $user User object to check for, only if FOR_THIS_USER is passed
748 * to the $audience parameter
751 public function getText( $audience = self
::FOR_PUBLIC
, User
$user = null ) {
752 if( $audience == self
::FOR_PUBLIC
&& $this->isDeleted( self
::DELETED_TEXT
) ) {
754 } elseif( $audience == self
::FOR_THIS_USER
&& !$this->userCan( self
::DELETED_TEXT
, $user ) ) {
757 return $this->getRawText();
762 * Alias for getText(Revision::FOR_THIS_USER)
764 * @deprecated since 1.17
767 public function revText() {
768 wfDeprecated( __METHOD__
, '1.17' );
769 return $this->getText( self
::FOR_THIS_USER
);
773 * Fetch revision text without regard for view restrictions
777 public function getRawText() {
778 if( is_null( $this->mText
) ) {
779 // Revision text is immutable. Load on demand:
780 $this->mText
= $this->loadText();
788 public function getTimestamp() {
789 return wfTimestamp( TS_MW
, $this->mTimestamp
);
795 public function isCurrent() {
796 return $this->mCurrent
;
800 * Get previous revision for this title
802 * @return Revision or null
804 public function getPrevious() {
805 if( $this->getTitle() ) {
806 $prev = $this->getTitle()->getPreviousRevisionID( $this->getId() );
808 return Revision
::newFromTitle( $this->getTitle(), $prev );
815 * Get next revision for this title
817 * @return Revision or null
819 public function getNext() {
820 if( $this->getTitle() ) {
821 $next = $this->getTitle()->getNextRevisionID( $this->getId() );
823 return Revision
::newFromTitle( $this->getTitle(), $next );
830 * Get previous revision Id for this page_id
831 * This is used to populate rev_parent_id on save
833 * @param $db DatabaseBase
836 private function getPreviousRevisionId( $db ) {
837 if( is_null( $this->mPage
) ) {
840 # Use page_latest if ID is not given
842 $prevId = $db->selectField( 'page', 'page_latest',
843 array( 'page_id' => $this->mPage
),
846 $prevId = $db->selectField( 'revision', 'rev_id',
847 array( 'rev_page' => $this->mPage
, 'rev_id < ' . $this->mId
),
849 array( 'ORDER BY' => 'rev_id DESC' ) );
851 return intval( $prevId );
855 * Get revision text associated with an old or archive row
856 * $row is usually an object from wfFetchRow(), both the flags and the text
857 * field must be included
859 * @param $row Object: the text data
860 * @param $prefix String: table prefix (default 'old_')
861 * @return String: text the text requested or false on failure
863 public static function getRevisionText( $row, $prefix = 'old_' ) {
864 wfProfileIn( __METHOD__
);
867 $textField = $prefix . 'text';
868 $flagsField = $prefix . 'flags';
870 if( isset( $row->$flagsField ) ) {
871 $flags = explode( ',', $row->$flagsField );
876 if( isset( $row->$textField ) ) {
877 $text = $row->$textField;
879 wfProfileOut( __METHOD__
);
883 # Use external methods for external objects, text in table is URL-only then
884 if ( in_array( 'external', $flags ) ) {
886 $parts = explode( '://', $url, 2 );
887 if( count( $parts ) == 1 ||
$parts[1] == '' ) {
888 wfProfileOut( __METHOD__
);
891 $text = ExternalStore
::fetchFromURL( $url );
894 // If the text was fetched without an error, convert it
895 if ( $text !== false ) {
896 if( in_array( 'gzip', $flags ) ) {
897 # Deal with optional compression of archived pages.
898 # This can be done periodically via maintenance/compressOld.php, and
899 # as pages are saved if $wgCompressRevisions is set.
900 $text = gzinflate( $text );
903 if( in_array( 'object', $flags ) ) {
904 # Generic compressed storage
905 $obj = unserialize( $text );
906 if ( !is_object( $obj ) ) {
908 wfProfileOut( __METHOD__
);
911 $text = $obj->getText();
914 global $wgLegacyEncoding;
915 if( $text !== false && $wgLegacyEncoding
916 && !in_array( 'utf-8', $flags ) && !in_array( 'utf8', $flags ) )
918 # Old revisions kept around in a legacy encoding?
919 # Upconvert on demand.
920 # ("utf8" checked for compatibility with some broken
921 # conversion scripts 2008-12-30)
923 $text = $wgContLang->iconv( $wgLegacyEncoding, 'UTF-8', $text );
926 wfProfileOut( __METHOD__
);
931 * If $wgCompressRevisions is enabled, we will compress data.
932 * The input string is modified in place.
933 * Return value is the flags field: contains 'gzip' if the
934 * data is compressed, and 'utf-8' if we're saving in UTF-8
937 * @param $text Mixed: reference to a text
940 public static function compressRevisionText( &$text ) {
941 global $wgCompressRevisions;
944 # Revisions not marked this way will be converted
945 # on load if $wgLegacyCharset is set in the future.
948 if( $wgCompressRevisions ) {
949 if( function_exists( 'gzdeflate' ) ) {
950 $text = gzdeflate( $text );
953 wfDebug( "Revision::compressRevisionText() -- no zlib support, not compressing\n" );
956 return implode( ',', $flags );
960 * Insert a new revision into the database, returning the new revision ID
961 * number on success and dies horribly on failure.
963 * @param $dbw DatabaseBase: (master connection)
966 public function insertOn( $dbw ) {
967 global $wgDefaultExternalStore;
969 wfProfileIn( __METHOD__
);
971 $data = $this->mText
;
972 $flags = Revision
::compressRevisionText( $data );
974 # Write to external storage if required
975 if( $wgDefaultExternalStore ) {
976 // Store and get the URL
977 $data = ExternalStore
::insertToDefault( $data );
979 throw new MWException( "Unable to store text to external storage" );
984 $flags .= 'external';
987 # Record the text (or external storage URL) to the text table
988 if( !isset( $this->mTextId
) ) {
989 $old_id = $dbw->nextSequenceValue( 'text_old_id_seq' );
990 $dbw->insert( 'text',
994 'old_flags' => $flags,
997 $this->mTextId
= $dbw->insertId();
1000 if ( $this->mComment
=== null ) $this->mComment
= "";
1002 # Record the edit in revisions
1003 $rev_id = isset( $this->mId
)
1005 : $dbw->nextSequenceValue( 'revision_rev_id_seq' );
1006 $dbw->insert( 'revision',
1008 'rev_id' => $rev_id,
1009 'rev_page' => $this->mPage
,
1010 'rev_text_id' => $this->mTextId
,
1011 'rev_comment' => $this->mComment
,
1012 'rev_minor_edit' => $this->mMinorEdit ?
1 : 0,
1013 'rev_user' => $this->mUser
,
1014 'rev_user_text' => $this->mUserText
,
1015 'rev_timestamp' => $dbw->timestamp( $this->mTimestamp
),
1016 'rev_deleted' => $this->mDeleted
,
1017 'rev_len' => $this->mSize
,
1018 'rev_parent_id' => is_null( $this->mParentId
)
1019 ?
$this->getPreviousRevisionId( $dbw )
1021 'rev_sha1' => is_null( $this->mSha1
)
1022 ? Revision
::base36Sha1( $this->mText
)
1027 $this->mId
= !is_null( $rev_id ) ?
$rev_id : $dbw->insertId();
1029 wfRunHooks( 'RevisionInsertComplete', array( &$this, $data, $flags ) );
1031 wfProfileOut( __METHOD__
);
1036 * Get the base 36 SHA-1 value for a string of text
1037 * @param $text String
1040 public static function base36Sha1( $text ) {
1041 return wfBaseConvert( sha1( $text ), 16, 36, 31 );
1045 * Lazy-load the revision's text.
1046 * Currently hardcoded to the 'text' table storage engine.
1050 protected function loadText() {
1051 wfProfileIn( __METHOD__
);
1053 // Caching may be beneficial for massive use of external storage
1054 global $wgRevisionCacheExpiry, $wgMemc;
1055 $textId = $this->getTextId();
1056 $key = wfMemcKey( 'revisiontext', 'textid', $textId );
1057 if( $wgRevisionCacheExpiry ) {
1058 $text = $wgMemc->get( $key );
1059 if( is_string( $text ) ) {
1060 wfDebug( __METHOD__
. ": got id $textId from cache\n" );
1061 wfProfileOut( __METHOD__
);
1066 // If we kept data for lazy extraction, use it now...
1067 if ( isset( $this->mTextRow
) ) {
1068 $row = $this->mTextRow
;
1069 $this->mTextRow
= null;
1075 // Text data is immutable; check slaves first.
1076 $dbr = wfGetDB( DB_SLAVE
);
1077 $row = $dbr->selectRow( 'text',
1078 array( 'old_text', 'old_flags' ),
1079 array( 'old_id' => $this->getTextId() ),
1083 if( !$row && wfGetLB()->getServerCount() > 1 ) {
1084 // Possible slave lag!
1085 $dbw = wfGetDB( DB_MASTER
);
1086 $row = $dbw->selectRow( 'text',
1087 array( 'old_text', 'old_flags' ),
1088 array( 'old_id' => $this->getTextId() ),
1092 $text = self
::getRevisionText( $row );
1094 # No negative caching -- negative hits on text rows may be due to corrupted slave servers
1095 if( $wgRevisionCacheExpiry && $text !== false ) {
1096 $wgMemc->set( $key, $text, $wgRevisionCacheExpiry );
1099 wfProfileOut( __METHOD__
);
1105 * Create a new null-revision for insertion into a page's
1106 * history. This will not re-save the text, but simply refer
1107 * to the text from the previous version.
1109 * Such revisions can for instance identify page rename
1110 * operations and other such meta-modifications.
1112 * @param $dbw DatabaseBase
1113 * @param $pageId Integer: ID number of the page to read from
1114 * @param $summary String: revision's summary
1115 * @param $minor Boolean: whether the revision should be considered as minor
1116 * @return Revision|null on error
1118 public static function newNullRevision( $dbw, $pageId, $summary, $minor ) {
1119 wfProfileIn( __METHOD__
);
1121 $current = $dbw->selectRow(
1122 array( 'page', 'revision' ),
1123 array( 'page_latest', 'page_namespace', 'page_title',
1124 'rev_text_id', 'rev_len', 'rev_sha1' ),
1126 'page_id' => $pageId,
1127 'page_latest=rev_id',
1132 $revision = new Revision( array(
1134 'comment' => $summary,
1135 'minor_edit' => $minor,
1136 'text_id' => $current->rev_text_id
,
1137 'parent_id' => $current->page_latest
,
1138 'len' => $current->rev_len
,
1139 'sha1' => $current->rev_sha1
1141 $revision->setTitle( Title
::makeTitle( $current->page_namespace
, $current->page_title
) );
1146 wfProfileOut( __METHOD__
);
1151 * Determine if the current user is allowed to view a particular
1152 * field of this revision, if it's marked as deleted.
1154 * @param $field Integer:one of self::DELETED_TEXT,
1155 * self::DELETED_COMMENT,
1156 * self::DELETED_USER
1157 * @param $user User object to check, or null to use $wgUser
1160 public function userCan( $field, User
$user = null ) {
1161 return self
::userCanBitfield( $this->mDeleted
, $field, $user );
1165 * Determine if the current user is allowed to view a particular
1166 * field of this revision, if it's marked as deleted. This is used
1167 * by various classes to avoid duplication.
1169 * @param $bitfield Integer: current field
1170 * @param $field Integer: one of self::DELETED_TEXT = File::DELETED_FILE,
1171 * self::DELETED_COMMENT = File::DELETED_COMMENT,
1172 * self::DELETED_USER = File::DELETED_USER
1173 * @param $user User object to check, or null to use $wgUser
1176 public static function userCanBitfield( $bitfield, $field, User
$user = null ) {
1177 if( $bitfield & $field ) { // aspect is deleted
1178 if ( $bitfield & self
::DELETED_RESTRICTED
) {
1179 $permission = 'suppressrevision';
1180 } elseif ( $field & self
::DELETED_TEXT
) {
1181 $permission = 'deletedtext';
1183 $permission = 'deletedhistory';
1185 wfDebug( "Checking for $permission due to $field match on $bitfield\n" );
1186 if ( $user === null ) {
1190 return $user->isAllowed( $permission );
1197 * Get rev_timestamp from rev_id, without loading the rest of the row
1199 * @param $title Title
1200 * @param $id Integer
1203 static function getTimestampFromId( $title, $id ) {
1204 $dbr = wfGetDB( DB_SLAVE
);
1205 // Casting fix for DB2
1209 $conds = array( 'rev_id' => $id );
1210 $conds['rev_page'] = $title->getArticleID();
1211 $timestamp = $dbr->selectField( 'revision', 'rev_timestamp', $conds, __METHOD__
);
1212 if ( $timestamp === false && wfGetLB()->getServerCount() > 1 ) {
1213 # Not in slave, try master
1214 $dbw = wfGetDB( DB_MASTER
);
1215 $timestamp = $dbw->selectField( 'revision', 'rev_timestamp', $conds, __METHOD__
);
1217 return wfTimestamp( TS_MW
, $timestamp );
1221 * Get count of revisions per page...not very efficient
1223 * @param $db DatabaseBase
1224 * @param $id Integer: page id
1227 static function countByPageId( $db, $id ) {
1228 $row = $db->selectRow( 'revision', 'COUNT(*) AS revCount',
1229 array( 'rev_page' => $id ), __METHOD__
);
1231 return $row->revCount
;
1237 * Get count of revisions per page...not very efficient
1239 * @param $db DatabaseBase
1240 * @param $title Title
1243 static function countByTitle( $db, $title ) {
1244 $id = $title->getArticleID();
1246 return Revision
::countByPageId( $db, $id );