SpecialTranslationStats.php

Go to the documentation of this file.

<?php
class SpecialTranslationStats extends IncludableSpecialPage {
    public function __construct() {
        parent::__construct( 'TranslationStats' );
    }

    protected static $graphs = array(
        'edits' => 'TranslatePerLanguageStats',
        'users' => 'TranslatePerLanguageStats',
        'registrations' => 'TranslateRegistrationStats',
        'reviews' => 'ReviewPerLanguageStats',
        'reviewers' => 'ReviewPerLanguageStats',
    );

    public function getGraphTypes() {
        return array_keys( self::$graphs );
    }

    public function getGraphClass( $type ) {
        return self::$graphs[$type];
    }

    public function execute( $par ) {
        $this->getOutput()->addModules( 'ext.translate.special.translationstats' );

        $opts = new FormOptions();
        $opts->add( 'graphit', false );
        $opts->add( 'preview', false );
        $opts->add( 'language', '' );
        $opts->add( 'count', 'edits' );
        $opts->add( 'scale', 'days' );
        $opts->add( 'days', 30 );
        $opts->add( 'width', 600 );
        $opts->add( 'height', 400 );
        $opts->add( 'group', '' );
        $opts->add( 'uselang', '' );
        $opts->add( 'start', '' );
        $opts->fetchValuesFromRequest( $this->getRequest() );

        $pars = explode( ';', $par );

        foreach ( $pars as $item ) {
            if ( strpos( $item, '=' ) === false ) {
                continue;
            }

            list( $key, $value ) = array_map( 'trim', explode( '=', $item, 2 ) );
            if ( isset( $opts[$key] ) ) {
                $opts[$key] = $value;
            }
        }

        $opts->validateIntBounds( 'days', 1, 10000 );
        $opts->validateIntBounds( 'width', 200, 1000 );
        $opts->validateIntBounds( 'height', 200, 1000 );

        if ( $opts['start'] !== '' ) {
            $opts['start'] = strval( wfTimestamp( TS_MW, $opts['start'] ) );
        }

        $validScales = array( 'months', 'weeks', 'days', 'hours' );
        if ( !in_array( $opts['scale'], $validScales ) ) {
            $opts['scale'] = 'days';
        }

        if ( $opts['scale'] === 'hours' ) {
            $opts->validateIntBounds( 'days', 1, 4 );
        }

        $validCounts = $this->getGraphTypes();
        if ( !in_array( $opts['count'], $validCounts ) ) {
            $opts['count'] = 'edits';
        }

        foreach ( array( 'group', 'language' ) as $t ) {
            $values = array_map( 'trim', explode( ',', $opts[$t] ) );
            $values = array_splice( $values, 0, 4 );
            if ( $t === 'group' ) {
                // BC for old syntax which replaced _ to | which was not allowed
                $values = preg_replace( '~^page_~', 'page-', $values );
            }
            $opts[$t] = implode( ',', $values );
        }

        if ( $this->including() ) {
            $this->getOutput()->addHTML( $this->image( $opts ) );
        } elseif ( $opts['graphit'] ) {

            if ( !class_exists( 'PHPlot' ) ) {
                header( "HTTP/1.0 500 Multi fail" );
                echo "PHPlot not found";
            }

            if ( !$this->getRequest()->getBool( 'debug' ) ) {
                $this->getOutput()->disable();
                header( 'Content-Type: image/png' );
                header( 'Cache-Control: private, max-age=3600' );
                header( 'Expires: ' . wfTimestamp( TS_RFC2822, time() + 3600 ) );
            }
            $this->draw( $opts );
        } else {
            $this->form( $opts );
        }
    }

