Context Navigation

← Previous Change
Next Change →

taxonomy.php

Timestamp:

04/10/2009 08:58:25 PM (17 years ago)

Author:

ryan

Message:

Add option to check if term exists with given parent. Update ajax add-cat check to pass parent when checking if cat exists.

File:

: 1 edited

trunk/wp-includes/taxonomy.php (modified) (2 diffs)

Legend:

: Unmodified
: Added
: Removed

trunk/wp-includes/taxonomy.php

-              r10813
+              r10905
  * @param int|string $term The term to check
  * @param string $taxonomy The taxonomy name to use
+ * @param int $parent ID of parent term under which to confine the exists search.
  * @return mixed Get the term id or Term Object, if exists.
  */
 function is_term($term, $taxonomy = '') {
+function is_term($term, $taxonomy = '', $parent = 0) {
         global $wpdb;
 …
         $where = 't.slug = %s';
         $else_where = 't.name = %s';
+        $where_fields = array($slug);
+        $else_where_fields = array($term);
         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) )
+                $parent = (int) $parent;
+                if ( $parent > 0 ) {
+                        $where_fields[] = $parent;
+                        $else_where_fields[] = $parent;
+                        $where .= ' AND tt.parent = %d';
+                        $else_where .= ' AND tt.parent = %d';
+                }
+                $where_fields[] = $taxonomy;
+                $else_where_fields[] = $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", $where_fields), 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 $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", $else_where_fields), ARRAY_A);
+        }
+        if ( $result = $wpdb->get_var( $wpdb->prepare("SELECT term_id FROM $wpdb->terms as t WHERE $where", $where_fields) ) )
                 return $result;
         return $wpdb->get_var( $wpdb->prepare("SELECT term_id FROM $wpdb->terms as t WHERE $else_where", $term) );
+        return $wpdb->get_var( $wpdb->prepare("SELECT term_id FROM $wpdb->terms as t WHERE $else_where", $else_where_fields) );
+}

Note: See TracChangeset for help on using the changeset viewer.

Context Navigation

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

Legend:

trunk/wp-includes/taxonomy.php

Download in other formats: