Changeset 14478 for trunk/wp-includes/query.php

Timestamp:

05/06/2010 06:03:05 PM (14 years ago)

Author:

nacin

Message:

Prevent ambiguous table aliases in wp_post_mime_type_where. props stephdau, jfarthing84, fixes #12750.

File:

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

trunk/wp-includes/query.php

@@ -2027 +2027 @@
                 if ( !is_wp_error($post_ids) && !empty($post_ids) ) {
                     $whichcat .= " AND $wpdb->posts.ID IN (" . implode(', ', $post_ids) . ") ";
-                    if ( '' === $post_type ) {
+                    if ( empty($post_type) ) {
                         $post_type = 'any';
                         $post_status_join = true;
@@ -2033 +2033 @@
                         $post_status_join = true;
                     }
-                    $q['post_status'] = 'publish';
+                    if ( empty($q['post_status']) )
+                        $q['post_status'] = 'publish';
                 } else {
                     $whichcat = " AND 0 ";
@@ -2084 +2085 @@
         // MIME-Type stuff for attachment browsing
 
-        if ( isset($q['post_mime_type']) && '' != $q['post_mime_type'] )
-            $whichmimetype = wp_post_mime_type_where($q['post_mime_type']);
+        if ( isset($q['post_mime_type']) && '' != $q['post_mime_type'] ) {
+            $table_alias = $post_status_join ? $wpdb->posts : '';
+            $whichmimetype = wp_post_mime_type_where($q['post_mime_type'], $table_alias);
+        }
 
         $where .= $search . $whichcat . $whichauthor . $whichmimetype;