-
帝国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}] lia href=/e/space/?userid=?=$bqr[userid]? target=_blankimg src=?=$bqr[titlepic]? alt=?=$bqr[ti…
帝国cms9年前 -
帝国cms模板里用灵动标签如何调用未回复的留言信息
灵动标签可以用sql调用 select * from phome_enewsgbook where retext!='' order by lyid desc limit 10…
帝国cms9年前 -
帝国cms网站优化使tags伪静态的实现
帝国cms网站优化值tags伪静态的实现步骤如下: 1.修改e/class/t_functions.php中的sys_eShowTags函数 代码如下: //显示TAGS function sys_eShowTags($cid,$num=0,$line=0,$order='',$isgood='',$isgoodshow='',$showjg='',$shownum=0,$cs=''){ global $empir…
帝国cms9年前 -
dedecms发手机短信的源码,做旅游网项目写的代码
if ($dzzt==1){ $dxa= $dsql->GetOne("SELECT userid from hw_shops_orders where oid='$n' ");…
dedecms9年前 -
帝国cms 封面模板循环子栏目代码支持内嵌标签
?php $bclassid=$GLOBALS[navclassid]; //取得本栏目id //取得本栏目下的子栏目 ? [e:loop={select classid, classname, classpath from `[!db.pre!]enewsclass` where bclassid='$bclassid' order by `classid` desc ,7,24,0}] [ecmsinfo] $bqr[classid] ,1…
帝国cms9年前 -
帝国cms首页调用指定栏目id的专题列表教程
代码如下: [e:loop={'select * from phome_enewszt where classid=3 order by ztid desc',10,24,0}] li class=nopicspan?=format_datetime($bqr[addtime],'m-d')?/spana href=?=$bqr['ztpath']? title=?=$bqr['ztname']??=$bqr['ztname']?/a/li [/e:loop]…
帝国cms9年前 -
帝国cms7.0内容页模板实现多背景tag标签
调用代码 加到内容页模板里 ?php $ecms_bq_sql=sys_ReturnEcmsLoopBq(select * from [!db.pre!]enewstagsdata where classid='$navinfor[classid]' and id='$navinfor[id]' order by tagid,10,24,0); $bqno=0; while($bqr=$empire-fetch($ecms_bq_sql)) { $b…
帝国cms9年前 -
phpcms v9 get调用热门文章的自定义调用办法
{pc:get sql="SELECT * FROM `v9_news` a, `v9_hits` p WHERE a.catid=$catid and a.status=99 and a.inputtime > UNIX_TIMESTAMP()-7*3600*24 and CONCAT( 'c-1-', a.id ) = p.hitsid ORDER BY p.weekviews DESC" num="15"}…
父类数据9年前 -
帝国cms教程调用某个数据表中会员的发帖排行榜
调用会员在某个数据表发帖量的排行,没有发布信息的会员按照会员ID排序 代码如下: select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember u group by u.userid order by myorder…
帝国cms9年前 -
帝国cms调用某个数据表中会员的发帖排行榜教程
调用会员在某个数据表发帖量的排行,没有发布信息的会员按照会员ID排序 sql: select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember u group by u.userid order by myorder desc…
帝国cms9年前