Changeset 13279

Timestamp:

03/05/2024 01:17:22 PM (14 months 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',