<?php
/* -----------------------------------------------------------------------------------------
$Id: xtc_get_product_path.inc.php 1009 2005-07-11 16:19:29Z mz $
XT-Commerce - community made shopping
http://www.xt-commerce.com
Copyright (c) 2003 XT-Commerce
-----------------------------------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(general.php,v 1.225 2003/05/29); www.oscommerce.com
(c) 2003 nextcommerce (xtc_get_product_path.inc.php,v 1.3 2003/08/13); www.nextcommerce.org
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
// Construct a category path to the product
// TABLES: products_to_categories
function xtc_get_product_path($products_id)
{
$cPath = '';
$category_query = "
SELECT
p.main_category_id AS categories_id
FROM
" . TABLE_PRODUCTS . " p,
" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c,
" . TABLE_CATEGORIES . " c
WHERE
p.products_id = '" . (int)$products_id . "' AND
p.products_status = '1' AND
p.products_id = p2c.products_id AND
c.categories_id= p2c.categories_id AND
p2c.categories_id != 0 AND
c.categories_status=1
LIMIT 1";
$category_query = xtc_db_query($category_query);
if(xtc_db_num_rows($category_query, true))
{
$category = xtc_db_fetch_array($category_query);
$categories = array();
xtc_get_parent_categories($categories, $category['categories_id']);
$categories = array_reverse($categories);
if(in_array(-1, $categories))
{
$categories = array();
$category = null;
}
$cPath = implode('_', $categories);
if(xtc_not_null($cPath))
{
$cPath .= '_';
}
$cPath .= $category['categories_id'];
}
return $cPath;
}