导读:DEDE技术

调用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标签和img标签了dede调用DZ论坛帖子及特定板块帖子的调用方法论坛最新主题：：{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}调特定板块的主题{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″}