Merge "Fix positioning of jQuery.tipsy tooltip arrows"

[mediawiki.git] / includes / changes / RecentChange.php

<?php
/**
 * Utility class for creating and accessing recent change entries.
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along
 * with this program; if not, write to the Free Software Foundation, Inc.,
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
 * http://www.gnu.org/copyleft/gpl.html
 *
 * @file
 */

/**
 * Utility class for creating new RC entries
 *
 * mAttribs:
 *  rc_id           id of the row in the recentchanges table
 *  rc_timestamp    time the entry was made
 *  rc_namespace    namespace #
 *  rc_title        non-prefixed db key
 *  rc_type         is new entry, used to determine whether updating is necessary
 *  rc_source       string representation of change source
 *  rc_minor        is minor
 *  rc_cur_id       page_id of associated page entry
 *  rc_user         user id who made the entry
 *  rc_user_text    user name who made the entry
 *  rc_comment      edit summary
 *  rc_this_oldid   rev_id associated with this entry (or zero)
 *  rc_last_oldid   rev_id associated with the entry before this one (or zero)
 *  rc_bot          is bot, hidden
 *  rc_ip           IP address of the user in dotted quad notation
 *  rc_new          obsolete, use rc_type==RC_NEW
 *  rc_patrolled    boolean whether or not someone has marked this edit as patrolled
 *  rc_old_len      integer byte length of the text before the edit
 *  rc_new_len      the same after the edit
 *  rc_deleted      partial deletion
 *  rc_logid        the log_id value for this log entry (or zero)
 *  rc_log_type     the log type (or null)
 *  rc_log_action   the log action (or null)
 *  rc_params       log params
 *
 * mExtra:
 *  prefixedDBkey   prefixed db key, used by external app via msg queue
 *  lastTimestamp   timestamp of previous entry, used in WHERE clause during update
 *  oldSize         text size before the change
 *  newSize         text size after the change
 *  pageStatus      status of the page: created, deleted, moved, restored, changed
 *
 * temporary:       not stored in the database
 *      notificationtimestamp
 *      numberofWatchingusers
 */
class RecentChange {
        // Constants for the rc_source field.  Extensions may also have
        // their own source constants.
        const SRC_EDIT = 'mw.edit';
        const SRC_NEW = 'mw.new';
        const SRC_LOG = 'mw.log';
        const SRC_EXTERNAL = 'mw.external'; // obsolete
        const SRC_CATEGORIZE = 'mw.categorize';

        public $mAttribs = array();
        public $mExtra = array();

        /**
         * @var Title
         */
        public $mTitle = false;

        /**
         * @var User
         */
        private $mPerformer = false;

        public $numberofWatchingusers = 0; # Dummy to prevent error message in SpecialRecentChangesLinked
        public $notificationtimestamp;

        /**
         * @var int Line number of recent change. Default -1.
         */
        public $counter = -1;

        /**
         * @var array Array of change types
         */
        private static $changeTypes = array(
                'edit' => RC_EDIT,
                'new' => RC_NEW,
                'log' => RC_LOG,
                'external' => RC_EXTERNAL,
                'categorize' => RC_CATEGORIZE,
        );

        # Factory methods

        /**
         * @param mixed $row
         * @return RecentChange
         */
        public static function newFromRow( $row ) {
                $rc = new RecentChange;
                $rc->loadFromRow( $row );

                return $rc;
        }

        /**
         * Parsing text to RC_* constants
         * @since 1.24
         * @param string|array $type
         * @throws MWException
         * @return int|array RC_TYPE
         */
        public static function parseToRCType( $type ) {
                if ( is_array( $type ) ) {
                        $retval = array();
                        foreach ( $type as $t ) {
                                $retval[] = RecentChange::parseToRCType( $t );
                        }

                        return $retval;
                }

                if ( !array_key_exists( $type, self::$changeTypes ) ) {
                        throw new MWException( "Unknown type '$type'" );
                }
                return self::$changeTypes[$type];
        }

