Changeset 5585

Timestamp:

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

Author:

ryan

Message:

get_objects_in_term()

Location:

trunk/wp-includes

Files:

• query.php (modified) (1 diff)
• taxonomy.php (modified) (1 diff)

trunk/wp-includes/query.php

@@ -860 +860 @@
                 $in_cats = " AND $wpdb->term_taxonomy.term_id IN ({$q['cat']}) ";
             if ( strlen($out_cats) > 0 ) {
-                // TODO
+                // TODO use get_objects_in_term
                 $ids = $wpdb->get_col("SELECT post_id FROM $wpdb->post2cat WHERE $wpdb->post2cat.category_id IN ($out_cats)");
                 if ( is_array($ids) && count($ids > 0) ) {

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;
 }