WordPress.org

Make WordPress Core


Ignore:
Timestamp:
05/06/2010 06:03:05 PM (10 years ago)
Author:
nacin
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-includes/post.php

    r14448 r14478  
    15741574 *
    15751575 * @param string|array $mime_types List of mime types or comma separated string of mime types.
     1576 * @param string $table_alias Optional. Specify a table alias, if needed. 
    15761577 * @return string The SQL AND clause for mime searching.
    15771578 */
    1578 function wp_post_mime_type_where($post_mime_types) {
     1579function wp_post_mime_type_where($post_mime_types, $table_alias = '') {
    15791580    $where = '';
    15801581    $wildcards = array('', '%', '%/%');
     
    16041605
    16051606        if ( false !== strpos($mime_pattern, '%') )
    1606             $wheres[] = "post_mime_type LIKE '$mime_pattern'";
     1607            $wheres[] = empty($table_alias) ? "post_mime_type LIKE '$mime_pattern'" : "$table_alias.post_mime_type LIKE '$mime_pattern'";
    16071608        else
    1608             $wheres[] = "post_mime_type = '$mime_pattern'";
     1609            $wheres[] = empty($table_alias) ? "post_mime_type = '$mime_pattern'" : "$table_alias.post_mime_type = '$mime_pattern'";
    16091610    }
    16101611    if ( !empty($wheres) )
Note: See TracChangeset for help on using the changeset viewer.