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

Timestamp:

07/19/2008 07:00:56 PM (16 years ago)

Author:

ryan

Message:

Revert accidental bits that snuck in with [8376]. see #7227

File:

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

trunk/wp-includes/taxonomy.php

@@ -762 +762 @@
     global $wpdb;
 
-    $select = "SELECT term_id FROM $wpdb->terms as t WHERE ";
-    $tax_select = "SELECT tt.term_id, tt.term_taxonomy_id FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy as tt ON tt.term_id = t.term_id WHERE ";
-
     if ( is_int($term) ) {
         if ( 0 == $term )
             return 0;
         $where = 't.term_id = %d';
-        if ( !empty($taxonomy) )
-            return $wpdb->get_row( $wpdb->prepare( $tax_select . $where . " AND tt.taxonomy = %s", $term, $taxonomy ), ARRAY_A );
-        else
-            return $wpdb->get_var( $wpdb->prepare( $select . $where, $term ) );
-    }
-
-    if ( '' === $slug = sanitize_title($term) )
-        return 0;
-
-    $where = 't.slug = %s';
-    $else_where = 't.name = %s';
-
-    if ( !empty($taxonomy) ) {
-        if ( $result = $wpdb->get_row( $wpdb->prepare("SELECT tt.term_id, tt.term_taxonomy_id FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy as tt ON tt.term_id = t.term_id WHERE $where AND tt.taxonomy = %s", $slug, $taxonomy), ARRAY_A) )
-            return $result;
-            
-        return $wpdb->get_row( $wpdb->prepare("SELECT tt.term_id, tt.term_taxonomy_id FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy as tt ON tt.term_id = t.term_id WHERE $else_where AND tt.taxonomy = %s", $term, $taxonomy), ARRAY_A);
-    }
-
-    if ( $result = $wpdb->get_var( $wpdb->prepare("SELECT term_id FROM $wpdb->terms as t WHERE $where", $slug) ) )
-        return $result;
-
-    return $wpdb->get_var( $wpdb->prepare("SELECT term_id FROM $wpdb->terms as t WHERE $else_where", $term) );
+    } else {
+        if ( '' === $term = sanitize_title($term) )
+            return 0;
+        $where = 't.slug = %s';
+    }
+
+    if ( !empty($taxonomy) )
+        return $wpdb->get_row( $wpdb->prepare("SELECT tt.term_id, tt.term_taxonomy_id FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy as tt ON tt.term_id = t.term_id WHERE $where AND tt.taxonomy = %s", $term, $taxonomy), ARRAY_A);
+
+    return $wpdb->get_var( $wpdb->prepare("SELECT term_id FROM $wpdb->terms as t WHERE $where", $term) );
 }