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

Timestamp:

07/08/2014 05:47:53 PM (11 years ago)

Author:

wonderboymusic

Message:

When setting the poster image for a video shortcode, set that image as the featured image for that attachment (if found) in the background. This AJAX functionality could be used for audio as well.

Introduces attachment_url_to_postid() to attempt to turn URLs into post IDs.

Fixes #27891.

File:

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

trunk/src/wp-includes/media.php

@@ -3219 +3219 @@
     }
 }
+
+/**
+ * Try to convert an attachment URL into a post ID.
+ *
+ * @since 4.0.0
+ *
+ * @global wpdb $wpdb WordPress database access abstraction object.
+ * @param string $url The URL to resolve.
+ * @return int The found post_id.
+ */
+function attachment_url_to_postid( $url ) {
+    global $wpdb;
+
+    $dir = wp_upload_dir();
+    $path = ltrim( $url, $dir['baseurl'] . '/' );
+
+    $sql = $wpdb->prepare(
+        "SELECT post_id FROM $wpdb->postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = %s",
+        $path
+    );
+    $post_id = $wpdb->get_var( $sql );
+    if ( ! empty( $post_id ) ) {
+        return (int) $post_id;
+    }
+}