        /**
         * Parsing RC_* constants to human-readable test
         * @since 1.24
         * @param int $rcType
         * @return string $type
         */
        public static function parseFromRCType( $rcType ) {
                return array_search( $rcType, self::$changeTypes, true ) ?: "$rcType";
        }

        /**
         * Get an array of all change types
         *
         * @since 1.26
         *
         * @return array
         */
        public static function getChangeTypes() {
                return array_keys( self::$changeTypes );
        }

        /**
         * Obtain the recent change with a given rc_id value
         *
         * @param int $rcid The rc_id value to retrieve
         * @return RecentChange|null
         */
        public static function newFromId( $rcid ) {
                return self::newFromConds( array( 'rc_id' => $rcid ), __METHOD__ );
        }

        /**
         * Find the first recent change matching some specific conditions
         *
         * @param array $conds Array of conditions
         * @param mixed $fname Override the method name in profiling/logs
         * @param int $dbType DB_* constant
         *
         * @return RecentChange|null
         */
        public static function newFromConds(
                $conds,
                $fname = __METHOD__,
                $dbType = DB_SLAVE
        ) {
                $db = wfGetDB( $dbType );
                $row = $db->selectRow( 'recentchanges', self::selectFields(), $conds, $fname );
                if ( $row !== false ) {
                        return self::newFromRow( $row );
                } else {
                        return null;
                }
        }

        /**
         * Return the list of recentchanges fields that should be selected to create
         * a new recentchanges object.
         * @return array
         */
        public static function selectFields() {
                return array(
                        'rc_id',
                        'rc_timestamp',
                        'rc_user',
                        'rc_user_text',
                        'rc_namespace',
                        'rc_title',
                        'rc_comment',
                        'rc_minor',
                        'rc_bot',
                        'rc_new',
                        'rc_cur_id',
                        'rc_this_oldid',
                        'rc_last_oldid',
                        'rc_type',
                        'rc_source',
                        'rc_patrolled',
                        'rc_ip',
                        'rc_old_len',
                        'rc_new_len',
                        'rc_deleted',
                        'rc_logid',
                        'rc_log_type',
                        'rc_log_action',
                        'rc_params',
                );
        }

        # Accessors

        /**
         * @param array $attribs
         */
        public function setAttribs( $attribs ) {
                $this->mAttribs = $attribs;
        }

        /**
         * @param array $extra
         */
        public function setExtra( $extra ) {
                $this->mExtra = $extra;
        }

        /**
         * @return Title
         */
        public function &getTitle() {
                if ( $this->mTitle === false ) {
                        $this->mTitle = Title::makeTitle( $this->mAttribs['rc_namespace'], $this->mAttribs['rc_title'] );
                }

                return $this->mTitle;
        }

        /**
         * Get the User object of the person who performed this change.
         *
         * @return User
         */
        public function getPerformer() {
                if ( $this->mPerformer === false ) {
                        if ( $this->mAttribs['rc_user'] ) {
                                $this->mPerformer = User::newFromId( $this->mAttribs['rc_user'] );
                        } else {
                                $this->mPerformer = User::newFromName( $this->mAttribs['rc_user_text'], false );
                        }
                }

                return $this->mPerformer;
        }

