function vam_show_category_content($counter)
{
global $foo, $categories_string, $id;
for ($a = 0; $a < $foo[$counter]['level']; $a++) {
$categories_string .= " ";
}
$categories_string .= '<a href="';
if ($foo[$counter]['parent'] == 0) {
$cPath_new = 'cPath=' . $counter;
} else {
$cPath_new = 'cPath=' . $foo[$counter]['path'];
}
$categories_string .= vam_href_link(FILENAME_DEFAULT, $cPath_new);
$categories_string .= '">';
if ($id && in_array($counter, $id)) {
$categories_string .= '<b>';
}
// display category name
$categories_string .= $foo[$counter]['name'];
if ($id && in_array($counter, $id)) {
$categories_string .= '</b>';
}
if (vam_has_category_subcategories($counter)) {
$categories_string .= '->';
}
$categories_string .= '</a>';
//if (SHOW_COUNTS == 'true') {
// $products_in_category = vam_count_products_in_category($counter);
// if ($products_in_category > 0) {
// $categories_string .= ' (' . $products_in_category . ')';
// }
//}
$categories_string .= '<br />';
if ($foo[$counter]['next_id']) {
vam_show_category_content($foo[$counter]['next_id']);
}
}
function vam_rss_category_tree($id_parent = 0, $cPath = '', $limit = null)
{
global $db, $rss;
if ($limit != null && $limit < 0) {
return;
}
if ($limit != null) {
$limit--;
}
$groups_cat_query = vam_db_query("select c.categories_id, c.parent_id, c.date_added, c.last_modified, c.categories_image, cd.categories_name, cd.categories_description\n\t\t\t\t\t\t\t\t\t\t\t from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd\n\t\t\t\t\t\t\t\t\t\t\t where c.parent_id = '" . (int) $id_parent . "'\n\t\t\t\t\t\t\t\t\t\t\t and c.categories_id = cd.categories_id\n\t\t\t\t\t\t\t\t\t\t\t and cd.language_id='" . (int) $_SESSION['languages_id'] . "'\n\t\t\t\t\t\t\t\t\t\t\t and c.categories_status= '1'\n\t\t\t\t\t\t\t\t\t\t\t order by c.sort_order, cd.categories_name");
if (vam_db_num_rows($groups_cat_query) == 0) {
return;
}
while ($groups_cat = vam_db_fetch_array($groups_cat_query)) {
$link_categories = addslashes(vam_href_link(FILENAME_DEFAULT, vam_category_link($groups_cat['categories_id'], $groups_cat['categories_name']) . (isset($_GET['ref']) ? '&ref=' . $_GET['ref'] : null), 'NONSSL', false));
$products_in_category = vam_count_products_in_category($groups_cat['categories_id']);
if (CATEGORIES_COUNT_ZERO == '1' && $products_in_category == 0 or $products_in_category >= 1) {
$rss->rss_feed_item($groups_cat['categories_name'], $link_categories, $link_categories, date('r', strtotime(max($groups_cat['date_added'], $groups_cat['last_modified']))), $groups_cat['categories_description'], $groups_cat['categories_image'], false, STORE_OWNER_EMAIL_ADDRESS . " (" . STORE_OWNER . ")");
}
if (vam_has_category_subcategories($groups_cat['categories_id'])) {
vam_rss_category_tree($groups_cat['categories_id'], vam_not_null($cPath) ? $cPath . '_' . $groups_cat['categories_id'] : $groups_cat['categories_id'], $limit);
// следующая группа
}
// $groups_cat->MoveNext();
}
}
// Link a specification group to a product category
$specification_group_id = (int) $_POST['specification_group_id'];
$categories_id = (int) $_POST['link_category_id'];
$link_subcats = $_POST['link_subcats'] == 'True' ? 'True' : 'False';
if ($specification_group_id != 0) {
$links_query_raw = "select specification_group_id\n from " . TABLE_SPECIFICATIONS_TO_CATEGORIES . "\n where specification_group_id = '" . $specification_group_id . "' \n and categories_id = '" . $categories_id . "'\n ";
//print $links_query_raw . "<br />\n";
$links_query = vam_db_query($links_query_raw);
if (vam_db_num_rows($links_query) < 1) {
$sql_data_array = array('specification_group_id' => $specification_group_id, 'categories_id' => $categories_id);
vam_db_perform(TABLE_SPECIFICATIONS_TO_CATEGORIES, $sql_data_array);
}
// if (vam_db_num_rows
}
// Link all subcategories if selected
if ($link_subcats == 'True' && vam_has_category_subcategories($categories_id)) {
$categories_array = array();
vam_get_subcategories($categories_array, $categories_id);
foreach ($categories_array as $categories_id) {
$sql_data_array = array();
$links_query_raw = "select specification_group_id\n from " . TABLE_SPECIFICATIONS_TO_CATEGORIES . "\n where specification_group_id = '" . $specification_group_id . "' \n and categories_id = '" . $categories_id . "'\n ";
//print $links_query_raw . "<br />\n";
$links_query = vam_db_query($links_query_raw);
if (vam_db_num_rows($links_query) < 1) {
$sql_data_array = array('specification_group_id' => $specification_group_id, 'categories_id' => $categories_id);
vam_db_perform(TABLE_SPECIFICATIONS_TO_CATEGORIES, $sql_data_array);
}
// if (vam_db_num_rows
}
// foreach ($categories_array
}
