dedecms模板调用论坛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,2"}
  <li><a href="/bbs/viewthread.php?tid=[field:tid /]"><img src="/bbs/attachments/[field:attachment/]"></a></li>
  <li><a href="/bbs/viewthread.php?tid=[field:tid /]">[field:subject function="cn_substr('@me',30)" /]</a></li>
{/dede:sql}

这是我琢磨自己写的希望对大家有帮助

{dede:sql sql="select dz_threads.tid,dz_attachments.attachment,dz_threads.subject from dz_threads,dz_attachments where dz_threads.tid= (select distinct  dz_threads.tid from dz_threads,dz_attachments where dz_attachments.isimage=1 and dz_attachments.tid=dz_threads.tid and dz_threads.fid=4 order by dz_threads.tid desc limit 0,1) and dz_attachments.tid=dz_threads.tid order by dz_threads.tid desc limit 0,1"}
  <li><a href="/bbs/viewthread.php?tid=[field:tid /]"><img src="/bbs/attachments/[field:attachment/]"></a></li>
  <li><a href="/bbs/viewthread.php?tid=[field:tid /]">[field:subject function="cn_substr('@me',30)" /]</a></li>
{/dede:sql}

本文标签：

声明：本文由代码号注册/游客用户【梦松】供稿发布，本站不对用户发布的dedecms模板调用论坛DZ的带附件为图片的帖子实现方法信息内容原创度和真实性等负责。如内容侵犯您的版权或其他权益，请留言并加以说明。站长审查之后若情况属实会及时为您删除。同时遵循 CC 4.0 BY-SA 版权协议，尊重和保护作者的劳动成果，转载请标明出处链接和本声明内容。本文作者：梦松» /dmh/10532.html

很赞哦！ ()