X-Cart forums

[ARW VISIONS]

I'm pulling my hair out on this.

I am using the sub cat list with columns, so I can display sub cat icons. On teh cat page I would also like the sub cat description to show also.

Can anyone help me out here?

[cflsystems]

You probably have to change this function in include/func/func.category.php to include decsription in the query

function func_get_categories_list

[ARW VISIONS]

wow... what do I change / or add?

[amy2203]

you'll probably need to add the descrition to the select query in include/categories.php

[cflsystems]

In include/func/func.category.php find below code under function

function func_get_categories_list

 if ($current_area == "C" || $current_area == "B") {
  $join_tbl .= " LEFT JOIN $sql_tbl[categories_lng] USE INDEX (PRIMARY) ON $sql_tbl[categories_lng].code='$shop_language' AND $sql_tbl[categories_lng].categoryid=$sql_tbl[categories].categoryid ";
  $join_tbl .= " LEFT JOIN $sql_tbl[category_memberships] ON $sql_tbl[category_memberships].categoryid = $sql_tbl[categories].categoryid ";
  $to_search .= ", IF($sql_tbl[categories_lng].categoryid IS NOT NULL AND $sql_tbl[categories_lng].category != '', $sql_tbl[categories_lng].category, $sql_tbl[categories].category) as category";
 }

and replace with

 if ($current_area == "C" || $current_area == "B") {
  $join_tbl .= " LEFT JOIN $sql_tbl[categories_lng] USE INDEX (PRIMARY) ON $sql_tbl[categories_lng].code='$shop_language' AND $sql_tbl[categories_lng].categoryid=$sql_tbl[categories].categoryid ";
  $join_tbl .= " LEFT JOIN $sql_tbl[category_memberships] ON $sql_tbl[category_memberships].categoryid = $sql_tbl[categories].categoryid ";
  $to_search .= ", IF($sql_tbl[categories_lng].categoryid IS NOT NULL AND $sql_tbl[categories_lng].category != '', $sql_tbl[categories_lng].category, $sql_tbl[categories].category) as category, $sql_tbl[categories].description";
 }

[cowsdonthack]

http://connectpoliticditto.files.wordpress.com/2008/04/jasparafterthedive.jpg

I've got your Sub Cat right here.