phpcmsV9调用dz论坛帖子标签和方法②

{pc:get sql="SELECT * FROM discuzx.pre_forum_post where first=1 and fid=62 order by tid desc" num="1" cache="" return="data"}
{loop $data $key $val}
<dt><a href="http://论坛网址/thread-{$val[tid]}-1-1.html">{str_cut($val[subject],60,'')}</a></dt>
<dd>
{str_cut($val[message],168,'')}…
</dd>
{/loop}
{/pc}

first=1 就是帖子的1楼，如果=0 就是调用回复。message 截取168字符。fid=62 是论坛版块号

{pc:get sql="SELECT a.*,b.* FROM discuzx.pre_forum_thread as a left join discuzx.pre_forum_forum as b on a.fid=b.fid order by tid desc" num="4" cache="" return="data"}

{loop $data $key $val}

<li><a id="lanmu" href="http://论坛网址/forum-{$val[fid]}-1.html">[{$val[name]}]</a><a href="http://论坛网址/thread-{$val[tid]}-1-1.html">{str_cut($val[subject],60,'')}</a></li>

{/loop}

{/pc}

调用论坛最新帖子并显示版块名称

按积分排行调用论坛用户头像和名称，也可以将 credits改成regdate，就是最新注册加入的会员
{pc:get sql="SELECT * FROM discuzx.pre_common_member order by credits desc" num="10" cache="" return="data"}

{loop $data $key $val}



<a class="head-img" href="http://论坛网址/space-uid-{$val[uid]}.html"><img alt="{$val[username]}" src="http://论坛网址/uc_server/avatar.php?uid={$val[uid]}&size=small" /></a>

<a class="head-name" href="http://论坛网址/space-uid-{$val[uid]}.html">{str_cut($val[username],9,'')}</a>



{/loop}

{/pc}

热门板块排行
{pc:get sql="SELECT * FROM discuzx.pre_forum_forum order by threads desc" num="10" cache="" return="data"}

{loop $data $key $val}

<li><a class="hot-bankuai-txt" href="http://论坛网址/forum-{$val[fid]}-1.html">{$val[name]}</a> 共{$val[posts]}帖今{$val[todayposts]}帖</li>

{/loop}

{/pc}

论坛最火帖子
{pc:get sql="SELECT * FROM discuzx.pre_forum_thread order by replies desc" num="6" cache="" return="data"}

{loop $data $key $val}

 <li><a href="http://论坛网址/thread-{$val[tid]}-1-1.html">{str_cut($val[subject],54,'')}</a></li>

{/loop}

{/pc}

论坛最热帖子
{pc:get sql="SELECT * FROM discuzx.pre_forum_thread order by views desc" num="6" cache="" return="data"}

{loop $data $key $val}

 <li><a href="http://论坛网址/thread-{$val[tid]}-1-1.html">{str_cut($val[subject],54,'')}</a></li>

{/loop}

{/pc}

论坛最新帖子
{pc:get sql="SELECT * FROM discuzx.pre_forum_thread order by tid desc" num="6" cache="" return="data"}

{loop $data $key $val}

 <li><a href="http://论坛网址/thread-{$val[tid]}-1-1.html">{str_cut($val[subject],54,'')}</a></li>

{/loop}

{/pc}

bbs_x_forum_thread 是论坛帖子的主表
里面有帖子序列号（tid）栏目序列号(fid)
帖子标题(subject) 查看量（views）精华等级(digest)