Changeset 4945

Timestamp:

02/19/2017 09:06:01 PM (8 years ago)

Author:

coffee2code

Message:

Support Forums, User Badges: Replace hardcoded database prefix for plugin tables with PLUGINS_TABLE_PREFIX.

Props SergeyBiryukov.
Fixes #2514.

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-user-badges/inc/class-plugin.php (modified) (2 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-bbp-user-badges/inc/class-plugin.php

@@ -354 +354 @@
                 // Get users who have commit access.
                 $authors = $wpdb->get_col( $wpdb->prepare(
-                    "SELECT user FROM plugin_2_svn_access WHERE `path` = %s",
+                    "SELECT user FROM " . PLUGINS_TABLE_PREFIX . "svn_access WHERE `path` = %s",
                     '/' . $slug
                 ) );
@@ -396 +396 @@
                 // TODO: Change this when the Plugin Directory switches over to WordPress.
                 $contributors = $wpdb->get_var( $wpdb->prepare(
-                    'SELECT meta_value FROM plugin_2_meta m LEFT JOIN plugin_2_topics t ON m.object_id = t.topic_id WHERE t.topic_slug = %s AND m.object_type = %s AND m.meta_key = %s',
+                    'SELECT meta_value FROM ' . PLUGINS_TABLE_PREFIX . 'meta m LEFT JOIN ' . PLUGINS_TABLE_PREFIX . 'topics t ON m.object_id = t.topic_id WHERE t.topic_slug = %s AND m.object_type = %s AND m.meta_key = %s',
                     $slug,
                     'bb_topic',