調(diào)用某版塊最新帖子:(紅色部分分別為:“DZ數(shù)據(jù)庫(kù)名,、版塊ID、調(diào)用條數(shù),、帖子ID,、標(biāo)題字?jǐn)?shù)”):
[e:loop={"select tid,subject,dateline from 數(shù)據(jù)庫(kù)名.表前綴_threads where fid=版塊ID order by tid desc limit 10",10,24,0}]<li><a href="/bbs/thread-<?=$bqr[tid]?>-1-1.html" target="_blank"><?=esub($bqr[subject],32)?></a></li>[/e:loop]
調(diào)用全論壇新帖子:
[e:loop={"select tid,subject,dateline from jinyu5.cdb_threads order by tid desc limit 8",10,24,0}]<li><a href="/bbs/thread-<?=$bqr[tid]?>-1-1.html" target="_blank"><?=esub($bqr[subject],32)?></a></li> [/e:loop]
調(diào)用全論壇熱帖子:
[e:loop={"select tid,subject,dateline from jinyu5.cdb_threads order by views desc limit 8",10,24,0}]<li><a href="/bbs/thread-<?=$bqr[tid]?>-1-1.html" target="_blank"><?=esub($bqr[subject],32)?></a></li> [/e:loop]
調(diào)用指定版塊的精華帖子:
[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}] <li><a href="http://www.xxxx.com/thread-<?=$bqr[tid]?>-1-1.html" title="<?=$bqr[subject]?>" target="_blank"><?=esub($bqr[subject],30)?></a></li>[/e:loop]
調(diào)用指定版塊熱門帖,如調(diào)用版塊ID為40的回復(fù)數(shù)超過(guò)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}] <li><a href="http://www.xxxx.com/thread-<?=$bqr[tid]?>-1-1.html" title="<?=$bqr[subject]?>" target="_blank"><?=esub($bqr[subject],30)?></a></li>[/e:loop]