CheckUser Installation

Jump to: navigation, search

yes, the download was complete.

Thetechexpert (talk)‎01:58, 24 February 2012

Hhm... try using an earlier version of CU, and make sure the PHP version you use is the latest you can use.

Jasper Deng (talk)‎05:31, 24 February 2012

I have already done all that

Thetechexpert (talk)‎23:57, 24 February 2012

hhm... can we see your CheckUser.hooks.php?

Jasper Deng (talk)‎01:31, 25 February 2012

Do you want me to copy/paste the code as a message? Because if so, then that is fine

Thetechexpert (talk)‎03:52, 25 February 2012

Yes. Put it between <source lang="php"> and </source>.

Jasper Deng (talk)‎04:42, 25 February 2012
Edited by another user.
Last edit: 02:14, 27 February 2012
class CheckUserHooks {
        /**
         * Hook function for RecentChange_save
         * Saves user data into the cu_changes table
         */
        public static function updateCheckUserData( RecentChange $rc ) {
                global $wgRequest;
 
                // Extract params
                extract( $rc->mAttribs );
                // Get IP
                $ip = wfGetIP();
                // Get XFF header
                $xff = $wgRequest->getHeader( 'X-Forwarded-For' );
                list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff );
                // Get agent
                $agent = $wgRequest->getHeader( 'User-Agent' );
                // Store the log action text for log events
                // $rc_comment should just be the log_comment
                // BC: check if log_type and log_action exists
                // If not, then $rc_comment is the actiontext and comment
                if ( isset( $rc_log_type ) && $rc_type == RC_LOG ) {
                        $target = Title::makeTitle( $rc_namespace, $rc_title );
                        $context = RequestContext::newExtraneousContext( $target );
 
                        $formatter = LogFormatter::newFromRow( $rc->mAttribs );
                        $formatter->setContext( $context );
                        $actionText = $formatter->getPlainActionText();
                } else {
                        $actionText = '';
                }
 
                $dbw = wfGetDB( DB_MASTER );
                $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' );
                $rcRow = array(
                        'cuc_id'         => $cuc_id,
                        'cuc_namespace'  => $rc_namespace,
                        'cuc_title'      => $rc_title,
                        'cuc_minor'      => $rc_minor,
                        'cuc_user'       => $rc_user,
                        'cuc_user_text'  => $rc_user_text,
                        'cuc_actiontext' => $actionText,
                        'cuc_comment'    => $rc_comment,
                        'cuc_this_oldid' => $rc_this_oldid,
                        'cuc_last_oldid' => $rc_last_oldid,
                        'cuc_type'       => $rc_type,
                        'cuc_timestamp'  => $rc_timestamp,
                        'cuc_ip'         => IP::sanitizeIP( $ip ),
                        'cuc_ip_hex'     => $ip ? IP::toHex( $ip ) : null,
                        'cuc_xff'        => !$isSquidOnly ? $xff : '',
                        'cuc_xff_hex'    => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null,
                        'cuc_agent'      => $agent
                );
                # On PG, MW unsets cur_id due to schema incompatibilites. So it may not be set!
                if ( isset( $rc_cur_id ) ) {
                        $rcRow['cuc_page_id'] = $rc_cur_id;
                }
                $dbw->insert( 'cu_changes', $rcRow, __METHOD__ );
 
