调用某版块最新帖子:(红色部分分别为:"DZ数据库名、版块ID、调用条数、帖子ID、标题字数"):
[e:loop={"select tid,subject,dateline from 数据库名.表前缀_threads where fid=版块ID order by tid desc limit 10",10,24,0}]> href="/bbs/thread-=$bqr[tid]?>-1-1.html" target="_blank">=esub($bqr[subject],32)?>> >[/e:loop]
调用全论坛新帖子:
[e:loop={"select tid,subject,dateline from jinyu5.cdb_threads order by tid desc limit 8",10,24,0}]> href="/bbs/thread-=$bqr[tid]?>-1-1.html" target="_blank">=esub($bqr[subject],32)?>> > [/e:loop]
调用全论坛热帖子:
[e:loop={"select tid,subject,dateline from jinyu5.cdb_threads order by views desc limit 8",10,24,0}]> href="/bbs/thread-=$bqr[tid]?>-1-1.html" target="_blank">=esub($bqr[subject],32)?>> > [/e:loop]
调用指定版块的精华帖子:
[e:loop={"select tid,subject,dateline,digest from accbbs.accbbsforum_thread where digest!=0 and fid=版块ID order by tid desc limit 10",10,24,0}]> href="http://www.caikaoyuan.com/thread-=$bqr[tid]?>-1-1.html" title="=$bqr[subject]?>" target="_blank">=esub($bqr[subject],30)?>> >
[/e:loop]
调用指定版块热门帖,如调用版块ID为40的回复数超过20的帖:
[e:loop={"select tid,subject,dateline,replies from accbbs.accbbsforum_thread where replies>=20 and fid=40 order by tid desc limit 10",10,24,0}]> href="http://www.caikaoyuan.com/thread-=$bqr[tid]?>-1-1.html" title="=$bqr[subject]?>" target="_blank">=esub($bqr[subject],30)?>> >
[/e:loop]
版权声明: 本站资源均来自互联网或会员发布,如果侵犯了您的权益请与我们联系,我们将在24小时内删除!谢谢!
转载请注明: 帝国CMS(ECMS)灵动标签调用Discuz帖子