帝国cms常见问题：灵动标签按照点击数实现天、周、月排行榜调用方法

帝国灵动标签调用最近7天内热门信息方法1[e:loop={"select * from {$dbtbpre}ecms_news where FROM_UNIXTIME(newstime)>SUBDATE(NOW(),INTERVAL 7 DAY) order by onclick

帝国灵动标签调用最近7天内热门信息nOFECMSPLUS

方法1nOFECMSPLUS

[e:loop={"select * from {$dbtbpre}ecms_news where FROM_UNIXTIME(newstime)>SUBDATE(NOW(),INTERVAL 7 DAY)  order by onclick desc limit 10",0,24,0}]nOFECMSPLUS

<a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> nOFECMSPLUS

[/e:loop]nOFECMSPLUS

方法2nOFECMSPLUS

[e:loop={"select * from {$dbtbpre}ecms_news where newstime>UNIX_TIMESTAMP()-86400*7  order by onclick desc limit 10",0,24,0}]nOFECMSPLUS

<a href="<?=$bqsr['titleurl']?>" target="_blank"><?=$bqr['title']?></a> nOFECMSPLUS

[/e:loop]nOFECMSPLUS

方法3nOFECMSPLUS
[e:loop={'news',10,18,0,'newstime>UNIX_TIMESTAMP()-86400*7','onclick desc'}]nOFECMSPLUS

<a href="<?=$bqsr[titleurl]?>" target="_blank"><?=$bqr[title]?></a>nOFECMSPLUS

[/e:loop]nOFECMSPLUS

newstime:代表文章发布时间nOFECMSPLUS

其中86400*7中的，86400是代表一天的时间戳，7表示7天，如果是月就是86400*30，年就是86400*365nOFECMSPLUS

其排列方式：文章发布时间起统计nOFECMSPLUS

今天（24小时）：newstime>UNIX_TIMESTAMP()-86400*1 必须是今天发布的文章  nOFECMSPLUS

一周：newstime>UNIX_TIMESTAMP()-86400*7 必须是一周内发布的文章  nOFECMSPLUS

news代表新闻表，如果调用其他请用其他比如articlenOFECMSPLUS

帝国CMS(EmpireCMS)调用当天的热门信息nOFECMSPLUS

[e:loop={'news',10,18,0,'newstime>UNIX_TIMESTAMP()-86400','onclick desc'}]nOFECMSPLUS

<a href="<?=$bqsr[titleurl]?>" target="_blank"><?=$bqr[title]?></a>nOFECMSPLUS

[/e:loop]nOFECMSPLUS

帝国CMS(EmpireCMS)调用当月热门信息nOFECMSPLUS

[e:loop={'news',10,18,0,'newstime>UNIX_TIMESTAMP()-86400*30','onclick desc'}]nOFECMSPLUS

<a href="<?=$bqsr[titleurl]?>" target="_blank"><?=$bqr[title]?></a>nOFECMSPLUS

[/e:loop]nOFECMSPLUS

如下示例代码：

方法1

[e:loop={"select * from {$dbtbpre}ecms_news where FROM_UNIXTIME(newstime)>SUBDATE(NOW(),INTERVAL 7 DAY)  order by onclick desc limit 10",0,24,0}]

<a href="&lt;?=$bqsr['titleurl']?>" target="_blank">&lt;?=$bqr['title']?></a> 

[/e:loop]

方法2

[e:loop={"select * from {$dbtbpre}ecms_news where newstime>UNIX_TIMESTAMP()-86400*7  order by onclick desc limit 10",0,24,0}]

<a href="&lt;?=$bqsr['titleurl']?>" target="_blank">&lt;?=$bqr['title']?></a> 

[/e:loop]

方法3
[e:loop={'news',10,18,0,'newstime>UNIX_TIMESTAMP()-86400*7','onclick desc'}]

<a href="&lt;?=$bqsr[titleurl]?>" target="_blank">&lt;?=$bqr[title]?></a>

[/e:loop]