    protected function form( FormOptions $opts ) {
        global $wgScript;

        $this->setHeaders();
        $out = $this->getOutput();
        TranslateUtils::addSpecialHelpLink( $out, 'Help:Extension:Translate/Statistics_and_reporting' );
        $out->addWikiMsg( 'translate-statsf-intro' );

        $out->addHTML(
            Xml::fieldset( $this->msg( 'translate-statsf-options' )->text() ) .
                Html::openElement( 'form', array( 'action' => $wgScript ) ) .
                Html::hidden( 'title', $this->getTitle()->getPrefixedText() ) .
                Html::hidden( 'preview', 1 ) .
                '<table>'
        );

        $submit = Xml::submitButton( $this->msg( 'translate-statsf-submit' )->text() );

        $out->addHTML(
            $this->eInput( 'width', $opts ) .
                $this->eInput( 'height', $opts ) .
                '<tr><td colspan="2"><hr /></td></tr>' .
                $this->eInput( 'start', $opts, 16 ) . // Should fit yyyymmddhhmmss
                $this->eInput( 'days', $opts ) .
                $this->eRadio( 'scale', $opts, array( 'months', 'weeks', 'days', 'hours' ) ) .
                $this->eRadio( 'count', $opts, $this->getGraphTypes() ) .
                '<tr><td colspan="2"><hr /></td></tr>' .
                $this->eLanguage( 'language', $opts ) .
                $this->eGroup( 'group', $opts ) .
                '<tr><td colspan="2"><hr /></td></tr>' .
                '<tr><td colspan="2">' . $submit . '</td></tr>'
        );

        $out->addHTML(
            '</table>' .
                '</form>' .
                '</fieldset>'
        );

        if ( !$opts['preview'] ) {
            return;
        }

        $spiParams = '';
        foreach ( $opts->getChangedValues() as $key => $v ) {
            if ( $key === 'preview' ) {
                continue;
            }

            if ( $spiParams !== '' ) {
                $spiParams .= ';';
            }

            $spiParams .= wfEscapeWikiText( "$key=$v" );
        }

        if ( $spiParams !== '' ) {
            $spiParams = '/' . $spiParams;
        }

        $titleText = $this->getTitle()->getPrefixedText();

        $out->addHTML(
            Html::element( 'hr' ) .
                Html::element( 'pre', array(), "{{{$titleText}{$spiParams}}}" )
        );

        $out->addHTML(
            Html::element( 'hr' ) .
                Html::rawElement(
                    'div',
                    array( 'style' => 'margin: 1em auto; text-align: center;' ),
                    $this->image( $opts )
                )
        );
    }

    protected function eInput( $name, FormOptions $opts, $width = 4 ) {
        $value = $opts[$name];

        return
            '<tr><td>' . $this->eLabel( $name ) . '</td><td>' .
            Xml::input( $name, $width, $value, array( 'id' => $name ) ) .
            '</td></tr>' . "\n";
    }

    protected function eLabel( $name ) {
        // Give grep a chance to find the usages:
        // translate-statsf-width, translate-statsf-height, translate-statsf-start,
        // translate-statsf-days, translate-statsf-scale, translate-statsf-count,
        // translate-statsf-language, translate-statsf-group
        $label = 'translate-statsf-' . $name;
        $label = $this->msg( $label )->escaped();

        return Xml::tags( 'label', array( 'for' => $name ), $label );
    }

    protected function eRadio( $name, FormOptions $opts, array $alts ) {
        // Give grep a chance to find the usages:
        // translate-statsf-scale, translate-statsf-count
        $label = 'translate-statsf-' . $name;
        $label = $this->msg( $label )->escaped();
        $s = '<tr><td>' . $label . '</td><td>';

        $options = array();
        foreach ( $alts as $alt ) {
            $id = "$name-$alt";
            $radio = Xml::radio( $name, $alt, $alt === $opts[$name],
                array( 'id' => $id ) ) . ' ';
            $options[] = $radio . ' ' . $this->eLabel( $id );
        }

        $s .= implode( ' ', $options );
        $s .= '</td></tr>' . "\n";

        return $s;
    }

    protected function eLanguage( $name, FormOptions $opts ) {
        $value = $opts[$name];

        $select = $this->languageSelector();
        $select->setTargetId( 'language' );

        return
            '<tr><td>' . $this->eLabel( $name ) . '</td><td>' .
            $select->getHtmlAndPrepareJs() . '<br />' .
            Xml::input( $name, 20, $value, array( 'id' => $name ) ) .
            '</td></tr>' . "\n";
    }

