注册 | 登录 |
地方论坛门户及新闻和人才网址大全

discuz 帖内调用作者所有带封面帖子

时间:2021-07-21人气:-


目录 帖内调用作者所有带封面帖子,可在viewthread.htm中使用。
<div class="uc-piclist">            <!--{eval $theuid = $_G[forum_thread][authorid]}-->            <!--{eval $authorthreads = DB::fetch_all("SELECT * FROM ".DB::table('forum_thread')." WHERE `authorid`= '$theuid' AND `cover`!=0 ORDER by dateline DESC LIMIT 0,9;");}-->            <ul>                <!--{loop $authorthreads $authorthread}-->                <!--{eval $threadcover = DB::result(DB::query("SELECT attachment FROM ".DB::table('forum_threadimage')." WHERE `tid`= '$authorthread[tid]'"));}-->                <!--{eval $threadfname = DB::result(DB::query("SELECT name FROM ".DB::table('forum_forum')." WHERE `fid`= '$authorthread[fid]'"));}-->                <li>                    <div class="uc-piclist-con-top">                        <div class="uc-thumb">                            <a href="forum.php?mod=viewthread&tid={$authorthread['tid']}" onclick="atarget(this)" title="$authorthread[subject] by admin" class="z">                            <img src="http://file.cmsbj.cn/cmsbj_file/forum/$threadcover" alt="$authorthread[subject] by $authorthread[author]" width="265" height="auto">                            </a>                        </div>                        <div class="uc-title">                            <a href="forum.php?mod=viewthread&tid={$authorthread['tid']}" onclick="atarget(this)" title="$authorthread[subject] by $authorthread[author]" class="uc-title-a"><span>$authorthread[subject]</span></a>                            <div class="uc-title-bg"></div>                        </div>                    </div>                    <div class="uc-piclist-con-bot">                        <div class="uc-stat">                            <span title="查看"><i class="ico-eye-open ico-gray"></i>$authorthread[views]</span>                            <span title="回复"><i class="ico-comment ico-gray"></i>$authorthread[replies]</span>                            <span title="喜欢"><i class="ico-heart ico-gray"></i>$authorthread[favtimes]</span>                            <!--{if $authorthread[digest] > 0}--><span title="精华"><font color=red>精华</font></span><!--{/if}-->                        </div>                        <div class="uc-author">                            <span><!--{echo dgmdate($authorthread[dateline], 'u', '9999', getglobal('setting/dateformat'))}--></span>                            <a href="forum.php?mod=forumdisplay&fid={$authorthread[fid]}" class="uc-forumname" title="TA发表在<!--{$threadfname}-->"><!--{$threadfname}--></a>                        </div>                    </div>                </li>                <!--{/loop}-->            </ul>            <div class="morethreads cl pgbtn"><a href="home.php?mod=space&uid=$authorthread[authorid]" hidefocus="true">去看更多...</a></div>        </div>
根据帖子作者uid查询帖子,再用获取到的tid查询帖子封面表获取封面。图片路径是远程附件路径,本服务器的换成data/attachment/forum/$threadcover也可缩略图显示,loop中加入<!--{eval $imagelistkeys = getforumimg($threadcover, 0, 265, 0); }-->。

上篇:discuz 任意位置调用友情链接代码

下篇:discuz 同一diy区块多loop显示