Making WordPress.org

Changeset 4350


Ignore:
Timestamp:
11/11/2016 11:54:36 PM (7 years ago)
Author:
ocean90
Message:

Translate, User Stats: Store current time when updating stats.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-custom-stats/stats/user.php

    r2739 r4350  
    6363        global $wpdb;
    6464
     65        $now = current_time( 'mysql', 1 );
     66
    6567        $values = array();
    6668        foreach ( $this->user_stats as $key => $stats ) {
    6769            list( $user_id, $locale, $locale_slug ) = explode( ',', $key );
    6870
    69             $values[] = $wpdb->prepare( '(%d, %s, %s, %d, %d)',
     71            $values[] = $wpdb->prepare( '(%d, %s, %s, %d, %d, %s, %s)',
    7072                $user_id,
    7173                $locale,
    7274                $locale_slug,
    7375                $stats->suggested,
    74                 $stats->accepted
     76                $stats->accepted,
     77                $now,
     78                $now
    7579            );
    7680
     
    7882            if ( count( $values ) > 50 ) {
    7983                $wpdb->query(
    80                     "INSERT INTO {$wpdb->user_translations_count} (`user_id`, `locale`, `locale_slug`, `suggested`, `accepted`)
     84                    "INSERT INTO {$wpdb->user_translations_count} (`user_id`, `locale`, `locale_slug`, `suggested`, `accepted`, `date_added`, `date_modified`)
    8185                    VALUES " . implode( ', ', $values ) . "
    82                     ON DUPLICATE KEY UPDATE `suggested`=`suggested` + VALUES(`suggested`), `accepted`=`accepted` + VALUES(`accepted`)"
     86                    ON DUPLICATE KEY UPDATE `suggested`=`suggested` + VALUES(`suggested`), `accepted`=`accepted` + VALUES(`accepted`), `date_modified`=VALUES(`date_modified`)"
    8387                );
    8488                $values = array();
     
    8892        if ( $values ) {
    8993            $wpdb->query(
    90                 "INSERT INTO {$wpdb->user_translations_count} (`user_id`, `locale`, `locale_slug`, `suggested`, `accepted`)
     94                "INSERT INTO {$wpdb->user_translations_count} (`user_id`, `locale`, `locale_slug`, `suggested`, `accepted`, `date_added`, `date_modified`)
    9195                VALUES " . implode( ', ', $values ) . "
    92                 ON DUPLICATE KEY UPDATE `suggested`=`suggested` + VALUES(`suggested`), `accepted`=`accepted` + VALUES(`accepted`)"
     96                ON DUPLICATE KEY UPDATE `suggested`=`suggested` + VALUES(`suggested`), `accepted`=`accepted` + VALUES(`accepted`), `date_modified`=VALUES(`date_modified`)"
    9397            );
    9498        }
     
    108112  `suggested` int(10) unsigned NOT NULL DEFAULT '0',
    109113  `accepted` int(10) unsigned NOT NULL DEFAULT '0',
     114  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
     115  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    110116  PRIMARY KEY (`id`),
    111117  UNIQUE KEY `user_id` (`user_id`,`locale`,`locale_slug`),
Note: See TracChangeset for help on using the changeset viewer.