1 <?php

     2 /**

     3  * Taxonomy API

     4  *

     5  * @package WordPress

     6  * @subpackage Taxonomy

     7  * @since 2.3.0

     8  */

     9 

    10 //

    11 // Taxonomy Registration

    12 //

    13 

    14 /**

    15  * Creates the initial taxonomies when 'init' action is fired.

    16  */

    17 function create_initial_taxonomies() {

    18 	register_taxonomy( 'category', 'post', array('hierarchical' => true, 'update_count_callback' => '_update_post_term_count', 'label' => __('Categories'), 'query_var' => false, 'rewrite' => false) ) ;

    19 	register_taxonomy( 'post_tag', 'post', array('hierarchical' => false, 'update_count_callback' => '_update_post_term_count', 'label' => __('Post Tags'), 'query_var' => false, 'rewrite' => false) ) ;

    20 	register_taxonomy( 'link_category', 'link', array('hierarchical' => false, 'label' => __('Categories'), 'query_var' => false, 'rewrite' => false) ) ;

    21 }

    22 add_action( 'init', 'create_initial_taxonomies', 0 ); // highest priority

    23 

    24 /**

    25  * Return all of the taxonomy names that are of $object_type.

    26  *

    27  * It appears that this function can be used to find all of the names inside of

    28  * $wp_taxonomies global variable.

    29  *

    30  * <code><?php $taxonomies = get_object_taxonomies('post'); ?></code> Should

    31  * result in <code>Array('category', 'post_tag')</code>

    32  *

    33  * @package WordPress

    34  * @subpackage Taxonomy

    35  * @since 2.3.0

    36  *

    37  * @uses $wp_taxonomies

    38  *

    39  * @param array|string|object $object Name of the type of taxonomy object, or an object (row from posts)

    40  * @return array The names of all taxonomy of $object_type.

    41  */

    42 function get_object_taxonomies($object) {

    43 	global $wp_taxonomies;

    44 

    45 	if ( is_object($object) ) {

    46 		if ( $object->post_type == 'attachment' )

    47 			return get_attachment_taxonomies($object);

    48 		$object = $object->post_type;

    49 	}

    50 

    51 	$object = (array) $object;

    52 

    53 	$taxonomies = array();

    54 	foreach ( (array) $wp_taxonomies as $taxonomy ) {

    55 		if ( array_intersect($object, (array) $taxonomy->object_type) )

    56 			$taxonomies[] = $taxonomy->name;

    57 	}

    58 

    59 	return $taxonomies;

    60 }

    61 

    62 /**

    63  * Retrieves the taxonomy object of $taxonomy.

    64  *

    65  * The get_taxonomy function will first check that the parameter string given

    66  * is a taxonomy object and if it is, it will return it.

    67  *

    68  * @package WordPress

    69  * @subpackage Taxonomy

    70  * @since 2.3.0

    71  *

    72  * @uses $wp_taxonomies

    73  * @uses is_taxonomy() Checks whether taxonomy exists

    74  *

    75  * @param string $taxonomy Name of taxonomy object to return

    76  * @return object|bool The Taxonomy Object or false if $taxonomy doesn't exist

    77  */

    78 function get_taxonomy( $taxonomy ) {

    79 	global $wp_taxonomies;

    80 

    81 	if ( ! is_taxonomy($taxonomy) )

    82 		return false;

    83 

    84 	return $wp_taxonomies[$taxonomy];

    85 }

    86 

    87 /**

    88  * Checks that the taxonomy name exists.

    89  *

    90  * @package WordPress

    91  * @subpackage Taxonomy

    92  * @since 2.3.0

    93  *

    94  * @uses $wp_taxonomies

    95  *

    96  * @param string $taxonomy Name of taxonomy object

    97  * @return bool Whether the taxonomy exists or not.

    98  */

    99 function is_taxonomy( $taxonomy ) {

   100 	global $wp_taxonomies;

   101 

   102 	return isset($wp_taxonomies[$taxonomy]);

   103 }

   104 

   105 /**

   106  * Whether the taxonomy object is hierarchical.

   107  *

   108  * Checks to make sure that the taxonomy is an object first. Then Gets the

   109  * object, and finally returns the hierarchical value in the object.

   110  *

   111  * A false return value might also mean that the taxonomy does not exist.

   112  *

   113  * @package WordPress

   114  * @subpackage Taxonomy

   115  * @since 2.3.0

   116  *

   117  * @uses is_taxonomy() Checks whether taxonomy exists

   118  * @uses get_taxonomy() Used to get the taxonomy object

   119  *

   120  * @param string $taxonomy Name of taxonomy object

   121  * @return bool Whether the taxonomy is hierarchical

   122  */

   123 function is_taxonomy_hierarchical($taxonomy) {

   124 	if ( ! is_taxonomy($taxonomy) )

   125 		return false;

   126 

   127 	$taxonomy = get_taxonomy($taxonomy);

   128 	return $taxonomy->hierarchical;

   129 }

   130 

   131 /**

   132  * Create or modify a taxonomy object. Do not use before init.

   133  *

   134  * A simple function for creating or modifying a taxonomy object based on the

   135  * parameters given. The function will accept an array (third optional

   136  * parameter), along with strings for the taxonomy name and another string for

   137  * the object type.

   138  *

   139  * Nothing is returned, so expect error maybe or use is_taxonomy() to check

   140  * whether taxonomy exists.

   141  *

   142  * Optional $args contents:

   143  *

   144  * hierarachical - has some defined purpose at other parts of the API and is a

   145  * boolean value.

   146  *

   147  * update_count_callback - works much like a hook, in that it will be called

   148  * when the count is updated.

   149  *

   150  * rewrite - false to prevent rewrite, or array('slug'=>$slug) to customize

   151  * permastruct; default will use $taxonomy as slug.

   152  *

   153  * query_var - false to prevent queries, or string to customize query var

   154  * (?$query_var=$term); default will use $taxonomy as query var.

   155  *

   156  * @package WordPress

   157  * @subpackage Taxonomy

   158  * @since 2.3.0

   159  * @uses $wp_taxonomies Inserts new taxonomy object into the list

   160  * @uses $wp_rewrite Adds rewrite tags and permastructs

   161  * @uses $wp Adds query vars

   162  *

   163  * @param string $taxonomy Name of taxonomy object

   164  * @param array|string $object_type Name of the object type for the taxonomy object.

   165  * @param array|string $args See above description for the two keys values.

   166  */

   167 function register_taxonomy( $taxonomy, $object_type, $args = array() ) {

   168 	global $wp_taxonomies, $wp_rewrite, $wp;

   169 

   170 	if (!is_array($wp_taxonomies))

   171 		$wp_taxonomies = array();

   172 

   173 	$defaults = array('hierarchical' => false, 'update_count_callback' => '', 'rewrite' => true, 'query_var' => true);

   174 	$args = wp_parse_args($args, $defaults);

   175 

   176 	if ( false !== $args['query_var'] && !empty($wp) ) {

   177 		if ( true === $args['query_var'] )

   178 			$args['query_var'] = $taxonomy;

   179 		$args['query_var'] = sanitize_title_with_dashes($args['query_var']);

   180 		$wp->add_query_var($args['query_var']);

   181 	}

   182 

   183 	if ( false !== $args['rewrite'] && !empty($wp_rewrite) ) {

   184 		if ( !is_array($args['rewrite']) )

   185 			$args['rewrite'] = array();

   186 		if ( !isset($args['rewrite']['slug']) )

   187 			$args['rewrite']['slug'] = sanitize_title_with_dashes($taxonomy);

   188 		$wp_rewrite->add_rewrite_tag("%$taxonomy%", '([^/]+)', $args['query_var'] ? "{$args['query_var']}=" : "taxonomy=$taxonomy&term=$term");

   189 		$wp_rewrite->add_permastruct($taxonomy, "{$args['rewrite']['slug']}/%$taxonomy%");

   190 	}

   191 

   192 	$args['name'] = $taxonomy;

   193 	$args['object_type'] = $object_type;

   194 	$wp_taxonomies[$taxonomy] = (object) $args;

   195 }

   196 

   197 //

   198 // Term API

   199 //

   200 

   201 /**

   202  * Retrieve object_ids of valid taxonomy and term.

   203  *

   204  * The strings of $taxonomies must exist before this function will continue. On

   205  * failure of finding a valid taxonomy, it will return an WP_Error class, kind

   206  * of like Exceptions in PHP 5, except you can't catch them. Even so, you can

   207  * still test for the WP_Error class and get the error message.

   208  *

   209  * The $terms aren't checked the same as $taxonomies, but still need to exist

   210  * for $object_ids to be returned.

   211  *

   212  * It is possible to change the order that object_ids is returned by either

   213  * using PHP sort family functions or using the database by using $args with

   214  * either ASC or DESC array. The value should be in the key named 'order'.

   215  *

   216  * @package WordPress

   217  * @subpackage Taxonomy

   218  * @since 2.3.0

   219  *

   220  * @uses $wpdb

   221  * @uses wp_parse_args() Creates an array from string $args.

   222  *

   223  * @param string|array $terms String of term or array of string values of terms that will be used

   224  * @param string|array $taxonomies String of taxonomy name or Array of string values of taxonomy names

   225  * @param array|string $args Change the order of the object_ids, either ASC or DESC

   226  * @return WP_Error|array If the taxonomy does not exist, then WP_Error will be returned. On success

   227  *	the array can be empty meaning that there are no $object_ids found or it will return the $object_ids found.

   228  */

   229 function get_objects_in_term( $terms, $taxonomies, $args = array() ) {

   230 	global $wpdb;

   231 

   232 	if ( !is_array( $terms) )

   233 		$terms = array($terms);

   234 

   235 	if ( !is_array($taxonomies) )

   236 		$taxonomies = array($taxonomies);

   237 

   238 	foreach ( (array) $taxonomies as $taxonomy ) {

   239 		if ( ! is_taxonomy($taxonomy) )

   240 			return new WP_Error('invalid_taxonomy', __('Invalid Taxonomy'));

   241 	}

   242 

   243 	$defaults = array('order' => 'ASC');

   244 	$args = wp_parse_args( $args, $defaults );

   245 	extract($args, EXTR_SKIP);

   246 

   247 	$order = ( 'desc' == strtolower($order) ) ? 'DESC' : 'ASC';

   248 

   249 	$terms = array_map('intval', $terms);

   250 

   251 	$taxonomies = "'" . implode("', '", $taxonomies) . "'";

   252 	$terms = "'" . implode("', '", $terms) . "'";

   253 

   254 	$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 ($terms) ORDER BY tr.object_id $order");

   255 

   256 	if ( ! $object_ids )

   257 		return array();

   258 

   259 	return $object_ids;

   260 }

   261 

   262 /**

   263  * Get all Term data from database by Term ID.

   264  *

   265  * The usage of the get_term function is to apply filters to a term object. It

   266  * is possible to get a term object from the database before applying the

   267  * filters.

   268  *

   269  * $term ID must be part of $taxonomy, to get from the database. Failure, might

   270  * be able to be captured by the hooks. Failure would be the same value as $wpdb

   271  * returns for the get_row method.

   272  *

   273  * There are two hooks, one is specifically for each term, named 'get_term', and

   274  * the second is for the taxonomy name, 'term_$taxonomy'. Both hooks gets the

   275  * term object, and the taxonomy name as parameters. Both hooks are expected to

   276  * return a Term object.

   277  *

   278  * 'get_term' hook - Takes two parameters the term Object and the taxonomy name.

   279  * Must return term object. Used in get_term() as a catch-all filter for every

   280  * $term.

   281  *

   282  * 'get_$taxonomy' hook - Takes two parameters the term Object and the taxonomy

   283  * name. Must return term object. $taxonomy will be the taxonomy name, so for

   284  * example, if 'category', it would be 'get_category' as the filter name. Useful

   285  * for custom taxonomies or plugging into default taxonomies.

   286  *

   287  * @package WordPress

   288  * @subpackage Taxonomy

   289  * @since 2.3.0

   290  *

   291  * @uses $wpdb

   292  * @uses sanitize_term() Cleanses the term based on $filter context before returning.

   293  * @see sanitize_term_field() The $context param lists the available values for get_term_by() $filter param.

   294  *

   295  * @param int|object $term If integer, will get from database. If object will apply filters and return $term.

   296  * @param string $taxonomy Taxonomy name that $term is part of.

   297  * @param string $output Constant OBJECT, ARRAY_A, or ARRAY_N

   298  * @param string $filter Optional, default is raw or no WordPress defined filter will applied.

   299  * @return mixed|null|WP_Error Term Row from database. Will return null if $term is empty. If taxonomy does not

   300  * exist then WP_Error will be returned.

   301  */

   302 function &get_term($term, $taxonomy, $output = OBJECT, $filter = 'raw') {

   303 	global $wpdb;

   304 

   305 	if ( empty($term) ) {

   306 		$error = new WP_Error('invalid_term', __('Empty Term'));

   307 		return $error;

   308 	}

   309 

   310 	if ( ! is_taxonomy($taxonomy) ) {

   311 		$error = new WP_Error('invalid_taxonomy', __('Invalid Taxonomy'));

   312 		return $error;

   313 	}

   314 

   315 	if ( is_object($term) && empty($term->filter) ) {

   316 		wp_cache_add($term->term_id, $term, $taxonomy);

   317 		$_term = $term;

   318 	} else {

   319 		if ( is_object($term) )

   320 			$term = $term->term_id;

   321 		$term = (int) $term;

   322 		if ( ! $_term = wp_cache_get($term, $taxonomy) ) {

   323 			$_term = $wpdb->get_row( $wpdb->prepare( "SELECT t.*, tt.* FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = %s AND t.term_id = %s LIMIT 1", $taxonomy, $term) );

   324 			wp_cache_add($term, $_term, $taxonomy);

   325 		}

   326 	}

   327 

   328 	$_term = apply_filters('get_term', $_term, $taxonomy);

   329 	$_term = apply_filters("get_$taxonomy", $_term, $taxonomy);

   330 	$_term = sanitize_term($_term, $taxonomy, $filter);

   331 

   332 	if ( $output == OBJECT ) {

   333 		return $_term;

   334 	} elseif ( $output == ARRAY_A ) {

   335 		$__term = get_object_vars($_term);

   336 		return $__term;

   337 	} elseif ( $output == ARRAY_N ) {

   338 		$__term = array_values(get_object_vars($_term));

   339 		return $__term;

   340 	} else {

   341 		return $_term;

   342 	}

   343 }

   344 

   345 /**

   346  * Get all Term data from database by Term field and data.

   347  *

   348  * Warning: $value is not escaped for 'name' $field. You must do it yourself, if

   349  * required.

   350  *

   351  * The default $field is 'id', therefore it is possible to also use null for

   352  * field, but not recommended that you do so.

   353  *

   354  * If $value does not exist, the return value will be false. If $taxonomy exists

   355  * and $field and $value combinations exist, the Term will be returned.

   356  *

   357  * @package WordPress

   358  * @subpackage Taxonomy

   359  * @since 2.3.0

   360  *

   361  * @uses $wpdb

   362  * @uses sanitize_term() Cleanses the term based on $filter context before returning.

   363  * @see sanitize_term_field() The $context param lists the available values for get_term_by() $filter param.

   364  *

   365  * @param string $field Either 'slug', 'name', or 'id'

   366  * @param string|int $value Search for this term value

   367  * @param string $taxonomy Taxonomy Name

   368  * @param string $output Constant OBJECT, ARRAY_A, or ARRAY_N

   369  * @param string $filter Optional, default is raw or no WordPress defined filter will applied.

   370  * @return mixed Term Row from database. Will return false if $taxonomy does not exist or $term was not found.

   371  */

   372 function get_term_by($field, $value, $taxonomy, $output = OBJECT, $filter = 'raw') {

   373 	global $wpdb;

   374 

   375 	if ( ! is_taxonomy($taxonomy) )

   376 		return false;

   377 

   378 	if ( 'slug' == $field ) {

   379 		$field = 't.slug';

   380 		$value = sanitize_title($value);

   381 		if ( empty($value) )

   382 			return false;

   383 	} else if ( 'name' == $field ) {

   384 		// Assume already escaped

   385 		$value = stripslashes($value);

   386 		$field = 't.name';

   387 	} else {

   388 		$field = 't.term_id';

   389 		$value = (int) $value;

   390 	}

   391 

   392 	$term = $wpdb->get_row( $wpdb->prepare( "SELECT t.*, tt.* FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = %s AND $field = %s LIMIT 1", $taxonomy, $value) );

   393 	if ( !$term )

   394 		return false;

   395 

   396 	wp_cache_add($term->term_id, $term, $taxonomy);

   397 

   398 	$term = sanitize_term($term, $taxonomy, $filter);

   399 

   400 	if ( $output == OBJECT ) {

   401 		return $term;

   402 	} elseif ( $output == ARRAY_A ) {

   403 		return get_object_vars($term);

   404 	} elseif ( $output == ARRAY_N ) {

   405 		return array_values(get_object_vars($term));

   406 	} else {

   407 		return $term;

   408 	}

   409 }

   410 

   411 /**

   412  * Merge all term children into a single array of their IDs.

   413  *

   414  * This recursive function will merge all of the children of $term into the same

   415  * array of term IDs. Only useful for taxonomies which are hierarchical.

   416  *

   417  * Will return an empty array if $term does not exist in $taxonomy.

   418  *

   419  * @package WordPress

   420  * @subpackage Taxonomy

   421  * @since 2.3.0

   422  *

   423  * @uses $wpdb

   424  * @uses _get_term_hierarchy()

   425  * @uses get_term_children() Used to get the children of both $taxonomy and the parent $term

   426  *

   427  * @param string $term ID of Term to get children

   428  * @param string $taxonomy Taxonomy Name

   429  * @return array|WP_Error List of Term Objects. WP_Error returned if $taxonomy does not exist

   430  */

   431 function get_term_children( $term_id, $taxonomy ) {

   432 	if ( ! is_taxonomy($taxonomy) )

   433 		return new WP_Error('invalid_taxonomy', __('Invalid Taxonomy'));

   434 

   435 	$term_id = intval( $term_id );

   436 

   437 	$terms = _get_term_hierarchy($taxonomy);

   438 

   439 	if ( ! isset($terms[$term_id]) )

   440 		return array();

   441 

   442 	$children = $terms[$term_id];

   443 

   444 	foreach ( (array) $terms[$term_id] as $child ) {

   445 		if ( isset($terms[$child]) )

   446 			$children = array_merge($children, get_term_children($child, $taxonomy));

   447 	}

   448 

   449 	return $children;

   450 }

   451 

   452 /**

   453  * Get sanitized Term field.

   454  *

   455  * Does checks for $term, based on the $taxonomy. The function is for contextual

   456  * reasons and for simplicity of usage. See sanitize_term_field() for more

   457  * information.

   458  *

   459  * @package WordPress

   460  * @subpackage Taxonomy

   461  * @since 2.3.0

   462  *

   463  * @uses sanitize_term_field() Passes the return value in sanitize_term_field on success.

   464  *

   465  * @param string $field Term field to fetch

   466  * @param int $term Term ID

   467  * @param string $taxonomy Taxonomy Name

   468  * @param string $context Optional, default is display. Look at sanitize_term_field() for available options.

   469  * @return mixed Will return an empty string if $term is not an object or if $field is not set in $term.

   470  */

   471 function get_term_field( $field, $term, $taxonomy, $context = 'display' ) {

   472 	$term = (int) $term;

   473 	$term = get_term( $term, $taxonomy );

   474 	if ( is_wp_error($term) )

   475 		return $term;

   476 

   477 	if ( !is_object($term) )

   478 		return '';

   479 

   480 	if ( !isset($term->$field) )

   481 		return '';

   482 

   483 	return sanitize_term_field($field, $term->$field, $term->term_id, $taxonomy, $context);

   484 }

   485 

   486 /**

   487  * Sanitizes Term for editing.

   488  *

   489  * Return value is sanitize_term() and usage is for sanitizing the term for

   490  * editing. Function is for contextual and simplicity.

   491  *

   492  * @package WordPress

   493  * @subpackage Taxonomy

   494  * @since 2.3.0

   495  *

   496  * @uses sanitize_term() Passes the return value on success

   497  *

   498  * @param int|object $id Term ID or Object

   499  * @param string $taxonomy Taxonomy Name

   500  * @return mixed|null|WP_Error Will return empty string if $term is not an object.

   501  */

   502 function get_term_to_edit( $id, $taxonomy ) {

   503 	$term = get_term( $id, $taxonomy );

   504 

   505 	if ( is_wp_error($term) )

   506 		return $term;

   507 

   508 	if ( !is_object($term) )

   509 		return '';

   510 

   511 	return sanitize_term($term, $taxonomy, 'edit');

   512 }

   513 

   514 /**

   515  * Retrieve the terms in a given taxonomy or list of taxonomies.

   516  *

   517  * You can fully inject any customizations to the query before it is sent, as

   518  * well as control the output with a filter.

   519  *

   520  * The 'get_terms' filter will be called when the cache has the term and will

   521  * pass the found term along with the array of $taxonomies and array of $args.

   522  * This filter is also called before the array of terms is passed and will pass

   523  * the array of terms, along with the $taxonomies and $args.

   524  *

   525  * The 'list_terms_exclusions' filter passes the compiled exclusions along with

   526  * the $args.

   527  *

   528  * The 'get_terms_orderby' filter passes the ORDER BY clause for the query

   529  * along with the $args array.

   530 

   531  * The 'get_terms_fields' filter passes the fields for the SELECT query

   532  * along with the $args array.

   533  *

   534  * The list of arguments that $args can contain, which will overwrite the defaults:

   535  *

   536  * orderby - Default is 'name'. Can be name, count, term_group, slug or nothing

   537  * (will use term_id), Passing a custom value other than these will cause it to

   538  * order based on the custom value.

   539  *

   540  * order - Default is ASC. Can use DESC.

   541  *

   542  * hide_empty - Default is true. Will not return empty terms, which means

   543  * terms whose count is 0 according to the given taxonomy.

   544  *

   545  * exclude - Default is an empty string.  A comma- or space-delimited string

   546  * of term ids to exclude from the return array.  If 'include' is non-empty,

   547  * 'exclude' is ignored.

   548  *

   549  * exclude_tree - A comma- or space-delimited string of term ids to exclude

   550  * from the return array, along with all of their descendant terms according to

   551  * the primary taxonomy.  If 'include' is non-empty, 'exclude_tree' is ignored.

   552  *

   553  * include - Default is an empty string.  A comma- or space-delimited string

   554  * of term ids to include in the return array.

   555  *

   556  * number - The maximum number of terms to return.  Default is empty.

   557  *

   558  * offset - The number by which to offset the terms query.

   559  *

   560  * fields - Default is 'all', which returns an array of term objects.

   561  * If 'fields' is 'ids' or 'names', returns an array of

   562  * integers or strings, respectively.

   563  *

   564  * slug - Returns terms whose "slug" matches this value. Default is empty string.

   565  *

   566  * hierarchical - Whether to include terms that have non-empty descendants

   567  * (even if 'hide_empty' is set to true).

   568  *

   569  * search - Returned terms' names will contain the value of 'search',

   570  * case-insensitive.  Default is an empty string.

   571  *

   572  * name__like - Returned terms' names will begin with the value of 'name__like',

   573  * case-insensitive. Default is empty string.

   574  *

   575  * The argument 'pad_counts', if set to true will include the quantity of a term's

   576  * children in the quantity of each term's "count" object variable.

   577  *

   578  * The 'get' argument, if set to 'all' instead of its default empty string,

   579  * returns terms regardless of ancestry or whether the terms are empty.

   580  *

   581  * The 'child_of' argument, when used, should be set to the integer of a term ID.  Its default

   582  * is 0.  If set to a non-zero value, all returned terms will be descendants

   583  * of that term according to the given taxonomy.  Hence 'child_of' is set to 0

   584  * if more than one taxonomy is passed in $taxonomies, because multiple taxonomies

   585  * make term ancestry ambiguous.

   586  *

   587  * The 'parent' argument, when used, should be set to the integer of a term ID.  Its default is

   588  * the empty string '', which has a different meaning from the integer 0.

   589  * If set to an integer value, all returned terms will have as an immediate

   590  * ancestor the term whose ID is specified by that integer according to the given taxonomy.

   591  * The 'parent' argument is different from 'child_of' in that a term X is considered a 'parent'

   592  * of term Y only if term X is the father of term Y, not its grandfather or great-grandfather, etc.

   593  *

   594  * @package WordPress

   595  * @subpackage Taxonomy

   596  * @since 2.3.0

   597  *

   598  * @uses $wpdb

   599  * @uses wp_parse_args() Merges the defaults with those defined by $args and allows for strings.

   600  *

   601  * @param string|array Taxonomy name or list of Taxonomy names

   602  * @param string|array $args The values of what to search for when returning terms

   603  * @return array|WP_Error List of Term Objects and their children. Will return WP_Error, if any of $taxonomies do not exist.

   604  */

   605 function &get_terms($taxonomies, $args = '') {

   606 	global $wpdb;

   607 	$empty_array = array();

   608 

   609 	$single_taxonomy = false;

   610 	if ( !is_array($taxonomies) ) {

   611 		$single_taxonomy = true;

   612 		$taxonomies = array($taxonomies);

   613 	}

   614 

   615 	foreach ( (array) $taxonomies as $taxonomy ) {

   616 		if ( ! is_taxonomy($taxonomy) ) {

   617 			$error = & new WP_Error('invalid_taxonomy', __('Invalid Taxonomy'));

   618 			return $error;

   619 		}

   620 	}

   621 

   622 	$in_taxonomies = "'" . implode("', '", $taxonomies) . "'";

   623 

   624 	$defaults = array('orderby' => 'name', 'order' => 'ASC',

   625 		'hide_empty' => true, 'exclude' => '', 'exclude_tree' => '', 'include' => '',

   626 		'number' => '', 'fields' => 'all', 'slug' => '', 'parent' => '',

   627 		'hierarchical' => true, 'child_of' => 0, 'get' => '', 'name__like' => '',

   628 		'pad_counts' => false, 'offset' => '', 'search' => '');

   629 	$args = wp_parse_args( $args, $defaults );

   630 	$args['number'] = absint( $args['number'] );

   631 	$args['offset'] = absint( $args['offset'] );

   632 	if ( !$single_taxonomy || !is_taxonomy_hierarchical($taxonomies[0]) ||

   633 		'' !== $args['parent'] ) {

   634 		$args['child_of'] = 0;

   635 		$args['hierarchical'] = false;

   636 		$args['pad_counts'] = false;

   637 	}

   638 

   639 	if ( 'all' == $args['get'] ) {

   640 		$args['child_of'] = 0;

   641 		$args['hide_empty'] = 0;

   642 		$args['hierarchical'] = false;

   643 		$args['pad_counts'] = false;

   644 	}

   645 	extract($args, EXTR_SKIP);

   646 

   647 	if ( $child_of ) {

   648 		$hierarchy = _get_term_hierarchy($taxonomies[0]);

   649 		if ( !isset($hierarchy[$child_of]) )

   650 			return $empty_array;

   651 	}

   652 

   653 	if ( $parent ) {

   654 		$hierarchy = _get_term_hierarchy($taxonomies[0]);

   655 		if ( !isset($hierarchy[$parent]) )

   656 			return $empty_array;

   657 	}

   658 

   659 	// $args can be whatever, only use the args defined in defaults to compute the key

   660 	$filter_key = ( has_filter('list_terms_exclusions') ) ? serialize($GLOBALS['wp_filter']['list_terms_exclusions']) : '';

   661 	$key = md5( serialize( compact(array_keys($defaults)) ) . serialize( $taxonomies ) . $filter_key );

   662 	$last_changed = wp_cache_get('last_changed', 'terms');

   663 	if ( !$last_changed ) {

   664 		$last_changed = time();

   665 		wp_cache_set('last_changed', $last_changed, 'terms');

   666 	}

   667 	$cache_key = "get_terms:$key:$last_changed";

   668 	$cache = wp_cache_get( $cache_key, 'terms' );

   669 	if ( false !== $cache ) {

   670 		$cache = apply_filters('get_terms', $cache, $taxonomies, $args);

   671 		return $cache;

   672 	}

   673 

   674 	$_orderby = strtolower($orderby);

   675 	if ( 'count' == $_orderby )

   676 		$orderby = 'tt.count';

   677 	else if ( 'name' == $_orderby )

   678 		$orderby = 't.name';

   679 	else if ( 'slug' == $_orderby )

   680 		$orderby = 't.slug';

   681 	else if ( 'term_group' == $_orderby )

   682 		$orderby = 't.term_group';

   683 	elseif ( empty($_orderby) || 'id' == $_orderby )

   684 		$orderby = 't.term_id';

   685 

   686 	$orderby = apply_filters( 'get_terms_orderby', $orderby, $args );

   687 

   688 	$where = '';

   689 	$inclusions = '';

   690 	if ( !empty($include) ) {

   691 		$exclude = '';

   692 		$exclude_tree = '';

   693 		$interms = preg_split('/[\s,]+/',$include);

   694 		if ( count($interms) ) {

   695 			foreach ( (array) $interms as $interm ) {

   696 				if (empty($inclusions))

   697 					$inclusions = ' AND ( t.term_id = ' . intval($interm) . ' ';

   698 				else

   699 					$inclusions .= ' OR t.term_id = ' . intval($interm) . ' ';

   700 			}

   701 		}

   702 	}

   703 

   704 	if ( !empty($inclusions) )

   705 		$inclusions .= ')';

   706 	$where .= $inclusions;

   707 

   708 	$exclusions = '';

   709 	if ( ! empty( $exclude_tree ) ) {

   710 		$excluded_trunks = preg_split('/[\s,]+/',$exclude_tree);

   711 		foreach( (array) $excluded_trunks as $extrunk ) {

   712 			$excluded_children = (array) get_terms($taxonomies[0], array('child_of' => intval($extrunk), 'fields' => 'ids'));

   713 			$excluded_children[] = $extrunk;

   714 			foreach( (array) $excluded_children as $exterm ) {

   715 				if ( empty($exclusions) )

   716 					$exclusions = ' AND ( t.term_id <> ' . intval($exterm) . ' ';

   717 				else

   718 					$exclusions .= ' AND t.term_id <> ' . intval($exterm) . ' ';

   719 

   720 			}

   721 		}

   722 	}

   723 	if ( !empty($exclude) ) {

   724 		$exterms = preg_split('/[\s,]+/',$exclude);

   725 		if ( count($exterms) ) {

   726 			foreach ( (array) $exterms as $exterm ) {

   727 				if ( empty($exclusions) )

   728 					$exclusions = ' AND ( t.term_id <> ' . intval($exterm) . ' ';

   729 				else

   730 					$exclusions .= ' AND t.term_id <> ' . intval($exterm) . ' ';

   731 			}

   732 		}

   733 	}

   734 

   735 	if ( !empty($exclusions) )

   736 		$exclusions .= ')';

   737 	$exclusions = apply_filters('list_terms_exclusions', $exclusions, $args );

   738 	$where .= $exclusions;

   739 

   740 	if ( !empty($slug) ) {

   741 		$slug = sanitize_title($slug);

   742 		$where .= " AND t.slug = '$slug'";

   743 	}

   744 

   745 	if ( !empty($name__like) )

   746 		$where .= " AND t.name LIKE '{$name__like}%'";

   747 

   748 	if ( '' !== $parent ) {

   749 		$parent = (int) $parent;

   750 		$where .= " AND tt.parent = '$parent'";

   751 	}

   752 

   753 	if ( $hide_empty && !$hierarchical )

   754 		$where .= ' AND tt.count > 0';

   755 

   756 	// don't limit the query results when we have to descend the family tree

   757 	if ( ! empty($number) && ! $hierarchical && empty( $child_of ) && '' === $parent ) {

   758 		if( $offset )

   759 			$limit = 'LIMIT ' . $offset . ',' . $number;

   760 		else

   761 			$limit = 'LIMIT ' . $number;

   762 

   763 	} else

   764 		$limit = '';

   765 

   766 	if ( !empty($search) ) {

   767 		$search = like_escape($search);

   768 		$where .= " AND (t.name LIKE '%$search%')";

   769 	}

   770 

   771 	$selects = array();

   772 	if ( 'all' == $fields )

   773 		$selects = array('t.*', 'tt.*');

   774 	else if ( 'ids' == $fields )

   775 		$selects = array('t.term_id', 'tt.parent', 'tt.count');

   776 	else if ( 'names' == $fields )

   777 		$selects = array('t.term_id', 'tt.parent', 'tt.count', 't.name');

   778         $select_this = implode(', ', apply_filters( 'get_terms_fields', $selects, $args ));

   779 

   780 	$query = "SELECT $select_this FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ($in_taxonomies) $where ORDER BY $orderby $order $limit";

   781 

   782 	$terms = $wpdb->get_results($query);

   783 	if ( 'all' == $fields ) {

   784 		update_term_cache($terms);

   785 	}

   786 

   787 	if ( empty($terms) ) {

   788 		wp_cache_add( $cache_key, array(), 'terms' );

   789 		$terms = apply_filters('get_terms', array(), $taxonomies, $args);

   790 		return $terms;

   791 	}

   792 

   793 	if ( $child_of ) {

   794 		$children = _get_term_hierarchy($taxonomies[0]);

   795 		if ( ! empty($children) )

   796 			$terms = & _get_term_children($child_of, $terms, $taxonomies[0]);

   797 	}

   798 

   799 	// Update term counts to include children.

   800 	if ( $pad_counts && 'all' == $fields )

   801 		_pad_term_counts($terms, $taxonomies[0]);

   802 

   803 	// Make sure we show empty categories that have children.

   804 	if ( $hierarchical && $hide_empty && is_array($terms) ) {

   805 		foreach ( $terms as $k => $term ) {

   806 			if ( ! $term->count ) {

   807 				$children = _get_term_children($term->term_id, $terms, $taxonomies[0]);

   808 				if( is_array($children) )

   809 					foreach ( $children as $child )

   810 						if ( $child->count )

   811 							continue 2;

   812 

   813 				// It really is empty

   814 				unset($terms[$k]);

   815 			}

   816 		}

   817 	}

   818 	reset ( $terms );

   819 

   820 	$_terms = array();

   821 	if ( 'ids' == $fields ) {

   822 		while ( $term = array_shift($terms) )

   823 			$_terms[] = $term->term_id;

   824 		$terms = $_terms;

   825 	} elseif ( 'names' == $fields ) {

   826 		while ( $term = array_shift($terms) )

   827 			$_terms[] = $term->name;

   828 		$terms = $_terms;

   829 	}

   830 

   831 	if ( 0 < $number && intval(@count($terms)) > $number ) {

   832 		$terms = array_slice($terms, $offset, $number);

   833 	}

   834 

   835 	wp_cache_add( $cache_key, $terms, 'terms' );

   836 

   837 	$terms = apply_filters('get_terms', $terms, $taxonomies, $args);

   838 	return $terms;

   839 }

   840 

   841 /**

   842  * Check if Term exists.

   843  *

   844  * Returns the index of a defined term, or 0 (false) if the term doesn't exist.

   845  *

   846  * @package WordPress

   847  * @subpackage Taxonomy

   848  * @since 2.3.0

   849  *

   850  * @uses $wpdb

   851  *

   852  * @param int|string $term The term to check

   853  * @param string $taxonomy The taxonomy name to use

   854  * @param int $parent ID of parent term under which to confine the exists search.

   855  * @return mixed Get the term id or Term Object, if exists.

   856  */

   857 function is_term($term, $taxonomy = '', $parent = 0) {

   858 	global $wpdb;

   859 

   860 	$select = "SELECT term_id FROM $wpdb->terms as t WHERE ";

   861 	$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 ";

   862 

   863 	if ( is_int($term) ) {

   864 		if ( 0 == $term )

   865 			return 0;

   866 		$where = 't.term_id = %d';

   867 		if ( !empty($taxonomy) )

   868 			return $wpdb->get_row( $wpdb->prepare( $tax_select . $where . " AND tt.taxonomy = %s", $term, $taxonomy ), ARRAY_A );

   869 		else

   870 			return $wpdb->get_var( $wpdb->prepare( $select . $where, $term ) );

   871 	}

   872 

   873 	$term = trim( stripslashes( $term ) );

   874 

   875 	if ( '' === $slug = sanitize_title($term) )

   876 		return 0;

   877 

   878 	$where = 't.slug = %s';

   879 	$else_where = 't.name = %s';

   880 	$where_fields = array($slug);

   881 	$else_where_fields = array($term);

   882 	if ( !empty($taxonomy) ) {

   883 		$parent = (int) $parent;

   884 		if ( $parent > 0 ) {

   885 			$where_fields[] = $parent;

   886 			$else_where_fields[] = $parent;

   887 			$where .= ' AND tt.parent = %d';

   888 			$else_where .= ' AND tt.parent = %d';

   889 		}

   890 

   891 		$where_fields[] = $taxonomy;

   892 		$else_where_fields[] = $taxonomy;

   893 

   894 		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) )

   895 			return $result;

   896 

   897 		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);

   898 	}

   899 

   900 	if ( $result = $wpdb->get_var( $wpdb->prepare("SELECT term_id FROM $wpdb->terms as t WHERE $where", $where_fields) ) )

   901 		return $result;

   902 

   903 	return $wpdb->get_var( $wpdb->prepare("SELECT term_id FROM $wpdb->terms as t WHERE $else_where", $else_where_fields) );

   904 }

   905 

   906 /**

   907  * Sanitize Term all fields.

   908  *

   909  * Relys on sanitize_term_field() to sanitize the term. The difference is that

   910  * this function will sanitize <strong>all</strong> fields. The context is based

   911  * on sanitize_term_field().

   912  *

   913  * The $term is expected to be either an array or an object.

   914  *

   915  * @package WordPress

   916  * @subpackage Taxonomy

   917  * @since 2.3.0

   918  *

   919  * @uses sanitize_term_field Used to sanitize all fields in a term

   920  *

   921  * @param array|object $term The term to check

   922  * @param string $taxonomy The taxonomy name to use

   923  * @param string $context Default is 'display'.

   924  * @return array|object Term with all fields sanitized

   925  */

   926 function sanitize_term($term, $taxonomy, $context = 'display') {

   927 

   928 	if ( 'raw' == $context )

   929 		return $term;

   930 

   931 	$fields = array('term_id', 'name', 'description', 'slug', 'count', 'parent', 'term_group');

   932 

   933 	$do_object = false;

   934 	if ( is_object($term) )

   935 		$do_object = true;

   936 

   937 	$term_id = $do_object ? $term->term_id : (isset($term['term_id']) ? $term['term_id'] : 0);

   938 

   939 	foreach ( (array) $fields as $field ) {

   940 		if ( $do_object ) {

   941 			if ( isset($term->$field) )

   942 				$term->$field = sanitize_term_field($field, $term->$field, $term_id, $taxonomy, $context);

   943 		} else {

   944 			if ( isset($term[$field]) )

   945 				$term[$field] = sanitize_term_field($field, $term[$field], $term_id, $taxonomy, $context);

   946 		}

   947 	}

   948 

   949 	if ( $do_object )

   950 		$term->filter = $context;

   951 	else

   952 		$term['filter'] = $context;

   953 

   954 	return $term;

   955 }

   956 

   957 /**

   958  * Cleanse the field value in the term based on the context.

   959  *

   960  * Passing a term field value through the function should be assumed to have

   961  * cleansed the value for whatever context the term field is going to be used.

   962  *

   963  * If no context or an unsupported context is given, then default filters will

   964  * be applied.

   965  *

   966  * There are enough filters for each context to support a custom filtering

   967  * without creating your own filter function. Simply create a function that

   968  * hooks into the filter you need.

   969  *

   970  * @package WordPress

   971  * @subpackage Taxonomy

   972  * @since 2.3.0

   973  *

   974  * @uses $wpdb

   975  *

   976  * @param string $field Term field to sanitize

   977  * @param string $value Search for this term value

   978  * @param int $term_id Term ID

   979  * @param string $taxonomy Taxonomy Name

   980  * @param string $context Either edit, db, display, attribute, or js.

   981  * @return mixed sanitized field

   982  */

   983 function sanitize_term_field($field, $value, $term_id, $taxonomy, $context) {

   984 	if ( 'parent' == $field  || 'term_id' == $field || 'count' == $field || 'term_group' == $field ) {

   985 		$value = (int) $value;

   986 		if ( $value < 0 )

   987 			$value = 0;

   988 	}

   989 

   990 	if ( 'raw' == $context )

   991 		return $value;

   992 

   993 	if ( 'edit' == $context ) {

   994 		$value = apply_filters("edit_term_$field", $value, $term_id, $taxonomy);

   995 		$value = apply_filters("edit_${taxonomy}_$field", $value, $term_id);

   996 		if ( 'description' == $field )

   997 			$value = format_to_edit($value);

   998 		else

   999 			$value = esc_attr($value);

  1000 	} else if ( 'db' == $context ) {

  1001 		$value = apply_filters("pre_term_$field", $value, $taxonomy);

  1002 		$value = apply_filters("pre_${taxonomy}_$field", $value);

  1003 		// Back compat filters

  1004 		if ( 'slug' == $field )

  1005 			$value = apply_filters('pre_category_nicename', $value);

  1006 

  1007 	} else if ( 'rss' == $context ) {

  1008 		$value = apply_filters("term_${field}_rss", $value, $taxonomy);

  1009 		$value = apply_filters("${taxonomy}_${field}_rss", $value);

  1010 	} else {

  1011 		// Use display filters by default.

  1012 		$value = apply_filters("term_$field", $value, $term_id, $taxonomy, $context);

  1013 		$value = apply_filters("${taxonomy}_$field", $value, $term_id, $context);

  1014 	}

  1015 

  1016 	if ( 'attribute' == $context )

  1017 		$value = esc_attr($value);

  1018 	else if ( 'js' == $context )

  1019 		$value = esc_js($value);

  1020 

  1021 	return $value;

  1022 }

  1023 

  1024 /**

  1025  * Count how many terms are in Taxonomy.

  1026  *

  1027  * Default $args is 'ignore_empty' which can be <code>'ignore_empty=true'</code>

  1028  * or <code>array('ignore_empty' => true);</code>.

  1029  *

  1030  * @package WordPress

  1031  * @subpackage Taxonomy

  1032  * @since 2.3.0

  1033  *

  1034  * @uses $wpdb

  1035  * @uses wp_parse_args() Turns strings into arrays and merges defaults into an array.

  1036  *

  1037  * @param string $taxonomy Taxonomy name

  1038  * @param array|string $args Overwrite defaults

  1039  * @return int How many terms are in $taxonomy

  1040  */

  1041 function wp_count_terms( $taxonomy, $args = array() ) {

  1042 	global $wpdb;

  1043 

  1044 	$defaults = array('ignore_empty' => false);

  1045 	$args = wp_parse_args($args, $defaults);

  1046 	extract($args, EXTR_SKIP);

  1047 

  1048 	$where = '';

  1049 	if ( $ignore_empty )

  1050 		$where = 'AND count > 0';

  1051 

  1052 	return $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM $wpdb->term_taxonomy WHERE taxonomy = %s $where", $taxonomy) );

  1053 }

  1054 

  1055 /**

  1056  * Will unlink the term from the taxonomy.

  1057  *

  1058  * Will remove the term's relationship to the taxonomy, not the term or taxonomy

  1059  * itself. The term and taxonomy will still exist. Will require the term's

  1060  * object ID to perform the operation.

  1061  *

  1062  * @package WordPress

  1063  * @subpackage Taxonomy

  1064  * @since 2.3.0

  1065  * @uses $wpdb

  1066  *

  1067  * @param int $object_id The term Object Id that refers to the term

  1068  * @param string|array $taxonomy List of Taxonomy Names or single Taxonomy name.

  1069  */

  1070 function wp_delete_object_term_relationships( $object_id, $taxonomies ) {

  1071 	global $wpdb;

  1072 

  1073 	$object_id = (int) $object_id;

  1074 

  1075 	if ( !is_array($taxonomies) )

  1076 		$taxonomies = array($taxonomies);

  1077 

  1078 	foreach ( (array) $taxonomies as $taxonomy ) {

  1079 		$tt_ids = wp_get_object_terms($object_id, $taxonomy, 'fields=tt_ids');

  1080 		$in_tt_ids = "'" . implode("', '", $tt_ids) . "'";

  1081 		$wpdb->query( $wpdb->prepare("DELETE FROM $wpdb->term_relationships WHERE object_id = %d AND term_taxonomy_id IN ($in_tt_ids)", $object_id) );

  1082 		wp_update_term_count($tt_ids, $taxonomy);

  1083 	}

  1084 }

  1085 

  1086 /**

  1087  * Removes a term from the database.

  1088  *

  1089  * If the term is a parent of other terms, then the children will be updated to

  1090  * that term's parent.

  1091  *

  1092  * The $args 'default' will only override the terms found, if there is only one

  1093  * term found. Any other and the found terms are used.

  1094  *

  1095  * The $args 'force_default' will force the term supplied as default to be

  1096  * assigned even if the object was not going to be termless

  1097  * @package WordPress

  1098  * @subpackage Taxonomy

  1099  * @since 2.3.0

  1100  *

  1101  * @uses $wpdb

  1102  * @uses do_action() Calls both 'delete_term' and 'delete_$taxonomy' action

  1103  *	hooks, passing term object, term id. 'delete_term' gets an additional

  1104  *	parameter with the $taxonomy parameter.

  1105  *

  1106  * @param int $term Term ID

  1107  * @param string $taxonomy Taxonomy Name

  1108  * @param array|string $args Optional. Change 'default' term id and override found term ids.

  1109  * @return bool|WP_Error Returns false if not term; true if completes delete action.

  1110  */

  1111 function wp_delete_term( $term, $taxonomy, $args = array() ) {

  1112 	global $wpdb;

  1113 

  1114 	$term = (int) $term;

  1115 

  1116 	if ( ! $ids = is_term($term, $taxonomy) )

  1117 		return false;

  1118 	if ( is_wp_error( $ids ) )

  1119 		return $ids;

  1120 

  1121 	$tt_id = $ids['term_taxonomy_id'];

  1122 

  1123 	$defaults = array();

  1124 	$args = wp_parse_args($args, $defaults);

  1125 	extract($args, EXTR_SKIP);

  1126 

  1127 	if ( isset($default) ) {

  1128 		$default = (int) $default;

  1129 		if ( ! is_term($default, $taxonomy) )

  1130 			unset($default);

  1131 	}

  1132 

  1133 	// Update children to point to new parent

  1134 	if ( is_taxonomy_hierarchical($taxonomy) ) {

  1135 		$term_obj = get_term($term, $taxonomy);