列表内容模板(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
$bclasid=$GLOBALS[navclasid]; 取得本栏目id取得本栏目下的子栏目[e:loop={select clasid, clasname, claspath from `[!db.pre!]enewsclas` where bclasid=$bclasid order by `clasid` desc ,7,24,0}][ecmsinfo] $b