public function getProductName($id)
{
if (empty(self::$productNamesCache)) {
self::$productNamesCache = array();
}
if (empty(self::$productNamesCache[$this->vmlang])) {
self::$productNamesCache[$this->vmlang] = array();
}
if (!isset(self::$productNamesCache[$this->vmlang][$id])) {
$db = JFactory::getDBO();
$query = 'SELECT `product_name` FROM `#__virtuemart_products_' . $this->vmlang . '` ' . ' WHERE `virtuemart_product_id` = ' . (int) $id;
$db->setQuery($query);
$name = $db->loadResult();
if (empty($name)) {
$db = JFactory::getDBO();
$query = 'SELECT `product_name` FROM `#__virtuemart_products_en_gb` ' . ' WHERE `virtuemart_product_id` = ' . (int) $id;
$db->setQuery($query);
$name = $db->loadResult();
}
if (!$this->nostatic) {
self::$productNamesCache[$this->vmlang][$id] = $name;
}
} else {
$name = self::$productNamesCache[$this->vmlang][$id];
}
return $name . $this->seo_sufix;
}
