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

Timestamp:

02/04/2014 02:19:11 AM (12 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' );
                 }