Changeset 10794 for trunk/src/bp-groups/classes/class-bp-groups-member.php

Timestamp:

05/21/2016 02:16:38 AM (5 years ago)

Author:

boonebgorges

Message:

Introduce caching for group memberships.

The new system works like this: The bp_groups_memberships_for_user cache
group stores arrays of membership IDs for individual users. The
bp_groups_memberships cache group stores data about individual memberships.
The new function bp_get_user_groups() populates a user's group memberships
from these caches, and filters them as requested in the function parameters.
Then, the various groups_is_user_*() functions use bp_get_user_groups()
instead of direct, uncached database queries to fetch their data.

In addition, the get_group_extras() method of BP_Groups_Group can now be
greatly simplified, since all necessary pre-fetching of current-user group
memberships happens via the bp_get_user_groups() cache.

Props boonebgorges, dcavins.
See #6327.

File:

• trunk/src/bp-groups/classes/class-bp-groups-member.php (modified) (3 diffs)

trunk/src/bp-groups/classes/class-bp-groups-member.php

@@ -822 +822 @@
         }
 
+        /**
+         * Fires before a group invitation is deleted.
+         *
+         * @since 2.6.0
+         *
+         * @param int $user_id  ID of the user.
+         * @param int $group_id ID of the group.
+         */
+        do_action( 'bp_groups_member_before_delete_invite', $user_id, $group_id );
+
         $table_name = buddypress()->groups->table_name_members;
 
@@ -1051 +1061 @@
 
         return $wpdb->get_results( $wpdb->prepare( "SELECT user_id, date_modified FROM {$bp->groups->table_name_members} WHERE group_id = %d AND is_mod = 1 AND is_banned = 0", $group_id ) );
+    }
+
+    /**
+     * Get group membership objects by ID (or an array of IDs).
+     *
+     * @since 2.6.0
+     *
+     * @param int|string|array $membership_ids Single membership ID or comma-separated/array list of membership IDs.
+     * @return array
+     */
+    public static function get_memberships_by_id( $membership_ids ) {
+        global $wpdb;
+
+        $bp = buddypress();
+
+        $membership_ids = implode( ',', wp_parse_id_list( $membership_ids ) );
+        return $wpdb->get_results( "SELECT * FROM {$bp->groups->table_name_members} WHERE id IN ({$membership_ids})" );
     }
 
@@ -1162 +1189 @@
 
     /**
+     * Get all membership IDs for a user.
+     *
+     * @since 2.6.0
+     *
+     * @param int $user_id ID of the user.
+     * @return array
+     */
+    public static function get_membership_ids_for_user( $user_id ) {
+        global $wpdb;
+
+        $bp = buddypress();
+
+        $group_ids = $wpdb->get_col( $wpdb->prepare( "SELECT id FROM {$bp->groups->table_name_members} WHERE user_id = %d ORDER BY id ASC", $user_id ) );
+
+        return $group_ids;
+    }
+
+    /**
      * Delete all memberships for a given group.
      *