BuddyPress.org

@shanebp I thought I shouldn’t be modifying core files, but wasn’t sure how else to do it. I’ll give the above a go and see how it works.

@shanebp So I have sort of made progress. I found this post by @eberger3. He seemed to be trying to do something similar to me. With his code I have now managed to order the results by price, which is great, but I am also experiencing the same issues he had:

• The pagination doesn’t work
• The member count shows ‘Viewing 1 member’ when there are many more
• The “search members” box doesn’t work. It returns the entire directory

Is this because I am using bp_user_query and not bp_ajax_querystring?

<?php
function ch_member_order_options() {
?>
   <option value="price"><?php _e( 'Price', 'buddypress' ); ?></option>
<?php
}
add_action( 'bp_members_directory_order_options', 'ch_member_order_options' );
add_action( 'bp_pre_user_query', 'sort_by_price' );
function sort_by_price( $bp_user_query ) {
	// Only run this if one of our custom options is selected
	if ( in_array( $bp_user_query->query_vars['type'], array( 'price') ) ) {
		global $wpdb;
		
		$field_id = 5; 
		$user_query = $wpdb->get_col("SELECT object_id FROM " . $wpdb->prefix . "term_relationships WHERE term_taxonomy_id = " . $field_id);
		$users_str = '';
		foreach ( $user_query as $user ) {
	        $users_str .=  $user . ',';
	    }
		$users_str = rtrim($users_str, ",");

		// Adjust SELECT
		$bp_user_query->uid_clauses['select'] = "SELECT user_id FROM " . $wpdb->prefix . "bp_xprofile_data";

		// Adjust WHERE
		$bp_user_query->uid_clauses['where'] = "WHERE user_id in (" . $users_str . ") AND field_id=18";

		// Adjust ORDER BY
	    $bp_user_query->uid_clauses['orderby'] = "ORDER BY CAST(value as UNSIGNED) ASC";
		
		$bp_user_query->uid_clauses['per_page'] = 10;
	}
}
?>

Edit: I can see this thread is in Installation category. This was a mistake. I should have but it into ‘How To’ or ‘Creating and Extending’ I can’t change this though.

@shanebp – That is cleaner and works, but pagination still doesn’t. Is it not possible to pass in the BP_User_Query parameters such as per_page in this format:

$object->query_vars['per_page'] = 10;

Tried this, but it seems to not work.

Do I need to use bp_pre_user_query_construct instead? I’m guessing I need to create a new function passing in these parameters?

Edit: I created a new function passing in this parameter:

$query->query_vars['per_page'] = 10;

I then add a new action for bp_pre_user_query_construct. This does indeed limit the first page’s results to 10; however it doesn’t display pagination to go to page 2 and it shows “1 – 11 of 11 Members” instead of “1 – 10 of 11 Members”.

@shanebp – Thank you this works really well. Weird, bug though. If you use the text search box, this breaks the pagination (without me editing any of your code). I’m guessing it has something to do with the URL parameters?

?s=examplesearch&members_search_submit=Search

This doesn’t break the pagination on the first page, but on page 2 and then when clicking back to page 1. The label displaying the number of members etc. is wrong and also the number of results per page is then wrong as it displays all results.

Interestingly, is it not possible to pass additional parameters either via members-loop.php? e.g.

if ( bp_has_members( bp_ajax_querystring( 'members' ).'member_type=expert' ) ) :

or via your code in bp-custom.php? I’m thinking I’m getting something mixed up when trying to add these additional parameters. It’s because I wanted to make use of the new ‘member_type’ in the latest version of BuddyPress but using a ‘member_type=exampletype’ doesn’t seem to work.

To be honest, if someone could point out how to create a completely new ‘Order By’ option from scratch how they are in the core files then I’d probably go down that route, but I’m not sure how to do that without actually editing the core files. Is there anyway I can hook into that part of the code?

I could then pretty much just copy one of the ‘Order By’ options that currently exists and then just edit the SQL to order by the XProfile field that I want.

@danbp – Thanks for this. I think I’d seen that before. I can create the new option for ‘Order By’, my issue is actually making it work properly. In that article, I’m not really understanding how I can create a simple ‘Order By’ for a numerical XProfile field.

I used @shanebp code above and it works with pagination unless there is a URL parameter, after which it breaks when navigating from page 2 to any other page. It doesn’t work with a search query ‘s=’ or with BP Profile Search. I think there is something I’m not getting.

The code on the page you provided seems a lot longer than the code shanebp provided above. I think this is really confusing me!

@danbp – Sorry to have so many questions. The example in the link you provided is for the activity loop, but I am trying to get this working for the members loop. Will it still work the same or do I have to take a completely different approach to this?