Hi Jack,
Ive gone through the whole thread and not seen this asked before so apologies if it has. With regards the related categories links, is it possible to exclude the current category? At the moment when on a subcategory all related categories including the one you are already on are returned. I would like to exclude the current category from the list if possible. I'm playing with the sql query in category_tree_no_products.php but nothing is working. Please could you help. The relevant code i need to tweak i think is this in category_tree_no_products.php:
<?php function osC_CategoryTree($catID = 0, $load_from_database = true) {
global $languages_id;
$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.categories_id = cd.categories_id where cd.language_id = '" . (int)$languages_id . "' order by c.parent_id, c.sort_order, cd.categories_name");
$this->data = array();
$this->root_category_id = $catID;
while ($categories = tep_db_fetch_array($categories_query)) {
$this->data[$categories['parent_id']][$categories['categories_id']] = array('name' => $categories['categories_name'], 'count' => 0);}
} //end class osC_CategoryTree
?>