Phpcms V9后臺可以輕松整合最新的DZX程序，或許有同學(xué)會問：怎么整合？而在這里，我們將分享Phpcms V9調(diào)用Discuz X2.5論壇最新帖、最熱帖、熱門版塊排行的具體調(diào)用方法。
下面具體一一來列出PC V9引用DZX2.5的數(shù)據(jù)的代碼：
一、Phpcms V9調(diào)用Discuz X2.5論壇指定版塊帖子或回復(fù)：
{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://論壇網(wǎng)址/thread-{$val[tid]}-1-1.html"><strong> {str_cut($val[subject],60,'')}</strong></a></dt>
<dd>
<p>{str_cut($val[message],168,'')}…</p>
</dd>
{/loop}
{/pc}
解釋：first=1 就是帖子的1樓，如果=0 就是調(diào)用回復(fù)。message 截取168字符。fid=62 是論壇版塊號。
二、Phpcms V9調(diào)用Discuz X2.5論壇最新帖子 并顯示版塊名稱：
{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://論壇網(wǎng)址/forum-{$val[fid]}-1.html">[{$val[name]}]</a>& amp; lt;a href="http://論壇網(wǎng)址/thread-{$val[tid]}-1-1.html"> {str_cut($val[subject],60,'')}</a></li>
{/loop}
{/pc}
解釋：first=1 就是帖子的1樓，如果=0 就是調(diào)用回復(fù)。message 截取168字符。fid=62 是論壇版塊號。
三、Phpcms V9調(diào)用Discuz X2.5論壇最新帖子 并顯示版塊名稱：
{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://論壇網(wǎng)址/forum-{$val[fid]}-1.html">[{$val[name]}]</a>& amp; lt;a href="http://論壇網(wǎng)址/thread-{$val[tid]}-1-1.html"> {str_cut($val[subject],60,'')}</a></li>
{/loop}
{/pc}
如果按積分排行調(diào)用論壇用戶頭像和名稱，也可以將 credits改成regdate，就是最新注冊加入的會員。具體代碼為：
{pc:get sql="SELECT * FROM discuzx.pre_common_member order by credits desc" num="10" cache="" return="data"}
{loop $data $key $val}
<span>
<a href="http://論壇網(wǎng)址/space-uid-{$val[uid]}.html"><img alt="{$val[username]}" src="http://論壇網(wǎng)址/uc_server/avatar.php?uid={$val[uid]}&size=small" /></a>
<a href="http://論壇網(wǎng)址/space-uid-{$val[uid]}.html">{str_cut($val[username],9,'')}</a>
</span>
{/loop}
{/pc}
四、Phpcms V9調(diào)用Discuz X2.5論壇熱門版塊排行：
{pc:get sql="SELECT * FROM discuzx.pre_forum_forum order by threads desc" num="10" cache="" return="data"}
{loop $data $key $val}
<li><span><a href="http://論壇網(wǎng)址/forum-{$val[fid]}-1.html">{$val[name]}</a>& amp; lt;/span> <span><!--<span class="fatieshu">{$val[threads]}</span>主題 -->共<span class="fatieshu">{$val[posts]}</span>帖 今<span class="fatieshu">{$val[todayposts]}</span>帖</span>< /li>
{/loop}
{/pc}
五、Phpcms V9調(diào)用Discuz X2.5論壇最熱帖：
{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://論壇網(wǎng)址/thread-{$val[tid]}-1-1.html">{str_cut($val[subject],54,'')}</a></li>
{/loop}
{/pc}
六：Phpcms V9調(diào)用Discuz X2.5論壇最新帖：
{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://論壇網(wǎng)址/thread-{$val[tid]}-1-1.html">{str_cut($val[subject],54,'')}</a></li>
{/loop}
{/pc}
上面的Phpcms V9調(diào)用Discuz X2.5論壇數(shù)據(jù)代碼，你不妨試試!