                return true;
        }
 
        /**
         * Hook function to store password reset
         * Saves user data into the cu_changes table
         */
        public static function updateCUPasswordResetData( User $user, $ip, $account ) {
                global $wgRequest;
 
                // Get XFF header
                $xff = $wgRequest->getHeader( 'X-Forwarded-For' );
                list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff );
                // Get agent
                $agent = $wgRequest->getHeader( 'User-Agent' );
                $dbw = wfGetDB( DB_MASTER );
                $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' );
                $rcRow = array(
                        'cuc_id'         => $cuc_id,
                        'cuc_namespace'  => NS_USER,
                        'cuc_title'      => '',
                        'cuc_minor'      => 0,
                        'cuc_user'       => $user->getId(),
                        'cuc_user_text'  => $user->getName(),
                        'cuc_actiontext' => wfMsgForContent( 'checkuser-reset-action', $account->getName() ),
                        'cuc_comment'    => '',
                        'cuc_this_oldid' => 0,
                        'cuc_last_oldid' => 0,
                        'cuc_type'       => RC_LOG,
                        'cuc_timestamp'  => $dbw->timestamp( wfTimestampNow() ),
                        'cuc_ip'         => IP::sanitizeIP( $ip ),
                        'cuc_ip_hex'     => $ip ? IP::toHex( $ip ) : null,
                        'cuc_xff'        => !$isSquidOnly ? $xff : '',
                        'cuc_xff_hex'    => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null,
                        'cuc_agent'      => $agent
                );
                $dbw->insert( 'cu_changes', $rcRow, __METHOD__ );
 
                return true;
        }
 
        /**
         * Hook function to store email data
         * Saves user data into the cu_changes table
         */
        public static function updateCUEmailData( $to, $from, $subject, $text ) {
                global $wgSecretKey, $wgRequest;
                if ( !$wgSecretKey || $from->name == $to->name ) {
                        return true;
                }
                $userFrom = User::newFromName( $from->name );
                $userTo = User::newFromName( $to->name );
                $hash = md5( $userTo->getEmail() . $userTo->getId() . $wgSecretKey );
                // Get IP
                $ip = wfGetIP();
                // Get XFF header
                $xff = $wgRequest->getHeader( 'X-Forwarded-For' );
                list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff );
                // Get agent
                $agent = $wgRequest->getHeader( 'User-Agent' );
                $dbw = wfGetDB( DB_MASTER );
                $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' );
                $rcRow = array(
                        'cuc_id'         => $cuc_id,
                        'cuc_namespace'  => NS_USER,
                        'cuc_title'      => '',
                        'cuc_minor'      => 0,
                        'cuc_user'       => $userFrom->getId(),
                        'cuc_user_text'  => $userFrom->getName(),
                        'cuc_actiontext' => wfMsgForContent( 'checkuser-email-action', $hash ),
                        'cuc_comment'    => '',
                        'cuc_this_oldid' => 0,
                        'cuc_last_oldid' => 0,
                        'cuc_type'       => RC_LOG,
                        'cuc_timestamp'  => $dbw->timestamp( wfTimestampNow() ),
                        'cuc_ip'         => IP::sanitizeIP( $ip ),
                        'cuc_ip_hex'     => $ip ? IP::toHex( $ip ) : null,
                        'cuc_xff'        => !$isSquidOnly ? $xff : '',
                        'cuc_xff_hex'    => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null,
                        'cuc_agent'      => $agent
                );
                $dbw->insert( 'cu_changes', $rcRow, __METHOD__ );
 
                return true;
        }
 
        /**
         * Hook function to store autocreation data from the auth plugin
         * Saves user data into the cu_changes table
         *
         * @param $user User
         *
         * @return true
         */
        public static function onAuthPluginAutoCreate( User $user ) {
                return self::logUserAccountCreation( $user, 'checkuser-autocreate-action' );
        }
 
        /**
         * Hook function to store registration data
         * Saves user data into the cu_changes table
         *
         * @param $user User
         * @param $byEmail bool
         * @return bool
         */
        public static function onAddNewAccount( User $user, $byEmail ) {
                return self::logUserAccountCreation( $user, 'checkuser-create-action' );
        }
 
        /**
         * @param $user User
         * @param $actiontext string
         * @return bool
         */
        protected static function logUserAccountCreation( User $user, $actiontext ) {
                global $wgRequest;
 
                // Get IP
                $ip = wfGetIP();
                // Get XFF header
                $xff = $wgRequest->getHeader( 'X-Forwarded-For' );
                list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff );
                // Get agent
                $agent = $wgRequest->getHeader( 'User-Agent' );
                $dbw = wfGetDB( DB_MASTER );
                $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' );
                $rcRow = array(
                        'cuc_id'         => $cuc_id,
                        'cuc_page_id'    => 0,
                        'cuc_namespace'  => NS_USER,
                        'cuc_title'      => '',
                        'cuc_minor'      => 0,
                        'cuc_user'       => $user->getId(),
                        'cuc_user_text'  => $user->getName(),
                        'cuc_actiontext' => wfMsgForContent( $actiontext ),
                        'cuc_comment'    => '',
                        'cuc_this_oldid' => 0,
                        'cuc_last_oldid' => 0,
                        'cuc_type'       => RC_LOG,
                        'cuc_timestamp'  => $dbw->timestamp( wfTimestampNow() ),
                        'cuc_ip'         => IP::sanitizeIP( $ip ),
                        'cuc_ip_hex'     => $ip ? IP::toHex( $ip ) : null,
                        'cuc_xff'        => !$isSquidOnly ? $xff : '',
                        'cuc_xff_hex'    => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null,
                        'cuc_agent'      => $agent
                );
                $dbw->insert( 'cu_changes', $rcRow, __METHOD__ );
 
                return true;
        }
 
        /**
         * Handler for non-standard (edit/log) entries that need IP data
         * 
         * @param $context IContextSource
         * @param $data Array
         * @return bool
         */
        protected static function onLoggableUserIPData( IContextSource $context, array $data ) {
                $user = $context->getUser();
                $request = $context->getRequest();
 
                // Get IP address
                $ip = $request->getIP();
                // Get XFF header
                $xff = $request->getHeader( 'X-Forwarded-For' );
                list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff );
                // Get agent
                $agent = $request->getHeader( 'User-Agent' );
 
                $dbw = wfGetDB( DB_MASTER );
                $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' );
                $rcRow = array(
                        'cuc_id'         => $cuc_id,
                        'cuc_page_id'    => $data['pageid'], // may be 0
                        'cuc_namespace'  => $data['namespace'],
                        'cuc_title'      => $data['title'], // may be ''
                        'cuc_minor'      => 0,
                        'cuc_user'       => $user->getId(),
                        'cuc_user_text'  => $user->getName(),
                        'cuc_actiontext' => $data['action'],
                        'cuc_comment'    => $data['comment'],
                        'cuc_this_oldid' => 0,
                        'cuc_last_oldid' => 0,
                        'cuc_type'       => RC_LOG,
                        'cuc_timestamp'  => $dbw->timestamp( $data['timestamp'] ),
                        'cuc_ip'         => IP::sanitizeIP( $ip ),
                        'cuc_ip_hex'     => $ip ? IP::toHex( $ip ) : null,
                        'cuc_xff'        => !$isSquidOnly ? $xff : '',
                        'cuc_xff_hex'    => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null,
                        'cuc_agent'      => $agent
                );
                $dbw->insert( 'cu_changes', $rcRow, __METHOD__ );
 
                return true;
        }
 
        /**
         * Hook function to prune data from the cu_changes table
         */
        public static function maybePruneIPData() {
                global $wgCUDMaxAge;
                # Every 100th edit, prune the checkuser changes table.
                if ( 0 == mt_rand( 0, 99 ) ) {
                        $dbw = wfGetDB( DB_MASTER );
                        $encCutoff = $dbw->addQuotes( $dbw->timestamp( time() - $wgCUDMaxAge ) );
                        $dbw->delete( 'cu_changes', array( "cuc_timestamp < $encCutoff" ), __METHOD__ );
                }
                return true;
        }
 
        /**
         * Locates the client IP within a given XFF string
         * @param string $xff
         * @return array( string, bool )
         */
        public static function getClientIPfromXFF( $xff ) {
                global $wgSquidServers, $wgSquidServersNoPurge;
 
                if ( !$xff ) {
                        return array( null, false );
                }
 
                // Avoid annoyingly long xff hacks
                $xff = trim( substr( $xff, 0, 255 ) );
                $client = null;
                $isSquidOnly = true;
                $trusted = true;
                // Check each IP, assuming they are separated by commas
                $ips = explode( ',', $xff );
                foreach ( $ips as $ip ) {
                        $ip = trim( $ip );
                        // If it is a valid IP, not a hash or such
                        if ( IP::isIPAddress( $ip ) ) {
                                # The first IP should be the client.
                                # Start only from the first public IP.
                                if ( is_null( $client ) ) {
                                        if ( IP::isPublic( $ip ) ) {
                                                $client = $ip;
                                        }
                                } elseif ( !in_array( $ip, $wgSquidServers )
                                        && !in_array( $ip, $wgSquidServersNoPurge ) )
                                {
                                        $isSquidOnly = false;
                                        break;
                                }
                        }
                }
 
                return array( $client, $isSquidOnly );
        }
 
        public static function checkUserSchemaUpdates( DatabaseUpdater $updater ) {
                $base = dirname( __FILE__ );
 
                $updater->addExtensionUpdate( array( 'CheckUserHooks::checkUserCreateTables' ) );
                if ( $updater->getDB()->getType() == 'mysql' ) {
                        $updater->addExtensionUpdate( array( 'addIndex', 'cu_changes',
                                'cuc_ip_hex_time', "$base/archives/patch-cu_changes_indexes.sql", true ) );
                        $updater->addExtensionUpdate( array( 'addIndex', 'cu_changes',
                                'cuc_user_ip_time', "$base/archives/patch-cu_changes_indexes2.sql", true ) );
                }
 
                return true;
        }
 
        public static function checkUserCreateTables( $updater ) {
                $base = dirname( __FILE__ );
 
        $db = $updater->getDB();
                if ( $db->tableExists( 'cu_changes' ) ) {
                        $updater->output( "...cu_changes table already exists.\n" );
                } else {
                        require_once "$base/install.inc";
                        create_cu_changes( $db );
                }
 
                if ( $db->tableExists( 'cu_log' ) ) {
                        $updater->output( "...cu_log table already exists.\n" );
                } else {
                        require_once "$base/install.inc";
                        create_cu_log( $db );
                }
        }
 
        /**
         * Tell the parser test engine to create a stub cu_changes table,
         * or temporary pages won't save correctly during the test run.
         */
        public static function checkUserParserTestTables( &$tables ) {
                $tables[] = 'cu_changes';
                return true;
        }
 
        /**
         * Add a link to Special:CheckUser on Special:Contributions/<username> for
         * privileged users.
         * @param $id Integer: user ID
         * @param $nt Title: user page title
         * @param $links Array: tool links
         * @return true
         */
        public static function loadCheckUserLink( $id, $nt, &$links ) {
                global $wgUser;
                if ( $wgUser->isAllowed( 'checkuser' ) ) {
                        $links[] = $wgUser->getSkin()->makeKnownLinkObj(
                                SpecialPage::getTitleFor( 'CheckUser' ),
                                wfMsgHtml( 'checkuser-contribs' ),
                                'user=' . urlencode( $nt->getText() )
                        );
                }
                return true;
        }
 
        /**
         * Retroactively autoblocks the last IP used by the user (if it is a user)
         * blocked by this Block.
         *
         * @param Block $block
         * @param Array &$blockIds
         */
        public static function doRetroactiveAutoblock( Block $block, array &$blockIds ) {
                $dbr = wfGetDB( DB_SLAVE );
 
                $user = User::newFromName( (string)$block->getTarget(), false );
                if ( !$user->getId() ) {
                        return array(); // user in an IP?
                }
 
                $options = array( 'ORDER BY' => 'cuc_timestamp DESC' );
                $options['LIMIT'] = 1; // just the last IP used
 
                $res = $dbr->select( 'cu_changes',
                        array( 'cuc_ip' ),
                        array( 'cuc_user' => $user->getId() ),
                        __METHOD__ ,
                        $options
                );
 
                # Iterate through IPs used (this is just one or zero for now)
                foreach ( $res as $row ) {
                        if ( $row->cuc_ip ) {
                                $id = $block->doAutoblock( $row->cuc_ip );
                                if ( $id ) $blockIds[] = $id;
                        }
                }
 
                return false; // autoblock handled
        }
}
Thetechexpert (talk)‎02:09, 27 February 2012

