Discuz!NT官方社区

<script type="text/javascript" src="tools/showtopics.aspx?template=4&agg=3&ordertype=0">
显示出来的是最老的日志
用2.0的源代码发现
D:\Source Code\Discuz.Data.SqlServer\WebsiteManage.cs

  public DataTable GetWebSiteAggSpacePostList(int topnumber)
        {
            return DbHelper.ExecuteDataset(" SELECT TOP " + topnumber + " [postid], [author], [uid], [postdatetime], [title], [commentcount], [views] FROM [" + BaseConfigs.GetTablePrefix + "spaceposts] WHERE [poststatus] = 1").Tables[0];
        }

        public DataTable GetWebSiteAggRecentUpdateSpaceList(int topnumber)
        {
            return DbHelper.ExecuteDataset(" SELECT TOP " + topnumber + " [spaceid], [userid], [spacetitle], [postcount], [commentcount], [visitedtimes] FROM [" + BaseConfigs.GetTablePrefix + "spaceconfigs] WHERE [status] = 0 AND [postcount]>0 ORDER BY [updatedatetime] DESC").Tables[0];
        }

        public DataTable GetWebSiteAggTopSpaceList(string orderby,int topnumber)
        {
            return DbHelper.ExecuteDataset(" SELECT TOP " + topnumber + " s.*,u.[avatar] FROM [" + BaseConfigs.GetTablePrefix + "spaceconfigs] s LEFT JOIN [" + BaseConfigs.GetTablePrefix + "userfields] u ON s.[userid] = u.[uid]  WHERE s.[status] = 0 ORDER BY s.[" + orderby + "] DESC").Tables[0];
        }

我看GetWebSiteAggSpacePostList 最后没有加DESC
实际应该是

public DataTable GetWebSiteAggSpacePostList(int topnumber)
        {
            return DbHelper.ExecuteDataset(" SELECT TOP " + topnumber + " [postid], [author], [uid], [postdatetime], [title], [commentcount], [views] FROM [" + BaseConfigs.GetTablePrefix + "spaceposts] WHERE [poststatus] = 1 ORDER BY [postid] DESC").Tables[0];
        }
不知道是不是一个bug

感谢您的反馈