调用论坛板块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"}
<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],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
还没有评论,来说两句吧...