Support Forum

No. How much do you know about using WordPress filters? If not a lot... then first step would be to check them out in the WP Codex.

The members list class provides a filter named 'sph_members_list_query' which passes a query object. So in the theme spFunctions.php file you can use the

add_filter('sph_members_list_query', 'your_function_name');

call to create your own function to manipulate the SQL.

function your_function_name($spdb)

The $spdb object contains the following properties:

$spdb->table
$spdb->fields
$spdb->found_rows
$spdb->distinct
$spdb->left_join
$spdb->where
$spdb->orderby
$spdb->limits

I warn you though that this query is somewhat complex and is due to be reviewed in a future release (i.e., a 5.1 or later) to make it simpler - possibly breaking into more than one query.

Let us know how you get on.

Giving each group it's own class based on the group name is not a bad idea and I will open a ticket to do that.

And yes this would be the easiest. But it doesn't do things properly.

The main problem would be if you had quite a few admins then the first page would look a little odd with only a small number of members showing as the paging controls will still include the missing rows.