discuz整合系列-----如何给标题显示附件图片数目

Discuz整合教程：论坛主题显示附件图片数量

最新推荐文章于 2021-03-22 05:18:54 发布

原创最新推荐文章于 2021-03-22 05:18:54 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#thread #query #join #email #sql

discuz 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了如何在Discuz论坛中修改代码，以实现在主题标题旁显示附件图片的数量。通过修改forumdisplay.php文件和相关模板文件forumdisplay.htm，实现了在帖子列表中展示每个主题包含的图片数。

实现的方法太多，下面只是其中一种，在这简略地操作一下，非完善版，下面的sql都雷同

如果有什么疑问，或bug之类请跟帖或email给我，收到即回复。

第一步 . 根目录文件forumdisplay.php

找到用/* */括住的代码，用/**/括号起来，

然后把/*----- -----*/之间的代码粘到下面，并把/*----- -----*/删除

if(($start_limit && $start_limit > $stickycount) || !$stickycount || $filterbool) { $querysticky = ''; /* $query = $sdb->query("SELECT t.* FROM {$tablepre}threads t WHERE t.fid='$fid' $filteradd AND $displayorderadd ORDER BY t.displayorder DESC, t.$orderby $ascdesc LIMIT ".($filterbool ? $start_limit : $start_limit - $stickycount).", $tpp"); */ /*---- $query = $sdb->query("SELECT t.*,count(a.tid) as aaa FROM {$tablepre}threads t LEFT JOIN {$tablepre}attachments a on a.tid = t.tid AND a.width > 0 WHERE t.fid='$fid' $filteradd AND $displayorderadd GROUP BY t.tid ORDER BY t.displayorder DESC, t.$orderby $ascdesc LIMIT ".($filterbool ? $start_limit : $start_limit - $stickycount).", $tpp"); ----*/ } else { /* $querysticky = $sdb->query("SELECT t.* FROM {$tablepre}threads t WHERE t.tid IN ($stickytids) AND t.displayorder IN (2, 3, 4) ORDER BY displayorder DESC, $orderby $ascdesc LIMIT $start_limit, ".($stickycount - $start_limit < $tpp ? $stickycount - $start_limit : $tpp)); */ /*---- $querysticky = $sdb->query("SELECT t.* FROM {$tablepre}threads t LEFT JOIN {$tablepre}attachments a on a.tid = t.tid AND a.width > 0 WHERE t.tid IN ($stickytids) AND t.displayorder IN (2, 3, 4) GROUP BY t.tid ORDER BY displayorder DESC, $orderby $ascdesc LIMIT $start_limit, ".($stickycount - $start_limit < $tpp ? $stickycount - $start_limit : $tpp)); ----*/ if($tpp - $stickycount + $start_limit > 0) { /* $query = $sdb->query("SELECT t.* FROM {$tablepre}threads t WHERE t.fid='$fid' $filteradd AND $displayorderadd ORDER BY displayorder DESC, $orderby $ascdesc LIMIT ".($tpp - $stickycount + $start_limit)); */ /*---- $query = $sdb->query("SELECT t.*,count(a.tid) as aaa FROM {$tablepre}threads t LEFT JOIN {$tablepre}attachments a on a.tid = t.tid AND a.width > 0 WHERE t.fid='$fid' $filteradd AND $displayorderadd GROUP BY t.tid ORDER BY displayorder DESC, $orderby $ascdesc LIMIT ".($tpp - $stickycount + $start_limit)); ----*/ } else { $query = ''; } }

第二步 .目录templates/(你所用的模板文件，一般为dafeult)/forumdisplay.htm

找到下面代码段，然后之间的内容插到相应位置，并去掉符号

<span id="thread_$thread[tid]"><a href="viewthread.php?tid=$thread[tid]&extra=$extra" mce_href="viewthread.php?tid=$thread[tid]&extra=$extra"$thread[highlight]>$thread[subject]</a>  </span>