Code:

<? 

/*****************************************************************************\ 

+-----------------------------------------------------------------------------+ 

| 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

Code:

{* $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 }

:wink: