今日有一朋友在織夢58詢問如何在DedeCMS調用Discuz7.2帶圖片附件主題，現在就把調用方法分享給大家，注意代碼中的bbs.liehuo.net為烈火論壇的網址，請修改為自己的論壇地址，將以下代碼插入到自己的DEDE模板中就可以了。

 

Copy to ClipboardLiehuo.Net Codes引用的內容：[www.dede58.com]

{dede:sql sql="SELECT cdb_attachments.aid, cdb_attachments.attachment,cdb_threads.tid, cdb_threads.subject FROM cdb_attachments LEFT JOIN cdb_threads ON cdb_threads.tid = cdb_attachments.tid WHERE cdb_attachments.readperm='0' AND cdb_threads.displayorder>='0' AND (right(cdb_attachments.filename,3)='jpg' or right(cdb_attachments.filename,3)='gif') GROUP BY tid LIMIT 0,4"} 

 

<li><a href="http://bbs.liehuo.net/viewthread.php?tid=[field:tid /]"><img src="http://bbs.liehuo.net/attachments/[field:attachment/]" alt="[field:subject/]"></a></li> 

 

{/dede:sql}