        /**
         * Writes the data in this object to the database
         * @param bool $noudp
         */
        public function save( $noudp = false ) {
                global $wgPutIPinRC, $wgUseEnotif, $wgShowUpdatedMarker, $wgContLang;

                $dbw = wfGetDB( DB_MASTER );
                if ( !is_array( $this->mExtra ) ) {
                        $this->mExtra = array();
                }

                if ( !$wgPutIPinRC ) {
                        $this->mAttribs['rc_ip'] = '';
                }

                # If our database is strict about IP addresses, use NULL instead of an empty string
                if ( $dbw->strictIPs() && $this->mAttribs['rc_ip'] == '' ) {
                        unset( $this->mAttribs['rc_ip'] );
                }

                # Trim spaces on user supplied text
                $this->mAttribs['rc_comment'] = trim( $this->mAttribs['rc_comment'] );

                # Make sure summary is truncated (whole multibyte characters)
                $this->mAttribs['rc_comment'] = $wgContLang->truncate( $this->mAttribs['rc_comment'], 255 );

                # Fixup database timestamps
                $this->mAttribs['rc_timestamp'] = $dbw->timestamp( $this->mAttribs['rc_timestamp'] );
                $this->mAttribs['rc_id'] = $dbw->nextSequenceValue( 'recentchanges_rc_id_seq' );

                # # If we are using foreign keys, an entry of 0 for the page_id will fail, so use NULL
                if ( $dbw->cascadingDeletes() && $this->mAttribs['rc_cur_id'] == 0 ) {
                        unset( $this->mAttribs['rc_cur_id'] );
                }

                # Insert new row
                $dbw->insert( 'recentchanges', $this->mAttribs, __METHOD__ );

                # Set the ID
                $this->mAttribs['rc_id'] = $dbw->insertId();

                # Notify extensions
                Hooks::run( 'RecentChange_save', array( &$this ) );

                # Notify external application via UDP
                if ( !$noudp ) {
                        $this->notifyRCFeeds();
                }

                # E-mail notifications
                if ( $wgUseEnotif || $wgShowUpdatedMarker ) {
                        $editor = $this->getPerformer();
                        $title = $this->getTitle();

                        // Never send an RC notification email about categorization changes
                        if ( $this->mAttribs['rc_type'] != RC_CATEGORIZE ) {
                                if ( Hooks::run( 'AbortEmailNotification', array( $editor, $title, $this ) ) ) {
                                        # @todo FIXME: This would be better as an extension hook
                                        $enotif = new EmailNotification();
                                        $enotif->notifyOnPageChange(
                                                $editor,
                                                $title,
                                                $this->mAttribs['rc_timestamp'],
                                                $this->mAttribs['rc_comment'],
                                                $this->mAttribs['rc_minor'],
                                                $this->mAttribs['rc_last_oldid'],
                                                $this->mExtra['pageStatus']
                                        );
                                }
                        }
                }

                // Update the cached list of active users
                if ( $this->mAttribs['rc_user'] > 0 ) {
                        JobQueueGroup::singleton()->lazyPush( RecentChangesUpdateJob::newCacheUpdateJob() );
                }
        }

        /**
         * Notify all the feeds about the change.
         * @param array $feeds Optional feeds to send to, defaults to $wgRCFeeds
         */
        public function notifyRCFeeds( array $feeds = null ) {
                global $wgRCFeeds;
                if ( $feeds === null ) {
                        $feeds = $wgRCFeeds;
                }

                $performer = $this->getPerformer();

                foreach ( $feeds as $feed ) {
                        $feed += array(
                                'omit_bots' => false,
                                'omit_anon' => false,
                                'omit_user' => false,
                                'omit_minor' => false,
                                'omit_patrolled' => false,
                        );

                        if (
                                ( $feed['omit_bots'] && $this->mAttribs['rc_bot'] ) ||
                                ( $feed['omit_anon'] && $performer->isAnon() ) ||
                                ( $feed['omit_user'] && !$performer->isAnon() ) ||
                                ( $feed['omit_minor'] && $this->mAttribs['rc_minor'] ) ||
                                ( $feed['omit_patrolled'] && $this->mAttribs['rc_patrolled'] ) ||
                                $this->mAttribs['rc_type'] == RC_EXTERNAL
                        ) {
                                continue;
                        }

                        $engine = self::getEngine( $feed['uri'] );

                        if ( isset( $this->mExtra['actionCommentIRC'] ) ) {
                                $actionComment = $this->mExtra['actionCommentIRC'];
                        } else {
                                $actionComment = null;
                        }

                        /** @var $formatter RCFeedFormatter */
                        $formatter = is_object( $feed['formatter'] ) ? $feed['formatter'] : new $feed['formatter']();
                        $line = $formatter->getLine( $feed, $this, $actionComment );
                        if ( !$line ) {
                                // T109544
                                // If a feed formatter returns null, this will otherwise cause an
                                // error in at least RedisPubSubFeedEngine.
                                // Not sure where/how this should best be handled.
                                continue;
                        }

                        $engine->send( $feed, $line );
                }
        }

