Changeset 35101 for trunk/src/wp-includes/class-wp-user-query.php

Timestamp:

10/13/2015 01:31:53 AM (9 years ago)

Author:

boonebgorges

Message:

Don't match partial roles in WP_User_Query.

Because 'role=ocean90' shouldn't match 'role=bocean901'.

Props bocean901, ocean90.
Fixes #22212.

File:

• trunk/src/wp-includes/class-wp-user-query.php (modified) (3 diffs)

trunk/src/wp-includes/class-wp-user-query.php

@@ -305 +305 @@
                     $roles_clauses[] = array(
                         'key'     => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities',
-                        'value'   => $role,
+                        'value'   => '"' . $role . '"',
                         'compare' => 'LIKE',
                     );
@@ -318 +318 @@
                     $role__in_clauses[] = array(
                         'key'     => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities',
-                        'value'   => $role,
+                        'value'   => '"' . $role . '"',
                         'compare' => 'LIKE',
                     );
@@ -331 +331 @@
                     $role__not_in_clauses[] = array(
                         'key'     => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities',
-                        'value'   => $role,
+                        'value'   => '"' . $role . '"',
                         'compare' => 'NOT LIKE',
                     );