帝国cms灵动标签调用最新评论方法

首页调用最新评论4条[参考]参考代码如下，具体效果参考我给的演示站点的首页：
 

[e:loop={"select * from {$dbtbpre}enewspl_1 where saytext not like '%ecomment%' order by saytime DESC limit 4",0,24,0}]
<?php
$myid=$bqr['userid'];
$myid2=$bqr['id'];
$member=$empire->fetch1("select userpic from {$dbtbpre}enewsmemberadd where userid='$myid'");
$picnum=intval(mt_rand(1,7));
for($i=0;$i<1;$i++)
{
$randpic='/e/extend/lgyPl/assets /userpic/user_0'.substr(strval($picnum),$i,1).'.jpg';
}
?>
<li>
<div class="pic">
<img src="<?=$member['userpic']?$member['userpic']:$randpic?>" alt="">
</div>
<div class="info">
<span><?=$bqr['username']?></span>
<p><?=esub(strip_tags($bqr['saytext']),80,'…')?></p>
<em><?=lgy_tranTime($bqr['saytime'])?></em>
</div>
</li>
[/e:loop]
还没结束，为了让首页调用的评论也能以“刚刚”、“几分钟前”来显示时间，需要将插件list.php中的以下代码剪切并粘贴至e/class/userfun.php（注意是剪切不是复制）：
function lgy_tranTime($time) {
$minute = date("H:i",$time);
$hour = date("H:i",$time);
$alltime = date("Y年m月d日 H:i",$time);
$time = time() – $time;
if ($time < 60) {
$str = ' 刚刚 ';
}
elseif ($time < 60 * 60) {
$min = floor($time/60);
$str = $min.'分钟前 ';
}
elseif ($time < 60 * 60 * 24) {
$h = floor($time/(60*60));
$str = $h.'小时前 ';
}
elseif ($time < 60 * 60 * 24 * 3) {
$d = floor($time/(60*60*24));
if($d=1)
   $str = '昨天 '.$minute;
else
   $str = $alltime;
}
    else {
$str = $alltime;
}
return $str;
}

用灵动标签调用最新最多评论文章：

[e:loop={'select * from [!db.pre!]ecms_news where checked=1 order by plnum desc,id desc limit 8',10,24,0}]

<li> <small><a href="<?=$bqsr[titleurl]?>" class="title"><?=sub($bqr[title],0,30,false)?></a></small>

<p><?=$bqr[smalltext]?></p>

</li>

[/e:loop]

如下示例代码：

function lgy_tranTime($time) {
$minute = date("H:i",$time);
$hour = date("H:i",$time);
$alltime = date("Y年m月d日 H:i",$time);
$time = time() - $time;
if ($time < 60) {
$str = ' 刚刚 ';
}
elseif ($time < 60 * 60) {
$min = floor($time/60);
$str = $min.'分钟前 ';
}
elseif ($time < 60 * 60 * 24) {
$h = floor($time/(60*60));
$str = $h.'小时前 ';
}
elseif ($time < 60 * 60 * 24 * 3) {
$d = floor($time/(60*60*24));
if($d=1)
   $str = '昨天 '.$minute;
else
   $str = $alltime;
}
    else {
$str = $alltime;
}
return $str;
}