BuddyPress.org

Boone wrote something that might be helpful: https://github.com/boonebgorges/bp-social-media-profiles/

It automatically converts some social site links in extended profile fields into the right kind of link.

That depends on where you’re using it. You could use a bp_signup_validate filter to check that a username has certain characteristics. But for profile fields or other places, you’d have to enforce it some other way.

Here’s an example of how you might disalloe long usernames:

add_action('bp_signup_validate', function() {
	if ( isset( $_POST[ 'signup_username' ] ) && strlen( $_POST[ 'signup_username' ] ) > 60 ) {
		$bp = buddypress();
		$bp->signup->errors['signup_username'] = 'Geez, your username is really long.';
	}
} );

Never mind! I’ve found a fabulous solution that has gotten me out of SQL query hell. Again, if anyone else is trying to sort a Members Directory, here’s what I did:

1) Put it in a table, not a list (I had done this anyway, since I wanted a single-page directory that displayed xprofile fields horizontally) — make sure it has a <th> table header row;
2) Install the plugin Table Sorter https://wordpress.org/plugins/table-sorter/ and add the class “tablesorter” to the table.

Et voilà! I commented out the sort type dropdown in members/index.php starting with
<div class="item-list-tabs" id="subnav" aria-label="<?php esc_attr_e( 'Members directory secondary navigation', 'buddypress' ); ?>" role="navigation">
all the way through

<?php
/**
 * Fires inside the members directory member order options.
 *
 * @since 1.2.0
 */
do_action( 'bp_members_directory_order_options' ); ?>
</select>
</li>
</ul>
</div>

and I made sure that the default single page list showed all users alphabetically by default in members-loop.php

<?php if ( bp_get_current_member_type() ) : ?>
	<p class="current-member-type"><?php bp_current_member_type_message() ?></p>
<?php endif; ?>

<?php if ( bp_has_members( bp_ajax_querystring( 'members' ) . '&per_page=500' . '&exclude=1,2,3,4,6' . '&type=alphabetical') ) : ?>

And then all I had to do was add that tablesorter class to the table as required by the tablesorter plugin, and I got a nice dynamic table with sortable columns, which can also be sorted by multiple criteria by holding down the Shift key on the second column. I set the initial sort order with parameters that select the column by number, as described at http://tablesorter.com/docs/example-option-sort-list.html and elsewhere.

<table id="members-list" class="tablesorter {sortlist:[[4,0], [3,0], [2,0], [1,0], [0,0]]}" aria-live="assertive" aria-relevant="all">

Yay.

I guess I’m never satisfied, but I do have an additional request / problem, if someone can help (cough @boonebgorges?). Our xprofile fields are geographical: City, State, Country. I’d like to do a sequential sort on them on the Members directory: first ASC by Country (which I’ve now got working, finally, thanks to this post), then second ASC by State, third ASC by City. I’ve mucked around with SQL statements and ORDER BY FIELD and CASE IF THEN, but I can’t get those subsequent sorts to work.

xprofile field_id values: 1 = Name, 8 = Org, 9 = City, 10 = State, 11 = Country

Members loop code:

<?php if ( bp_has_members( bp_ajax_querystring( 'members' ) . '&per_page=500' . '&populate_extras&type=alphabetical' . '&exclude=1,2,3,4,6') ) : ?>

Below code in functions.php works – it sorts members by Country ASC
custom_ids = $wpdb->get_col("SELECT user_id FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id = 11 ORDER BY value ASC");

Below code in functions.php doesn’t work to sort by Country, State, City ASC – returns an unsorted members list. I think it’s sorting randomly. It isn’t by user id, username, last active, or newest registered. When I apply the default member type sorts, though, with the members-order-select dropdown, that works.

$custom_ids = $wpdb->get_col("SELECT user_id FROM {$wpdb->prefix}bp_xprofile_data WHERE field_id IN ('1', '8', '9', '10', '11') ORDER BY FIELD (field_id, '11', '10', '9', '8', '1')");

Any advice for constructing that SQL query? Do I need to look more into bp_parse_args?

Yep BuddyPress has it’s own registration page, it ususally automatically creates it – register though in reality buddypress does not use this pages content and just uses the pages slug as an anchor. You can go to Dashboard>>Users>>Profile Fields to add additional profile fields to the register page, you just add them to the Main field group. These are added to the right side of the registration page in the same order as viewed in the main profile group page.

I don’t think they work that way, I also looked at BuddyPress Xprofile Custom Fields but that did not allow for that, just a single field to enter the value. You might want to suggest it as a feature request on BuddyPress Trac:

https://buddypress.trac.wordpress.org/

@tom-corvus You can check codes at
https://plugins.svn.wordpress.org/bp-default-data/tags/1.2.0/process.php with function name bpdd_import_users_profile()
BP Default data plugin have created some fields and field group for BuddyPress.

Unfortunately, the fields are synchronized only when the profile is updated. I do not know how to start mass synchronization

This is likely because you’re hooking to a hook fired at profile update. You’ll need to hook your code to something that gets fired at another point in time.