DEDE5.3调用DZ论坛最新，最热，精华贴子的方法

DZ7.0+UC1.5+DEDE5.3测试通过
------------------------------------------------------------------------------------------
论坛之星/活跃会员
------------------------------------------------------------------------------------------
{dede:loop table="cdb_members" sort="posts" row="3"}
  <LI>
      <A href="/bbs/space.php?uid=[field:uid /]"><IMG src="/bbs/uc_server/avatar.php?uid=[field:uid /]&size=middle"></A>
      <A href="/bbs/space.php?uid=[field:uid /]">[field:username/]</A>
      <BR>贴子：[field:posts/]
      <BR>加入：[field:regdate function="GetDateMK(@me)"/]
</LI>
{/dede:loop}

/bbs/space.php?uid=[field:uid /] 个人信息地址
/bbs/uc_server/avatar.php?uid=[field:uid /]&size=middle 论坛头像
/home/space.php?uid=[field:uid /] UCHOME的个人空间地址

-------------------------------------------------------------------------------------------
调用贴子
-------------------------------------------------------------------------------------------
{dede:loop table="cdb_threads" if='digest>0' sort="tid" row="10"}
       <LI><A href="/bbs/viewthread.php?tid=[field:tid /]">[field:subject function="cn_substr('@me',30)" /]</A>
{/dede:loop}

if=""  条件

示例1：调用版块ID为4的贴子：
if="fid=4" 调用指定版块的贴子

示例2：调用版块ID为4的精华贴子
if="fid=4 AND digest>0"

示例3：调用回复超过20贴的贴子
if="fid=4 AND replies>20"

-------------------------------------------------------------------------------------------
调用附件带图片的贴子
-------------------------------------------------------------------------------------------
{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}

评论总数：2 条 [ 查看全部 ] 网友评论