    protected function languageSelector() {
        if ( is_callable( array( 'LanguageNames', 'getNames' ) ) ) {
            $languages = LanguageNames::getNames( $this->getLanguage()->getCode(),
                LanguageNames::FALLBACK_NORMAL,
                LanguageNames::LIST_MW_AND_CLDR
            );
        } else {
            $languages = Language::getLanguageNames( false );
        }

        ksort( $languages );

        $selector = new XmlSelect( 'mw-language-selector', 'mw-language-selector' );
        foreach ( $languages as $code => $name ) {
            $selector->addOption( "$code - $name", $code );
        }

        $jsSelect = new JsSelectToInput( $selector );
        $jsSelect->setSourceId( 'mw-language-selector' );

        return $jsSelect;
    }

    protected function eGroup( $name, FormOptions $opts ) {
        $value = $opts[$name];

        $select = $this->groupSelector();
        $select->setTargetId( 'group' );

        return
            '<tr><td>' . $this->eLabel( $name ) . '</td><td>' .
            $select->getHtmlAndPrepareJs() . '<br />' .
            Xml::input( $name, 20, $value, array( 'id' => $name ) ) .
            '</td></tr>' . "\n";
    }

    protected function groupSelector() {
        $groups = MessageGroups::singleton()->getGroups();
        foreach ( $groups as $key => $group ) {
            if ( !$group->exists() ) {
                unset( $groups[$key] );
                continue;
            }
        }

        ksort( $groups );

        $selector = new XmlSelect( 'mw-group-selector', 'mw-group-selector' );
        foreach ( $groups as $code => $name ) {
            $selector->addOption( $name->getLabel(), $code );
        }

        $jsSelect = new JsSelectToInput( $selector );
        $jsSelect->setSourceId( 'mw-group-selector' );

        return $jsSelect;
    }

    protected function image( FormOptions $opts ) {
        $title = $this->getTitle();
        $cgiparams = wfArrayToCgi( array( 'graphit' => true ), $opts->getAllValues() );
        $href = $title->getLocalUrl( $cgiparams );

        return Xml::element( 'img',
            array(
                'src' => $href,
                'width' => $opts['width'],
                'height' => $opts['height'],
            )
        );
    }

