帝国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