assign('tpl_path','templates/'.CURRENT_TEMPLATE.'/'); require_once(DIR_FS_INC . 'xtc_count_products_in_category.inc.php'); //to get category trees function get_category_tree($parent_id = '0', $spacing = '', $exclude = '', $category_tree_array = '', $include_itself = false, $cPath = '') { if ($parent_id == 0){ $cPath = ''; } else { $cPath .= $parent_id . '_'; } if (!is_array($category_tree_array)) $category_tree_array = array(); if ( (sizeof($category_tree_array) < 1) && ($exclude != '0') ) { $category_tree_array[] = array('id' => '0', 'text' => TEXT_TOP); } if ($include_itself) { $category_query = " select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd where cd.language_id = '" . $_SESSION['languages_id'] . "' and cd.categories_id = '" . $parent_id . "'"; $category_query = xtDBquery($category_query); $category = xtc_db_fetch_array($category_query,true); $category_tree_array[] = array('id' => $parent_id, 'text' => $category['categories_name']); } $categories_query = " select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = " . (int)$_SESSION['languages_id'] . " and c.parent_id = " . (int)$parent_id . " and c.categories_status = '1' order by c.sort_order, cd.categories_name"; $categories_query = xtDBquery($categories_query); while ($categories = xtc_db_fetch_array($categories_query,true)) { $SEF_link = xtc_href_link(FILENAME_DEFAULT, xtc_category_link($categories['categories_id'],$categories['categories_name'])); if ($exclude != $categories['categories_id']) $category_tree_array[] = array( 'id' => $categories['categories_id'], 'text' => $spacing . $categories['categories_name'], 'link' => $SEF_link); $category_tree_array = get_category_tree($categories['categories_id'], $spacing . '   ', $exclude, $category_tree_array, false, $cPath); } return $category_tree_array; } $categories_query = " select c.categories_image, c.categories_id, cd.categories_name FROM " . TABLE_CATEGORIES . " c left join " . TABLE_CATEGORIES_DESCRIPTION ." cd on c.categories_id = cd.categories_id WHERE c.categories_status = 1 and cd.language_id = " . (int)$_SESSION['languages_id'] . " and c.parent_id = 0 ".helper::getGroupCheck('c')." order by c.sort_order ASC"; // db Cache $categories_query = xtDBquery($categories_query); $module_content = array(); while ($categories = xtc_db_fetch_array($categories_query,true)) { $SEF_link = xtc_href_link(FILENAME_DEFAULT, xtc_category_link($categories['categories_id'], $categories['categories_name'])); $module_content[] = array( 'ID' => $categories['categories_id'], 'CAT_NAME' => $categories['categories_name'], 'CAT_IMAGE' => DIR_WS_IMAGES . 'categories/' . $categories['categories_image'], 'CAT_LINK' => $SEF_link, 'SCATS' => get_category_tree($categories['categories_id'], '', 0)); } // if there's sth -> assign it if (sizeof($module_content) >= 1) { $module_smarty->assign('language', $_SESSION['language']); $module_smarty->assign('module_content',$module_content); // set cache ID if (!CacheCheck()) { $module_smarty->caching = 0; echo $module_smarty->fetch(CURRENT_TEMPLATE.'/module/sitemap.html'); } else { $module_smarty->caching = 1; $module_smarty->cache_lifetime=CACHE_LIFETIME; $module_smarty->cache_modified_check=CACHE_CHECK; $cache_id = $GET['cPath'].$_SESSION['language'].$_SESSION['customers_status']['customers_status_name'].$_SESSION['currency']; echo $module_smarty->fetch(CURRENT_TEMPLATE.'/module/sitemap.html', $cache_id); } }

Mac Speichershop

• Tel.: +49 38736 81511
• Mail: info@mac-speicher-shop.de