How has s2member replaced wp_user_query?

So I am trying to use a bit of php code to add onto my website to search by first and last name in the WordPress back end.

The code works when s2member is disabled. It doesn’t when s2member is turned back on. From WordPress’s codex, I’m under the impression that the wp_user_query I’m using is referencing the wp_user and the wp_usermeta tables. What is s2member doing to not allow me to reference just this simple tables? I was trying to read through the s2member codex, and I noticed this: users_list_query, and tried to replace wp_user_query with it and also tried this one: c_ws_plugin__s2member_users_list. No dice.

Or maybe I’m way over my head on this. haha. Any help?

Or maybe I’m not even problem solving this right. Here is the code:

function user_search_by_multiple_parameters($wp_user_query) {
        if(false === strpos($wp_user_query->query_where, '@') && !empty($_GET["s"])) {

            global $wpdb;

            $uids=array();

            $usermeta_affected_ids = $wpdb->get_results("SELECT DISTINCT user_id FROM $wpdb->usermeta WHERE (meta_key='first_name' OR meta_key='last_name'".$iusib_add.") AND LOWER(meta_value) LIKE '%".$qstr."%'");

            foreach($usermeta_affected_ids as $maf) {
                array_push($uids,$maf->user_id);
            }

            $users_affected_ids = $wpdb->get_results("SELECT DISTINCT ID FROM $wpdb->users WHERE LOWER(user_nicename) LIKE '%".$qstr."%' OR LOWER(user_email) LIKE '%".$qstr."%'");

            foreach($users_affected_ids as $maf) {
                if(!in_array($maf->ID,$uids)) {
                    array_push($uids,$maf->ID);
                }
            }
			
            $id_string = implode(",",$uids);

            $wp_user_query->query_where = str_replace("user_nicename LIKE '%".$qstr."%'", "ID IN(".$id_string.")", $wp_user_query->query_where);
        }
        return $wp_user_query;
        

I don’t know if s2Member alters that… I’ll ask Jason about it.

I was trying to read through the s2member codex, and I noticed this: users_list_query, and tried to replace wp_user_query with it and also tried this one: c_ws_plugin__s2member_users_list. No dice.

[hilite mono]c_ws_plugin__s2member_users_list::users_list_query[/hilite] attaches to the hook [hilite mono]pre_user_query[/hilite] in the [hilite mono]WP_User_Query[/hilite] class. I don’t think you can use it separately because it expects a [hilite mono]WP_User_Query[/hilite] object by reference.

The code works when s2member is disabled. It doesn’t when s2member is turned back on.

Do you only have s2Member active or are there other plugins? If you have only s2Member active in the WP installation, do you still have that problem?

I actually installed s2member on a clean testing environment with my theme installed. I then placed this script in, and it still doesn’t return the user by last name. But once I disable s2member, the script works.

So before that script enacts, I have

add_action('pre_user_query', 'user_search_by_multiple_parameters');

Should I then add an input to the action like below or make a separate action?

add_action('pre_user_query', 'user_search_by_multiple_parameters', 'c_ws_plugin__s2member_users_list');

Thanks again for any help you can pass my way.

Thanks for the heads up on this thread :-)

I think that would be a good idea for s2Member® to include the first/last names by default. Currently, it searches only the Display Name field. We’re going to have this updated in the next maintenance release.

Until then, I’m attaching a PATCH file for you. If you’d like to patch your existing installation, please download and unzip the attached file. Please upload the file to your installation, allowing it to override your existing copy of: /s2member/includes/classes/users-list.inc.php

http://d1v41qemfjie0l.cloudfront.net/s2member/uploads/users-list.inc_.php_.zip

If you look at s2Member’s source code in this file, you will find that it exposes several additional WP filters that would allow you to customize user searches even further. Please see class method users_list_query in this file.

Fantastic! Thank you! It works!

I’m also running some heavy plugins, which are Event Espresso, Easy Reservation, CIMY (which is about to go away, still need to port the data), BuddyPress, and W3 Total Cache, and seem to not conflict at all with the search.