prefix."product_categories` WHERE `active`='1' AND `category_parent` = '".$id."' ORDER BY `id`"; $subcategories = $wpdb->get_results($subcategory_sql,ARRAY_A); if($subcategories != null) { $output .= "

".stripslashes($subcategory['name'])."".display_subcategories($subcategory['id'])."

"; } else { return ''; } return $output; } function show_cats_brands($category_group = null , $display_method = null, $order_by = 'name', $image = null) { global $wpdb; if($category_group == null) { $category_group = $wpdb->get_var("SELECT `id` FROM `".$wpdb->prefix."wpsc_categorisation_groups` WHERE `active` IN ('1') AND `default` IN ('1') LIMIT 1 "); } else { $category_group = (int)$category_group; } // Show cats & brands list if displaying on every page or if on a shop page (bit hacky but out of time). if (get_option('cat_brand_loc') != 3 && !function_exists("nzshpcrt_display_categories_groups") && ($display_method != 'sidebar')) { return; } if(get_option('permalink_structure') != '') { $seperator ="?"; } else { $seperator ="&"; } $output = "

"; switch(get_option('show_categorybrands')) { case 1: $output .= "

".TXT_WPSC_CATEGORIES." | ".TXT_WPSC_BRANDS."

"; break; } $output .= "

"; $output .= "

"; if((get_option('show_categorybrands') == 1 ) || (get_option('show_categorybrands') == 2)) { $output .= "

"; $categories = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `group_id` IN ('$category_group') AND `active`='1' AND `category_parent` = '0' ORDER BY `".$wpdb->escape($order_by)."` ASC",ARRAY_A); if($categories != null) { $output .= "

".stripslashes($option['name']).$addCount.""; }else{ // Adrian - otherwise create normal category text with or without product count if (!$image) { $output .= "
".stripslashes($option['name']).$addCount.""; } else { $output .= "
".stripslashes($option['name']).$addCount.""; } }//end get_option $subcategory_sql = "SELECT * FROM `".$wpdb->prefix."product_categories` WHERE `group_id` IN ('$category_group') AND `active`='1' AND `category_parent` = '".$option['id']."' ORDER BY `id`"; $subcategories = $wpdb->get_results($subcategory_sql,ARRAY_A); if($subcategories != null) { $output .= display_subcategories($option['id']); } else { // Adrian - check if the user wants categories only or sliding categories if (get_option('permalink_structure')!=''){ $uri = $_SERVER['REQUEST_URI']; $category = explode('/',$uri); $count = count($category); $category_nice_name = $category[$count-2]; $category_nice_name2 = $wpdb->get_var("SELECT `nice-name` FROM {$wpdb->prefix}product_categories WHERE id='{$option['id']}'"); if ($category_nice_name == $category_nice_name2) { $list_product=true; } else { $list_product=false; } } if ((get_option('catsprods_display_type') == 1) && (($option['id'] == $_GET['category']) || $list_product) ){ // Adrian - display all products for that category $product_sql = "SELECT product_id FROM `".$wpdb->prefix."item_category_associations` WHERE `category_id` = '".$option['id']."'"; $productIDs = $wpdb->get_results($product_sql,ARRAY_A); if($productIDs != null){ $output .= "
- ".$productName[0]['name']."
"; }//end if productsIDs }//end if get_option }//end else $output .= "

"; } $output .= "

"; } if((get_option('show_categorybrands') == 1 ) || (get_option('show_categorybrands') == 3)) { if(get_option('show_categorybrands') == 1) { $output .= "

"; echo $output; } function wpsc_category_url($category_id) { global $wpdb, $wp_rewrite; $category_data = $wpdb->get_row("SELECT `nice-name`,`category_parent` FROM `".$wpdb->prefix."product_categories` WHERE `id` IN ('".(int)$category_id."') AND `active` IN('1') LIMIT 1", ARRAY_A); $category_name[] = $category_data['nice-name']; if($category_data['category_parent'] > 0) { $num = 0; while($category_data['category_parent'] > 0) { $category_data = $wpdb->get_row("SELECT `nice-name`,`category_parent` FROM `".$wpdb->prefix."product_categories` WHERE `id` IN ('".(int)$category_data['category_parent']."') AND `active` IN('1') LIMIT 1", ARRAY_A); $category_name[] = $category_data['nice-name']; if($num > 10) { break; } $num++; } } $category_name = array_reverse($category_name); if((($wp_rewrite->rules != null) && ($wp_rewrite != null)) || (get_option('rewrite_rules') != null)) { $url_name = get_product_meta($product_id, 'url_name', true); if(!empty($category_name)) { if(substr(get_option('product_list_url'), -1, 1) == '/') { $category_url = get_option('product_list_url').implode($category_name,"/")."/"; } else { $category_url = get_option('product_list_url')."/".implode($category_name,"/")."/"; } } else { $category_url = get_option('product_list_url'); } } else { $category_url = get_option('product_list_url')."&category=".$category_id; } return $category_url; } function wpsc_category_description($category_id = null) { global $wpdb, $wp_query; /* */ if($category_id == null) { if($wp_query->query_vars['product_category'] != null) { $category_id = $wp_query->query_vars['product_category']; } else if(is_numeric($_GET['category'])) { $category_id = $_GET['category']; } } $category_description = "

"; $category_description .= $wpdb->get_var("SELECT `description` FROM `".$wpdb->prefix."product_categories` WHERE `id` IN ('".(int)$category_id."') AND `active` IN('1') LIMIT 1"); $category_description .= "

"; return $category_description; } ?>