首頁調用最新評論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;
}