1 修正了已删除帖子仍可调用的问题;
2 修正了发帖排行调用昵称错误的问题;
3 统一了调用主题显示颜色;
4 热门话题改为最新回复,更新更快;
5 精华主题以最新发表排序。
预览地址http://www.china-radiology.com
下载地址http://nt.discuz.net/showtopic-127587.html
今日发帖修改
先创建一个存储过程
CREATE PROCEDURE fzl234_todaytopuser
as
SELECT top 10 posterid,poster,count(*) as postcount FROM dnt_posts1 WHERE datediff(d,[postdatetime],getdate())=0 group by posterid,poster order by postcount desc
GO
第二步 dnt_posts2现在使用的分表
alter PROCEDURE fzl234_todaytopuser
as
SELECT top 10 posterid,poster,count(*) as postcount FROM dnt_posts2 WHERE datediff(day,[postdatetime],getdate())=0 group by posterid,poster order by postcount desc
GO
第三步
<bbs:storeprocedure name="fzl234_todaytopuser">
<li><img src="{bbspath}fzl234.bbs/images/{num+1}.gif" /> <a href="{bbspath}userinfo-{$posterid}.aspx">{$poster,15}</a> (<font color="#ff0000">{$postcount}</font>)</li>
</bbs:storeprocedure>