[finestshops]

Hi,

Below is a small mod for showing all categories and subcategories on all pages. It's combined from several modes posted on this forum (most by funkydunk ).

- Cat A
--- Sub Cat 1
--- Sub Cat 2
--- Sub Cat 3
- Cat B
- Cat C
- Cat D

Example is here: http://earthbab.finestshops.com (v. 3.5.2 but should work in any version - just small changes in the categories.php are required for 3.4.*)

include/categories.php

<? 
/*****************************************************************************\ 
+-----------------------------------------------------------------------------+ 
| X-Cart                                                                      | 
| Copyright (c) 2001-2003 Ruslan R. Fazliev <rrf@rrf.ru>                      | 
| All rights reserved.                                                        | 
+-----------------------------------------------------------------------------+ 
| PLEASE READ  THE FULL TEXT OF SOFTWARE LICENSE AGREEMENT IN THE "COPYRIGHT" | 
| FILE PROVIDED WITH THIS DISTRIBUTION. THE AGREEMENT TEXT IS ALSO AVAILABLE  | 
| AT THE FOLLOWING URL: http://www.x-cart.com/license.php                     | 
|                                                                             | 
| THIS  AGREEMENT  EXPRESSES  THE  TERMS  AND CONDITIONS ON WHICH YOU MAY USE | 
| THIS SOFTWARE   PROGRAM   AND  ASSOCIATED  DOCUMENTATION   THAT  RUSLAN  R. | 
| FAZLIEV (hereinafter  referred to as "THE AUTHOR") IS FURNISHING  OR MAKING | 
| AVAILABLE TO YOU WITH  THIS  AGREEMENT  (COLLECTIVELY,  THE  "SOFTWARE").   | 
| PLEASE   REVIEW   THE  TERMS  AND   CONDITIONS  OF  THIS  LICENSE AGREEMENT | 
| CAREFULLY   BEFORE   INSTALLING   OR  USING  THE  SOFTWARE.  BY INSTALLING, | 
| COPYING   OR   OTHERWISE   USING   THE   SOFTWARE,  YOU  AND  YOUR  COMPANY | 
| (COLLECTIVELY,  "YOU")  ARE  ACCEPTING  AND AGREEING  TO  THE TERMS OF THIS | 
| LICENSE   AGREEMENT.   IF  YOU    ARE  NOT  WILLING   TO  BE  BOUND BY THIS | 
| AGREEMENT, DO  NOT INSTALL OR USE THE SOFTWARE.  VARIOUS   COPYRIGHTS   AND | 
| OTHER   INTELLECTUAL   PROPERTY   RIGHTS    PROTECT   THE   SOFTWARE.  THIS | 
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE | 
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.| 
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      | 
|                                                                             | 
| The Initial Developer of the Original Code is Ruslan R. Fazliev             | 
| Portions created by Ruslan R. Fazliev are Copyright (C) 2001-2003           | 
| Ruslan R. Fazliev. All Rights Reserved.                                     | 
+-----------------------------------------------------------------------------+ 
\*****************************************************************************/ 

# 
# $Id: categories.php,v 1.46.2.1 2003/06/02 11:57:44 svowl Exp $ 
# 

# 
# For users some categories may be disabled 
# 

if ($current_area == "C") { 
   $membership_condition = " AND ($sql_tbl[categories].membership='$user_account[membership]' OR $sql_tbl[categories].membership='') "; 
} else { 
   $membership_condition = ""; 
} 

// funkydunk modification 
// amended query to get the main cat and subcat for each record 
$categories_data = func_query("select $sql_tbl[categories].*, SUBSTRING_INDEX($sql_tbl[categories].category, '\/', -1) as category_name, SUBSTRING_INDEX($sql_tbl[categories].category, '\/', 1) as maincat, SUBSTRING_INDEX($sql_tbl[categories].category, '\/', 2) as subcat from $sql_tbl[categories] ".($current_area=="C"?"where $sql_tbl[categories].avail='Y' $membership_condition ":"")." group by $sql_tbl[categories].categoryid order by ".($current_area=="C" ? "order_by" : "category")); 


# 
# Put all categories into $all_categories array and find current_category 
# by categoryid stored in $cat 
# 
if(!$categories_data) $categories_data = array(); 


foreach($categories_data as $k=>$category_data) { 

   if ($current_area == "C") { 
      $int_res = func_query_first("SELECT * FROM $sql_tbl[categories_lng] WHERE code='$store_language' AND categoryid='$category_data[categoryid]'"); 
      if ($int_res["category"]) 
         $categories_data[$k]["category_name"] = $category_data["category_name"] = $int_res["category"]; 
      if ($int_res["description"]) 
         $categories_data[$k]["description"] = $category_data["description"] = $int_res["description"]; 
   } 

   if ($category_data["categoryid"]==$cat) { 
      $current_category = $category_data; 
   } 
    
   // funkydunk code 
   if(strstr($category_data["category"],"/")) { 
      if ($category_data["category"] == $category_data["subcat"]){ 
      // echo "got one"; 
      // after taking off the initial category name this checks to see if this is only a sub category with no categories below it. 
      // if i didn't do this the subcategory would be duplicated in the list 
      $categories_data[$k]["subcatonly"]="true"; 
      } 
   } 
   // end of funkydunk amended code 


$all_categories = $categories_data; 
// func_print_r ($all_categories); 
} 

