you are welcome...
here is what i did:
step 1:
in includes/functions/functions_lookups.php, add the code at the bottom but before the '?>'
PHP Code:
/*
* Return products url, based on specified language (or current lang if not specified)
*/
function zen_get_products_url($product_id, $language = '') {
global $db;
if (empty($language)) $language = $_SESSION['languages_id'];
$product_query = "select products_url
from " . TABLE_PRODUCTS_DESCRIPTION . "
where products_id = '" . (int)$product_id . "'
and language_id = '" . (int)$language . "'";
$product = $db->Execute($product_query);
return $product->fields['products_url'];
}
Bookmarks