Changeset 8200 for trunk/bp-groups/bp-groups-classes.php

Timestamp:

03/29/2014 12:35:30 AM (11 years ago)

Author:

r-a-y

Message:

Cache the group invite count for a user.

This commit:

• Caches calls to BP_Groups_Member::get_invite_count_for_user()
• Invalidates the group invite count cache on various actions
• Adds a unit test

See #5414

File:

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

trunk/bp-groups/bp-groups-classes.php

@@ -2363 +2363 @@
         $bp = buddypress();
 
-        return (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE m.group_id = g.id AND m.is_confirmed = 0 AND m.inviter_id != 0 AND m.invite_sent = 1 AND m.user_id = %d ORDER BY date_modified ASC", $user_id ) );
+        $count = wp_cache_get( $user_id, 'bp_group_invite_count' );
+
+        if ( false === $count ) {
+            $count = (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE m.group_id = g.id AND m.is_confirmed = 0 AND m.inviter_id != 0 AND m.invite_sent = 1 AND m.user_id = %d", $user_id ) );
+            wp_cache_set( $user_id, $count, 'bp_group_invite_count' );
+        }
+
+        return $count;
     }