Tag Info

Hot answers tagged

8

This should get you really close. I haven't tested it, but it's nearly identical to a setup I've used a few times. /* * We start by doing a query to retrieve all users * We need a total user count so that we can calculate how many pages there are */ $count_args = array( 'role' => 'Subscriber', 'fields' => 'all_with_meta', ...


7

Well I have come up with 2 solutions. Solution 1 - foreach loop and verify each user This one is based off of @GhostToast's solution, but with updated WordPress functions //new query with default args $author_query = new WP_User_Query(); // Get the results $authors = $author_query->get_results(); if( $authors ) { foreach( $authors as $author ) ...


5

Searching the main table Simply use WP_User_Query with a search argument. So if you want to search for example for a user with a keyword in his user_email or similar columns from the {$wpdb->prefix}users table, then you can do the following: $users = new WP_User_Query( array( 'search' => '*'.esc_attr( $your_search_string ).'*', ...


5

You can try this: /** * Add support for the "display_name" search column in WP_User_Query * * @see http://wordpress.stackexchange.com/a/166369/26350 */ add_filter( 'user_search_columns', function( $search_columns ) { $search_columns[] = 'display_name'; return $search_columns; } ); where we use the user_search_columns filter to modify the ...


4

I wonder if this works for you: add_action( 'pre_user_query', 'wpse_order_by_include_values' ) $query = new WP_User_Query( $args ); remove_action( 'pre_user_query', 'wpse_order_by_include_values' ) where function wpse_order_by_include_values( $q ) { if( isset( $q->query_vars['include'] ) ) { $values = join( ',', ...


4

@m0r7if3r provided the correct answer. For the sake of providing a directly usable snippet to anyone else looking at this issue, here's what I ended up using. $wp_users = $wpdb->get_results(" SELECT users.*, meta.meta_value FROM $wpdb->users AS users LEFT JOIN $wpdb->usermeta AS meta ON users.ID = meta.user_id WHERE ...


4

The search parameter can take an email address and can also accept wildcards: $wp_user_search = new WP_User_Query( array( 'search' => '*@mydomain.com' ) ); $users = $wp_user_search->get_results();


4

Made something myself: Page template file: <?php $paged = (get_query_var('paged')) ? get_query_var('paged') : 1; $paged -= 1; $limit = 20; $offset = $paged * $limit; $args = array( 'number' => $limit, 'offset' => $offset, ); // Create the WP_User_Query object global $wp_query; $wp_query = new WP_User_Query($args); // Get the results ...


3

I don't see an "orderby Rand()" parameter for either get_users or WP_User_Query. There is a filter called pre_user_query that could be used but I am not sure I see the benefit of that when shuffle will randomize the array you already have. $args = array( 'fields' => 'all_with_meta', 'exclude' => array(1), ); $users = get_users( $args ); ...


3

Method #1: The pre_user_query hook: There are not many filters available, but you can try the pre_user_query hook: // Add filter: add_action( 'pre_user_query', 'wpse_filter_by_reg_date' ); // Query: $query = new WP_User_Query( $args ); // Remove filter: remove_action( 'pre_user_query', 'wpse_filter_by_reg_date' ); where the filter callback is: /** ...


2

You can make use of WP_User_Query to retrieve a list of all user's ID's and then pass that to get_userdata to retrieve a user's registration date. You can then sort and exclude users from that according to a specific date and time. Here is my idea <?php $user_query = new WP_User_Query( array( 'fields' => 'ID', ) ); $users = ...


2

You could save the values with the separate user meta keys: x1, ..., x6, points instead of the array: achievements to simplify your WP_User_Query() usage and not having to deal with serialized arrays as user meta values. But I guess you've already considered this setup and wanted to avoid it ;-) A compromise would be to move only the points out of ...


2

According to the codex, display_name isn't supported. You could use the pre_user_query filter. function henry_display_name_find( $query ) { global $wpdb; /* you don't say where the name comes from - this assumes a $_POST field */ $display_name = $_POST['display_name']; $use_like_syntax = false; if ( $use_like_syntax = true ) { ...


2

There is a better way to do this as of Wordpress version 3.7. Use the Wordpress property meta_key to select the last name property and then orderby => meta_value with an ascending order. <?php $args = array( 'meta_key' => 'last_name', 'orderby' => 'meta_value', 'order' => 'ASC' ); $user_query = new WP_User_Query( $args ); if ( ! ...


2

WP_User objects have some magic methods which do allow you to access any custom field: foreach ( $agents as $agent ) { var_dump( $agent->bio ); var_dump( $agent->get( 'bio' ) ); } The two are equivalent. More info: http://scribu.net/wordpress/the-magic-of-wp_user.html


2

No, it isn't possible without modifications to the p2p plugin, as indicated here: https://github.com/scribu/wp-posts-to-posts/issues/374 Relevant code is here: https://github.com/scribu/wp-posts-to-posts/blob/master/core/connection-type.php#L374


2

Filter the string 'query' and change the ORDER BY part. See https://gist.github.com/1281778#L160 for an example.


2

This is covered in the link you reference: The search_columns attribute does not set what should be searched for in each column, but instead specifies which columns should be searched for the term set in 'search'. Specifically, you can only search for one term - but you can look in one or more columns. //Search user logins & emails for 'foo'. ...


2

You shouldn't be passing in $users["results"] directly to a foreach without checking that $users is an array, and that it has a 'results' key. What if $users is empty, or false, and a WP_Error object? In this case, it isn't an array, it's a WP_User_Query object. Casting it to an array won't fix that. Instead you should be using it like this: $user_query = ...


1

You can use the WP_User_Query class which works much like WP_Query. The docs: http://codex.wordpress.org/Class_Reference/WP_User_Query Below is a dump of the WP_User object that it will return, in this example using: $wp_user_search = new WP_User_Query( array( 'fields' => 'all_with_meta' ) ); $get_users = $wp_user_search->get_results(); This ...


1

As Brian noted, your form sends the data via POST, and you are fetching via GET. Change for method to "GET" or else use the $_POST variable. (But note that your search term is passed along using your current code, because both POST and GET populate the $_REQUEST variable). You can make the search more flexible by ensuring that it is surrounded by wildcard ...


1

It was actually much easier than I originally thought - just doing a WP_User_Query for a meta value (meta arrays are supported as well, like for the other query classes). public function on_deactivate() { $meta_key = 'tools_page_tsi_per_page'; $query = new WP_User_Query( array( 'meta_key' => $meta_key ) ); if ( empty( $query->results ) ) ...


1

How to use the class methods in the callback The $query object inside pre_user_query is a fully qualified core object, so you can use $query->set( 'key', 'value' ); as well as $query->get( 'key' );. If you got the problem that this might interfere with other callbacks, then simply add remove_filter( current_filter(), __FUNCTION__ ); to your callback, ...


1

This worked for me. $user_query = new WP_User_Query( array( 'search' => '*example.net*', 'search_columns' => array('user_url') )); $authors = $user_query->get_results(); The wild card to be used in the search string is '*' and not '%'. Also you have to include the 'search_columns' parameter with the following possible values search_columns = ...


1

Thank you for your attantion, I made it working with update_user_meta Here is my little function I wrote global $blog_id; $current_blog_details = get_blog_details( array( 'blog_id' => $blog_id ) ); if (is_user_logged_in()) { $user = wp_get_current_user(); $last_visited_blogs = get_user_meta($user->ID, 'last_visited_blogs',true); ...


1

I found the following class in the add user autocomplete plugin . It extends the normal searcha and allows '*'; Example: $wp_user_search = new A2B_User_Query( array( 'search' => $s . '*' ) ) ; class A2B_User_Query extends WP_User_Query { /** * @see WP_User_Query::get_search_sql() */ function get_search_sql( $string, $cols, $wild = false ) ...


1

Mashable Follow is custom built for Mashable.com, so you won't find a plugin that brings that level of integration to your WordPress site. That said, there are two that may suit your purpose: Social: Integrates your WordPress site with social networking sites Twitter and Facebook, thereby offering a whole lot of features including—automatically ...


1

It looks like you're using wrong parameters, please try this instead (untested): $q = new WP_User_Query( array( 'role' => 'contributor', 'meta_query' => array( 'relation' => 'AND', array( 'key' => 'first_meta', 'value' => '2', ), ...


1

One alternative offered to the above answer is to add a column (meta key) with meta values which can easily be sorted with 'orderby' => 'meta_value' in the args. Here is a function I wrote to add the meta values to each user. I'm including it here because $my_order_ids = array( 3, 4, 6, 2, 5 ); determines the ascending order users should be sorted by ...


1

A way to do it using SQL is to use SUBSTR and LOCATE to pick out the serialized value: function wpse162668_pre_user_query( $query ) { if ( ( $orderby = $query->get( 'orderby' ) ) != 'achievements_points' ) { return $query; } global $wpdb; $order = $query->get( 'order' ); $points_str = 's:6:"points";i:'; ...



Only top voted, non community-wiki answers of a minimum length are eligible