# 
# Put all root categories to $categories array 
# Put all subcategories of current_category to $categories array 
# 

foreach($all_categories as $all_category) { 

   $category=$all_category["category"]; 

   $cur_dir_len = strlen($current_category["category"]); 

   if(!strstr($category,"/")) { 
            $categories[]=$all_category; 
         if(empty($current_category)) { 
            $subcategories[]=$all_category; 
         } 

   } 

   if(substr($category,0,$cur_dir_len+1) == $current_category["category"]."/" and $category!=$current_category["category"]) 
      if(!strstr(substr($category,$cur_dir_len+1),"/")) { 
         $all_category["category"]=ereg_replace("^.*/","",$all_category["category"]); 
         $subcategories[]=$all_category; 
      } 

} 


# 
# Put  subcategory_count  to $subcategories array 
# 
if ($subcategories) 
foreach($subcategories as $key =>$subcategory) { 
    
   $subcategory["subcategory_count"]=0; 

   foreach($all_categories as $all_category) { 
      if ($all_category["categoryid"]==$subcategory["categoryid"]) {       
         $cur_dir_len = strlen($all_category["category"]); 
         $current_subcategory=$all_category["category"]; 
      }       
   } 
    
   foreach($all_categories as $all_category) { 
      $category=$all_category["category"]; 
      if(substr($category,0,$cur_dir_len+1) == $current_subcategory."/" and $category!=$current_subcategory) 
         if(!strstr(substr($category,$cur_dir_len+1),"/")) 
            $subcategory["subcategory_count"]++; 
   } 
   $subcategories[$key]["subcategory_count"]=$subcategory["subcategory_count"]; 
} 

# 
# Generate category sequence, i.e. 
# Books, Books/Poetry, Books/Poetry/Philosophy ... 
# 

$current_category_array = explode("/",$current_category["category"]); 
$prev = $current_category_array[0]; 
list($key,$val)=each($current_category_array); 

$new_array = array($val); 

while(list($key,$val)=each($current_category_array)) { 
   $new_array[] = $prev."/".$val; 
   $prev = $prev."/".$val; 
} 
unset($current_category_array); 

# 
# Generate array for displaying categories sequence in location 
# 

$category_location=array(); 
reset($all_categories); 

$my_cats = array (); 

foreach($all_categories as $all_category) { 

   $categoryid=$all_category["categoryid"]; 
   $category=$all_category["category"]; 

   $my_cats [$categoryid] = $category; 
} 

asort ($my_cats); 

foreach ($my_cats as $categoryid => $category) { 
   reset ($new_array); 
   while(list($key,$val)=each($new_array)) { 
      if ($val==$category) { 
         foreach($categories_data as $category_data) { 
            if ($category_data["categoryid"] == $categoryid) 
               $val = $category_data["category_name"]; 
         } 
         $category_location[]=array(ereg_replace(".*/","",$val),"home.php?cat=".$categoryid); 
      } 
   } 
} 

if ($current_area == "C" and !empty($current_category) and $config["Images"]["icons_location"] == "FS") {
	$current_category["image_path"] = array_pop(func_query_first("SELECT image_path FROM $sql_tbl[icons] WHERE categoryid='$cat'"));
	if (eregi("^(http|ftp)://", $current_category["image_path"])) {
	# image_path is an URL
		$current_category["icon_url"] = $current_category["image_path"];
	}
	elseif (eregi($xcart_dir, $current_category["image_path"])) {

	# image_path is an locally placed image 
		$current_category["icon_url"] = $http_location.ereg_replace($xcart_dir, "", $current_category["image_path"]);
	}
}


# 
# Assign Smarty variables 
# 

$smarty->assign("allcategories",$all_categories); 
$smarty->assign("categories",$categories); 
$smarty->assign("subcategories",$subcategories); 
$smarty->assign("current_category",$current_category); 
$smarty->assign("cat",$cat); 
?>

skin1/customer/categories.tpl

{* $Id: categories.tpl, modified *} 

{capture name=menu} 

{section name=cat_num loop=$categories} 
{assign var="tmp" value="0"} 

{section name=cat loop=$allcategories} 
{if $allcategories[cat].maincat eq $categories[cat_num].category_name} 
{if $allcategories[cat].subcatonly}{assign var="tmp" value="1"}{/if} 
{/if} 
{/section} 

<font class=CategoriesList> 
<a href="home.php?cat={ $categories[cat_num].categoryid }" class="VertMenuItems">
{ $categories[cat_num].category_name|escape }</a></font>
 

  {if $tmp eq 1}

{assign var="temp" value="0"} 
{section name=cat loop=$allcategories} 
{if $allcategories[cat].maincat eq $categories[cat_num].category_name} 
{if $allcategories[cat].subcatonly} 


{if $temp gt 0}
- {$allcategories[cat].category_name}
{else} 
- {$allcategories[cat].category_name}
{/if} 

{math equation="temp+1" temp=$temp assign=temp}

{/if} 
{/if} 
{/section} 

  {/if}

<hr>
{/section} 


{/capture} 
{ include file="menu.tpl" dingbats="dingbats_categorie.gif" menu_title=$lng.lbl_categories menu_content=$smarty.capture.menu }