It is not working, I have followed what your link mentioned.
Replace this in /administrator/components/com_virtuemart/classes/ps_product.php file:
function latestProducts($random, $products) {
return “”;
}
With this
function latestProducts($random, $category_id) {
global $VM_LANG;
require_once( CLASSPATH . ‘ps_product_attribute.php’);
$ps_product_attribute = new ps_product_attribute();
$max_items = 4;
$db = new ps_DB;
$tpl = new $GLOBALS[‘VM_THEMECLASS’]();
$category_id = null;
if($categories) {
$category_id = vmRequest::getInt(‘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_i d n”;
$q .= “AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id n”;
if( !empty( $category_id ) ) {
$q .= “AND #__{vm}_category.category_id=’$category_id’ “;
}
if( CHECK_STOCK && PSHOP_SHOW_OUT_OF_STOCK_PRODUCTS != “1”) {
$q .= ” AND product_in_stock > 0 “;
}
$q .= “AND #__{vm}_product.product_publish=’Y’ “;
$q .= “ORDER BY #__{vm}_product.product_id DESC “;
$q .= “LIMIT 0, $max_items “;
$db->query($q);
if( $db->num_rows() > 0 ){
$i = 0;
$latest_products = array();
while($db->next_record() ){
$flypage = $this->get_flypage($db->f(“product_id”));
$latest_products[$i][‘product_sku’] = $db->f(“product_sku”);
$latest_products[$i][‘product_name’] = $db->f(“product_name”);
$price = “”;
if (_SHOW_PRICES == ‘1’) {
// Show price, but without “including X% tax”
$price = $this->show_price( $db->f(“product_id”), false );
}
$latest_products[$i][‘product_price’] = $price;
$latest_products[$i][‘product_s_desc’] = $db->f(“product_s_desc”);
$latest_products[$i][‘product_url’] = $db->f(“product_url”);
$latest_products[$i][‘product_thumb’] = $db->f(“product_thumb_image”);
$latest_products[$i][‘product_full_image’]= $db->f(“product_full_image”);
$latest_products[$i][‘product_id’] = $db->f(“product_id”);
$latest_products[$i][‘flypage’] = $flypage;
$latest_products[$i][‘form_addtocart’] = “”;
if (USE_AS_CATALOGUE != ‘1’ && $price != “”
&& !stristr( $price, $VM_LANG->_(‘PHPSHOP_PRODUCT_CALL’) )
&& !$this->product_has_attributes( $db->f(‘product_id’), true )
&& $tpl->get_cfg( ‘showAddtocartButtonOnProductList’ ) ) {
$tpl->set( ‘i’, $i );
$tpl->set( ‘product_id’, $db->f(‘product_id’) );
$tpl->set( ‘ps_product_attribute’, $ps_product_attribute );
$tpl->set( ‘product_in_stock’, $db->f(‘product_in_stock’));
$latest_products[$i][‘form_addtocart’] = $tpl->fetch( ‘browse/includes/addtocart_form.tpl.php’ );
$latest_products[$i][‘has_addtocart’] = true;
}
$i++;
}
$tpl->set( ‘latest_products’, $latest_products );
return $tpl->fetch( ‘common/latestProducts.tpl.php’);
}
}
I can confirm that your template has problem.
Please advice.
Kent
sfpkent 13 years, 3 months ago.