Indeed, I cannot find anything in a "RequestContext" class for my version of CU, using MW 1.18.0. I might suggest (I'd defer to a developer's opinion) that you replace:

 if ( isset( $rc_log_type ) && $rc_type == RC_LOG ) {
                        $target = Title::makeTitle( $rc_namespace, $rc_title );
                        $context = RequestContext::newExtraneousContext( $target );
 
                        $formatter = LogFormatter::newFromRow( $rc->mAttribs );
                        $formatter->setContext( $context );
                        $actionText = $formatter->getPlainActionText();

with

if ( isset( $rc_log_type ) && $rc_type == RC_LOG ) {
                        $target = Title::makeTitle( $rc_namespace, $rc_title );
                        $actionText = LogPage::actionText( $rc_log_type, $rc_log_action, $target,
                                null, LogPage::extractParams( $rc_params )
                        );
Jasper Deng (talk)‎02:18, 27 February 2012
 

when importing: cu_chanfes.sql and cu_log.sql on phpmyadmin should the code language be binary,utf8 or some other code language?

Thetechexpert (talk)‎02:18, 27 February 2012

The default works fine for me. I don't know much about that one.

Jasper Deng (talk)‎02:34, 27 February 2012
is it cu_log or cu_log.pg
is it cu_changes or cu_changes.pg
which one do I import?
Thetechexpert (talk)‎04:07, 27 February 2012
 

now I am getting this error:

Parse error: syntax error, unexpected T_PUBLIC in H:\www\wikipedia\extensions\CheckUser\CheckUser.hooks.php on line 63

Thetechexpert (talk)‎04:15, 27 February 2012

It looks like your version of this file is missing some things; did you download using Subversion?

Jasper Deng (talk)‎04:28, 27 February 2012

Yes

Thetechexpert (talk)‎04:58, 27 February 2012

Then, if you're using MediaWiki 1.18.0, you'll have to use Special:ExtensionDistributor/CheckUser to download a 1.18-appropriate version. The version you downloaded is likely a late version with things not implemented yet in 1.18.

Jasper Deng (talk)‎05:21, 27 February 2012

Thanks, That worked!

Thetechexpert (talk)‎05:39, 27 February 2012
 
 
 
 
 
 
 
 
 
 
 
 
 
Retrieved from "http://www.mediawiki.org/wiki/Thread:Project:Support_desk/CheckUser_Installation/reply_(11)#CheckUser_Installation_12499"