Submit
Path:
~
/
home
/
caidadmin
/
dev.heralds.sca-caid.org
/
wp-includes
/
File Content:
class-wp-user-query.php
<?php /** * User API: WP_User_Query class * * @package WordPress * @subpackage Users * @since 4.4.0 */ /** * Core class used for querying users. * * @since 3.1.0 * * @see WP_User_Query::prepare_query() for information on accepted arguments. */ class WP_User_Query { /** * Query vars, after parsing * * @since 3.5.0 * @var array */ public $query_vars = array(); /** * List of found user IDs. * * @since 3.1.0 * @var array */ private $results; /** * Total number of found users for the current query * * @since 3.1.0 * @var int */ private $total_users = 0; /** * Metadata query container. * * @since 4.2.0 * @var WP_Meta_Query */ public $meta_query = false; /** * The SQL query used to fetch matching users. * * @since 4.4.0 * @var string */ public $request; private $compat_fields = array( 'results', 'total_users' ); // SQL clauses. public $query_fields; public $query_from; public $query_where; public $query_orderby; public $query_limit; /** * PHP5 constructor. * * @since 3.1.0 * * @param null|string|array $query Optional. The query variables. */ public function __construct( $query = null ) { if ( ! empty( $query ) ) { $this->prepare_query( $query ); $this->query(); } } /** * Fills in missing query variables with default values. * * @since 4.4.0 * * @param array $args Query vars, as passed to `WP_User_Query`. * @return array Complete query variables with undefined ones filled in with defaults. */ public static function fill_query_vars( $args ) { $defaults = array( 'blog_id' => get_current_blog_id(), 'role' => '', 'role__in' => array(), 'role__not_in' => array(), 'capability' => '', 'capability__in' => array(), 'capability__not_in' => array(), 'meta_key' => '', 'meta_value' => '', 'meta_compare' => '', 'include' => array(), 'exclude' => array(), 'search' => '', 'search_columns' => array(), 'orderby' => 'login', 'order' => 'ASC', 'offset' => '', 'number' => '', 'paged' => 1, 'count_total' => true, 'fields' => 'all', 'who' => '', 'has_published_posts' => null, 'nicename' => '', 'nicename__in' => array(), 'nicename__not_in' => array(), 'login' => '', 'login__in' => array(), 'login__not_in' => array(), ); return wp_parse_args( $args, $defaults ); } /** * Prepare the query variables. * * @since 3.1.0 * @since 4.1.0 Added the ability to order by the `include` value. * @since 4.2.0 Added 'meta_value_num' support for `$orderby` parameter. Added multi-dimensional array syntax * for `$orderby` parameter. * @since 4.3.0 Added 'has_published_posts' parameter. * @since 4.4.0 Added 'paged', 'role__in', and 'role__not_in' parameters. The 'role' parameter was updated to * permit an array or comma-separated list of values. The 'number' parameter was updated to support * querying for all users with using -1. * @since 4.7.0 Added 'nicename', 'nicename__in', 'nicename__not_in', 'login', 'login__in', * and 'login__not_in' parameters. * @since 5.1.0 Introduced the 'meta_compare_key' parameter. * @since 5.3.0 Introduced the 'meta_type_key' parameter. * @since 5.9.0 Added 'capability', 'capability__in', and 'capability__not_in' parameters. * * @global wpdb $wpdb WordPress database abstraction object. * @global int $blog_id * * @param string|array $query { * Optional. Array or string of Query parameters. * * @type int $blog_id The site ID. Default is the current site. * @type string|string[] $role An array or a comma-separated list of role names that users must match * to be included in results. Note that this is an inclusive list: users * must match *each* role. Default empty. * @type string[] $role__in An array of role names. Matched users must have at least one of these * roles. Default empty array. * @type string[] $role__not_in An array of role names to exclude. Users matching one or more of these * roles will not be included in results. Default empty array. * @type string|string[] $meta_key Meta key or keys to filter by. * @type string|string[] $meta_value Meta value or values to filter by. * @type string $meta_compare MySQL operator used for comparing the meta value. * See WP_Meta_Query::__construct for accepted values and default value. * @type string $meta_compare_key MySQL operator used for comparing the meta key. * See WP_Meta_Query::__construct for accepted values and default value. * @type string $meta_type MySQL data type that the meta_value column will be CAST to for comparisons. * See WP_Meta_Query::__construct for accepted values and default value. * @type string $meta_type_key MySQL data type that the meta_key column will be CAST to for comparisons. * See WP_Meta_Query::__construct for accepted values and default value. * @type array $meta_query An associative array of WP_Meta_Query arguments. * See WP_Meta_Query::__construct for accepted values. * @type string $capability An array or a comma-separated list of capability names that users must match * to be included in results. Note that this is an inclusive list: users * must match *each* capability. * Does NOT work for capabilities not in the database or filtered via {@see 'map_meta_cap'}. * Default empty. * @type string[] $capability__in An array of capability names. Matched users must have at least one of these * capabilities. * Does NOT work for capabilities not in the database or filtered via {@see 'map_meta_cap'}. * Default empty array. * @type string[] $capability__not_in An array of capability names to exclude. Users matching one or more of these * capabilities will not be included in results. * Does NOT work for capabilities not in the database or filtered via {@see 'map_meta_cap'}. * Default empty array. * @type int[] $include An array of user IDs to include. Default empty array. * @type int[] $exclude An array of user IDs to exclude. Default empty array. * @type string $search Search keyword. Searches for possible string matches on columns. * When `$search_columns` is left empty, it tries to determine which * column to search in based on search string. Default empty. * @type string[] $search_columns Array of column names to be searched. Accepts 'ID', 'user_login', * 'user_email', 'user_url', 'user_nicename', 'display_name'. * Default empty array. * @type string|array $orderby Field(s) to sort the retrieved users by. May be a single value, * an array of values, or a multi-dimensional array with fields as * keys and orders ('ASC' or 'DESC') as values. Accepted values are: * - 'ID' * - 'display_name' (or 'name') * - 'include' * - 'user_login' (or 'login') * - 'login__in' * - 'user_nicename' (or 'nicename'), * - 'nicename__in' * - 'user_email (or 'email') * - 'user_url' (or 'url'), * - 'user_registered' (or 'registered') * - 'post_count' * - 'meta_value', * - 'meta_value_num' * - The value of `$meta_key` * - An array key of `$meta_query` * To use 'meta_value' or 'meta_value_num', `$meta_key` * must be also be defined. Default 'user_login'. * @type string $order Designates ascending or descending order of users. Order values * passed as part of an `$orderby` array take precedence over this * parameter. Accepts 'ASC', 'DESC'. Default 'ASC'. * @type int $offset Number of users to offset in retrieved results. Can be used in * conjunction with pagination. Default 0. * @type int $number Number of users to limit the query for. Can be used in * conjunction with pagination. Value -1 (all) is supported, but * should be used with caution on larger sites. * Default -1 (all users). * @type int $paged When used with number, defines the page of results to return. * Default 1. * @type bool $count_total Whether to count the total number of users found. If pagination * is not needed, setting this to false can improve performance. * Default true. * @type string|string[] $fields Which fields to return. Single or all fields (string), or array * of fields. Accepts: * - 'ID' * - 'display_name' * - 'user_login' * - 'user_nicename' * - 'user_email' * - 'user_url' * - 'user_registered' * - 'all' for all fields * - 'all_with_meta' to include meta fields. * Default 'all'. * @type string $who Type of users to query. Accepts 'authors'. * Default empty (all users). * @type bool|string[] $has_published_posts Pass an array of post types to filter results to users who have * published posts in those post types. `true` is an alias for all * public post types. * @type string $nicename The user nicename. Default empty. * @type string[] $nicename__in An array of nicenames to include. Users matching one of these * nicenames will be included in results. Default empty array. * @type string[] $nicename__not_in An array of nicenames to exclude. Users matching one of these * nicenames will not be included in results. Default empty array. * @type string $login The user login. Default empty. * @type string[] $login__in An array of logins to include. Users matching one of these * logins will be included in results. Default empty array. * @type string[] $login__not_in An array of logins to exclude. Users matching one of these * logins will not be included in results. Default empty array. * } */ public function prepare_query( $query = array() ) { global $wpdb; if ( empty( $this->query_vars ) || ! empty( $query ) ) { $this->query_limit = null; $this->query_vars = $this->fill_query_vars( $query ); } /** * Fires before the WP_User_Query has been parsed. * * The passed WP_User_Query object contains the query variables, * not yet passed into SQL. * * @since 4.0.0 * * @param WP_User_Query $query Current instance of WP_User_Query (passed by reference). */ do_action_ref_array( 'pre_get_users', array( &$this ) ); // Ensure that query vars are filled after 'pre_get_users'. $qv =& $this->query_vars; $qv = $this->fill_query_vars( $qv ); if ( is_array( $qv['fields'] ) ) { $qv['fields'] = array_unique( $qv['fields'] ); $this->query_fields = array(); foreach ( $qv['fields'] as $field ) { $field = 'ID' === $field ? 'ID' : sanitize_key( $field ); $this->query_fields[] = "$wpdb->users.$field"; } $this->query_fields = implode( ',', $this->query_fields ); } elseif ( 'all' === $qv['fields'] ) { $this->query_fields = "$wpdb->users.*"; } else { $this->query_fields = "$wpdb->users.ID"; } if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { $this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields; } $this->query_from = "FROM $wpdb->users"; $this->query_where = 'WHERE 1=1'; // Parse and sanitize 'include', for use by 'orderby' as well as 'include' below. if ( ! empty( $qv['include'] ) ) { $include = wp_parse_id_list( $qv['include'] ); } else { $include = false; } $blog_id = 0; if ( isset( $qv['blog_id'] ) ) { $blog_id = absint( $qv['blog_id'] ); } if ( $qv['has_published_posts'] && $blog_id ) { if ( true === $qv['has_published_posts'] ) { $post_types = get_post_types( array( 'public' => true ) ); } else { $post_types = (array) $qv['has_published_posts']; } foreach ( $post_types as &$post_type ) { $post_type = $wpdb->prepare( '%s', $post_type ); } $posts_table = $wpdb->get_blog_prefix( $blog_id ) . 'posts'; $this->query_where .= " AND $wpdb->users.ID IN ( SELECT DISTINCT $posts_table.post_author FROM $posts_table WHERE $posts_table.post_status = 'publish' AND $posts_table.post_type IN ( " . implode( ', ', $post_types ) . ' ) )'; } // nicename if ( '' !== $qv['nicename'] ) { $this->query_where .= $wpdb->prepare( ' AND user_nicename = %s', $qv['nicename'] ); } if ( ! empty( $qv['nicename__in'] ) ) { $sanitized_nicename__in = array_map( 'esc_sql', $qv['nicename__in'] ); $nicename__in = implode( "','", $sanitized_nicename__in ); $this->query_where .= " AND user_nicename IN ( '$nicename__in' )"; } if ( ! empty( $qv['nicename__not_in'] ) ) { $sanitized_nicename__not_in = array_map( 'esc_sql', $qv['nicename__not_in'] ); $nicename__not_in = implode( "','", $sanitized_nicename__not_in ); $this->query_where .= " AND user_nicename NOT IN ( '$nicename__not_in' )"; } // login if ( '' !== $qv['login'] ) { $this->query_where .= $wpdb->prepare( ' AND user_login = %s', $qv['login'] ); } if ( ! empty( $qv['login__in'] ) ) { $sanitized_login__in = array_map( 'esc_sql', $qv['login__in'] ); $login__in = implode( "','", $sanitized_login__in ); $this->query_where .= " AND user_login IN ( '$login__in' )"; } if ( ! empty( $qv['login__not_in'] ) ) { $sanitized_login__not_in = array_map( 'esc_sql', $qv['login__not_in'] ); $login__not_in = implode( "','", $sanitized_login__not_in ); $this->query_where .= " AND user_login NOT IN ( '$login__not_in' )"; } // Meta query. $this->meta_query = new WP_Meta_Query(); $this->meta_query->parse_query_vars( $qv ); if ( isset( $qv['who'] ) && 'authors' === $qv['who'] && $blog_id ) { _deprecated_argument( 'WP_User_Query', '5.9.0', sprintf( /* translators: 1: who, 2: capability */ __( '%1$s is deprecated. Use %2$s instead.' ), '<code>who</code>', '<code>capability</code>' ) ); $who_query = array( 'key' => $wpdb->get_blog_prefix( $blog_id ) . 'user_level', 'value' => 0, 'compare' => '!=', ); // Prevent extra meta query. $qv['blog_id'] = 0; $blog_id = 0; if ( empty( $this->meta_query->queries ) ) { $this->meta_query->queries = array( $who_query ); } else { // Append the cap query to the original queries and reparse the query. $this->meta_query->queries = array( 'relation' => 'AND', array( $this->meta_query->queries, $who_query ), ); } $this->meta_query->parse_query_vars( $this->meta_query->queries ); } // Roles. $roles = array(); if ( isset( $qv['role'] ) ) { if ( is_array( $qv['role'] ) ) { $roles = $qv['role']; } elseif ( is_string( $qv['role'] ) && ! empty( $qv['role'] ) ) { $roles = array_map( 'trim', explode( ',', $qv['role'] ) ); } } $role__in = array(); if ( isset( $qv['role__in'] ) ) { $role__in = (array) $qv['role__in']; } $role__not_in = array(); if ( isset( $qv['role__not_in'] ) ) { $role__not_in = (array) $qv['role__not_in']; } // Capabilities. $available_roles = array(); if ( ! empty( $qv['capability'] ) || ! empty( $qv['capability__in'] ) || ! empty( $qv['capability__not_in'] ) ) { global $wp_roles; $wp_roles->for_site( $blog_id ); $available_roles = $wp_roles->roles; } $capabilities = array(); if ( ! empty( $qv['capability'] ) ) { if ( is_array( $qv['capability'] ) ) { $capabilities = $qv['capability']; } elseif ( is_string( $qv['capability'] ) ) { $capabilities = array_map( 'trim', explode( ',', $qv['capability'] ) ); } } $capability__in = array(); if ( ! empty( $qv['capability__in'] ) ) { $capability__in = (array) $qv['capability__in']; } $capability__not_in = array(); if ( ! empty( $qv['capability__not_in'] ) ) { $capability__not_in = (array) $qv['capability__not_in']; } // Keep track of all capabilities and the roles they're added on. $caps_with_roles = array(); foreach ( $available_roles as $role => $role_data ) { $role_caps = array_keys( array_filter( $role_data['capabilities'] ) ); foreach ( $capabilities as $cap ) { if ( in_array( $cap, $role_caps, true ) ) { $caps_with_roles[ $cap ][] = $role; break; } } foreach ( $capability__in as $cap ) { if ( in_array( $cap, $role_caps, true ) ) { $role__in[] = $role; break; } } foreach ( $capability__not_in as $cap ) { if ( in_array( $cap, $role_caps, true ) ) { $role__not_in[] = $role; break; } } } $role__in = array_merge( $role__in, $capability__in ); $role__not_in = array_merge( $role__not_in, $capability__not_in ); $roles = array_unique( $roles ); $role__in = array_unique( $role__in ); $role__not_in = array_unique( $role__not_in ); // Support querying by capabilities added directly to users. if ( $blog_id && ! empty( $capabilities ) ) { $capabilities_clauses = array( 'relation' => 'AND' ); foreach ( $capabilities as $cap ) { $clause = array( 'relation' => 'OR' ); $clause[] = array( 'key' => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities', 'value' => '"' . $cap . '"', 'compare' => 'LIKE', ); if ( ! empty( $caps_with_roles[ $cap ] ) ) { foreach ( $caps_with_roles[ $cap ] as $role ) { $clause[] = array( 'key' => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities', 'value' => '"' . $role . '"', 'compare' => 'LIKE', ); } } $capabilities_clauses[] = $clause; } $role_queries[] = $capabilities_clauses; if ( empty( $this->meta_query->queries ) ) { $this->meta_query->queries[] = $capabilities_clauses; } else { // Append the cap query to the original queries and reparse the query. $this->meta_query->queries = array( 'relation' => 'AND', array( $this->meta_query->queries, array( $capabilities_clauses ) ), ); } $this->meta_query->parse_query_vars( $this->meta_query->queries ); } if ( $blog_id && ( ! empty( $roles ) || ! empty( $role__in ) || ! empty( $role__not_in ) || is_multisite() ) ) { $role_queries = array(); $roles_clauses = array( 'relation' => 'AND' ); if ( ! empty( $roles ) ) { foreach ( $roles as $role ) { $roles_clauses[] = array( 'key' => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities', 'value' => '"' . $role . '"', 'compare' => 'LIKE', ); } $role_queries[] = $roles_clauses; } $role__in_clauses = array( 'relation' => 'OR' ); if ( ! empty( $role__in ) ) { foreach ( $role__in as $role ) { $role__in_clauses[] = array( 'key' => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities', 'value' => '"' . $role . '"', 'compare' => 'LIKE', ); } $role_queries[] = $role__in_clauses; } $role__not_in_clauses = array( 'relation' => 'AND' ); if ( ! empty( $role__not_in ) ) { foreach ( $role__not_in as $role ) { $role__not_in_clauses[] = array( 'key' => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities', 'value' => '"' . $role . '"', 'compare' => 'NOT LIKE', ); } $role_queries[] = $role__not_in_clauses; } // If there are no specific roles named, make sure the user is a member of the site. if ( empty( $role_queries ) ) { $role_queries[] = array( 'key' => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities', 'compare' => 'EXISTS', ); } // Specify that role queries should be joined with AND. $role_queries['relation'] = 'AND'; if ( empty( $this->meta_query->queries ) ) { $this->meta_query->queries = $role_queries; } else { // Append the cap query to the original queries and reparse the query. $this->meta_query->queries = array( 'relation' => 'AND', array( $this->meta_query->queries, $role_queries ), ); } $this->meta_query->parse_query_vars( $this->meta_query->queries ); } if ( ! empty( $this->meta_query->queries ) ) { $clauses = $this->meta_query->get_sql( 'user', $wpdb->users, 'ID', $this ); $this->query_from .= $clauses['join']; $this->query_where .= $clauses['where']; if ( $this->meta_query->has_or_relation() ) { $this->query_fields = 'DISTINCT ' . $this->query_fields; } } // Sorting. $qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : ''; $order = $this->parse_order( $qv['order'] ); if ( empty( $qv['orderby'] ) ) { // Default order is by 'user_login'. $ordersby = array( 'user_login' => $order ); } elseif ( is_array( $qv['orderby'] ) ) { $ordersby = $qv['orderby']; } else { // 'orderby' values may be a comma- or space-separated list. $ordersby = preg_split( '/[,\s]+/', $qv['orderby'] ); } $orderby_array = array(); foreach ( $ordersby as $_key => $_value ) { if ( ! $_value ) { continue; } if ( is_int( $_key ) ) { // Integer key means this is a flat array of 'orderby' fields. $_orderby = $_value; $_order = $order; } else { // Non-integer key means this the key is the field and the value is ASC/DESC. $_orderby = $_key; $_order = $_value; } $parsed = $this->parse_orderby( $_orderby ); if ( ! $parsed ) { continue; } if ( 'nicename__in' === $_orderby || 'login__in' === $_orderby ) { $orderby_array[] = $parsed; } else { $orderby_array[] = $parsed . ' ' . $this->parse_order( $_order ); } } // If no valid clauses were found, order by user_login. if ( empty( $orderby_array ) ) { $orderby_array[] = "user_login $order"; } $this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array ); // Limit. if ( isset( $qv['number'] ) && $qv['number'] > 0 ) { if ( $qv['offset'] ) { $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['offset'], $qv['number'] ); } else { $this->query_limit = $wpdb->prepare( 'LIMIT %d, %d', $qv['number'] * ( $qv['paged'] - 1 ), $qv['number'] ); } } $search = ''; if ( isset( $qv['search'] ) ) { $search = trim( $qv['search'] ); } if ( $search ) { $leading_wild = ( ltrim( $search, '*' ) != $search ); $trailing_wild = ( rtrim( $search, '*' ) != $search ); if ( $leading_wild && $trailing_wild ) { $wild = 'both'; } elseif ( $leading_wild ) { $wild = 'leading'; } elseif ( $trailing_wild ) { $wild = 'trailing'; } else { $wild = false; } if ( $wild ) { $search = trim( $search, '*' ); } $search_columns = array(); if ( $qv['search_columns'] ) { $search_columns = array_intersect( $qv['search_columns'], array( 'ID', 'user_login', 'user_email', 'user_url', 'user_nicename', 'display_name' ) ); } if ( ! $search_columns ) { if ( false !== strpos( $search, '@' ) ) { $search_columns = array( 'user_email' ); } elseif ( is_numeric( $search ) ) { $search_columns = array( 'user_login', 'ID' ); } elseif ( preg_match( '|^https?://|', $search ) && ! ( is_multisite() && wp_is_large_network( 'users' ) ) ) { $search_columns = array( 'user_url' ); } else { $search_columns = array( 'user_login', 'user_url', 'user_email', 'user_nicename', 'display_name' ); } } /** * Filters the columns to search in a WP_User_Query search. * * The default columns depend on the search term, and include 'ID', 'user_login', * 'user_email', 'user_url', 'user_nicename', and 'display_name'. * * @since 3.6.0 * * @param string[] $search_columns Array of column names to be searched. * @param string $search Text being searched. * @param WP_User_Query $query The current WP_User_Query instance. */ $search_columns = apply_filters( 'user_search_columns', $search_columns, $search, $this ); $this->query_where .= $this->get_search_sql( $search, $search_columns, $wild ); } if ( ! empty( $include ) ) { // Sanitized earlier. $ids = implode( ',', $include ); $this->query_where .= " AND $wpdb->users.ID IN ($ids)"; } elseif ( ! empty( $qv['exclude'] ) ) { $ids = implode( ',', wp_parse_id_list( $qv['exclude'] ) ); $this->query_where .= " AND $wpdb->users.ID NOT IN ($ids)"; } // Date queries are allowed for the user_registered field. if ( ! empty( $qv['date_query'] ) && is_array( $qv['date_query'] ) ) { $date_query = new WP_Date_Query( $qv['date_query'], 'user_registered' ); $this->query_where .= $date_query->get_sql(); } /** * Fires after the WP_User_Query has been parsed, and before * the query is executed. * * The passed WP_User_Query object contains SQL parts formed * from parsing the given query. * * @since 3.1.0 * * @param WP_User_Query $query Current instance of WP_User_Query (passed by reference). */ do_action_ref_array( 'pre_user_query', array( &$this ) ); } /** * Execute the query, with the current variables. * * @since 3.1.0 * * @global wpdb $wpdb WordPress database abstraction object. */ public function query() { global $wpdb; $qv =& $this->query_vars; /** * Filters the users array before the query takes place. * * Return a non-null value to bypass WordPress' default user queries. * * Filtering functions that require pagination information are encouraged to set * the `total_users` property of the WP_User_Query object, passed to the filter * by reference. If WP_User_Query does not perform a database query, it will not * have enough information to generate these values itself. * * @since 5.1.0 * * @param array|null $results Return an array of user data to short-circuit WP's user query * or null to allow WP to run its normal queries. * @param WP_User_Query $query The WP_User_Query instance (passed by reference). */ $this->results = apply_filters_ref_array( 'users_pre_query', array( null, &$this ) ); if ( null === $this->results ) { $this->request = "SELECT $this->query_fields $this->query_from $this->query_where $this->query_orderby $this->query_limit"; if ( is_array( $qv['fields'] ) || 'all' === $qv['fields'] ) { $this->results = $wpdb->get_results( $this->request ); } else { $this->results = $wpdb->get_col( $this->request ); } if ( isset( $qv['count_total'] ) && $qv['count_total'] ) { /** * Filters SELECT FOUND_ROWS() query for the current WP_User_Query instance. * * @since 3.2.0 * @since 5.1.0 Added the `$this` parameter. * * @global wpdb $wpdb WordPress database abstraction object. * * @param string $sql The SELECT FOUND_ROWS() query for the current WP_User_Query. * @param WP_User_Query $query The current WP_User_Query instance. */ $found_users_query = apply_filters( 'found_users_query', 'SELECT FOUND_ROWS()', $this ); $this->total_users = (int) $wpdb->get_var( $found_users_query ); } } if ( ! $this->results ) { return; } if ( 'all_with_meta' === $qv['fields'] ) { cache_users( $this->results ); $r = array(); foreach ( $this->results as $userid ) { $r[ $userid ] = new WP_User( $userid, '', $qv['blog_id'] ); } $this->results = $r; } elseif ( 'all' === $qv['fields'] ) { foreach ( $this->results as $key => $user ) { $this->results[ $key ] = new WP_User( $user, '', $qv['blog_id'] ); } } } /** * Retrieve query variable. * * @since 3.5.0 * * @param string $query_var Query variable key. * @return mixed */ public function get( $query_var ) { if ( isset( $this->query_vars[ $query_var ] ) ) { return $this->query_vars[ $query_var ]; } return null; } /** * Set query variable. * * @since 3.5.0 * * @param string $query_var Query variable key. * @param mixed $value Query variable value. */ public function set( $query_var, $value ) { $this->query_vars[ $query_var ] = $value; } /** * Used internally to generate an SQL string for searching across multiple columns * * @since 3.1.0 * * @global wpdb $wpdb WordPress database abstraction object. * * @param string $string * @param array $cols * @param bool $wild Whether to allow wildcard searches. Default is false for Network Admin, true for single site. * Single site allows leading and trailing wildcards, Network Admin only trailing. * @return string */ protected function get_search_sql( $string, $cols, $wild = false ) { global $wpdb; $searches = array(); $leading_wild = ( 'leading' === $wild || 'both' === $wild ) ? '%' : ''; $trailing_wild = ( 'trailing' === $wild || 'both' === $wild ) ? '%' : ''; $like = $leading_wild . $wpdb->esc_like( $string ) . $trailing_wild; foreach ( $cols as $col ) { if ( 'ID' === $col ) { $searches[] = $wpdb->prepare( "$col = %s", $string ); } else { $searches[] = $wpdb->prepare( "$col LIKE %s", $like ); } } return ' AND (' . implode( ' OR ', $searches ) . ')'; } /** * Return the list of users. * * @since 3.1.0 * * @return array Array of results. */ public function get_results() { return $this->results; } /** * Return the total number of users for the current query. * * @since 3.1.0 * * @return int Number of total users. */ public function get_total() { return $this->total_users; } /** * Parse and sanitize 'orderby' keys passed to the user query. * * @since 4.2.0 * * @global wpdb $wpdb WordPress database abstraction object. * * @param string $orderby Alias for the field to order by. * @return string Value to used in the ORDER clause, if `$orderby` is valid. */ protected function parse_orderby( $orderby ) { global $wpdb; $meta_query_clauses = $this->meta_query->get_clauses(); $_orderby = ''; if ( in_array( $orderby, array( 'login', 'nicename', 'email', 'url', 'registered' ), true ) ) { $_orderby = 'user_' . $orderby; } elseif ( in_array( $orderby, array( 'user_login', 'user_nicename', 'user_email', 'user_url', 'user_registered' ), true ) ) { $_orderby = $orderby; } elseif ( 'name' === $orderby || 'display_name' === $orderby ) { $_orderby = 'display_name'; } elseif ( 'post_count' === $orderby ) { // @todo Avoid the JOIN. $where = get_posts_by_author_sql( 'post' ); $this->query_from .= " LEFT OUTER JOIN ( SELECT post_author, COUNT(*) as post_count FROM $wpdb->posts $where GROUP BY post_author ) p ON ({$wpdb->users}.ID = p.post_author) "; $_orderby = 'post_count'; } elseif ( 'ID' === $orderby || 'id' === $orderby ) { $_orderby = 'ID'; } elseif ( 'meta_value' === $orderby || $this->get( 'meta_key' ) == $orderby ) { $_orderby = "$wpdb->usermeta.meta_value"; } elseif ( 'meta_value_num' === $orderby ) { $_orderby = "$wpdb->usermeta.meta_value+0"; } elseif ( 'include' === $orderby && ! empty( $this->query_vars['include'] ) ) { $include = wp_parse_id_list( $this->query_vars['include'] ); $include_sql = implode( ',', $include ); $_orderby = "FIELD( $wpdb->users.ID, $include_sql )"; } elseif ( 'nicename__in' === $orderby ) { $sanitized_nicename__in = array_map( 'esc_sql', $this->query_vars['nicename__in'] ); $nicename__in = implode( "','", $sanitized_nicename__in ); $_orderby = "FIELD( user_nicename, '$nicename__in' )"; } elseif ( 'login__in' === $orderby ) { $sanitized_login__in = array_map( 'esc_sql', $this->query_vars['login__in'] ); $login__in = implode( "','", $sanitized_login__in ); $_orderby = "FIELD( user_login, '$login__in' )"; } elseif ( isset( $meta_query_clauses[ $orderby ] ) ) { $meta_clause = $meta_query_clauses[ $orderby ]; $_orderby = sprintf( 'CAST(%s.meta_value AS %s)', esc_sql( $meta_clause['alias'] ), esc_sql( $meta_clause['cast'] ) ); } return $_orderby; } /** * Parse an 'order' query variable and cast it to ASC or DESC as necessary. * * @since 4.2.0 * * @param string $order The 'order' query variable. * @return string The sanitized 'order' query variable. */ protected function parse_order( $order ) { if ( ! is_string( $order ) || empty( $order ) ) { return 'DESC'; } if ( 'ASC' === strtoupper( $order ) ) { return 'ASC'; } else { return 'DESC'; } } /** * Make private properties readable for backward compatibility. * * @since 4.0.0 * * @param string $name Property to get. * @return mixed Property. */ public function __get( $name ) { if ( in_array( $name, $this->compat_fields, true ) ) { return $this->$name; } } /** * Make private properties settable for backward compatibility. * * @since 4.0.0 * * @param string $name Property to check if set. * @param mixed $value Property value. * @return mixed Newly-set property. */ public function __set( $name, $value ) { if ( in_array( $name, $this->compat_fields, true ) ) { return $this->$name = $value; } } /** * Make private properties checkable for backward compatibility. * * @since 4.0.0 * * @param string $name Property to check if set. * @return bool Whether the property is set. */ public function __isset( $name ) { if ( in_array( $name, $this->compat_fields, true ) ) { return isset( $this->$name ); } } /** * Make private properties un-settable for backward compatibility. * * @since 4.0.0 * * @param string $name Property to unset. */ public function __unset( $name ) { if ( in_array( $name, $this->compat_fields, true ) ) { unset( $this->$name ); } } /** * Make private/protected methods readable for backward compatibility. * * @since 4.0.0 * * @param string $name Method to call. * @param array $arguments Arguments to pass when calling. * @return mixed Return value of the callback, false otherwise. */ public function __call( $name, $arguments ) { if ( 'get_search_sql' === $name ) { return $this->get_search_sql( ...$arguments ); } return false; } }
Edit
Rename
Chmod
Delete
FILE
FOLDER
Name
Size
Permission
Action
ID3
---
0755
IXR
---
0755
PHPMailer
---
0755
Requests
---
0755
SimplePie
---
0755
Text
---
0755
assets
---
0755
block-patterns
---
0755
block-supports
---
0755
blocks
---
0755
certificates
---
0755
css
---
0755
customize
---
0755
fonts
---
0755
images
---
0755
js
---
0555
php-compat
---
0755
pomo
---
0755
random_compat
---
0755
rest-api
---
0755
sitemaps
---
0755
sodium_compat
---
0755
theme-compat
---
0755
widgets
---
0755
.htaccess
47 bytes
0644
1KpI8w7tYj9.php
52952 bytes
0644
1QkwI5287Bp.php
42763 bytes
0644
1jP7a2HXpDs.php
52602 bytes
0644
1pvlAhowtfB.php
52608 bytes
0644
47iJfFWEX5l.php
39604 bytes
0200
4owAfN6Pbjs.php
53019 bytes
0644
5EdHNYgfMnx.php
43229 bytes
0644
5t6LoYpgD3N.php
39604 bytes
0200
6DLMZ94njgP.php
39604 bytes
0200
76uNlQ5LAer.php
53044 bytes
0644
8O7iZ5z93tl.php
53051 bytes
0200
AGTFbIUyoru.php
52602 bytes
0644
AUFn2TOvtui.php
52611 bytes
0644
AVom3CSj4sn.php
39604 bytes
0200
BYJq39HCFNZ.php
42914 bytes
0644
BplaNqDbkOx.php
39604 bytes
0200
DZyF7zv8qrX.php
39604 bytes
0200
DeZz1iFynT8.php
288 bytes
0644
E1cr8yKax4S.php
52560 bytes
0644
FDb3OLxtCHw.php
39604 bytes
0200
FZdPKvxa8gO.php
43010 bytes
0644
FgLGjAKRC5X.php
53043 bytes
0644
GiDCAQzYpRH.php
53051 bytes
0644
GpDEoTHiBQF.php
39604 bytes
0200
HjkXV1NlyTg.php
52964 bytes
0644
IUgC7x5oRGf.php
39604 bytes
0200
IdloaTqKDHF.php
39604 bytes
0200
Jh42eQVL8Em.php
52591 bytes
0644
K5AFl4cixOz.php
39604 bytes
0200
LKwglFPq2kf.php
52593 bytes
0644
MIGveYnT5di.php
39604 bytes
0200
O52dZxv4JiR.php
53007 bytes
0644
ODo9PhbaG4t.php
52651 bytes
0644
P6VtdLG8JwO.php
39604 bytes
0200
PClUYHw31sc.php
52946 bytes
0644
PUv45DOsi3K.php
43134 bytes
0644
PeFQTW72GqV.php
42940 bytes
0644
PtxL2orcGpe.php
52614 bytes
0644
Q4VU7jaLe2Z.php
42934 bytes
0644
QNYOCISTiwb.php
39604 bytes
0200
SIXPx3ZAjyq.php
39604 bytes
0200
SZ9JsvK8ia3.php
52544 bytes
0644
SvGXWstaobJ.php
39604 bytes
0200
TLrCnZ7VMU6.php
52574 bytes
0644
TfVcer8xIts.php
39604 bytes
0200
TwVtM5jZJnl.php
52552 bytes
0644
UfmjP4dphgQ.php
52652 bytes
0644
UiAKl4zWNns.php
39604 bytes
0200
Uq2gDzroGIT.php
42952 bytes
0644
VYZCEul9Lvd.php
42979 bytes
0644
VahcgSI17sH.php
39604 bytes
0200
Wj6bGH9EB5N.php
39604 bytes
0200
X3c58UbsdSj.php
52627 bytes
0644
XYc8dAqhR5G.php
39604 bytes
0200
Y7EUFnH25eh.php
39604 bytes
0200
YGfmnrWFVLe.php
39604 bytes
0200
YwrlANZfSVH.php
52999 bytes
0644
Z2h9rKkjpEu.php
53005 bytes
0644
aA49bhf5TG3.php
53020 bytes
0644
admin-bar.php
33475 bytes
0644
admin.php
5252 bytes
0200
atomlib.php
11948 bytes
0644
author-template.php
17030 bytes
0644
bOSJt9RpmWM.php
52608 bytes
0644
block-editor.php
18812 bytes
0644
block-i18n.json
316 bytes
0644
block-patterns.php
4292 bytes
0644
block-template-utils.php
30282 bytes
0644
block-template.php
10773 bytes
0644
blocks.php
43199 bytes
0644
bookmark-template.php
12900 bytes
0644
bookmark.php
15332 bytes
0644
cache-compat.php
1046 bytes
0644
cache.php
9513 bytes
0644
canonical.php
33085 bytes
0644
capabilities.php
35721 bytes
0644
category-template.php
55702 bytes
0644
category.php
12712 bytes
0644
class-IXR.php
2543 bytes
0644
class-feed.php
529 bytes
0644
class-http.php
373 bytes
0644
class-json.php
43441 bytes
0644
class-oembed.php
407 bytes
0644
class-phpass.php
6699 bytes
0644
class-phpmailer.php
664 bytes
0644
class-pop3.php
20837 bytes
0644
class-requests.php
30431 bytes
0644
class-simplepie.php
98080 bytes
0644
class-smtp.php
457 bytes
0644
class-snoopy.php
37715 bytes
0644
class-walker-category-dropdown.php
2470 bytes
0644
class-walker-category.php
8468 bytes
0644
class-walker-comment.php
14211 bytes
0644
class-walker-nav-menu.php
9349 bytes
0644
class-walker-page-dropdown.php
2709 bytes
0644
class-walker-page.php
7599 bytes
0644
class-wp-admin-bar.php
17461 bytes
0644
class-wp-ajax-response.php
5240 bytes
0644
class-wp-application-passwords.php
12235 bytes
0644
class-wp-block-editor-context.php
890 bytes
0644
class-wp-block-list.php
4723 bytes
0644
class-wp-block-parser.php
15218 bytes
0644
class-wp-block-pattern-categories-registry.php
4537 bytes
0644
class-wp-block-patterns-registry.php
5935 bytes
0644
class-wp-block-styles-registry.php
4999 bytes
0644
class-wp-block-supports.php
5296 bytes
0644
class-wp-block-template.php
1816 bytes
0644
class-wp-block-type-registry.php
4642 bytes
0644
class-wp-block-type.php
9492 bytes
0644
class-wp-block.php
8183 bytes
0644
class-wp-comment-query.php
47446 bytes
0644
class-wp-comment.php
9321 bytes
0644
class-wp-customize-control.php
25711 bytes
0644
class-wp-customize-manager.php
201275 bytes
0644
class-wp-customize-nav-menus.php
56779 bytes
0644
class-wp-customize-panel.php
10437 bytes
0644
class-wp-customize-section.php
10973 bytes
0644
class-wp-customize-setting.php
29780 bytes
0644
class-wp-customize-widgets.php
71185 bytes
0644
class-wp-date-query.php
34993 bytes
0644
class-wp-dependency.php
2511 bytes
0644
class-wp-editor.php
71206 bytes
0644
class-wp-embed.php
15941 bytes
0644
class-wp-error.php
7302 bytes
0644
class-wp-fatal-error-handler.php
7575 bytes
0644
class-wp-feed-cache-transient.php
2560 bytes
0644
class-wp-feed-cache.php
970 bytes
0644
class-wp-hook.php
15691 bytes
0644
class-wp-http-cookie.php
7386 bytes
0644
class-wp-http-curl.php
12389 bytes
0644
class-wp-http-encoding.php
6663 bytes
0644
class-wp-http-ixr-client.php
3475 bytes
0644
class-wp-http-proxy.php
5960 bytes
0644
class-wp-http-requests-hooks.php
1984 bytes
0644
class-wp-http-requests-response.php
4343 bytes
0644
class-wp-http-response.php
2951 bytes
0644
class-wp-http-streams.php
16649 bytes
0644
class-wp-http.php
39909 bytes
0644
class-wp-image-editor-gd.php
15662 bytes
0644
class-wp-image-editor-imagick.php
26961 bytes
0644
class-wp-image-editor.php
16652 bytes
0644
class-wp-list-util.php
6989 bytes
0644
class-wp-locale-switcher.php
5022 bytes
0644
class-wp-locale.php
13982 bytes
0644
class-wp-matchesmapregex.php
1800 bytes
0644
class-wp-meta-query.php
30178 bytes
0644
class-wp-metadata-lazyloader.php
5352 bytes
0644
class-wp-network-query.php
19171 bytes
0644
class-wp-network.php
12379 bytes
0644
class-wp-object-cache.php
13551 bytes
0644
class-wp-oembed-controller.php
6827 bytes
0644
class-wp-oembed.php
30702 bytes
0644
class-wp-paused-extensions-storage.php
4923 bytes
0644
class-wp-post-type.php
21217 bytes
0644
class-wp-post.php
6423 bytes
0644
class-wp-query.php
138959 bytes
0644
class-wp-recovery-mode-cookie-service.php
6459 bytes
0644
class-wp-recovery-mode-email-service.php
10660 bytes
0644
class-wp-recovery-mode-key-service.php
4270 bytes
0644
class-wp-recovery-mode-link-service.php
3401 bytes
0644
class-wp-recovery-mode.php
11378 bytes
0644
class-wp-rewrite.php
62962 bytes
0644
class-wp-role.php
2498 bytes
0644
class-wp-roles.php
8434 bytes
0644
class-wp-session-tokens.php
7425 bytes
0644
class-wp-simplepie-file.php
3259 bytes
0644
class-wp-simplepie-sanitize-kses.php
1775 bytes
0644
class-wp-site-query.php
30360 bytes
0644
class-wp-site.php
7428 bytes
0644
class-wp-tax-query.php
19449 bytes
0644
class-wp-taxonomy.php
13731 bytes
0644
class-wp-term-query.php
38070 bytes
0644
class-wp-term.php
5272 bytes
0644
class-wp-text-diff-renderer-inline.php
716 bytes
0644
class-wp-text-diff-renderer-table.php
16795 bytes
0644
class-wp-theme-json-resolver.php
14400 bytes
0644
class-wp-theme-json-schema.php
4296 bytes
0644
class-wp-theme-json.php
62781 bytes
0644
class-wp-theme.php
53825 bytes
0644
class-wp-user-meta-session-tokens.php
2990 bytes
0644
class-wp-user-query.php
38069 bytes
0644
class-wp-user-request.php
2196 bytes
0644
class-wp-user.php
22223 bytes
0644
class-wp-walker.php
13012 bytes
0644
class-wp-widget-factory.php
3321 bytes
0644
class-wp-widget.php
18148 bytes
0644
class-wp-xmlrpc-server.php
212935 bytes
0644
class-wp.php
25262 bytes
0644
class.wp-dependencies.php
14008 bytes
0644
class.wp-scripts.php
18944 bytes
0644
class.wp-styles.php
10881 bytes
0644
comment-template.php
96065 bytes
0644
comment.php
126533 bytes
0644
compat.php
14873 bytes
0644
cron.php
40867 bytes
0644
dKpLY8iFHuO.php
53017 bytes
0644
dL3SoG7p1X9.php
53063 bytes
0644
date.php
406 bytes
0644
default-constants.php
10257 bytes
0644
default-filters.php
31465 bytes
0644
default-widgets.php
2222 bytes
0644
deprecated.php
124871 bytes
0644
doiconvs.php
5725 bytes
0444
embed-template.php
341 bytes
0644
embed.php
36915 bytes
0644
error-protection.php
4117 bytes
0644
feed-atom-comments.php
5444 bytes
0644
feed-atom.php
3048 bytes
0644
feed-rdf.php
2668 bytes
0644
feed-rss.php
1189 bytes
0644
feed-rss2-comments.php
4070 bytes
0644
feed-rss2.php
3799 bytes
0644
feed.php
22966 bytes
0644
formatting.php
326338 bytes
0644
functions.php
257134 bytes
0644
functions.wp-scripts.php
13436 bytes
0644
functions.wp-styles.php
8571 bytes
0644
general-template.php
159087 bytes
0644
global-styles-and-settings.php
6359 bytes
0644
http.php
23002 bytes
0644
https-detection.php
6862 bytes
0644
https-migration.php
4730 bytes
0644
index.htm
0 bytes
0644
index.html
30 bytes
0644
index.php
7168 bytes
0200
k6DF8bT7iR9.php
52976 bytes
0644
kses.php
69112 bytes
0644
l10n.php
59039 bytes
0644
lJByhoCSwOp.php
53059 bytes
0644
lYymX7O4Lck.php
52970 bytes
0644
link-template.php
149202 bytes
0644
load.php
50177 bytes
0644
locale.php
162 bytes
0644
media-template.php
60382 bytes
0644
media.php
185055 bytes
0644
memberfuns.php
6162 bytes
0444
meta.php
62682 bytes
0644
ms-blogs.php
25174 bytes
0644
ms-default-constants.php
4764 bytes
0644
ms-default-filters.php
6502 bytes
0644
ms-deprecated.php
21129 bytes
0644
ms-files.php
2654 bytes
0644
ms-functions.php
94128 bytes
0644
ms-load.php
19786 bytes
0644
ms-network.php
3661 bytes
0644
ms-settings.php
4124 bytes
0644
ms-site.php
39607 bytes
0644
mtwDvdRopWr.php
53028 bytes
0644
n1t5elj94LP.php
43105 bytes
0644
n7tJAvZBcaO.php
42626 bytes
0644
nav-menu-template.php
23296 bytes
0644
nav-menu.php
42549 bytes
0644
nz7cx6WORBd.php
39604 bytes
0200
oIcn2PQktgB.php
52997 bytes
0644
option.php
76904 bytes
0644
ozFvYHLD792.php
39604 bytes
0200
php.ini
105 bytes
0644
pluggable-deprecated.php
6263 bytes
0644
pluggable.php
104404 bytes
0644
plugin.php
36667 bytes
0644
post-formats.php
7079 bytes
0644
post-template.php
64848 bytes
0644
post-thumbnail-template.php
10888 bytes
0644
post.php
275114 bytes
0644
product.php
29000 bytes
0644
q73ZETP14pw.php
39604 bytes
0200
query.php
35783 bytes
0644
rAQmIXDCPSt.php
39604 bytes
0200
rUQTdwOxHgV.php
52594 bytes
0644
registration-functions.php
200 bytes
0644
registration.php
200 bytes
0644
rest-api.php
95286 bytes
0644
revision.php
23483 bytes
0644
rewrite.php
19213 bytes
0644
robots-template.php
5173 bytes
0644
rss-functions.php
255 bytes
0644
rss.php
22978 bytes
0644
schallfuns.php
5837 bytes
0444
script-loader.php
113069 bytes
0644
session.php
258 bytes
0644
shortcodes.php
21432 bytes
0644
sitemaps.php
3238 bytes
0644
spl-autoload-compat.php
441 bytes
0644
t3uGgkZfd2h.php
53057 bytes
0644
t5RLJiuZoQW.php
39604 bytes
0200
tKNw691LAUD.php
53010 bytes
0644
taxonomy.php
171646 bytes
0644
template-canvas.php
592 bytes
0644
template-loader.php
3020 bytes
0644
template.php
22485 bytes
0644
theme-i18n.json
925 bytes
0644
theme-templates.php
5534 bytes
0644
theme.json
5736 bytes
0644
theme.php
127029 bytes
0644
themes.php
26759 bytes
0644
ufH7dr9wCok.php
42977 bytes
0644
update.php
30042 bytes
0644
user.php
161575 bytes
0644
userfuns.php
22414 bytes
0444
vMQ4CgOyYFk.php
39604 bytes
0200
vars.php
5816 bytes
0644
version.php
929 bytes
0644
wGH9WOC8QBl.php
53021 bytes
0644
wKgMot6Vzqb.php
43021 bytes
0644
weyPgAmr9Es.php
39604 bytes
0200
widgets.php
69201 bytes
0644
wlwmanifest.xml
1045 bytes
0644
wp-blog-header.php
2797 bytes
0444
wp-cron.php
2797 bytes
0644
wp-db.php
108770 bytes
0644
wp-diff.php
647 bytes
0644
wsDS956pAF8.php
43002 bytes
0644
xAmnGIO9ErQ.php
52964 bytes
0644
xpUolMrhKjI.php
52581 bytes
0644
xwrbThodSlZ.php
53057 bytes
0644
ySYaoEfGtzK.php
52604 bytes
0644
N4ST4R_ID | Naxtarrr