    protected function getData( FormOptions $opts ) {
        $dbr = wfGetDB( DB_SLAVE );

        $class = $this->getGraphClass( $opts['count'] );
        $so = new $class( $opts );

        $fixedStart = $opts->getValue( 'start' ) !== '';

        $now = time();
        $period = 3600 * 24 * $opts->getValue( 'days' );

        if ( $fixedStart ) {
            $cutoff = wfTimestamp( TS_UNIX, $opts->getValue( 'start' ) );
        } else {
            $cutoff = $now - $period;
        }
        $cutoff = self::roundTimestampToCutoff( $opts['scale'], $cutoff, 'earlier' );

        $start = $cutoff;

        if ( $fixedStart ) {
            $end = self::roundTimestampToCutoff( $opts['scale'], $start + $period, 'later' ) - 1;
        } else {
            $end = null;
        }

        $tables = array();
        $fields = array();
        $conds = array();
        $type = __METHOD__;
        $options = array();

        $so->preQuery( $tables, $fields, $conds, $type, $options, $start, $end );
        $res = $dbr->select( $tables, $fields, $conds, $type, $options );
        wfDebug( __METHOD__ . "-queryend\n" );

        // Start processing the data
        $dateFormat = $so->getDateFormat();
        $increment = self::getIncrement( $opts['scale'] );

        $labels = $so->labels();
        $keys = array_keys( $labels );
        $values = array_pad( array(), count( $labels ), 0 );
        $defaults = array_combine( $keys, $values );

        $data = array();
        // Allow 10 seconds in the future for processing time
        $lastValue = $end !== null ? $end : $now + 10;
        $lang = $this->getLanguage();
        while ( $cutoff <= $lastValue ) {
            $date = $lang->sprintfDate( $dateFormat, wfTimestamp( TS_MW, $cutoff ) );
            $cutoff += $increment;
            $data[$date] = $defaults;
        }

        // Processing
        $labelToIndex = array_flip( $labels );

        foreach ( $res as $row ) {
            $indexLabels = $so->indexOf( $row );
            if ( $indexLabels === false ) {
                continue;
            }

            foreach ( (array)$indexLabels as $i ) {
                if ( !isset( $labelToIndex[$i] ) ) {
                    continue;
                }
                $date = $lang->sprintfDate( $dateFormat, $so->getTimestamp( $row ) );
                // Ignore values outside range
                if ( !isset( $data[$date] ) ) {
                    continue;
                }

                $data[$date][$labelToIndex[$i]]++;
            }
        }

        // Don't display dummy label
        if ( count( $labels ) === 1 && $labels[0] === 'all' ) {
            $labels = array();
        }

        foreach ( $labels as &$label ) {
            if ( strpos( $label, '@' ) === false ) {
                continue;
            }
            list( $groupId, $code ) = explode( '@', $label, 2 );
            if ( $code && $groupId ) {
                $code = TranslateUtils::getLanguageName( $code, $lang->getCode() ) . " ($code)";
                $group = MessageGroups::getGroup( $groupId );
                $group = $group ? $group->getLabel() : $groupId;
                $label = "$group @ $code";
            } elseif ( $code ) {
                $label = TranslateUtils::getLanguageName( $code, $lang->getCode() ) . " ($code)";
            } elseif ( $groupId ) {
                $group = MessageGroups::getGroup( $groupId );
                $label = $group ? $group->getLabel() : $groupId;
            }
        }

        if ( $end == null ) {
            $last = array_splice( $data, -1, 1 );
            // Indicator that the last value is not full
            $data[key( $last ) . '*'] = current( $last );
        }

        return array( $labels, $data );
    }

    protected static function roundTimestampToCutoff( $scale, $cutoff, $direction = 'earlier' ) {
        $dir = $direction === 'earlier' ? -1 : 1;

        /* Ensure that the first item in the graph has full data even
        * if it doesn't align with the given 'days' boundary */
        if ( $scale === 'hours' ) {
            $cutoff += self::roundingAddition( $cutoff, 3600, $dir );
        } elseif ( $scale === 'days' ) {
            $cutoff += self::roundingAddition( $cutoff, 86400, $dir );
        } elseif ( $scale === 'weeks' ) {
            /* Here we assume that week starts on monday, which does not
            * always hold true. Go Xwards day by day until we are on monday */
            while ( date( 'D', $cutoff ) !== "Mon" ) {
                $cutoff += $dir * 86400;
            }
            // Round to nearest day
            $cutoff -= ( $cutoff % 86400 );
        } elseif ( $scale === 'months' ) {
            // Go Xwards/ day by day until we are on the first day of the month
            while ( date( 'j', $cutoff ) !== "1" ) {
                $cutoff += $dir * 86400;
            }
            // Round to nearest day
            $cutoff -= ( $cutoff % 86400 );
        }

        return $cutoff;
    }

    protected static function roundingAddition( $ts, $amount, $dir ) {
        if ( $dir === -1 ) {
            return -1 * ( $ts % $amount );
        } else {
            return $amount - ( $ts % $amount );
        }
    }

