Changeset 42061 for branches/4.4/src/wp-includes/post.php

Timestamp:

10/31/2017 12:45:48 PM (9 years ago)

Author:

pento

Message:

Database: Restore numbered placeholders in wpdb::prepare().

[41496] removed support for numbered placeholders in queries send through wpdb::prepare(), which, despite being undocumented, were quite commonly used.

This change restores support for numbered placeholders (as well as a subset of placeholder formatting), while also adding extra checks to ensure the correct number of arguments are being passed to wpdb::prepare(), given the number of placeholders.

Merges [41662], [42056] to the 4.4 branch.
See #41925.

Location:

branches/4.4

Files:

• . (modified) (1 prop)
• src/wp-includes/post.php (modified) (1 diff)

branches/4.4/src/wp-includes/post.php

@@ -4089 +4089 @@
         $page_path = str_replace('%20', ' ', $page_path);
         $parts = explode( '/', trim( $page_path, '/' ) );
-        $parts = esc_sql( $parts );
         $parts = array_map( 'sanitize_title_for_query', $parts );
-
-        $in_string = "'" . implode( "','", $parts ) . "'";
+        $escaped_parts = esc_sql( $parts );
+
+        $in_string = "'" . implode( "','", $escaped_parts ) . "'";
 
         if ( is_array( $post_type ) ) {