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

调用论坛板块10条新帖

{pc:get sql="SELECT * FROM nc_forum_thread WHERE FID=98 ORDER BY `tid` DESC" cache="3600" dbsource="nc" return="data" num="7"}
         <ul class="list lh24 f14">
             {loop $data $key $val}
             <li>·<a href="http://nc.qybi.com/thread-{$val[tid]}-1-1.html" target='_blank'>{str_cut($val[subject],27,'')}{$val[username]}</a></li>
                {/loop}
            </ul>
            {/pc}

调用多板块十条新帖

{pc:get sql="SELECT * FROM nc_forum_thread where fid in(46,47) order by `tid` desc" cache="3600" dbsource="nc" return="data" num="1"}
{loop $data $key $val}
<li><a href="http://nc.qybi.com/thread-{$val[tid]}-1-1.html" target='_blank'>{str_cut($val[subject],28,'')}</a></li>
{/loop}
{/pc}

论坛全站新帖10条加作者空间链接

{pc:get sql="SELECT * FROM wzbbs_forum_thread ORDER BY `tid` DESC" cache="3600" dbsource="wzbbs" return="data" num="10"}
         <ul class="list lh24 f14">
             {loop $data $key $val}
             <li><a href="http://论坛地址/forum.php?mod=viewthread&tid={$val[tid]}&extra=page%3D1" target='_blank'>{str_cut($val[subject],28,'')}</a>【<a href="http://论坛地址/home.php?mod=space&uid={$val[authorid]}" target='_blank'>{$val[author]}</a>】</li>
                {/loop}
            </ul>
            {/pc}

提示：{$val[authorid]} 获取个人空间的UID号 {$val[author]} 获取会员名

调用全站10条最新帖子

{pc:get sql="SELECT * FROM nc_forum_thread ORDER BY `tid` DESC" cache="3600" dbsource="nc" return="data" num="11"}

{loop $data $key $val}

             <li>·<a href="http://nc.qybi.com/thread-{$val[tid]}-1-1.html"target='_blank'>{str_cut($val[subject],38,'')}{$val[username]}</a></li>
                {/loop}
            </ul>
            {/pc}

调用全站最热门10条帖子

{pc:get sql="SELECT * FROM nc_forum_thread order by views desc" cache="3600" dbsource="nc" return="data" num="9"}
{loop $data $key $val}
<li><a href="http://nc.qybi.com/thread-{$val[tid]}-1-1.html" target='_blank'>{str_cut($val[subject],40,'')}</a></li>
{/loop}
{/pc}

调用多栏目10条最热帖子

{pc:get sql="SELECT * FROM wzbbs_forum_thread where fid in(46,47) order by views desc" cache="3600" dbsource="wzbbs" return="data" num="10"}
{loop $data $key $val}
<li><a href="论坛地址/forum.php?mod=viewthread&tid={$val[tid]}&extra=page%3D1" target='_blank'>{str_cut($val[subject],28,'')}</a></li>
{/loop}
{/pc}

调用多栏目10条精华帖子

{pc:get sql="SELECT * FROM nc_forum_thread where fid in(46,47) order by digest desc" cache="3600" dbsource="nc" return="data" num="1"}
{loop $data $key $val}
<li><a href="http://nc.qybi.com/thread-{$val[tid]}-1-1.html" target='_blank'>{str_cut($val[subject],28,'')}</a></li>
{/loop}
{/pc}

调用某栏目下10条精华贴

{pc:get sql="SELECT * FROM nc_forum_thread where fid=47 order by digest desc" cache="3600" dbsource="nc" return="data" num="1"}
{loop $data $key $val}
<li><a href="http://nc.qybi.com/thread-{$val[tid]}-1-1.html" target='_blank'>{str_cut($val[subject],28,'')}</a></li>
{/loop}
{/pc}

调用全站10条精华帖
{pc:get sql="SELECT * FROM pet_forum_thread order by digest desc" cache="3600" dbsource="pet" return="data" num="1"}
{loop $data $key $val}
<li><a href="http://nc.qybi.com/thread-{$val[tid]}-1-1.html" target='_blank'>{str_cut($val[subject],28,'')}</a></li>
{/loop}
{/pc}

列出某栏目下所有子栏目名称

{pc:get sql="SELECT * FROM wzbbs_forum_forum where fum=37 order by displayorder asc" cache="3600" dbsource="wzbbs" return="data" num="10"}
{loop $data $key $val}
<li><a href="论坛地址/forum.php?mod=viewthread&tid={$val[tid]}&extra=page%3D1" target='_blank'>{str_cut($val[subject],28,'')}</a></li>
{/loop}
{/pc}
比如论坛有一个栏目叫“网赚论坛” 下面有众多网赚的子栏目网赚论坛gid=37 在上面代码中fum就是gid

伪静态地址：thread-{$val[tid]}-1-1.html
用户空间链接：space-uid-{$val[authorid]}.html