Changeset 6910 for trunk/wp-includes/post.php

Timestamp:

02/19/2008 06:13:20 AM (19 years ago)

Author:

ryan

Message:

Media Library design updates from Andy. see #5911

File:

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

trunk/wp-includes/post.php

@@ -808 +808 @@
 
 /**
+ * wp_count_attachments() - Count number of attachments
+ *
+ * {@internal Missing Long Description}}
+ *
+ * @package WordPress
+ * @subpackage Post
+ * @since 2.5
+ *
+ * @param string|array $post_mime_type Array or comma-separated list of MIME patterns
+ * @return array Number of posts for each post_mime_type
+ */
+
+function wp_count_attachments( $mime_type = '' ) {
+        global $wpdb;
+
+        $and = wp_post_mime_type_where( $mime_type );
+        $count = $wpdb->get_results( "SELECT post_mime_type, COUNT( * ) AS num_posts FROM $wpdb->posts WHERE post_type = 'attachment' $and GROUP BY post_mime_type", ARRAY_A );
+
+        $stats = array( );
+        foreach( (array) $count as $row ) {
+                $stats[$row['post_mime_type']] = $row['num_posts'];
+        }
+
+        return (object) $stats;
+}
+
+/**
+ * wp_match_mime_type() - Check a MIME-Type against a list
+ *
+ * {@internal Missing Long Description}}
+ *
+ * @package WordPress
+ * @subpackage Post
+ * @since 2.5
+ *
+ * @param string|array $wildcard_mime_types e.g. audio/mpeg or image (same as image/*) or flash (same as *flash*)
+ * @param string|array $real_mime_types post_mime_type values
+ * @return array array(wildcard=>array(real types))
+ */
+function wp_match_mime_types($wildcard_mime_types, $real_mime_types) {
+        $matches = array();
+        if ( is_string($wildcard_mime_types) )
+                $wildcard_mime_types = array_map('trim', explode(',', $wildcard_mime_types));
+        if ( is_string($real_mime_types) )
+                $real_mime_types = array_map('trim', explode(',', $real_mime_types));
+        $wild = '[-._a-z0-9]*';
+        foreach ( (array) $wildcard_mime_types as $type ) {
+                $type = str_replace('*', $wild, $type);
+                $patternses[1][$type] = $type;
+                if ( false === strpos($type, '/') ) {
+                        $patternses[2][$type] = "^$type/$wild$";
+                        $patternses[3][$type] = "$wild$type$wild";
+                }
+        }
+        asort($patternses);
+        foreach ( $patternses as $patterns )
+                foreach ( $patterns as $type => $pattern )
+                        foreach ( (array) $real_mime_types as $real )
+                                if ( preg_match("#$pattern#", $real) && ( empty($matches[$type]) || false === array_search($real, $matches[$type]) ) )
+                                        $matches[$type][] = $real;
+        return $matches;
+}
+
+/**
+ * wp_get_post_mime_type_where() - Convert MIME types into SQL
+ *
+ * @package WordPress
+ * @subpackage Post
+ * @since 2.5
+ *
+ * @param string|array $mime_types MIME types
+ * @return string SQL AND clause
+ */
+function wp_post_mime_type_where($post_mime_types) {
+        $where = '';
+        $wildcards = array('', '%', '%/%');
+        if ( is_string($post_mime_types) )
+                $post_mime_types = array_map('trim', explode(',', $post_mime_types));
+        foreach ( (array) $post_mime_types as $mime_type ) {
+                $mime_type = preg_replace('/\s/', '', $mime_type);
+                $slashpos = strpos($mime_type, '/');
+                if ( false !== $slashpos ) {
+                        $mime_group = preg_replace('/[^-*.a-zA-Z0-9]/', '', substr($mime_type, 0, $slashpos));
+                        $mime_subgroup = preg_replace('/[^-*.a-zA-Z0-9]/', '', substr($mime_type, $slashpos + 1));
+                        if ( empty($mime_subgroup) )
+                                $mime_subgroup = '*';
+                        else
+                                $mime_subgroup = str_replace('/', '', $mime_subgroup);
+                        $mime_pattern = "$mime_group/$mime_subgroup";
+                } else {
+                        $mime_pattern = preg_replace('/[^-*.a-zA-Z0-9]/', '', $mime_type);
+                        if ( false === strpos($mime_pattern, '*') )
+                                $mime_pattern .= '/*';
+                }
+
+                $mime_pattern = preg_replace('/\*+/', '%', $mime_pattern);
+
+                if ( in_array( $mime_type, $wildcards ) )
+                        return '';
+
+                if ( false !== strpos($mime_pattern, '%') )
+                        $wheres[] = "post_mime_type LIKE '$mime_pattern'";
+                else
+                        $wheres[] = "post_mime_type = '$mime_pattern'";
+        }
+        if ( !empty($wheres) )
+                $where = ' AND (' . join(' OR ', $wheres) . ') ';
+        return $where;
+}
+
+/**
  * wp_delete_post() - Deletes a Post
  *