<?php
function smarty_function_last_products ($params, &$smarty){
$default_limit = 10;
$limit = (isset ($params['limit']) && $params['limit'] > 0)? $params['limit'] : $default_limit;
$products = db_phquery_fetch (DBRFETCH_ROW_ALL, 'SELECT `products`.*, `products`.'.LanguagesManager::sql_prepareField('name').' as `name`, `products`.'.LanguagesManager::sql_prepareField('brief_description').' as `brief_description`, `pictures`.`thumbnail` FROM `?#PRODUCTS_TABLE` `products` LEFT JOIN `?#PRODUCT_PICTURES` `pictures` USING (`productID`) WHERE `products`.`enabled` = 1 AND `products`.`categoryID` > 1 AND `pictures`.`photoID` = `products`.`default_picture` ORDER BY `products`.`productID` DESC LIMIT ?', $limit);
foreach ($products as $i => $product){
$products[$i]['PriceWithUnit'] = show_price ($product['Price']);
}
if ($products){
$smarty->assign ('products', $products);
$smarty->display (DIR_FTPLS.'/last_products.html');
}
}
?>