<?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 DISTINCT
      p2c.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 = xtDBquery($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;
}