users}";
if( !empty( $s ) ) {
$search = '%' . trim( $s ) . '%';
$query .= " WHERE user_login LIKE '$search' OR user_email LIKE '$search'";
}
if( !isset($_GET['sortby']) ) {
$_GET['sortby'] = 'id';
}
if( $_GET['sortby'] == 'email' ) {
$query .= ' ORDER BY user_email ';
} elseif( $_GET['sortby'] == 'id' ) {
$query .= ' ORDER BY ID ';
} elseif( $_GET['sortby'] == 'login' ) {
$query .= ' ORDER BY user_login ';
} elseif( $_GET['sortby'] == 'name' ) {
$query .= ' ORDER BY display_name ';
} elseif( $_GET['sortby'] == 'registered' ) {
$query .= ' ORDER BY user_registered ';
}
$query .= ( $_GET['order'] == 'DESC' ) ? 'DESC' : 'ASC';
if( !empty( $s )) {
$total = $wpdb->get_var( str_replace('SELECT *', 'SELECT COUNT(ID)', $query) );
} else {
$total = $wpdb->get_var( "SELECT COUNT(ID) FROM {$wpdb->users}");
}
$query .= " LIMIT " . intval( ( $apage - 1 ) * $num) . ", " . intval( $num );
$user_list = $wpdb->get_results( $query, ARRAY_A );
// Pagination
$user_navigation = paginate_links( array(
'base' => add_query_arg( 'apage', '%#%' ),
'format' => '',
'total' => ceil($total / $num),
'current' => $apage
));
?>