        /**
         * Gets the stream engine object for a given URI from $wgRCEngines
         *
         * @param string $uri URI to get the engine object for
         * @throws MWException
         * @return RCFeedEngine The engine object
         */
        public static function getEngine( $uri ) {
                global $wgRCEngines;

                $scheme = parse_url( $uri, PHP_URL_SCHEME );
                if ( !$scheme ) {
                        throw new MWException( __FUNCTION__ . ": Invalid stream logger URI: '$uri'" );
                }

                if ( !isset( $wgRCEngines[$scheme] ) ) {
                        throw new MWException( __FUNCTION__ . ": Unknown stream logger URI scheme: $scheme" );
                }

                return new $wgRCEngines[$scheme];
        }

        /**
         * Mark a given change as patrolled
         *
         * @param RecentChange|int $change RecentChange or corresponding rc_id
         * @param bool $auto For automatic patrol
         * @return array See doMarkPatrolled(), or null if $change is not an existing rc_id
         */
        public static function markPatrolled( $change, $auto = false ) {
                global $wgUser;

                $change = $change instanceof RecentChange
                        ? $change
                        : RecentChange::newFromId( $change );

                if ( !$change instanceof RecentChange ) {
                        return null;
                }

                return $change->doMarkPatrolled( $wgUser, $auto );
        }

        /**
         * Mark this RecentChange as patrolled
         *
         * NOTE: Can also return 'rcpatroldisabled', 'hookaborted' and
         * 'markedaspatrollederror-noautopatrol' as errors
         * @param User $user User object doing the action
         * @param bool $auto For automatic patrol
         * @return array Array of permissions errors, see Title::getUserPermissionsErrors()
         */
        public function doMarkPatrolled( User $user, $auto = false ) {
                global $wgUseRCPatrol, $wgUseNPPatrol;
                $errors = array();
                // If recentchanges patrol is disabled, only new pages
                // can be patrolled
                if ( !$wgUseRCPatrol && ( !$wgUseNPPatrol || $this->getAttribute( 'rc_type' ) != RC_NEW ) ) {
                        $errors[] = array( 'rcpatroldisabled' );
                }
                // Automatic patrol needs "autopatrol", ordinary patrol needs "patrol"
                $right = $auto ? 'autopatrol' : 'patrol';
                $errors = array_merge( $errors, $this->getTitle()->getUserPermissionsErrors( $right, $user ) );
                if ( !Hooks::run( 'MarkPatrolled',
                                        array( $this->getAttribute( 'rc_id' ), &$user, false, $auto ) )
                ) {
                        $errors[] = array( 'hookaborted' );
                }
                // Users without the 'autopatrol' right can't patrol their
                // own revisions
                if ( $user->getName() === $this->getAttribute( 'rc_user_text' )
                        && !$user->isAllowed( 'autopatrol' )
                ) {
                        $errors[] = array( 'markedaspatrollederror-noautopatrol' );
                }
                if ( $errors ) {
                        return $errors;
                }
                // If the change was patrolled already, do nothing
                if ( $this->getAttribute( 'rc_patrolled' ) ) {
                        return array();
                }
                // Actually set the 'patrolled' flag in RC
                $this->reallyMarkPatrolled();
                // Log this patrol event
                PatrolLog::record( $this, $auto, $user );
                Hooks::run(
                                        'MarkPatrolledComplete',
                                        array( $this->getAttribute( 'rc_id' ), &$user, false, $auto )
                );

                return array();
        }

