Changeset 31369 for trunk/src/wp-includes/user.php

Timestamp:

02/08/2015 04:58:14 PM (10 years ago)

Author:

boonebgorges

Message:

Add orderby=meta_value_num support to WP_User_Query.

Props tyxla, genkisan.
Fixes #27887.

File:

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

trunk/src/wp-includes/user.php

@@ -501 +501 @@
      *
      * @since 3.1.0
+     * @since 4.2.0 Added 'meta_value_num' support for `$orderby` parameter.
      * @access public
      *
@@ -522 +523 @@
      *                                         'nicename', 'email', 'url'. Default empty array.
      *     @type string       $orderby         Field to sort the retrieved users by. Accepts 'ID', 'display_name',
-     *                                         'login', 'nicename', 'email', 'url', 'registered', 'post_count', or
-     *                                         'meta_value'. To use 'meta_value', `$meta_key` must be also be defined.
+     *                                         'login', 'nicename', 'email', 'url', 'registered', 'post_count',
+     *                                         'meta_value' or 'meta_value_num'. 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. Accepts 'ASC',
@@ -632 +634 @@
             } elseif ( 'meta_value' == $qv['orderby'] ) {
                 $orderby = "$wpdb->usermeta.meta_value";
+            } elseif ( 'meta_value_num' == $qv['orderby'] ) {
+                $orderby = "$wpdb->usermeta.meta_value+0";
             } elseif ( 'include' === $qv['orderby'] && ! empty( $include ) ) {
                 // Sanitized earlier.