function vam_get_category_path($cID) { $cPath = ''; $category = $cID; $categories = array(); vam_get_parent_categories($categories, $cID); $categories = array_reverse($categories); $cPath = implode('_', $categories); if (vam_not_null($cPath)) { $cPath .= '_'; } $cPath .= $cID; return $cPath; }
function vam_get_parent_categories(&$categories, $categories_id) { $parent_categories_query = "select parent_id from " . TABLE_CATEGORIES . " where categories_id = '" . $categories_id . "'"; $parent_categories_query = vamDBquery($parent_categories_query); while ($parent_categories = vam_db_fetch_array($parent_categories_query, true)) { if ($parent_categories['parent_id'] == 0) { return true; } $categories[sizeof($categories)] = $parent_categories['parent_id']; if ($parent_categories['parent_id'] != $categories_id) { vam_get_parent_categories($categories, $parent_categories['parent_id']); } } }
function vam_get_product_path($products_id) { $cPath = ''; $category_query = "select p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = '" . (int) $products_id . "' and p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id != 0 limit 1"; $category_query = vamDBquery($category_query); if (vam_db_num_rows($category_query, true)) { $category = vam_db_fetch_array($category_query); $categories = array(); vam_get_parent_categories($categories, $category['categories_id']); $categories = array_reverse($categories); $cPath = implode('_', $categories); if (vam_not_null($cPath)) { $cPath .= '_'; } $cPath .= $category['categories_id']; } return $cPath; }