Changeset 7781 for trunk/bp-xprofile/bp-xprofile-classes.php

Timestamp:

02/04/2014 02:19:11 AM (11 years ago)

Author:

boonebgorges

Message:

Add caching support for default xprofile field visibility settings

These settings rarely change, and so are good candidates for persistent caching

See #1332

File:

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

trunk/bp-xprofile/bp-xprofile-classes.php

@@ -389 +389 @@
 
     /**
-     * Fetch the admin-set preferences for all fields
-     *
-     * @since BuddyPress (1.6)
-     *
-     * @return array $default_visibility_levels An array, keyed by field_id, of default
-     *   visibility level + allow_custom (whether the admin allows this field to be set by user)
+     * Fetch the admin-set preferences for all fields.
+     *
+     * @since BuddyPress (1.6.0)
+     *
+     * @return array $default_visibility_levels An array, keyed by
+     *         field_id, of default visibility level + allow_custom
+     *         (whether the admin allows this field to be set by user)
      */
     public static function fetch_default_visibility_levels() {
         global $wpdb, $bp;
 
-        $levels = $wpdb->get_results( "SELECT object_id, meta_key, meta_value FROM {$bp->profile->table_name_meta} WHERE object_type = 'field' AND ( meta_key = 'default_visibility' OR meta_key = 'allow_custom_visibility' )" );
-
-        // Arrange so that the field id is the key and the visibility level the value
-        $default_visibility_levels = array();
-        foreach( $levels as $level ) {
-            if ( 'default_visibility' == $level->meta_key ) {
-                $default_visibility_levels[$level->object_id]['default'] = $level->meta_value;
-            } else if ( 'allow_custom_visibility' == $level->meta_key ) {
-                $default_visibility_levels[$level->object_id]['allow_custom'] = $level->meta_value;
-            }
+        $default_visibility_levels = wp_cache_get( 'xprofile_default_visibility_levels', 'bp' );
+
+        if ( false === $default_visibility_levels ) {
+            $levels = $wpdb->get_results( "SELECT object_id, meta_key, meta_value FROM {$bp->profile->table_name_meta} WHERE object_type = 'field' AND ( meta_key = 'default_visibility' OR meta_key = 'allow_custom_visibility' )" );
+
+            // Arrange so that the field id is the key and the visibility level the value
+            $default_visibility_levels = array();
+            foreach ( $levels as $level ) {
+                if ( 'default_visibility' == $level->meta_key ) {
+                    $default_visibility_levels[ $level->object_id ]['default'] = $level->meta_value;
+                } else if ( 'allow_custom_visibility' == $level->meta_key ) {
+                    $default_visibility_levels[ $level->object_id ]['allow_custom'] = $level->meta_value;
+                }
+            }
+
+            wp_cache_set( 'xprofile_default_visibility_levels', $default_visibility_levels, 'bp' );
         }