ECSHOP首页调用最新评论插件

ECSHOP首页调用最新评论插件，提供如下修改代码：

<?php

if(!function_exists("get_comments")){

function get_comments($num)

{

$sql = 'SELECT a.*,b.goods_id,b.goods_thumb,b.goods_name FROM '. $GLOBALS['ecs']->table('comment') .

' AS a,'. $GLOBALS['ecs']->table('goods') .'AS b WHERE a.status = 1 AND a.parent_id = 0 and a.comment_type=0 and

a.id_value=b.goods_id '.

' ORDER BY a.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'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);

$comments[$idx]['content'] = $row['content'];

$comments[$idx]['id_value'] = $row['id_value'];

$comments[$idx]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);

$comments[$idx]['goods_name'] = $row['goods_name'];

}

return $comments;

}

}

?>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<!--数据调用-最新评论开始 -->

<?php

$this->assign('my_comments',get_comments(5)); // 数据条数

?>

<!--{foreach from=$my_comments item=comments}-->

<table width="290" border="0" cellspacing="0" cellpadding="0" style=" border-bottom:1px #ccc dashed;">

<tr>

<td width="73" height="70" align="center"><a href="goods.php?id={$comments.id_value}" target="_blank"><img

src="{$comments.goods_thumb}" border="0" width="60" height="60" style=" border:1px #CCCCCC solid;"/></a></td>

<td width="473" align="left" valign="top">

<div style="height:3px; overflow:hidden;"> </div>

<div><a href="goods.php?id={$comments.id_value}" target="_blank"><font style=" color:#FF0000; font-size:14px;">

{$comments.goods_name}</font></a></div>

<div><img src="../images/pl.gif" width="38" height="19" align="absmiddle">{$comments.content|truncate:100:""}</div>

<div style="color:#999999;">时间：{$comments.add_time}</div>

</td>

</tr>

</table>

<!--{/foreach}-->

此处：

<?php

$this->assign('my_comments',get_comments(5)); // 数据条数 这里的5 是你要调用的数量。。。

?>