Hi,
That will work.
May I suggest using the following

$table  = buddypress()->profile->table_name_data;
$qry    = $wpdb->prepare( "SELECT value FROM {$table} WHERE field_id = %d AND value = %s", $field_id, $field );
$result = $wpdb->get_var( $qry );

instead of

$qry = "SELECT value FROM wp_bp_xprofile_data WHERE value = " . $field;
    $result = $wpdb->get_results( $qry );

It will work even when the prefix for database is different than wp_ and sanitizing the query is important to avoid any issue. Also, It limits the search for the value ot specific field id.

Bets Regards
Brajesh

Please use the following

/**
 * Check if a user has given WordPress role(or any of the roles).
 *
 * @param int           $user_id user.
 * @param string|array  $role role(s).
 *
 * @return bool|array
 */
function buddydev_user_has_role( $user_id, $role ) {
	$user   = get_user_by( 'id', $user_id );

	if ( empty( $user ) ) {
		return false;
	}

	$user_roles = $user->roles;

	if ( empty( $user_roles ) ) {
		return false;
	}
	// if an array o roles was given.
	return is_array( $role) ? array_intersect( $role, $user_roles ) : in_array( $role, $user_roles, true );
}

/**
 * Only allow galleries for a certain role.
 *
 * @param bool   $is_active Can create gallery or not.
 * @param string $component Component name.
 * @param int    $component_id Component id.
 *
 * @return bool
 */
function buddydev_disable_gallery_for_roles( $is_active, $component, $component_id ) {

	if ( 'members' !== $component ) {
		return $is_active;
	}

	$restricted_roles = array( 'subscriber', 'contributor' );// 'editor', 'contributor', 'subscriber'

	if ( buddydev_user_has_role( $component_id, $restricted_roles ) ) {
		$is_active = false;
	}

	return $is_active;
}
add_filter( 'mpp_is_enabled', 'buddydev_disable_gallery_for_roles', 10, 3 );

Please feel free to modify the roles list.

Let me know if it works for you or not?

PS:- The code should go to wp-content/plugins/bp-custom.php

Regards
Brajesh

Hi Leile,

I don’t see any function that does it. It will be faster and simpler to write a query. If you want, I can do that for you.

Thank you
Brajesh

Hi Mike,
Marking resolved as you already fixed it(as per private message).

Regards
Brajesh

Hi Max,
I am sorry, this plugin is not suitable for that purpose.

BuddyPress User Testimonials does allow writing about the profile owner but the other functionality is not there.

Regards
Brajesh