    public function draw( FormOptions $opts ) {
        global $wgTranslatePHPlotFont;

        $width = $opts->getValue( 'width' );
        $height = $opts->getValue( 'height' );
        // Define the object
        $plot = new PHPlot( $width, $height );

        list( $legend, $resData ) = $this->getData( $opts );
        $count = count( $resData );
        $skip = intval( $count / ( $width / 60 ) - 1 );
        $i = $count;
        $data = array();

        foreach ( $resData as $date => $edits ) {
            if ( $skip > 0 ) {
                if ( ( $count - $i ) % $skip !== 0 ) {
                    $date = '';
                }
            }

            if ( strpos( $date, ';' ) !== false ) {
                list( , $date ) = explode( ';', $date, 2 );
            }

            array_unshift( $edits, $date );
            $data[] = $edits;
            $i--;
        }

        $font = FCFontFinder::findFile( $this->getLanguage()->getCode() );

        if ( $font ) {
            $plot->SetDefaultTTFont( $font );
        } else {
            $plot->SetDefaultTTFont( $wgTranslatePHPlotFont );
        }
        $plot->SetDataValues( $data );

        if ( $legend !== null ) {
            $plot->SetLegend( $legend );
        }

        $numberFont = FCFontFinder::findFile( 'en' );

        $plot->setFont( 'x_label', $numberFont, 8 );
        $plot->setFont( 'y_label', $numberFont, 8 );
        // Give grep a chance to find the usages:
        // translate-stats-edits, translate-stats-users, translate-stats-registrations,
        // translate-stats-reviews, translate-stats-reviewers
        $yTitle = $this->msg( 'translate-stats-' . $opts['count'] )->escaped();

        // Turn off X axis ticks and labels because they get in the way:
        $plot->SetYTitle( $yTitle );
        $plot->SetXTickLabelPos( 'none' );
        $plot->SetXTickPos( 'none' );
        $plot->SetXLabelAngle( 45 );

        $max = max( array_map( 'max', $resData ) );
        $max = self::roundToSignificant( $max, 1 );
        $max = round( $max, intval( -log( $max, 10 ) ) );

        $yTick = 10;
        while ( $max / $yTick > $height / 20 ) {
            $yTick *= 2;
        }

        // If we have very small case, ensure that there is at least one tick
        $yTick = min( $max, $yTick );
        $yTick = self::roundToSignificant( $yTick );
        $plot->SetYTickIncrement( $yTick );
        $plot->SetPlotAreaWorld( null, 0, null, $max );

        $plot->SetTransparentColor( 'white' );
        $plot->SetBackgroundColor( 'white' );

        // Draw it
        $plot->DrawGraph();
    }

    public static function roundToSignificant( $number, $significant = 1 ) {
        $log = (int)log( $number, 10 );
        $nonSignificant = max( 0, $log - $significant + 1 );
        $factor = pow( 10, $nonSignificant );

        return intval( ceil( $number / $factor ) * $factor );
    }

    public static function getIncrement( $scale ) {
        $increment = 3600 * 24;
        if ( $scale === 'months' ) {
            /* We use increment to fill up the values. Use number small enough
             * to ensure we hit each month */
            $increment = 3600 * 24 * 15;
        } elseif ( $scale === 'weeks' ) {
            $increment = 3600 * 24 * 7;
        } elseif ( $scale === 'hours' ) {
            $increment = 3600;
        }

        return $increment;
    }
}

interface TranslationStatsInterface {
    public function __construct( FormOptions $opts );

    public function preQuery( &$tables, &$fields, &$conds, &$type, &$options, $start, $end );

    public function indexOf( $row );

    public function labels();

    public function getTimestamp( $row );

    public function getDateFormat();
}

abstract class TranslationStatsBase implements TranslationStatsInterface {
    protected $opts;

    public function __construct( FormOptions $opts ) {
        $this->opts = $opts;
    }

    public function indexOf( $row ) {
        return array( 'all' );
    }

    public function labels() {
        return array( 'all' );
    }

    public function getDateFormat() {
        $dateFormat = 'Y-m-d';
        if ( $this->opts['scale'] === 'months' ) {
            $dateFormat = 'Y-m';
        } elseif ( $this->opts['scale'] === 'weeks' ) {
            $dateFormat = 'Y-\WW';
        } elseif ( $this->opts['scale'] === 'hours' ) {
            $dateFormat .= ';H';
        }

        return $dateFormat;
    }

    protected static function makeTimeCondition( $field, $start, $end ) {
        $db = wfGetDB( DB_SLAVE );

        $conds = array();
        if ( $start !== null ) {
            $conds[] = "$field >= '{$db->timestamp( $start )}'";
        }
        if ( $end !== null ) {
            $conds[] = "$field <= '{$db->timestamp( $end )}'";
        }

        return $conds;
    }

