Changeset 4350

Timestamp:

11/11/2016 11:54:36 PM (7 years ago)

Author:

ocean90

Message:

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

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-custom-stats/stats/user.php (modified) (4 diffs)

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

@@ -63 +63 @@
         global $wpdb;
 
+        $now = current_time( 'mysql', 1 );
+
         $values = array();
         foreach ( $this->user_stats as $key => $stats ) {
             list( $user_id, $locale, $locale_slug ) = explode( ',', $key );
 
-            $values[] = $wpdb->prepare( '(%d, %s, %s, %d, %d)',
+            $values[] = $wpdb->prepare( '(%d, %s, %s, %d, %d, %s, %s)',
                 $user_id,
                 $locale,
                 $locale_slug,
                 $stats->suggested,
-                $stats->accepted
+                $stats->accepted,
+                $now,
+                $now
             );
 
@@ -78 +82 @@
             if ( count( $values ) > 50 ) {
                 $wpdb->query(
-                    "INSERT INTO {$wpdb->user_translations_count} (`user_id`, `locale`, `locale_slug`, `suggested`, `accepted`)
+                    "INSERT INTO {$wpdb->user_translations_count} (`user_id`, `locale`, `locale_slug`, `suggested`, `accepted`, `date_added`, `date_modified`)
                     VALUES " . implode( ', ', $values ) . "
-                    ON DUPLICATE KEY UPDATE `suggested`=`suggested` + VALUES(`suggested`), `accepted`=`accepted` + VALUES(`accepted`)"
+                    ON DUPLICATE KEY UPDATE `suggested`=`suggested` + VALUES(`suggested`), `accepted`=`accepted` + VALUES(`accepted`), `date_modified`=VALUES(`date_modified`)"
                 );
                 $values = array();
@@ -88 +92 @@
         if ( $values ) {
             $wpdb->query(
-                "INSERT INTO {$wpdb->user_translations_count} (`user_id`, `locale`, `locale_slug`, `suggested`, `accepted`)
+                "INSERT INTO {$wpdb->user_translations_count} (`user_id`, `locale`, `locale_slug`, `suggested`, `accepted`, `date_added`, `date_modified`)
                 VALUES " . implode( ', ', $values ) . "
-                ON DUPLICATE KEY UPDATE `suggested`=`suggested` + VALUES(`suggested`), `accepted`=`accepted` + VALUES(`accepted`)"
+                ON DUPLICATE KEY UPDATE `suggested`=`suggested` + VALUES(`suggested`), `accepted`=`accepted` + VALUES(`accepted`), `date_modified`=VALUES(`date_modified`)"
             );
         }
@@ -108 +112 @@
   `suggested` int(10) unsigned NOT NULL DEFAULT '0',
   `accepted` int(10) unsigned NOT NULL DEFAULT '0',
+  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   PRIMARY KEY (`id`),
   UNIQUE KEY `user_id` (`user_id`,`locale`,`locale_slug`),