Усовершенствованный VirtueMart SEF роутер [алиасы товаров, категорий, брэндов, файлов, мин. запросов - страница 8 - [VM1] Установка и обновление

if ( $category_id ) {
	        $q  = "SELECT DISTINCT product_sku,#__{vm}_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE \n";
	        $q .= "(#__{vm}_product.product_parent_id='' OR #__{vm}_product.product_parent_id='0') \n";
	        $q .= "AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id \n";
	        $q .= "AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id \n";
            $q .= "AND #__{vm}_category.category_id='$category_id' \n";
	        $q .= "AND #__{vm}_product.product_publish='Y' \n";
	        $q .= "AND #__{vm}_product.product_special='Y' \n";
	        if( CHECK_STOCK && PSHOP_SHOW_OUT_OF_STOCK_PRODUCTS != "1") {
		        $q .= " AND product_in_stock > 0 \n";
	        }
	        $q .= 'ORDER BY RAND() LIMIT 0, '.(int)$products;
        }
        else {
	        $q  = "SELECT DISTINCT product_sku,product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url FROM #__{vm}_product WHERE ";
	        $q .= "(#__{vm}_product.product_parent_id='' OR #__{vm}_product.product_parent_id='0') AND vendor_id='".$_SESSION['ps_vendor_id']."' ";
	        $q .= "AND #__{vm}_product.product_publish='Y' ";
	        $q .= "AND #__{vm}_product.product_special='Y' ";
	        if( CHECK_STOCK && PSHOP_SHOW_OUT_OF_STOCK_PRODUCTS != "1") {
		        $q .= " AND product_in_stock > 0 ";
	        }
	        $q .= 'ORDER BY RAND() LIMIT 0, '.(int)$products;
        }

	        $q  = "SELECT DISTINCT product_sku,#__{vm}_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url, #__{vm}_category.category_id FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE \n";
	        $q .= "(#__{vm}_product.product_parent_id='' OR #__{vm}_product.product_parent_id='0') \n";
	        $q .= "AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id \n";
	        $q .= "AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id \n";
if ( $category_id ) {$q .= "AND #__{vm}_category.category_id='$category_id' \n"; }
	        $q .= "AND #__{vm}_product.product_publish='Y' \n";
	        $q .= "AND #__{vm}_product.product_special='Y' \n";
	        if( CHECK_STOCK && PSHOP_SHOW_OUT_OF_STOCK_PRODUCTS != "1") {
		        $q .= " AND product_in_stock > 0 \n";
	        }
	        $q .= 'ORDER BY RAND() LIMIT 0, '.(int)$products;
        

$featured_products[$i]['category_id'] = $db->f("category_id");

define('REDIRECT_WITHOUT_SEO_URLS',true);//true - автоматически перенаправлять со ссылок без ЧПУ на ссылки с ЧПУ: true - разрешить, false - запретить, тоесть при заходе на ссылку page=shop.browse&category_id=6987 301 редирект на category/6987-elektronnye-knigi.html и у посетителя откроется та же страница но с ЧПУ ссылкой: category/6987-elektronnye-knigi.html 
        
        $uri	 								= & JURI::getInstance();
	$current 								= $uri->toString( array('query'));
       
        $option								= JRequest::getCMD('option');
		
	if(!empty($current) && REDIRECT_WITHOUT_SEO_URLS && $option == 'com_virtuemart'){
			$query						= array();
			$current						= JString::str_ireplace('?','',$current);
			$current						= JString::str_ireplace('&','&',$current);
				
					
			parse_str($current,$query);
			
			if(isset($query['page']) && !empty($query['page'])){
						$uri	 			= & JURI::getInstance();
						$current 			= $uri->toString( JURI::root()).''.JRoute::_('index.php?'.$uri->getQuery());
						$current			= JString::str_ireplace('&','&',$current);
						$mainframe			= & JFactory::getApplication();
						$mainframe->redirect($current,'','',true);
						exit();
				}		
				
		
	}