Skip to content

Instantly share code, notes, and snippets.

@ipokkel
Created April 2, 2019 07:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ipokkel/def33accb635d978f0a5c98c359c7b9e to your computer and use it in GitHub Desktop.
Save ipokkel/def33accb635d978f0a5c98c359c7b9e to your computer and use it in GitHub Desktop.
Randomize user names for Paid Memberships Pro Member Directory and sort members according to level id or level name
<?php
function my_rand_directory($sqlQuery, $levels, $s, $pn, $limit, $start, $end, $order_by, $order) {
/**
* OPTIONS
*/
// Ternary: Set to 1 to sort by membership id or 0 to sort by membership name
$level_sort_by = 0 ? 'mu.membership_id' : 'm.name';
// Ternary: Set to 1 for ascending or 0 for descending
$my_sort_order = 1 ? 'ASC' : 'DESC';
// END OPTIONS
// $sqlQuery = str_replace("u.display_name ".$order, "mu.membership_id DESC, RAND()", $sqlQuery);
$sqlQuery = str_replace("u.display_name ".$order, "$level_sort_by $my_sort_order, RAND()", $sqlQuery);
return $sqlQuery;
}
add_filter('pmpro_member_directory_sql', 'my_rand_directory', 10, 9);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment