Changeset 47010 for trunk/src/wp-includes/media.php

Timestamp:

12/25/2019 02:24:38 AM (5 years ago)

Author:

SergeyBiryukov

Message:

Media: Make sure attachment_url_to_postid() performs a case-sensitive search for the uploaded file name.

Previously, the first available match was returned, regardless of the case, which was not always the expected result.

Props archon810, ben.greeley, tristangemus, vsamoletov, SergeyBiryukov.
Fixes #39768.

File:

• trunk/src/wp-includes/media.php (modified) (1 diff)

trunk/src/wp-includes/media.php

@@ -4296 +4296 @@
 
     $sql = $wpdb->prepare(
-        "SELECT post_id FROM $wpdb->postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = %s",
+        "SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = %s",
         $path
     );
 
-    $post_id = $wpdb->get_var( $sql );
+    $results = $wpdb->get_results( $sql );
+    $post_id = null;
+
+    if ( $results ) {
+        // Use the first available result, but prefer a case-sensitive match, if exists.
+        $post_id = reset( $results )->post_id;
+
+        if ( count( $results ) > 1 ) {
+            foreach ( $results as $result ) {
+                if ( $path === $result->meta_value ) {
+                    $post_id = $result->post_id;
+                    break;
+                }
+            }
+        }
+    }
 
     /**