    protected static function namespacesFromGroups( $groupIds ) {
        $namespaces = array();
        foreach ( $groupIds as $id ) {
            $group = MessageGroups::getGroup( $id );
            if ( $group ) {
                $namespace = $group->getNamespace();
                $namespaces[$namespace] = true;
            }
        }

        return array_keys( $namespaces );
    }
}

class TranslatePerLanguageStats extends TranslationStatsBase {
    protected $usercache;

    protected $codes, $groups;

    public function __construct( FormOptions $opts ) {
        parent::__construct( $opts );
        // This query is slow... ensure a lower limit.
        $opts->validateIntBounds( 'days', 1, 200 );
    }

    public function preQuery( &$tables, &$fields, &$conds, &$type, &$options, $start, $end ) {
        global $wgTranslateMessageNamespaces;

        $db = wfGetDB( DB_SLAVE );

        $tables = array( 'recentchanges' );
        $fields = array( 'rc_timestamp' );

        $conds = array(
            'rc_namespace' => $wgTranslateMessageNamespaces,
            'rc_bot' => 0,
            'rc_type != ' . RC_LOG,
        );

        $timeConds = self::makeTimeCondition( 'rc_timestamp', $start, $end );
        $conds = array_merge( $conds, $timeConds );

        $options = array( 'ORDER BY' => 'rc_timestamp' );

        $this->groups = array_filter( array_map( 'trim', explode( ',', $this->opts['group'] ) ) );
        $this->codes = array_filter( array_map( 'trim', explode( ',', $this->opts['language'] ) ) );

        $namespaces = self::namespacesFromGroups( $this->groups );
        if ( count( $namespaces ) ) {
            $conds['rc_namespace'] = $namespaces;
        }

        $languages = array();
        foreach ( $this->codes as $code ) {
            $languages[] = 'rc_title ' . $db->buildLike( $db->anyString(), "/$code" );
        }
        if ( count( $languages ) ) {
            $conds[] = $db->makeList( $languages, LIST_OR );
        }

        $fields[] = 'rc_title';

        if ( $this->groups ) {
            $fields[] = 'rc_namespace';
        }

        if ( $this->opts['count'] === 'users' ) {
            $fields[] = 'rc_user_text';
        }

        $type .= '-perlang';
    }

    public function indexOf( $row ) {
        // We need to check that there is only one user per day.
        if ( $this->opts['count'] === 'users' ) {
            $date = $this->formatTimestamp( $row->rc_timestamp );

            if ( isset( $this->usercache[$date][$row->rc_user_text] ) ) {
                return -1;
            } else {
                $this->usercache[$date][$row->rc_user_text] = 1;
            }
        }

        // Do not consider language-less pages.
        if ( strpos( $row->rc_title, '/' ) === false ) {
            return false;
        }

        // No filters, just one key to track.
        if ( !$this->groups && !$this->codes ) {
            return 'all';
        }

        // The key-building needs to be in sync with ::labels().
        list( $key, $code ) = TranslateUtils::figureMessage( $row->rc_title );

        $groups = array();
        $codes = array();

        if ( $this->groups ) {
            /*
             * Get list of keys that the message belongs to, and filter
             * out those which are not requested.
             */
            $groups = TranslateUtils::messageKeyToGroups( $row->rc_namespace, $key );
            $groups = array_intersect( $this->groups, $groups );
        }

        if ( $this->codes ) {
            $codes = array( $code );
        }

        return $this->combineTwoArrays( $groups, $codes );
    }

    public function labels() {
        return $this->combineTwoArrays( $this->groups, $this->codes );
    }

    public function getTimestamp( $row ) {
        return $row->rc_timestamp;
    }

    protected function makeLabel( $group, $code ) {
        if ( $group || $code ) {
            return "$group@$code";
        } else {
            return 'all';
        }
    }

    protected function combineTwoArrays( $groups, $codes ) {
        if ( !count( $groups ) ) {
            $groups[] = false;
        }

        if ( !count( $codes ) ) {
            $codes[] = false;
        }

        $items = array();
        foreach ( $groups as $group ) {
            foreach ( $codes as $code ) {
                $items[] = $this->makeLabel( $group, $code );
            }
        }

        return $items;
    }

