if ($value > 0) {
$column_list[] = $key;
}
}
// Eversun mod for sppp
if (!isset($_SESSION['sppc_customer_group_id'])) {
$customer_group_id = 'G';
} else {
$customer_group_id = $_SESSION['sppc_customer_group_id'];
}
// Eversun mod end for sppp
$customer_group_array = array();
if (!isset($_SESSION['sppc_customer_group_id'])) {
$customer_group_array[] = 'G';
} else {
$customer_group_array = tep_get_customers_access_group($_SESSION['customer_id']);
}
$select_column_list = '';
for ($i = 0, $n = sizeof($column_list); $i < $n; $i++) {
switch ($column_list[$i]) {
case 'PRODUCT_LIST_MODEL':
$select_column_list .= 'p.products_model, ';
break;
case 'PRODUCT_LIST_MANUFACTURER':
$select_column_list .= 'm.manufacturers_name, ';
break;
case 'PRODUCT_LIST_QUANTITY':
$select_column_list .= 'p.products_quantity, ';
break;
case 'PRODUCT_LIST_IMAGE':
$select_column_list .= 'p.products_image, ';
function tep_show_category3($cid, $cpath, $COLLAPSABLE, $level = 0)
{
global $categories_string3, $languages_id, $categories;
$selectedPath = array();
// Get all of the categories on this level
$level++;
$customer_group_array = array();
if (!isset($_SESSION['sppc_customer_group_id'])) {
$customer_group_array[] = 'G';
} else {
$customer_group_array = tep_get_customers_access_group($_SESSION['customer_id']);
}
$categories_query_raw = "SELECT c.categories_id, cd.categories_name, c.parent_id\r\n from " . TABLE_CATEGORIES . " c,\r\n " . TABLE_CATEGORIES_DESCRIPTION . " cd\r\n WHERE c.parent_id = '" . $cid . "'\r\n and c.categories_id = cd.categories_id\r\n and cd.language_id='" . $languages_id . "'";
$categories_query_raw .= tep_get_access_sql('c.products_group_access', $customer_group_array);
$categories_query_raw .= " ORDER BY sort_order, cd.categories_name";
$categories_query = tep_db_query($categories_query_raw);
while ($categories = tep_db_fetch_array($categories_query)) {
if (!isset($categories[$level]['parent_id']) || $categories[$level]['parent_id'] == "") {
$categories[$level]['parent_id'] = 0;
}
$categories[$level]['categories_id'] = $categories[$level]['parent_id'] + 1;
// Add category link to $categories_string3
for ($a = 1; $a < $level; $a++) {
$categories_string3 .= " ";
}
$categories_string3 .= '<a href="';
$cPath_new = $cpath;
// if ($categories[$level]['parent_id'] > 0) {
if ($categories['parent_id'] > 0) {
$cPath_new .= "_";
}
$cPath_new .= $categories['categories_id'];
// added for CDS CDpath support
$CDpath = isset($_SESSION['CDpath']) ? '&CDpath=' . $_SESSION['CDpath'] : '';
$cPath_new_text = "cPath=" . $cPath_new . $CDpath;
$categories_string3 .= tep_href_link(FILENAME_DEFAULT, $cPath_new_text);
$categories_string3 .= '">';
if ($_GET['cPath']) {
$selectedPath = explode("_", $_GET['cPath']);
}
if (in_array($categories['categories_id'], $selectedPath)) {
$categories_string3 .= '<b>';
}
if ($categories[$level]['categories_id'] == 1) {
$categories_string3 .= '<u>';
}
$categories_string3 .= tep_db_decoder($categories['categories_name']);
if ($COLLAPSABLE && tep_has_category_subcategories($categories['categories_id'])) {
$categories_string3 .= ' ->';
}
if ($categories[$level]['categories_id'] == 1) {
$categories_string3 .= '</u>';
}
if (in_array($categories['categories_id'], $selectedPath)) {
$categories_string3 .= '</b>';
}
$categories_string3 .= '</a>';
if (SHOW_COUNTS) {
$products_in_category = tep_count_products_in_category($categories['categories_id']);
if ($products_in_category > 0) {
$categories_string3 .= ' (' . $products_in_category . ')';
}
}
$categories_string3 .= '<br>';
// If I have subcategories, get them and show them
if (tep_has_category_subcategories($categories['categories_id'])) {
if ($COLLAPSABLE) {
if (in_array($categories['categories_id'], $selectedPath)) {
tep_show_category3($categories['categories_id'], $cPath_new, $COLLAPSABLE, $level);
}
} else {
tep_show_category3($categories['categories_id'], $cPath_new, $COLLAPSABLE, $level);
}
}
}
}