        /**
         * Mark this RecentChange patrolled, without error checking
         * @return int Number of affected rows
         */
        public function reallyMarkPatrolled() {
                $dbw = wfGetDB( DB_MASTER );
                $dbw->update(
                        'recentchanges',
                        array(
                                'rc_patrolled' => 1
                        ),
                        array(
                                'rc_id' => $this->getAttribute( 'rc_id' )
                        ),
                        __METHOD__
                );
                // Invalidate the page cache after the page has been patrolled
                // to make sure that the Patrol link isn't visible any longer!
                $this->getTitle()->invalidateCache();

                return $dbw->affectedRows();
        }

        /**
         * Makes an entry in the database corresponding to an edit
         *
         * @param string $timestamp
         * @param Title $title
         * @param bool $minor
         * @param User $user
         * @param string $comment
         * @param int $oldId
         * @param string $lastTimestamp
         * @param bool $bot
         * @param string $ip
         * @param int $oldSize
         * @param int $newSize
         * @param int $newId
         * @param int $patrol
         * @return RecentChange
         */
        public static function notifyEdit(
                $timestamp, &$title, $minor, &$user, $comment, $oldId, $lastTimestamp,
                $bot, $ip = '', $oldSize = 0, $newSize = 0, $newId = 0, $patrol = 0
        ) {
                $rc = new RecentChange;
                $rc->mTitle = $title;
                $rc->mPerformer = $user;
                $rc->mAttribs = array(
                        'rc_timestamp' => $timestamp,
                        'rc_namespace' => $title->getNamespace(),
                        'rc_title' => $title->getDBkey(),
                        'rc_type' => RC_EDIT,
                        'rc_source' => self::SRC_EDIT,
                        'rc_minor' => $minor ? 1 : 0,
                        'rc_cur_id' => $title->getArticleID(),
                        'rc_user' => $user->getId(),
                        'rc_user_text' => $user->getName(),
                        'rc_comment' => $comment,
                        'rc_this_oldid' => $newId,
                        'rc_last_oldid' => $oldId,
                        'rc_bot' => $bot ? 1 : 0,
                        'rc_ip' => self::checkIPAddress( $ip ),
                        'rc_patrolled' => intval( $patrol ),
                        'rc_new' => 0, # obsolete
                        'rc_old_len' => $oldSize,
                        'rc_new_len' => $newSize,
                        'rc_deleted' => 0,
                        'rc_logid' => 0,
                        'rc_log_type' => null,
                        'rc_log_action' => '',
                        'rc_params' => ''
                );

                $rc->mExtra = array(
                        'prefixedDBkey' => $title->getPrefixedDBkey(),
                        'lastTimestamp' => $lastTimestamp,
                        'oldSize' => $oldSize,
                        'newSize' => $newSize,
                        'pageStatus' => 'changed'
                );

                DeferredUpdates::addCallableUpdate( function() use ( $rc ) {
                        $rc->save();
                        if ( $rc->mAttribs['rc_patrolled'] ) {
                                PatrolLog::record( $rc, true, $rc->getPerformer() );
                        }
                } );

                return $rc;
        }

