Changeset 6851

Timestamp:

02/14/2008 05:17:57 PM (17 years ago)

Author:

ryan

Message:

Support ordering for term relationships. Props andy. fixes #5857

Location:

trunk

Files:

• wp-admin/includes/schema.php (modified) (1 diff)
• wp-includes/taxonomy.php (modified) (2 diffs)
• wp-includes/version.php (modified) (1 diff)

trunk/wp-admin/includes/schema.php

@@ -32 +32 @@
  object_id bigint(20) NOT NULL default 0,
  term_taxonomy_id bigint(20) NOT NULL default 0,
+ term_order int(11) NOT NULL default 0,
  PRIMARY KEY  (object_id,term_taxonomy_id),
  KEY term_taxonomy_id (term_taxonomy_id)

trunk/wp-includes/taxonomy.php

@@ -1034 +1034 @@
     else if ( 'term_group' == $orderby )
         $orderby = 't.term_group';
+    else if ( 'term_order' == $orderby )
+        $orderby = 'tr.term_order';
     else
         $orderby = 't.term_id';
@@ -1248 +1250 @@
             wp_update_term_count($delete_terms, $taxonomy);
         }
+    }
+
+    $t = get_taxonomy($taxonomy);
+    if ( ! $append && $t->sort ) {
+        $values = array();
+        $term_order = 0;
+        $final_term_ids = wp_get_object_terms($object_id, $taxonomy, 'fields=tt_ids');
+        foreach ( $term_ids as $term_id )
+            if ( in_array($term_id, $final_term_ids) )
+                $values[] = $wpdb->prepare( "(%d, %d, %d)", $object_id, $term_id, ++$term_order);
+        if ( $values )
+            $wpdb->query("INSERT INTO $wpdb->term_relationships (object_id, term_taxonomy_id, term_order) VALUES " . join(',', $values) . " ON DUPLICATE KEY UPDATE term_order = VALUES(term_order)");
     }
 

trunk/wp-includes/version.php

@@ -17 +17 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 6825;
+$wp_db_version = 6846;
 
 ?>