Custom Orderby sorting

@dontdream No, without that line it doesn’t work

You can use this for tests, it search for a value inside user_meta

function users_sortby_points( $object ) {
    global $wpdb;

	// Adjust SELECT
	$object->uid_clauses['select'] = "
	SELECT $wpdb->usermeta.user_id AS id
	FROM $wpdb->usermeta";

	// Adjust WHERE
	$object->uid_clauses['where'] = "WHERE $wpdb->usermeta.meta_key = 'userpoints'";

	// Adjust ORDER BY
	$object->uid_clauses['orderby'] = " ORDER BY $wpdb->usermeta.meta_value";

	// Adjust ORDER
	$object->uid_clauses['order'] = 'DESC';
}
add_action( 'bp_pre_user_query', 'users_sortby_points' );

function add_sortby_point() {
echo '<option value="points">Points</option>';
}
add_action( 'bp_members_directory_order_options', 'add_sortby_point', 1, 0 );

• This reply was modified 6 years, 9 months ago by DAM.
• This reply was modified 6 years, 9 months ago by DAM.