        /**
         * Makes an entry in the database corresponding to page creation
         * Note: the title object must be loaded with the new id using resetArticleID()
         *
         * @param string $timestamp
         * @param Title $title
         * @param bool $minor
         * @param User $user
         * @param string $comment
         * @param bool $bot
         * @param string $ip
         * @param int $size
         * @param int $newId
         * @param int $patrol
         * @return RecentChange
         */
        public static function notifyNew(
                $timestamp, &$title, $minor, &$user, $comment, $bot,
                $ip = '', $size = 0, $newId = 0, $patrol = 0
        ) {
                $rc = new RecentChange;
                $rc->mTitle = $title;
                $rc->mPerformer = $user;
                $rc->mAttribs = array(
                        'rc_timestamp' => $timestamp,
                        'rc_namespace' => $title->getNamespace(),
                        'rc_title' => $title->getDBkey(),
                        'rc_type' => RC_NEW,
                        'rc_source' => self::SRC_NEW,
                        'rc_minor' => $minor ? 1 : 0,
                        'rc_cur_id' => $title->getArticleID(),
                        'rc_user' => $user->getId(),
                        'rc_user_text' => $user->getName(),
                        'rc_comment' => $comment,
                        'rc_this_oldid' => $newId,
                        'rc_last_oldid' => 0,
                        'rc_bot' => $bot ? 1 : 0,
                        'rc_ip' => self::checkIPAddress( $ip ),
                        'rc_patrolled' => intval( $patrol ),
                        'rc_new' => 1, # obsolete
                        'rc_old_len' => 0,
                        'rc_new_len' => $size,
                        'rc_deleted' => 0,
                        'rc_logid' => 0,
                        'rc_log_type' => null,
                        'rc_log_action' => '',
                        'rc_params' => ''
                );

                $rc->mExtra = array(
                        'prefixedDBkey' => $title->getPrefixedDBkey(),
                        'lastTimestamp' => 0,
                        'oldSize' => 0,
                        'newSize' => $size,
                        'pageStatus' => 'created'
                );

                DeferredUpdates::addCallableUpdate( function() use ( $rc ) {
                        $rc->save();
                        if ( $rc->mAttribs['rc_patrolled'] ) {
                                PatrolLog::record( $rc, true, $rc->getPerformer() );
                        }
                } );

                return $rc;
        }

        /**
         * @param string $timestamp
         * @param Title $title
         * @param User $user
         * @param string $actionComment
         * @param string $ip
         * @param string $type
         * @param string $action
         * @param Title $target
         * @param string $logComment
         * @param string $params
         * @param int $newId
         * @param string $actionCommentIRC
         * @return bool
         */
        public static function notifyLog( $timestamp, &$title, &$user, $actionComment, $ip, $type,
                $action, $target, $logComment, $params, $newId = 0, $actionCommentIRC = ''
        ) {
                global $wgLogRestrictions;

                # Don't add private logs to RC!
                if ( isset( $wgLogRestrictions[$type] ) && $wgLogRestrictions[$type] != '*' ) {
                        return false;
                }
                $rc = self::newLogEntry( $timestamp, $title, $user, $actionComment, $ip, $type, $action,
                        $target, $logComment, $params, $newId, $actionCommentIRC );
                $rc->save();

                return true;
        }

