首页模板加入即可

这种方法适用于 PC与disucz在同一个数据库中
DZ的数据库前缀为默认
如果你改了请修改pre_ 为你自己的

 

 

 

<div class="box">
            <h5 class="title-2"><span class="rt fn f12 tab SwapTab"><span class="fb">热帖</span> | <span >评论</span> | <span>新帖</span></span>论坛</h5>
            <div class="tab-content">
            <ul class="content digg">
                        {pc:get sql="SELECT * FROM pre_forum_thread ORDER BY dateline>=UNIX_TIMESTAMP()-604800 DESC" num="10" cache="3600" return="data"}
                                {loop $data $key $val}
                                        <li><a title="{$r[subject]}" href="/bbs/thread_{$val[tid]}_1_1.html">{$val[subject]}</a></li>
                                {/loop}
                        {/pc}
            </ul>
            <ul class="content digg hidden">
                        {pc:get sql="SELECT * FROM pre_forum_thread order by lastpost DESC" num="10" cache="3600" return="data"}
                                {loop $data $key $val}
                                        <li><a title="{$r[subject]}" href="/bbs/thread_{$val[tid]}_1_1.html">{$val[subject]}</a></li>
                                {/loop}
                        {/pc}
            </ul>
            <ul class="content digg hidden">
                        {pc:get sql="SELECT * FROM pre_forum_thread order by tid desc" num="10" cache="3600" return="data"}
                                {loop $data $key $val}
                                        <li><a title="{$r[subject]}" href="/bbs/thread_{$val[tid]}_1_1.html">{$val[subject]}</a></li>
                                {/loop}
                        {/pc}
            </ul>
            </div>
        </div>
        <div class="bk10"></div>