演示地址：https://www.tuyuanma.com/tag.html
找到TAG.html" target="_blank" class="relatedlink">标签显示页，修改更换如下代码- <!--{eval $mtags = DB::fetch_all("SELECT a.tagid, a.tagname, count(b.tagid) as tag_count FROM ".DB::table("common_tag")." a LEFT JOIN ".DB::table("common_tagitem")." b on b.tagid=a.tagid WHERE a.`status` = 0 group by b.tagid ORDER BY a.`tagid` DESC LIMIT 0,480");}-->
- <div class="fmtags">
- <!--{loop $mtags $mtag}-->
- <!--{if $mtag[tag_count]>0}-->
- <a href="misc.php?mod=tag&id=$mtag[tagid]" target="_blank" class="xi2">$mtag[tagname]{$mtag[tag_count]}</a>
- <!--{/if}-->
- <!--{/loop}-->
- </div>
按标签相关帖子数排序代码- <!--{eval $mtags = DB::fetch_all("SELECT a.tagid, a.tagname, count(b.tagid) as tag_count FROM ".DB::table("common_tag")." a LEFT JOIN ".DB::table("common_tagitem")." b on b.tagid=a.tagid WHERE a.`status` = 0 group by b.tagid ORDER BY `tag_count` DESC LIMIT 0,480");}-->
- <div class="fmtags">
- <!--{loop $mtags $mtag}-->
- <!--{if $mtag[tag_count]>0}-->
- <a href="misc.php?mod=tag&id=$mtag[tagid]" target="_blank" class="xi2">$mtag[tagname]{$mtag[tag_count]}</a>
- <!--{/if}-->
- <!--{/loop}-->
- </div>
查询tag的两个表common_tag和common_tagitem，获取tagid，tagname两个字段，并统计tagid个数，分组合计，按tagid倒序排序，取前480条 |
2566
0
©2015-2022 www.tuyuanma.com 版权所有 Sitemap.xml
提升卡
置顶卡
沉默卡
变色卡
千斤顶
赣公网安备36112102000036号
赣ICP备17001544号-10