Changeset 14478 for trunk/wp-includes/post.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/post.php (modified) (2 diffs)

trunk/wp-includes/post.php

@@ -1574 +1574 @@
  *
  * @param string|array $mime_types List of mime types or comma separated string of mime types.
+ * @param string $table_alias Optional. Specify a table alias, if needed. 
  * @return string The SQL AND clause for mime searching.
  */
-function wp_post_mime_type_where($post_mime_types) {
+function wp_post_mime_type_where($post_mime_types, $table_alias = '') {
     $where = '';
     $wildcards = array('', '%', '%/%');
@@ -1604 +1605 @@
 
         if ( false !== strpos($mime_pattern, '%') )
-            $wheres[] = "post_mime_type LIKE '$mime_pattern'";
+            $wheres[] = empty($table_alias) ? "post_mime_type LIKE '$mime_pattern'" : "$table_alias.post_mime_type LIKE '$mime_pattern'";
         else
-            $wheres[] = "post_mime_type = '$mime_pattern'";
+            $wheres[] = empty($table_alias) ? "post_mime_type = '$mime_pattern'" : "$table_alias.post_mime_type = '$mime_pattern'";
     }
     if ( !empty($wheres) )