導(dǎo)讀:DEDE技術(shù)

調(diào)用DZ論壇圖片：{dede:sql sql=”SELECT`cdb_attachments`.`aid`, `cdb_attachments`.`attachment`,`cdb_threads`.`tid`, `cdb_threads`.`fid`, `cdb_threads`.`subject` FROM `cdb_attachments` LEFT JOIN `cdb_threads` ON `cdb_threads`.`tid`=`cdb_attachments`.`tid` WHERE `cdb_attachments`.`readperm`=’0′ AND `displayorder`>=’0′ AND `filetype`=’image/pjpeg’ GROUP BY tid LIMIT 0,1 “}<a href=”/bbs/viewthread.php?tid=[field:tid /]“><img src=”/bbs/attachments/[field:attachment/]” ALT=”[field:subject/]” width=”100″ height=”80″ border=”0″ /></A>{/dede:sql} 余下的工作就是用css定義你的a標(biāo)簽和img標(biāo)簽了dede調(diào)用DZ論壇帖子及特定板塊帖子的調(diào)用方法論壇最新主題：：{dede:loop table=”cdb_threads” sort=”tid” row=”10″}<a href=”/dz/viewthread.php?tid=[field:tid /]“>·[field:subject function="cn_substr('@me',30)" /]([field:lastpost function="date('m-d H:M','@me')" /])</a>{/dede:loop}調(diào)特定板塊的主題{dede:loop table=”cdb_threads” if=”fid=5 and displayorder!=-1″ sort=”tid” row=”10″}<a href=”/dz/viewthread.php?tid=[field:tid /]“>·[field:subject function="cn_substr('@me',30)" /]([field:lastpost function="date('m-d H:M','@me')" /])</a>顯示精華帖{dede:loop table=”cdb_threads” if=”fid=5 AND digest>0 and displayorder!=-1 ” sort=”tid” row=”10″}