希望在会员中心首页,调用显示会员总共投稿发布了多少篇信息,以帝国CMS7.0为例,代码如下:<?=$empire->gettotal("select count(*) as total from phome_ecms_info where userid='$user[userid]' ")?>这是根据数据表查询调……
可以实现,调用最新300条信息中点中率最高的2条信息,而不是所有信息。[e:loop={'select * from (select a.id,a.title,a.newspath,a.newstime,b.classpath,b.classname,b.filetype,a.onclick,a.smalltext from '.$dbtbpr……
通过以下方法可以在帝国CMS子栏目页调用父栏目的自定义字段内容:<?phpglobal $empire;$r=$empire->fetch1("select * from phome_enewsclassadd where classid=".$class_r[$GLOBALS[navclassid]][bclassid]."");echo $……
因为帝国CMS 7.0信息页不再有ztid字段,所以直接是查询不到的,但是可以用灵动标签sql调用,具体调下方法如下:灵动标签sql调用:select ztid from phome_enewsztinfo where classid='$navinfor[classid]' and id='$navinfor[i……
帝国CMS统计今日文章数,昨日文章数,总文章数,会员数,最新会员<?php$members=$empire->gettotal("select count(*) as total from phome_enewsmember");$newmember=$empire->fetch1("select userid,username from phom……
软件总下载数: <?=$empire->gettotal("select sum(totaldown) as total from phome_ecms_download")?>文章总浏览数:
<?=$empire->gettotal("select sum(onclick) as total from phome_ecms_news")?>……
问:有若干个专题,所属一个栏目,那在栏目模板中如何自动调用这些专题名?能否象调用子栏目一样。用sql标签倒是可以:select ztname as title,ztpath as newspath from phome_enewszt where classid='".$GLOBALS['navclassi……
常常需要利用自定义页面来制作单页面,并放置在导航里,又希望能实现当前自定义页面高亮[e:loop={'select id,path,title from [!db.pre!]enewspage where classid=1 order by id',20,24,0}]
<?php
$pageurl=$public_r['n……
帝国CMS内置的专题调用标签总是不理想,调用不方便,还是灵动标签调用来得方便实在。代码:[e:loop={'select ztid,ztname,ztimg,maxnum,intro,onclick,ztpath from [!db.pre!]enewszt where showzt=1 order by ztid limit……
灵动标签调用当前栏目下子栏目,支持栏目自定义排序。[e:loop={"select classname,classpath,classid from phome_enewsclass where bclassid='$GLOBALS[navclassid]' and showclass=0 order by myorder,classid desc",……
通过本教程实现帝国CMS栏目页使用灵动标签调用当前栏目 缩略图[e:loop={"select classimg from phome_enewsclass where classid='$GLOBALS[navclassid]'",1,24,0}]<img src="<?=$bqr[classimg]?>" alt="[!---class.n……
(一)、当前栏目ID或专题ID:$GLOBALS[navclassid]
通过这个变量可以输出这个栏目id的所有数据(如:select * from phome_enewsclass where classid='$GLOBALS[navclassid]')
(二)、使用范例:调用当前栏目下的栏目简介。
用SQ……
帝国CMS显示指定时间内更新的信息数量,如1天内列新多少条信息:用sql调用
12小时:<?=$empire->gettotal("select count(*) as total from phome_ecms_表 where newstime>UNIX_TIMESTAMP()-24*3600")?>
6小时:<?=$empire->……
帝国CMS 用灵动标签调用最新会员[头像+用户名+链接]:<ul>
[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}]……
用灵动标签调用调用最新DIGG顶的最多的文章:[e:loop={'select * from [!db.pre!]ecms_news where checked=1 order by diggtop desc,id desc limit 8',10,24,0}]
<li><a href="<?=$bqsr[titleurl]?>"><?=sub($bqr[titl……