Changeset 18825

Timestamp:

09/29/2011 10:10:56 PM (13 years ago)

Author:

duck_

Message:

Automatically set 'compare' => 'IN' in WP_Meta_Query::get_sql() when the meta value is an array. Props ldebrouwer, SergeyBiryukov. Fixes #16829.

File:

• trunk/wp-includes/meta.php (modified) (2 diffs)

trunk/wp-includes/meta.php

@@ -710 +710 @@
         foreach ( $this->queries as $k => $q ) {
             $meta_key = isset( $q['key'] ) ? trim( $q['key'] ) : '';
-            $meta_compare = isset( $q['compare'] ) ? strtoupper( $q['compare'] ) : '=';
             $meta_type = isset( $q['type'] ) ? strtoupper( $q['type'] ) : 'CHAR';
-
-            if ( ! in_array( $meta_compare, array( '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN' ) ) )
-                $meta_compare = '=';
 
             if ( 'NUMERIC' == $meta_type )
@@ -740 +736 @@
 
             $meta_value = $q['value'];
+
+            $meta_compare = is_array( $meta_value ) ? 'IN' : '=';
+            if ( isset( $q['compare'] ) )
+                $meta_compare = strtoupper( $q['compare'] );
+
+            if ( ! in_array( $meta_compare, array( '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN' ) ) )
+                $meta_compare = '=';
 
             if ( in_array( $meta_compare, array( 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN' ) ) ) {