Changeset 8105 for trunk/bp-friends/bp-friends-classes.php

Timestamp:

03/10/2014 08:36:19 PM (11 years ago)

Author:

r-a-y

Message:

Cache the friendship request user IDs for a given user.

This commit:

• Caches calls to BP_Friends_Friendship::get_friendship_request_user_ids()
• Invalidates the friend request cache when a friendship is saved or removed
• Adds unit tests

See #5435, #5414

File:

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

trunk/bp-friends/bp-friends-classes.php

@@ -227 +227 @@
      */
     public static function get_friendship_request_user_ids( $user_id ) {
-        global $wpdb, $bp;
-
-        return $wpdb->get_col( $wpdb->prepare( "SELECT initiator_user_id FROM {$bp->friends->table_name} WHERE friend_user_id = %d AND is_confirmed = 0", $user_id ) );
+        $friend_requests = wp_cache_get( $user_id, 'bp_friends_requests' );
+
+        if ( false === $friend_requests ) {
+            global $wpdb, $bp;
+
+            $friend_requests = $wpdb->get_col( $wpdb->prepare( "SELECT initiator_user_id FROM {$bp->friends->table_name} WHERE friend_user_id = %d AND is_confirmed = 0", $user_id ) );
+
+            wp_cache_set( $user_id, $friend_requests, 'bp_friends_requests' );
+        }
+
+        return $friend_requests;
     }