    protected function formatTimestamp( $timestamp ) {
        global $wgContLang;

        switch ( $this->opts['scale'] ) {
            case 'hours' :
                $cut = 4;
                break;
            case 'days' :
                $cut = 6;
                break;
            case 'months':
                $cut = 8;
                break;
            default :
                return $wgContLang->sprintfDate( $this->getDateFormat(), $timestamp );
        }

        return substr( $timestamp, 0, -$cut );
    }
}

class TranslateRegistrationStats extends TranslationStatsBase {
    public function preQuery( &$tables, &$fields, &$conds, &$type, &$options, $start, $end ) {
        $tables = 'user';
        $fields = 'user_registration';
        $conds = self::makeTimeCondition( 'user_registration', $start, $end );
        $type .= '-registration';
        $options = array();
    }

    public function getTimestamp( $row ) {
        return $row->user_registration;
    }
}

class ReviewPerLanguageStats extends TranslatePerLanguageStats {
    public function preQuery( &$tables, &$fields, &$conds, &$type, &$options, $start, $end ) {
        global $wgTranslateMessageNamespaces;

        $db = wfGetDB( DB_SLAVE );

        $tables = array( 'logging' );
        $fields = array( 'log_timestamp' );

        $conds = array(
            'log_namespace' => $wgTranslateMessageNamespaces,
            'log_action' => 'message',
        );

        $timeConds = self::makeTimeCondition( 'log_timestamp', $start, $end );
        $conds = array_merge( $conds, $timeConds );

        $options = array( 'ORDER BY' => 'log_timestamp' );

        $this->groups = array_filter( array_map( 'trim', explode( ',', $this->opts['group'] ) ) );
        $this->codes = array_filter( array_map( 'trim', explode( ',', $this->opts['language'] ) ) );

        $namespaces = self::namespacesFromGroups( $this->groups );
        if ( count( $namespaces ) ) {
            $conds['log_namespace'] = $namespaces;
        }

        $languages = array();
        foreach ( $this->codes as $code ) {
            $languages[] = 'log_title ' . $db->buildLike( $db->anyString(), "/$code" );
        }
        if ( count( $languages ) ) {
            $conds[] = $db->makeList( $languages, LIST_OR );
        }

        $fields[] = 'log_title';

        if ( $this->groups ) {
            $fields[] = 'log_namespace';
        }

        if ( $this->opts['count'] === 'reviewers' ) {
            $fields[] = 'log_user_text';
        }

        $type .= '-reviews';
    }

    public function indexOf( $row ) {
        // We need to check that there is only one user per day.
        if ( $this->opts['count'] === 'reviewers' ) {
            $date = $this->formatTimestamp( $row->log_timestamp );

            if ( isset( $this->usercache[$date][$row->log_user_text] ) ) {
                return -1;
            } else {
                $this->usercache[$date][$row->log_user_text] = 1;
            }
        }

        // Do not consider language-less pages.
        if ( strpos( $row->log_title, '/' ) === false ) {
            return false;
        }

        // No filters, just one key to track.
        if ( !$this->groups && !$this->codes ) {
            return 'all';
        }

        // The key-building needs to be in sync with ::labels().
        list( $key, $code ) = TranslateUtils::figureMessage( $row->log_title );

        $groups = array();
        $codes = array();

        if ( $this->groups ) {
            /* Get list of keys that the message belongs to, and filter
             * out those which are not requested. */
            $groups = TranslateUtils::messageKeyToGroups( $row->log_namespace, $key );
            $groups = array_intersect( $this->groups, $groups );
        }

        if ( $this->codes ) {
            $codes = array( $code );
        }

        return $this->combineTwoArrays( $groups, $codes );
    }

    public function labels() {
        return $this->combineTwoArrays( $this->groups, $this->codes );
    }

    public function getTimestamp( $row ) {
        return $row->log_timestamp;
    }
}