        /**
         * @param string $timestamp
         * @param Title $title
         * @param User $user
         * @param string $actionComment
         * @param string $ip
         * @param string $type
         * @param string $action
         * @param Title $target
         * @param string $logComment
         * @param string $params
         * @param int $newId
         * @param string $actionCommentIRC
         * @return RecentChange
         */
        public static function newLogEntry( $timestamp, &$title, &$user, $actionComment, $ip,
                $type, $action, $target, $logComment, $params, $newId = 0, $actionCommentIRC = '' ) {
                global $wgRequest;

                # # Get pageStatus for email notification
                switch ( $type . '-' . $action ) {
                        case 'delete-delete':
                                $pageStatus = 'deleted';
                                break;
                        case 'move-move':
                        case 'move-move_redir':
                                $pageStatus = 'moved';
                                break;
                        case 'delete-restore':
                                $pageStatus = 'restored';
                                break;
                        case 'upload-upload':
                                $pageStatus = 'created';
                                break;
                        case 'upload-overwrite':
                        default:
                                $pageStatus = 'changed';
                                break;
                }

                $rc = new RecentChange;
                $rc->mTitle = $target;
                $rc->mPerformer = $user;
                $rc->mAttribs = array(
                        'rc_timestamp' => $timestamp,
                        'rc_namespace' => $target->getNamespace(),
                        'rc_title' => $target->getDBkey(),
                        'rc_type' => RC_LOG,
                        'rc_source' => self::SRC_LOG,
                        'rc_minor' => 0,
                        'rc_cur_id' => $target->getArticleID(),
                        'rc_user' => $user->getId(),
                        'rc_user_text' => $user->getName(),
                        'rc_comment' => $logComment,
                        'rc_this_oldid' => 0,
                        'rc_last_oldid' => 0,
                        'rc_bot' => $user->isAllowed( 'bot' ) ? $wgRequest->getBool( 'bot', true ) : 0,
                        'rc_ip' => self::checkIPAddress( $ip ),
                        'rc_patrolled' => 1,
                        'rc_new' => 0, # obsolete
                        'rc_old_len' => null,
                        'rc_new_len' => null,
                        'rc_deleted' => 0,
                        'rc_logid' => $newId,
                        'rc_log_type' => $type,
                        'rc_log_action' => $action,
                        'rc_params' => $params
                );

                $rc->mExtra = array(
                        'prefixedDBkey' => $title->getPrefixedDBkey(),
                        'lastTimestamp' => 0,
                        'actionComment' => $actionComment, // the comment appended to the action, passed from LogPage
                        'pageStatus' => $pageStatus,
                        'actionCommentIRC' => $actionCommentIRC
                );

                return $rc;
        }

        /**
         * Constructs a RecentChange object for the given categorization
         * This does not call save() on the object and thus does not write to the db
         *
         * @since 1.27
         *
         * @param string $timestamp Timestamp of the recent change to occur
         * @param Title $categoryTitle Title of the category a page is being added to or removed from
         * @param User $user User object of the user that made the change
         * @param string $comment Change summary
         * @param Title $pageTitle Title of the page that is being added or removed
         * @param int $oldRevId Parent revision ID of this change
         * @param int $newRevId Revision ID of this change
         * @param string $lastTimestamp Parent revision timestamp of this change
         * @param bool $bot true, if the change was made by a bot
         * @param string $ip IP address of the user, if the change was made anonymously
         * @param int $deleted Indicates whether the change has been deleted
         *
         * @return RecentChange
         */
        public static function newForCategorization(
                $timestamp,
                Title $categoryTitle,
                User $user = null,
                $comment,
                Title $pageTitle,
                $oldRevId,
                $newRevId,
                $lastTimestamp,
                $bot,
                $ip = '',
                $deleted = 0
        ) {
                $rc = new RecentChange;
                $rc->mTitle = $categoryTitle;
                $rc->mPerformer = $user;
                $rc->mAttribs = array(
                        'rc_timestamp' => $timestamp,
                        'rc_namespace' => $categoryTitle->getNamespace(),
                        'rc_title' => $categoryTitle->getDBkey(),
                        'rc_type' => RC_CATEGORIZE,
                        'rc_source' => self::SRC_CATEGORIZE,
                        'rc_minor' => 0,
                        'rc_cur_id' => $pageTitle->getArticleID(),
                        'rc_user' => $user ? $user->getId() : 0,
                        'rc_user_text' => $user ? $user->getName() : '',
                        'rc_comment' => $comment,
                        'rc_this_oldid' => $newRevId,
                        'rc_last_oldid' => $oldRevId,
                        'rc_bot' => $bot ? 1 : 0,
                        'rc_ip' => self::checkIPAddress( $ip ),
                        'rc_patrolled' => 1, // Always patrolled, just like log entries
                        'rc_new' => 0, # obsolete
                        'rc_old_len' => 0,
                        'rc_new_len' => 0,
                        'rc_deleted' => $deleted,
                        'rc_logid' => 0,
                        'rc_log_type' => null,
                        'rc_log_action' => '',
                        'rc_params' => ''
                );

                $rc->mExtra = array(
                        'prefixedDBkey' => $categoryTitle->getPrefixedDBkey(),
                        'lastTimestamp' => $lastTimestamp,
                        'oldSize' => 0,
                        'newSize' => 0,
                        'pageStatus' => 'changed'
                );

                return $rc;
        }

