if exists (select * from sysobjects where id = object_id(N'[dnt_getadmintopiclist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_getadmintopiclist]
GO
CREATE PROCEDURE [dnt_getadmintopiclist]
@pagesize int,
@pageindex int,
@startnum int,
@condition varchar(80)
AS
DECLARE @strSQL varchar(5000)
IF @pageindex = 1
BEGIN
SET @strSQL = 'SELECT TOP ' + STR(@pagesize) +' [tid],[iconid],[title],
[poster],[posterid],[replies],[views],[postdatetime],[lastpost],[lastposter],[price],
[lastpostid],[lastposterid],[replies],[highlight],[digest],[displayorder],[closed],[magic] FROM
[dnt_topics] WHERE '+ @condition + ' ORDER BY [lastpostid] DESC'
END
ELSE
BEGIN
SET @strSQL = 'SELECT TOP ' + STR(@pagesize) +' [tid],[iconid],[title],
[special],[poster],[posterid],[replies],[views],[postdatetime],[lastpost],[lastposter],[price],
[lastpostid],[lastposterid],[replies],[highlight],[digest],[displayorder],[closed],[magic] FROM
[dnt_topics] WHERE [lastpostid] < (SELECT min([lastpostid]) FROM (SELECT TOP ' + STR
((@pageindex-1)*@pagesize-@startnum) + ' [lastpostid] FROM [dnt_topics] WHERE [displayorder]=0' + @condition + ' ORDER BY [lastpostid] DESC) AS tblTmp )
AND ' + @condition + ' ORDER BY [lastpostid] DESC'
END
EXEC(@strSQL)
GO
if exists (select * from sysobjects where id = object_id(N'[dnt_deletetopicbytidlist]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletetopicbytidlist]
GO
CREATE PROCEDURE [dnt_deletetopicbytidlist]
@tidlist AS VARCHAR(2000),
@posttablename AS VARCHAR(20),
@chanageposts AS BIT
AS
DECLARE @postcount int
DECLARE @topiccount int
DECLARE @todaycount int
DECLARE @sqlstr nvarchar(4000)
DECLARE @fid varchar(2000)
DECLARE @posterid varchar(200)
DECLARE @tempFid int
DECLARE @tempPosterid int
DECLARE @tempLayer int
DECLARE @temppostdatetime datetime
DECLARE @tempfidlist AS VARCHAR(1000)
SET @fid = ''
SET @posterid = ''
SET @postcount=0
SET @topiccount=0
SET @todaycount=0
SET @tempfidlist = '';
IF @tidlist<>''
BEGIN
SET @sqlstr = 'DECLARE cu_dnt_posts CURSOR FOR SELECT [fid],[posterid],[layer],[postdatetime] FROM [' + @posttablename + '] WHERE [tid] IN (' + @tidlist + ')'
EXEC (@sqlstr)
OPEN cu_dnt_posts
FETCH NEXT FROM cu_dnt_posts into @tempFid,@tempPosterid,@tempLayer,@temppostdatetime
WHILE @@FETCH_STATUS = 0
BEGIN
SET @postcount = @postcount + 1
IF @tempLayer = 0
BEGIN
SET @topiccount = @topiccount + 1
END
IF DATEDIFF(d,@temppostdatetime,GETDATE()) = 0
BEGIN
SET @todaycount = @todaycount + 1
END
IF CHARINDEX(',' + LTRIM(STR(@tempFid)) + ',',@fid + ',') = 0
BEGIN
--SET @fid = @fid + ',' + LTRIM(STR(@tempFid))
SELECT @tempfidlist = ISNULL([parentidlist],'') FROM [dnt_forums] WHERE [fid] = @tempFid
IF RTRIM(@tempfidlist)<>''
BEGIN
SET @fid = RTRIM(@fid) + ',' + RTRIM(@tempfidlist) + ',' + CAST(@tempFid AS VARCHAR(10))
END
ELSE
BEGIN
SET @fid =RTRIM(@fid) + ',' + CAST(@tempFid AS VARCHAR(10))
END
END
IF @chanageposts = 1
BEGIN
UPDATE [dnt_users] SET [posts] = [posts] - 1 WHERE [uid] = @tempPosterid
END
FETCH NEXT FROM cu_dnt_posts into @tempFid,@tempPosterid,@tempLayer,@temppostdatetime
END
CLOSE cu_dnt_posts
DEALLOCATE cu_dnt_posts
IF LEN(@fid)>0
BEGIN
SET @fid = SUBSTRING(@fid,2,LEN(@fid)-1)
IF @chanageposts = 1
BEGIN
UPDATE [dnt_statistics] SET [totaltopic]=[totaltopic] - @topiccount, [totalpost]=[totalpost] - @postcount
SET @sqlstr = 'UPDATE [dnt_forums] SET [posts]=[posts] - ' + cast(@postcount AS VARCHAR(10)) +
', [topics]=[topics] - ' + cast(@topiccount AS VARCHAR(10)) +
', [todayposts] = [todayposts] - ' + cast(@todaycount AS VARCHAR(10)) +
' WHERE [fid] IN (' + @fid + ')'
EXEC (@sqlstr)
END
SET @sqlstr = 'DELETE FROM [dnt_favorites] WHERE [tid] IN (' + @tidlist + ') AND [typeid]=0'
EXEC (@sqlstr)
SET @sqlstr = 'DELETE FROM [dnt_polls] WHERE [tid] IN (' + @tidlist + ')'
EXEC (@sqlstr)
SET @sqlstr = 'DELETE FROM [' + @posttablename + '] WHERE [tid] IN (' + @tidlist + ')'
EXEC (@sqlstr)
SET @sqlstr = 'DELETE FROM [dnt_mytopics] WHERE [tid] IN (' + @tidlist + ')'
EXEC(@sqlstr)
END
SET @sqlstr = 'DELETE FROM [dnt_topics] WHERE [closed] IN (' + @tidlist + ') OR [tid] IN (' + @tidlist + ')'
EXEC (@sqlstr)
SET @sqlstr = 'UPDATE [dnt_tags] SET [count]=[count]-1, [fcount]=[fcount]-1 WHERE [tagid] IN (SELECT [tagid] FROM [dnt_topictags] WHERE [tid] IN (' + @tidlist + '))'
EXEC (@sqlstr)
SET @sqlstr = 'DELETE FROM [dnt_topictags] WHERE [tid] IN (' + @tidlist + ')'
EXEC (@sqlstr)
SET @sqlstr = 'DELETE FROM [dnt_topictagcaches] WHERE [tid] IN (' + @tidlist + ') OR [linktid] IN (' + @tidlist + ')'
END
GO
if exists (select * from sysobjects where id = object_id(N'[dnt_deletepost1bypid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dnt_deletepost1bypid]
GO
CREATE PROCEDURE [dnt_deletepost1bypid]
@pid int,
@chanageposts AS BIT
AS
DECLARE @fid int
DECLARE @tid int
DECLARE @posterid int
DECLARE @lastforumposterid int
DECLARE @layer int
DECLARE @postdatetime smalldatetime
DECLARE @poster varchar(50)
DECLARE @postcount int
DECLARE @title nchar(60)
DECLARE @lasttid int
DECLARE @postid int
DECLARE @todaycount int
SELECT @fid = [fid],@tid = [tid],@posterid = [posterid],@layer = [layer], @postdatetime = [postdatetime] FROM [dnt_posts1] WHERE pid = @pid
DECLARE @fidlist AS VARCHAR(1000)
SET @fidlist = '';
SELECT @fidlist = ISNULL([parentidlist],'') FROM [dnt_forums] WHERE [fid] = @fid
IF RTRIM(@fidlist)<>''
BEGIN
SET @fidlist = RTRIM(@fidlist) + ',' + CAST(@fid AS VARCHAR(10))
END
ELSE
BEGIN
SET @fidlist = CAST(@fid AS VARCHAR(10))
END
IF @layer<>0
BEGIN
IF @chanageposts = 1
BEGIN
UPDATE [dnt_statistics] SET [totalpost]=[totalpost] - 1
UPDATE [dnt_forums] SET
[posts]=[posts] - 1,
[todayposts]=CASE
WHEN DATEPART(yyyy, @postdatetime)=DATEPART(yyyy,GETDATE()) AND DATEPART(mm, @postdatetime)=DATEPART(mm,GETDATE()) AND DATEPART(dd, @postdatetime)=DATEPART(dd,GETDATE()) THEN [todayposts] - 1
ELSE [todayposts]
END
WHERE (CHARINDEX(',' + RTRIM([fid]) + ',', ',' +
(SELECT @fidlist AS [fid]) + ',') > 0)
UPDATE [dnt_users] SET [posts] = [posts] - 1 WHERE [uid] = @posterid
UPDATE [dnt_topics] SET [replies]=[replies] - 1 WHERE [tid]=@tid
END
DELETE FROM [dnt_posts1] WHERE [pid]=@pid
END
ELSE
[论坛社区]Discuz!NT 2.6.1 源码包 Bulid 090305_dnt_n2_src.zip （7331个子文件） 
usergrouppowersetting.ascx 8KB ajaxviewuserpost.ascx 6KB ajaxuserbloglist.ascx 5KB ajaxuserspacecommentlist.ascx 4KB ajaxtopicinfo.ascx 4KB ajaxsubmitcomment.ascx 3KB ajaxspaceinfo.ascx 3KB ajaxspacepostinfo.ascx 3KB ajaxalbumlist.ascx 3KB ajaxphotoinfo.ascx 2KB uploadfile.ascx 2KB ajaxuseralbums.ascx 2KB forumstree.ascx 2KB fronttop.ascx 2KB ajaxuserbloglistbydate.ascx 2KB shortcutmenu.ascx 2KB textarearesize.ascx 2KB onlineeditor.ascx 1KB ajaxtopnewcomment.ascx 1KB ajaxtopnewpost.ascx 1KB ajaxspacelink.ascx 1011B ajaxspaceconfigstatic.ascx 992B frontleftnavmenu.ascx 841B ajaxpostinfo.ascx 801B spacecalendar.ascx 686B pageinfo.ascx 576B dropdownpost.ascx 287B frontbottom.ascx 222B AddTopictype.ascx 187B searchfunction.ascx 174B searchuser.ascx 166B favoritefunction.ascx 157B MetaBlog.ashx 74B MixObjects.asmx 75B editgoods.aspx 134KB editpost.aspx 132KB showforum.aspx 127KB showtopic.aspx 122KB posttopic.aspx 121KB postgoods.aspx 118KB showtree.aspx 108KB postreply.aspx 105KB showbonus.aspx 101KB modcp.aspx 100KB website.aspx 71KB showdebate.aspx 69KB showgoods.aspx 68KB topicadmin.aspx 67KB register.aspx 64KB search.aspx 62KB usercpmygoods.aspx 62KB showgoodslist.aspx 59KB forumindex.aspx 57KB offlinetrade.aspx 53KB usercp.aspx 53KB stats.aspx 51KB usercpspacephotoadd.aspx 47KB global_edituser.aspx 45KB tags.aspx 45KB showtopiclist.aspx 43KB usercppreference.aspx 43KB usercpshopgoodsmanage.aspx 43KB userinfo.aspx 41KB onlinetrade.aspx 41KB spaceindex.aspx 40KB usercpspacemanagealbum.aspx 38KB usercpspaceset.aspx 38KB showphoto.aspx 37KB goodsadmin.aspx 37KB usercpshowpm.aspx 37KB usercpinbox.aspx 36KB usercpdraftbox.aspx 36KB usercpsentbox.aspx 36KB usercpspacemanagephoto.aspx 36KB buytopic.aspx 35KB usercpspaceeditblog.aspx 35KB usercppostpm.aspx 35KB usercpnotice.aspx 35KB usercpspacepostblog.aspx 35KB usercpprofile.aspx 34KB mallindex.aspx 34KB usercppmset.aspx 34KB usercpshopcategory.aspx 34KB usercpannouncepm.aspx 33KB albumindex.aspx 33KB mallgoodslist.aspx 33KB usercpspacemanageblog.aspx 33KB usercpspacemanageattachment.aspx 33KB usercpshoplink.aspx 33KB usercpignorelist.aspx 33KB usercpspacemanagecategory.aspx 33KB forum_editforums.aspx 33KB usercpspacelinklist.aspx 33KB global_editadvs.aspx 33KB usercpnewpassword.aspx 32KB usercpcreditspay.aspx 32KB usercpsubscribe.aspx 32KB buygoods.aspx 32KB usercpspacecomment.aspx 32KB usercpcreditstransfer.aspx 32KB共 7331 条
- 1
- 2
- 3
- 4
- 5
- 6
- 74
资源评论
