Changeset 28191 for trunk/src/wp-includes/post.php

Timestamp:

04/23/2014 10:04:03 PM (10 years ago)

Author:

johnbillion

Message:

Avoid an expensive attachment counting query on the post editing screen. See #27985, for trunk.

File:

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

trunk/src/wp-includes/post.php

@@ -2293 +2293 @@
 
 /**
+ * Determine if at least one attachment of a particular mime-type has been uploaded
+ *
+ * @global wpdb $wpdb
+ *
+ * @since 3.9.1
+ *
+ * @param string $mime_type The mime-type string to check.
+ *
+ * @return int|null If exist, the post ID of the first found attachment.
+ */
+function wp_has_mime_type_attachments( $mime_type ) {
+    global $wpdb;
+    $sql = sprintf( "SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_mime_type LIKE '%s%%' LIMIT 1", like_escape( $mime_type ) );
+    return $wpdb->get_var( $sql );
+}
+
+/**
  * Get default post mime types
  *