帝国CMS自定义列表按时间调用

演示代码按8小时、24小时、7天、30天、365天时间调用，大家可以参照代码按实际情况修改3600*72=72小时
 

8小时内

select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*720
select * from[!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*720 order by onclick desc

24小时内

select count(*) as total from[!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*2400
select * from[!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*2400 order by onclick desc

7天内

select count(*) as total from[!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*7*24
select * from[!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*7*24 order by onclick desc

一个月

select count(*) as total from[!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*30*24
select * from[!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*30*24 order by onclick desc

一年

select count(*) as total from[!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*365*24
select * from[!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*365*24 order by onclick desc