Changeset 12180 for trunk/src/bp-groups/bp-groups-functions.php

Timestamp:

07/02/2018 06:07:46 PM (8 years ago)

Author:

johnjamesjacoby

Message:

Meta: Prefer internal table references over $wpdb ones.

This change updates a few direct database queries to reference the database table names internally set by BP_Component rather than what's been passed into the $wpdb global.

We want to use these everywhere, as they are already in use everywhere else direct queries are made.

Blogs, Groups, and Messages meta deletion functions are affected.

See #7834.

File:

• trunk/src/bp-groups/bp-groups-functions.php (modified) (1 diff)

trunk/src/bp-groups/bp-groups-functions.php

@@ -2117 +2117 @@
     // Legacy - if no meta_key is passed, delete all for the item.
     if ( empty( $meta_key ) ) {
-        $keys = $wpdb->get_col( $wpdb->prepare( "SELECT meta_key FROM {$wpdb->groupmeta} WHERE group_id = %d", $group_id ) );
+        $table_name = buddypress()->groups->table_name_groupmeta;
+        $sql        = "SELECT meta_key FROM {$table_name} WHERE group_id = %d";
+        $query      = $wpdb->prepare( $sql, $group_id );
+        $keys       = $wpdb->get_col( $query );
 
         // With no meta_key, ignore $delete_all.