Changeset 4350
- Timestamp:
- 11/11/2016 11:54:36 PM (7 years ago)
- 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 63 63 global $wpdb; 64 64 65 $now = current_time( 'mysql', 1 ); 66 65 67 $values = array(); 66 68 foreach ( $this->user_stats as $key => $stats ) { 67 69 list( $user_id, $locale, $locale_slug ) = explode( ',', $key ); 68 70 69 $values[] = $wpdb->prepare( '(%d, %s, %s, %d, %d )',71 $values[] = $wpdb->prepare( '(%d, %s, %s, %d, %d, %s, %s)', 70 72 $user_id, 71 73 $locale, 72 74 $locale_slug, 73 75 $stats->suggested, 74 $stats->accepted 76 $stats->accepted, 77 $now, 78 $now 75 79 ); 76 80 … … 78 82 if ( count( $values ) > 50 ) { 79 83 $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`) 81 85 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`)" 83 87 ); 84 88 $values = array(); … … 88 92 if ( $values ) { 89 93 $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`) 91 95 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`)" 93 97 ); 94 98 } … … 108 112 `suggested` int(10) unsigned NOT NULL DEFAULT '0', 109 113 `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', 110 116 PRIMARY KEY (`id`), 111 117 UNIQUE KEY `user_id` (`user_id`,`locale`,`locale_slug`),
Note: See TracChangeset
for help on using the changeset viewer.