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 ) ...


6

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 ).'*', ...


6

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 ...


5

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

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

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

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

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

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 = ...


2

You can simply use the date_query parameter on the user registration date: $args = array ( 'role' => 'subscriber', 'date_query' => array( array( 'after' => '2010-01-13 00:00:00', 'inclusive' => true, ), ), ); $user_query = new WP_User_Query( $args ); This part of the ...


1

WP doesn't provide (as far as I remember) hooks specific to CPTs. There are a lot of hooks in WP_Query class to bend the post queries different ways. In most cases they are passed the query object itself, which is used to derive the context (such as is query for specific post type).


1

This is untested, but I believe if you set type in your meta query to numeric, that will cast the values as numbers so orderby meta_value should work correctly.


1

From the Codex: Multiple custom user fields handling $args = array( 'meta_query' => array( 'relation' => 'OR', 0 => array( 'key' => 'country', 'value' => 'Israel', 'compare' => '=' ), 1 => array( 'key' => 'age', 'value' => array( 20, 30 ), 'type' => ...


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

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

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); ...



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