Changeset 13279

Timestamp:

03/05/2024 01:17:22 PM (3 years ago)

Author:

amieiro

Message:

Translate: Sync "Translation Events" from GitHub

Location:

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-translation-events

Files:

• includes/stats-calculator.php (modified) (2 diffs)
• includes/stats-listener.php (modified) (1 diff)
• wporg-gp-translation-events.php (modified) (1 diff)

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-translation-events/includes/stats-calculator.php

@@ -66 +66 @@
         public function for_event( WP_Post $event ): Event_Stats {
                 $stats = new Event_Stats();
-                global $wpdb;
+                global $wpdb, $gp_table_prefix;
 
+                // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
                 // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery
                 // phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching
@@ -79 +80 @@
                                            count(*) as total,
                                            count(distinct user_id) as users
-                                from {$wpdb->base_prefix}event_actions
+                                from {$gp_table_prefix}event_actions
                                 where event_id = %d
                                 group by locale with rollup

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-translation-events/includes/stats-listener.php

@@ -76 +76 @@
                         /** @var GP_Translation_Set $translation_set Translation set */
                         $translation_set = ( new GP_Translation_Set() )->find_one( array( 'id' => $translation->translation_set_id ) );
-                        global $wpdb;
+                        global $wpdb, $gp_table_prefix;
 
                         foreach ( $events as $event ) {
                                 // A given user can only do one action on a specific translation.
                                 // So we insert ignore, which will keep only the first action.
+                                // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
                                 // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery
                                 // phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching
                                 $wpdb->query(
                                         $wpdb->prepare(
-                                                "insert ignore into {$wpdb->base_prefix}event_actions (event_id, locale, user_id, original_id, action, happened_at) values (%d, %s, %d, %d, %s, %s)",
+                                                "insert ignore into {$gp_table_prefix}event_actions (event_id, locale, user_id, original_id, action, happened_at) values (%d, %s, %d, %d, %s, %s)",
                                                 array(
                                                         // Start unique key.

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-translation-events/wporg-gp-translation-events.php

@@ -73 +73 @@
 
         public function activate() {
-                global $wpdb;
+                global $gp_table_prefix;
                 $create_table = "
-                CREATE TABLE `{$wpdb->base_prefix}event_actions` (
+                CREATE TABLE `{$gp_table_prefix}event_actions` (
                         `translate_event_actions_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
                         `event_id` int(10) NOT NULL COMMENT 'Post_ID of the translation_event post in the wp_posts table',