Changeset 5585 for trunk/wp-includes/taxonomy.php

Timestamp:

05/29/2007 04:25:09 AM (19 years ago)

Author:

ryan

Message:

get_objects_in_term()

File:

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

trunk/wp-includes/taxonomy.php

@@ -365 +365 @@
 
         return $tt_ids;
+}
+
+function get_objects_in_term( $terms, $taxonomies, $args = array() ) {
+        global $wpdb;
+
+        if ( !is_array( $terms) )
+                $terms = array($terms);
+
+        if ( !is_array($taxonomies) )
+                $taxonomies = array($taxonomies);
+
+        $defaults = array('order' => 'ASC');
+        $args = wp_parse_args( $args, $defaults );
+        extract($args);
+
+        $taxonomies = "'" . implode("', '", $taxonomies) . "'";
+        $terms = "'" . implode("', '", $terms) . "'";
+
+        $object_ids = $wpdb->get_col("SELECT tr.object_id FROM $wpdb->term_relationships AS tr INNER JOIN $wpdb->term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ($taxonomies) AND tt.term_id IN ($in_terms) ORDER BY tr.object_id $order");
+
+        if ( ! $object_ids )
+                return array();
+
+        return $object_ids;
 }