本周热点排行之类的sql标签 [ecmsinfo]"select * from phome_ecms_news where newstime>SUBDATE(NOW(),INTERVAL 7 DAY) order by onclick desc limit 10",10,30,0,24,7,0[/ecmsinfo]注意：30 是单位（天，当然你也可以修改单位为hour(小时)，month(月)…
帝国CMS高级应用－灵动标签之循环子栏目导航如下图：代码如下：[e:loop={"select classid,classname,islast from {$dbtbpre}enewsclass where bclassid='0' and showclass=0 order by myorder,classid ASC limit 11",0,24,0}]
<?php
$classu…
如题，会员空间反馈信息调用。代码如下：<?
//会员空间反馈 调用
//userid='1' 会员ID
$sql=$empire->query("select ftext,uname,uid from {$dbtbpre}enewsmemberfeedback where userid='1' order by fid desc limit 8");
while($…
帝国CMS任意模板中调用留言，可只调用已审核的留言，也可不限制是否审核。代码如下：<?
//bid为留言分类ID，checked='0' 0为已审核，1为未审核
$sql=$empire->query("select * from {$dbtbpre}enewsgbook where bid='1' and checked=…
帝国CMS默认的友情链接标签内置的格式太坑爹了，无法满足个性化需求。可使用灵动标签来调用：调用文字链接：[e:loop={'select * from [!db.pre!]enewslink where checked=1 and classid=1 order by lid',20,24,0}]<a href="<?=$bqr[lurl]?>"…
