/**
* 获得积分商城热门商品
*
* @param   int      $maxtop        列出条数
* @return array
*/
function exchange_gets_goods($maxtop)
{
    /* 获得热门积分商品列表 */
$sql = 'SELECT g.goods_id, g.goods_name, g.goods_name_style, eg.exchange_integral, '
.' g.goods_type,g.goods_brief, g.goods_thumb, g.goods_img, eg.is_hot ' 
.' FROM `ecshop`.`ecshop_exchange_goods` AS eg LEFT JOIN `ecshop`.`ecshop_goods` AS g ON g.goods_id = eg.goods_id LEFT JOIN `ecshop`.`ecshop_brand` AS b ON b.brand_id = g.brand_id '
.' WHERE eg.is_exchange = 1 AND g.is_delete = 0 AND eg.is_hot = 1 ORDER BY g.sort_order, g.last_update DESC limit ';
$sql.=$maxtop;
$res = $GLOBALS['db']->getAll($sql);
    $arr = array();
   foreach($res AS $idx => $row)
    {
$arr[$idx]['name']              = $row['goods_name'];
$arr[$idx]['goods_brief']       = $row['goods_brief'];
$arr[$idx]['goods_style_name'] = add_style($row['goods_name'],$row['goods_name_style']);
$arr[$idx]['exchange_integral'] = $row['exchange_integral'];
$arr[$idx]['type']              = $row['goods_type'];
$arr[$idx]['goods_thumb']       = get_image_path($row['goods_id'], $row['goods_thumb'], true);
$arr[$idx]['goods_img']         = get_image_path($row['goods_id'], $row['goods_img']);
$arr[$idx]['url']               = build_uri('exchange_goods', array('gid'=>$row['goods_id']), $row['goods_name']);
    }
    return $arr;
}

->

$smarty -> assign('goods_exchange_list',exchange_gets_goods(6));