// Security check to ensure this file is being included by a parent file.
defined('_JEXEC') or die('Restricted access.');
 
//Attempt 2
require_once(CLASSPATH.'ps_database.php');
 
class SefExt_com_virtuemart extends SefExt
{
    function get_product_name($product){
        $db = new ps_DB();
        $query = "SELECT `product_name` FROM `#__{vm}_product` WHERE `product_id`= $product";
        $db->query($query);
        $result = $db->loadResult();
        return stripslashes($result);
    }
    function get_category_name($category){
        $db = new ps_DB();
        $query = "SELECT `category_name` FROM `#__{vm}_category` WHERE `category_id`= $category";
        $db->query($query);
        $result = $db->loadResult();
        return stripslashes($result);
    }
    function create(&$uri) {
        $vars = $uri->getQuery(true);
        extract($vars);
        if(isset($_REQUEST['category_id'])){
            $cat_id = $_REQUEST['category_id'];
            $title[] = $this->get_category_name($cat_id);
            //     ^ this form of adding to a array is suposed to increse key by one
        }
        if(isset($_REQUEST['product_id'])){
            $product_id = $_REQUEST['product_id'];
            $title[] = $this->get_product_name($product_id);
        }
        $newUri = $uri;
        if (count($title) > 0) {
            $newUri = JoomSEF::_sefGetLocation($uri, $title, null, null, null, @$lang);
        }
        echo var_dump($newUri);
        return $newUri;
    }
}