本周热点排行之类的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高级应用-灵动标签之循环子栏目导航
1.jpg
[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$classurl=sys_ReturnBqClassname...
如题,会员空间反馈信息调用。
代码如下:
<?
//会员空间反馈 调用
//userid='1' 会员ID
$sql=$empire->query("select ftext,uname,uid from {$dbtbpre}enewsmemberfeedback where userid='1' order by fid desc limit 8");
while($r=$empire->fetch($sql...
帝国CMS任意模板中调用留言,可只调用已审核的留言,也可不限制是否审核。
代码如下:
<?
//bid为留言分类ID,checked='0' 0为已审核,1为未审核
$sql=$empire->query("select * from {$dbtbpre}enewsgbook where bid='1' and checked='0' order by lyid desc ...
帝国CMS默认的友情链接标签内置的格式太坑爹了,无法满足个性化需求。
可使用灵动标签来调用:
调用文字链接:
[e:loop={'select * from [!db.pre!]enewslink where checked=1 and classid=1 order by lid',20,24,0}]<?=$bqr[lname]?>[/e:loop]
调用图文链...
用灵动标签调用最新最多评论文章:
[e:loop={'select * from [!db.pre!]ecms_news where checked=1 order by plnum desc,id desc limit 8',10,24,0}]
<?=sub($bqr[title],0,30,false)?>
<?=$b...
用灵动标签调用调用最新DIGG顶的最多的文章:
[e:loop={'select * from [!db.pre!]ecms_news where checked=1 order by diggtop desc,id desc limit 8',10,24,0}]
<?=sub($bqr[title],0,30,false)?>]点击:<?=$bqr[o...
帝国CMS 用灵动标签调用最新会员[头像+用户名+链接]:
[e:loop={'select userid as userid,truename as title,userpic as titlepic from [!db.pre!]enewsmemberadd order by userid desc limit 8',10,24,0}]
...