[!--news.url--]skin/default/
[e:loop={"select classid,classname,bname from phome_enewsclass where classid='$GLOBALS[navclassid]'",1,24,0}][/e:loop]
[e:loop={"select * from phome_enewsclass where classid='$GLOBALS[navclassid]'",1,24,0}][/e:loop]
<&#63;php
$fcr=explode('|',$class_r[$GLOBALS[navclassid]][featherclass]);
$topbclassid=$fcr[1]&#63;$fcr[1]:$GLOBALS[navclassid];//取得当前栏目的顶级栏目ID
$rs=$empire->fetch1("select * from phome_enewsclass where classid=$topbclassid");
&#63;>
_<&#63;=$rs['bname']&#63;>_<&#63;=$public_r[sitename]&#63;> 顶级栏目名称+网站标题
<&#63;=$class_r[$GLOBALS[navclassid]][bname]&#63;> 得到当前栏目的名称
或
isgood=1 一级推荐
firsttitle=1 一级头条
[e:loop={10,3,0,0}] 10当前栏目,3显示条数,
[e:loop={4,1000,0,1,'leib="楼市快讯"','id DESC'}] 1有图片的显示。
[e:loop={"select * from phome_ecms_xtgg where firsttitle=1 order by id DESC limit 20",6,24,0}]
<&#63;=$bqno&#63;> [!--no.num--] 循环序号
<&#63;=$bqsr['titleurl']&#63;> <&#63;=$bqr[title]&#63;> <&#63;=esub($bqr[title],8)&#63;>
[/e:loop]
代码如下:
<&#63;php
//报名人数
$num=$empire->gettotal("select count(*) as total from phome_enewsfeedback where kft='".$navinfor[title]."'");
&#63;>
帝国CMS经常用到的调用sql语句:
请注意,如果是帝国7.0版本的,需要将checked=1去掉
代码如下:
1,根据最新文章 select * from [!db.pre!]ecms_news where checked=1 order by newstime desc limit 10
2,根据推荐文章 select * from [!db.pre!]ecms_news where checked=1 and isgood=1 order by newstime desc limit 10
3,根据热门文章 select * from [!db.pre!]ecms_news where checked=1 order by onclick desc limit 10
4,根据头条新闻 select * from [!db.pre!]ecms_news where checked=1 and firsttitle=1 order by newstime desc limit 10
5,根据评论排行 select * from [!db.pre!]ecms_news where checked=1 order by plnum desc limit 10
6,根据digg排行 select * from [!db.pre!]ecms_news where checked=1 order by diggtop desc limit 10
7,根据投票排行 select * from [!db.pre!]ecms_news where checked=1 order by votenum desc limit 10
8,根据下载排行 select * from [!db.pre!]ecms_news where checked=1 order by totaldown desc limit 10
9,根据评分排行 select * from [!db.pre!]ecms_news where checked=1 order by infopfen desc limit 10
代码如下:
<&#63;
$favas=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsfava where id='$navinfor[id]' and classid='$GLOBALS[navclassid]'");
&#63;>
<&#63;=$favas&#63;>就是这条信息的收藏数