1、调用会员发布文章数table[e:loop={SELECT userid, username, count(username) as total from [!db.pre!]ecms_news group by username order by total desc,0,24,0}]trtd=$bqno/tdtd=$bqr[username]
以下代码加到帝国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/us
列表内容模板(list.var)代码:$uid=$empirefetch1(select * from {$dbtbpre}enewsmemberadd where userid={$r[userid]});$usql=$empirefetch1(select * from {$dbtbpre}enewsmember where userid = {$r[userid]});$use
$members=$empiregettotal(select count(*) as total from phome_enewsmember);$newmember=$empirefetch1(select userid,username from phome_enewsmember order by userid desc limit 1);$tzcount=$empiregettotal(