以下代码加入到帝国cms模板里面$ue=$empirefetch1(select * from phome_ecms_fj where mc=$navinfor[mc] limit 1);$uee=$empirefetch1(select * from phome_enewsclas where clasid=$ue[clasid] limit 1);$str=
列表内容模板(list.var)代码:$uid=$empirefetch1(select * from {$dbtbpre}enewsmemberadd where userid={$r[userid]});$usql=$empirefetch1(select * from {$dbtbpre}enewsmember where userid = {$r[userid]});$use
以下代码适合放到封面模板,列表模板和内容页模板$clas_sql=$empirefetch1('select clasid,clasname,bname from '.$dbtbpre.'enewsclas where clasid='.$GLOBALS[navclasid].'');$bname=$clas_sql[bname];
会员空间模板支持用php查询所有表,例子:会员空间的留言用这个调用:$gbsql=$empirequery(select gid,isprivate,uid,uname,ip,addtime,gbtext,retext from {$dbtbpre}enewsmembergbook where userid=$userid order by gid
修改/e/clas/functions.php文件,找到解析代码function RepExeCode($string)在这之前添加标签替换4function CustomNewsBq($name,$indextext){ global $empire,$dbtbpre,$public_r,$emod_r,$clas_r,$clas_zr,$fu
以下代码就是调用多个父栏目信息的调用代码select * from [!db.pre!]ecms_news where clasid in (select clasid from [!db.pre!]enewsclas where bclasid in (7,8,9)) order by onclick DESC limit 8