1. 查找: 判断是否存在缓存,如果存在则调用缓存,反之读取相应内容, 看到下面有$smarty->assign这些的,如:
$smarty->assign('invoice_list', index_get_invoice_query()); // 发货查询
$smarty->assign('new_articles', index_get_new_articles()); // 最新文章
$smarty->assign('group_buy_goods', index_get_group_buy()); // 团购商品
$smarty->assign('auction_list', index_get_auction()); // 拍卖活动
$smarty->assign('shop_notice', $_CFG['shop_notice']); // 商店公告
在下面添加
$smarty->assign('my_comments', get_comments(10)); //评论添加
2、在最下面, ?> 标签前添加:
function get_comments($num)
{
$sql = 'SELECT * FROM '. $GLOBALS['ecs']->table('comment') .
' WHERE status = 1 AND parent_id = 0 and comment_type=0 '.
' ORDER BY add_time DESC';
if ($num > 0)
{
$sql .= ' LIMIT ' . $num;
}
//echo $sql;
$res = $GLOBALS['db']->getAll($sql);
$comments = array();
foreach ($res AS $idx => $row)
{
$comments[$idx]['add_time'] = $comments[$idx]['add_time'] = local_date
($GLOBALS['_CFG']['time_format'], $row['add_time']);
$comments[$idx]['user_name'] = $row['user_name'];
$comments[$idx]['content'] = $row['content'];
$comments[$idx]['id_value'] = $row['id_value'];
}
return $comments;
}
二、打开首页模板文件 index.dwt,指定位置添加
<div class="comments">
<!--{foreach from=$my_comments item=comments}-->
<div class="t_l f_l"><a href="goods.php?id={$comments.id_value}" target="_blank">
{$comments.content|truncate:15:""}</a></div><div class="d_r f_r">时间:
{$comments.add_time}</div>
<!--{/foreach}-->
</div>