ID, 'closedpostboxes_products');
$variations_processor = new nzshpcrt_variations;
function category_and_tag_box($product_data=''){
global $closed_postboxes, $wpdb, $variations_processor;
$output = '';
if ($product_data == 'empty') {
$display = "style='visibility:hidden;'";
}
$output .= "
";
if (IS_WP27) {
$output .= "
";
} else {
$output .= "
+";
}
$output .= TXT_WPSC_CATEGORY_AND_TAG_CONTROL;
if ($product_data != '') {
if(function_exists('wp_insert_term')) {
$term_relationships = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."term_relationships WHERE object_id = ".$product_data['id'], ARRAY_A);
foreach ((array)$term_relationships as $term_relationship) {
$tt_ids[] = $term_relationship['term_taxonomy_id'];
}
foreach ((array)$tt_ids as $tt_id) {
$results = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."term_taxonomy WHERE term_taxonomy_id = ".$tt_id." AND taxonomy = 'product_tag'", ARRAY_A);
$term_ids[] = $results[0]['term_id'];
}
foreach ((array)$term_ids as $term_id ) {
if ($term_id != NULL){
$results = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."terms WHERE term_id=".$term_id." ",ARRAY_A);
$tags[] = $results[0]['name'];
}
}
if ($tags != NULL){
$imtags = implode(',', $tags);
}
}
}
$output .= "
";
$output .= "
".TXT_WPSC_CATEGORISATION.": ";
$categorisation_groups = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}wpsc_categorisation_groups` WHERE `active` IN ('1')", ARRAY_A);
foreach($categorisation_groups as $categorisation_group){
$category_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}product_categories` WHERE `group_id` IN ('{$categorisation_group['id']}')");
if($category_count > 0) {
$output .= "
";
foreach((array)$custom_fields as $custom_field) {
$i = $custom_field['id'];
// for editing, the container needs an id, I can find no other tidyish method of passing a way to target this object through an ajax request
$output .= "
![](".WPSC_URL."/images/download.gif)