Changeset 2139 for trunk/bb-includes/class.bb-taxonomy.php

Timestamp:

06/10/2009 08:09:35 AM (17 years ago)

Author:

sambauers

Message:

Update bb-taxonomy based on last sync of wp-taxonomy.

File:

• trunk/bb-includes/class.bb-taxonomy.php (modified) (11 diffs)

trunk/bb-includes/class.bb-taxonomy.php

@@ -66 +66 @@
                 $terms = "'" . implode("', '", $terms) . "'";
 
-                $sql = "SELECT tr.object_id FROM {$this->db->term_relationships} AS tr INNER JOIN {$this->db->term_taxonomy} AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ($taxonomies) AND tt.term_taxonomy_id IN ($terms)";
+                $sql = "SELECT tr.object_id FROM {$this->db->term_relationships} AS tr INNER JOIN {$this->db->term_taxonomy} AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ($taxonomies) AND $field IN ($terms)";
                 if ( $user_id )
                         $sql .= " AND tr.user_id = '$user_id'";
@@ -80 +80 @@
 
         /**
-         * Will unlink the term from the taxonomy
+         * Will unlink the term from the taxonomy.
          *
          * Will remove the term's relationship to the taxonomy, not the term or taxonomy
@@ -92 +92 @@
          * @param int $object_id The term Object Id that refers to the term
          * @param string|array $taxonomy List of Taxonomy Names or single Taxonomy name.
+         * @param int $user_id The ID of the user who created the relationship.
          */
         function delete_object_term_relationships( $object_id, $taxonomies, $user_id = 0 ) {
@@ -163 +164 @@
                         foreach ( $taxonomies as $index => $taxonomy ) {
                                 $t = $this->get_taxonomy($taxonomy);
-                                if ( is_array($t->args) && $args != array_merge($args, $t->args) ) {
+                                if ( isset($t->args) && is_array($t->args) && $args != array_merge($args, $t->args) ) {
                                         unset($taxonomies[$index]);
                                         $terms = array_merge($terms, $this->get_object_terms($object_ids, $taxonomy, array_merge($args, $t->args)));
@@ -187 +188 @@
                 else if ( 'term_order' == $orderby )
                         $orderby = 'tr.term_order';
-                else
+                else if ( 'none' == $orderby ) {
+                        $orderby = '';
+                        $order = '';
+                } else {
                         $orderby = 't.term_id';
+                }
+
+                // tt_ids queries can only be none or tr.term_taxonomy_id
+                if ( ('tt_ids' == $fields) && !empty($orderby) )
+                        $orderby = 'tr.term_taxonomy_id';
+
+                if ( !empty($orderby) )
+                        $orderby = "ORDER BY $orderby";
 
                 $taxonomies = "'" . implode("', '", $taxonomies) . "'";
@@ -206 +218 @@
                 if ( $user_id )
                         $query .= " AND user_id = '$user_id'";
-                $query .= " ORDER BY $orderby $order";
+                $query .= " $orderby $order";
 
                 if ( 'all' == $fields || 'all_with_object_id' == $fields ) {
@@ -217 +229 @@
                         if ( $user_id )
                                 $query .= " AND tr.user_id = '$user_id'";
-                        $query .= " ORDER BY tr.term_taxonomy_id $order";
+                        $query .= " $orderby $order";
                         $terms = $this->db->get_col( $query );
                 }
 
                 if ( ! $terms )
-                        return array();
-
-                return $terms;
+                        $terms = array();
+
+                return apply_filters('wp_get_object_terms', $terms, $object_ids, $taxonomies, $args);
         }
 
@@ -243 +255 @@
          *
          * @param int $object_id The object to relate to.
-         * @param array|int|string $term The slug or id of the term.
+         * @param array|int|string $term The slug or id of the term, will replace all existing
+         * related terms in this taxonomy.
          * @param array|string $taxonomy The context in which to relate the term to the object.
          * @param bool $append If false will delete difference of terms.
@@ -266 +279 @@
 
                 if ( ! $append )
-                        $old_terms =  $this->get_object_terms($object_id, $taxonomy, array( 'user_id' => $user_id, 'fields' => 'tt_ids' ));
+                        $old_tt_ids = $this->get_object_terms($object_id, $taxonomy, array('user_id' => $user_id, 'fields' => 'tt_ids', 'orderby' => 'none'));
 
                 $tt_ids = array();
@@ -291 +304 @@
 
                 if ( ! $append ) {
-                        $delete_terms = array_diff($old_terms, $tt_ids);
+                        $delete_terms = array_diff($old_tt_ids, $tt_ids);
                         if ( $delete_terms ) {
                                 $in_delete_terms = "'" . implode("', '", $delete_terms) . "'";
@@ -303 +316 @@
                         $values = array();
                         $term_order = 0;
-                        $final_term_ids = $this->get_object_terms($object_id, $taxonomy, array( 'user_id' => $user_id, 'fields' => 'tt_ids' ));
-                        foreach ( $term_ids as $term_id )
-                                if ( in_array($term_id, $final_term_ids) )
-                                        $values[] = $this->db->prepare( "(%d, %d, %d, %d)", $object_id, $term_id, $user_id, ++$term_order);
+                        $final_tt_ids = $this->get_object_terms($object_id, $taxonomy, array( 'user_id' => $user_id, 'fields' => 'tt_ids' ));
+                        foreach ( $tt_ids as $tt_id )
+                                if ( in_array($tt_id, $final_tt_ids) )
+                                        $values[] = $this->db->prepare( "(%d, %d, %d, %d)", $object_id, $tt_id, $user_id, ++$term_order);
                         if ( $values )
                                 $this->db->query("INSERT INTO {$this->db->term_relationships} (object_id, term_taxonomy_id, user_id, term_order) VALUES " . join(',', $values) . " ON DUPLICATE KEY UPDATE term_order = VALUES(term_order)");
                 }
 
+                do_action('set_object_terms', $object_id, $terms, $tt_ids, $taxonomy, $append);
                 return $tt_ids;
         }