        /**
         * Initialises the members of this object from a mysql row object
         *
         * @param mixed $row
         */
        public function loadFromRow( $row ) {
                $this->mAttribs = get_object_vars( $row );
                $this->mAttribs['rc_timestamp'] = wfTimestamp( TS_MW, $this->mAttribs['rc_timestamp'] );
                $this->mAttribs['rc_deleted'] = $row->rc_deleted; // MUST be set
        }

        /**
         * Get an attribute value
         *
         * @param string $name Attribute name
         * @return mixed
         */
        public function getAttribute( $name ) {
                return isset( $this->mAttribs[$name] ) ? $this->mAttribs[$name] : null;
        }

        /**
         * @return array
         */
        public function getAttributes() {
                return $this->mAttribs;
        }

        /**
         * Gets the end part of the diff URL associated with this object
         * Blank if no diff link should be displayed
         * @param bool $forceCur
         * @return string
         */
        public function diffLinkTrail( $forceCur ) {
                if ( $this->mAttribs['rc_type'] == RC_EDIT ) {
                        $trail = "curid=" . (int)( $this->mAttribs['rc_cur_id'] ) .
                                "&oldid=" . (int)( $this->mAttribs['rc_last_oldid'] );
                        if ( $forceCur ) {
                                $trail .= '&diff=0';
                        } else {
                                $trail .= '&diff=' . (int)( $this->mAttribs['rc_this_oldid'] );
                        }
                } else {
                        $trail = '';
                }

                return $trail;
        }

        /**
         * Returns the change size (HTML).
         * The lengths can be given optionally.
         * @param int $old
         * @param int $new
         * @return string
         */
        public function getCharacterDifference( $old = 0, $new = 0 ) {
                if ( $old === 0 ) {
                        $old = $this->mAttribs['rc_old_len'];
                }
                if ( $new === 0 ) {
                        $new = $this->mAttribs['rc_new_len'];
                }
                if ( $old === null || $new === null ) {
                        return '';
                }

                return ChangesList::showCharacterDifference( $old, $new );
        }

        private static function checkIPAddress( $ip ) {
                global $wgRequest;
                if ( $ip ) {
                        if ( !IP::isIPAddress( $ip ) ) {
                                throw new MWException( "Attempt to write \"" . $ip .
                                        "\" as an IP address into recent changes" );
                        }
                } else {
                        $ip = $wgRequest->getIP();
                        if ( !$ip ) {
                                $ip = '';
                        }
                }

                return $ip;
        }

        /**
         * Check whether the given timestamp is new enough to have a RC row with a given tolerance
         * as the recentchanges table might not be cleared out regularly (so older entries might exist)
         * or rows which will be deleted soon shouldn't be included.
         *
         * @param mixed $timestamp MWTimestamp compatible timestamp
         * @param int $tolerance Tolerance in seconds
         * @return bool
         */
        public static function isInRCLifespan( $timestamp, $tolerance = 0 ) {
                global $wgRCMaxAge;

                return wfTimestamp( TS_UNIX, $timestamp ) > time() - $tolerance - $wgRCMaxAge;
        }

        /**
         * Parses and returns the rc_params attribute
         *
         * @since 1.26
         *
         * @return array|null
         */
        public function parseParams() {
                $rcParams = $this->getAttribute( 'rc_params' );

                MediaWiki\suppressWarnings();
                $unserializedParams = unserialize( $rcParams );
                MediaWiki\restoreWarnings();

                return $unserializedParams;
        }
}