软件总下载数:
<?=$empire->gettotal("select sum(totaldown) as total from phome_ecms_download")?>
文章总浏览数:
<?=$empire->gettotal("select sum(onclick) as total from phome_ecms_news")?>
...
帝国CMS统计今日文章数,昨日文章数,总文章数,会员数,最新会员
<?php$members=$empire->gettotal("select count(*) as total from phome_enewsmember");$newmember=$empire->fetch1("select userid,username from phome_enewsmember order by userid desc ...
因为帝国CMS 7.0信息页不再有ztid字段,所以直接是查询不到的,但是可以用灵动标签sql调用,具体调下方法如下:
灵动标签sql调用:
select ztid from phome_enewsztinfo where classid='$navinfor[classid]' and id='$navinfor[id]'
...
通过以下方法可以在帝国CMS子栏目页调用父栏目的自定义字段内容:
<?phpglobal $empire;$r=$empire->fetch1("select * from phome_enewsclassadd where classid=".$class_r[$GLOBALS[navclassid]][bclassid]."");echo $r[about];?>
...
可以实现,调用最新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 '.$dbtbpre.'ecms_article as a,'.$dbtbpre.'...