程序源码 Discuz!NT v2.5 Build 081029 SQL For .Net2.0（ASP.NET源码）.rar

CREATE PROCEDURE dnt_checkemailandsecques @username nchar(20), @email char(32), @secques char(8) AS SELECT TOP 1 [uid] FROM [dnt_users] WHERE [username]=@username AND [email]=@email AND [secques]=@secques GO CREATE PROCEDURE dnt_checkpasswordandsecques @username nchar(20), @password char(32), @secques char(8) AS SELECT TOP 1 [uid] FROM [dnt_users] WHERE [username]=@username AND [password]=@password AND [secques]=@secques GO CREATE PROCEDURE dnt_checkpasswordbyuid @uid int, @password char(32) AS SELECT TOP 1 [uid], [groupid], [adminid] FROM [dnt_users] WHERE [uid]=@uid AND [password]=@password GO CREATE PROCEDURE dnt_checkpasswordbyusername @username nchar(20), @password char(32) AS SELECT TOP 1 [uid], [groupid], [adminid] FROM [dnt_users] WHERE [username]=@username AND [password]=@password GO CREATE PROCEDURE dnt_createadmingroup @admingid smallint, @alloweditpost tinyint, @alloweditpoll tinyint, @allowstickthread tinyint, @allowmodpost tinyint, @allowdelpost tinyint, @allowmassprune tinyint, @allowrefund tinyint, @allowcensorword tinyint, @allowviewip tinyint, @allowbanip tinyint, @allowedituser tinyint, @allowmoduser tinyint, @allowbanuser tinyint, @allowpostannounce tinyint, @allowviewlog tinyint, @disablepostctrl tinyint, @allowviewrealname tinyint AS INSERT INTO dnt_admingroups ([admingid],[alloweditpost],[alloweditpoll],[allowstickthread],[allowmodpost],[allowdelpost],[allowmassprune],[allowrefund],[allowcensorword],[allowviewip],[allowbanip],[allowedituser],[allowmoduser],[allowbanuser],[allowpostannounce],[allowviewlog],[disablepostctrl],[allowviewrealname]) VALUES (@admingid,@alloweditpost,@alloweditpoll,@allowstickthread,@allowmodpost,@allowdelpost,@allowmassprune,@allowrefund,@allowcensorword,@allowviewip,@allowbanip,@allowedituser,@allowmoduser,@allowbanuser,@allowpostannounce,@allowviewlog,@disablepostctrl,@allowviewrealname) GO CREATE PROCEDURE dnt_createattachment @uid int, @tid int, @pid int, @postdatetime datetime, @readperm int, @filename nchar(200), @description nchar(200), @filetype nchar(100), @filesize int, @attachment nchar(200), @downloads int, @extname nvarchar(50) AS DECLARE @aid int INSERT INTO [dnt_attachments]([uid],[tid], [pid], [postdatetime], [readperm], [filename], [description], [filetype], [filesize], [attachment], [downloads]) VALUES(@uid, @tid, @pid, @postdatetime, @readperm, @filename, @description, @filetype, @filesize, @attachment, @downloads) SELECT SCOPE_IDENTITY() AS 'aid' set @aid=(SELECT SCOPE_IDENTITY() AS 'aid') UPDATE [dnt_posts1] SET [attachment]=1 WHERE [pid]=@pid INSERT INTO [dnt_myattachments]([aid],[uid],[attachment],[description],[postdatetime],[downloads],[filename],[pid],[tid],[extname]) VALUES(@aid,@uid,@attachment,@description,@postdatetime,@downloads,@filename,@pid,@tid,@extname) GO CREATE PROCEDURE dnt_createdebatepostexpand @tid int, @pid int, @opinion int, @diggs int AS BEGIN INSERT INTO [dnt_postdebatefields] VALUES(@tid, @pid, @opinion, @diggs) IF @opinion = 1 UPDATE [dnt_debates] SET [positivediggs] = [positivediggs] + 1 WHERE [tid] = @tid ELSE IF @opinion = 2 UPDATE [dnt_debates] SET [negativediggs] = [negativediggs] + 1 WHERE [tid] = @tid END GO CREATE PROCEDURE dnt_createfavorite @uid int, @tid int, @type tinyint AS INSERT INTO [dnt_favorites] ([uid],[tid],[typeid]) VALUES(@uid,@tid,@type) RETURN GO CREATE PROCEDURE dnt_createpm @pmid int, @msgfrom nvarchar(20), @msgto nvarchar(20), @msgfromid int, @msgtoid int, @folder smallint=0, @new int=0, @subject nvarchar(60), @postdatetime datetime, @message ntext, @savetosentbox smallint=1 AS IF @folder<>0 BEGIN SET @msgfrom=@msgto END ELSE BEGIN UPDATE [dnt_users] SET [newpmcount]=ABS(ISNULL([newpmcount],0)*1)+1,[newpm] = 1 WHERE [uid]=@msgtoid END INSERT INTO [dnt_pms] ([msgfrom],[msgfromid],[msgto],[msgtoid],[folder],[new],[subject],[postdatetime],[message]) VALUES (@msgfrom,@msgfromid,@msgto,@msgtoid,@folder,@new,@subject,@postdatetime,@message) SELECT SCOPE_IDENTITY() AS 'pmid' IF @savetosentbox=1 AND @folder=0 BEGIN INSERT INTO [dnt_pms] ([msgfrom],[msgfromid],[msgto],[msgtoid],[folder],[new],[subject],[postdatetime],[message]) VALUES (@msgfrom,@msgfromid,@msgto,@msgtoid,1,@new,@subject,@postdatetime,@message) END GO CREATE PROCEDURE dnt_createpost1 @fid int, @tid int, @parentid int, @layer int, @poster varchar(20), @posterid int, @title nvarchar(60), @topictitle nvarchar(60), @postdatetime char(20), @message ntext, @ip varchar(15), @lastedit varchar(50), @invisible int, @usesig int, @htmlon int, @smileyoff int, @bbcodeoff int, @parseurloff int, @attachment int, @rate int, @ratetimes int AS DEClARE @postid int DELETE FROM [dnt_postid] WHERE DATEDIFF(n, postdatetime, GETDATE()) >5 INSERT INTO [dnt_postid] ([postdatetime]) VALUES(GETDATE()) SELECT @postid=SCOPE_IDENTITY() INSERT INTO [dnt_posts1]([pid], [fid], [tid], [parentid], [layer], [poster], [posterid], [title], [postdatetime], [message], [ip], [lastedit], [invisible], [usesig], [htmlon], [smileyoff], [bbcodeoff], [parseurloff], [attachment], [rate], [ratetimes]) VALUES(@postid, @fid, @tid, @parentid, @layer, @poster, @posterid, @title, @postdatetime, @message, @ip, @lastedit, @invisible, @usesig, @htmlon, @smileyoff, @bbcodeoff, @parseurloff, @attachment, @rate, @ratetimes) IF @parentid=0 BEGIN UPDATE [dnt_posts1] SET [parentid]=@postid WHERE [pid]=@postid END IF @@ERROR=0 BEGIN IF @invisible = 0 BEGIN UPDATE [dnt_statistics] SET [totalpost]=[totalpost] + 1 DECLARE @fidlist AS VARCHAR(1000) DECLARE @strsql AS VARCHAR(4000) 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 UPDATE [dnt_forums] SET [posts]=[posts] + 1, [todayposts]=CASE WHEN DATEDIFF(day, [lastpost], GETDATE())=0 THEN [todayposts]*1 + 1 ELSE 1 END, [lasttid]=@tid, [lasttitle]=@topictitle, [lastpost]=@postdatetime, [lastposter]=@poster, [lastposterid]=@posterid WHERE (CHARINDEX(',' + RTRIM([fid]) + ',', ',' + (SELECT @fidlist AS [fid]) + ',') > 0) UPDATE [dnt_users] SET [lastpost] = @postdatetime, [lastpostid] = @postid, [lastposttitle] = @title, [posts] = [posts] + 1, [lastactivity] = GETDATE() WHERE [uid] = @posterid IF @layer<=0 BEGIN UPDATE [dnt_topics] SET [replies]=0,[lastposter]=@poster,[lastpost]=@postdatetime,[lastposterid]=@posterid WHERE [tid]=@tid END ELSE BEGIN UPDATE [dnt_topics] SET [replies]=[replies] + 1,[lastposter]=@poster,[lastpost]=@postdatetime,[lastposterid]=@posterid WHERE [tid]=@tid END END UPDATE [dnt_topics] SET [lastpostid]=@postid WHERE [tid]=@tid IF @posterid <> -1 BEGIN INSERT [dnt_myposts]([uid], [tid], [pid], [dateline]) VALUES(@posterid, @tid, @postid, @postdatetime) END END SELECT @postid AS postid GO CREATE PROCEDURE dnt_createsearchcache @keywords varchar(255), @searchstring varchar(255), @ip varchar(15), @uid int, @groupid int, @postdatetime varchar(19), @expiration varchar(19), @topics int, @tids text AS INSERT INTO dnt_searchcaches ([keywords],[searchstring],[ip],[uid],[groupid],[postdatetime],[expiration],[topics],[tids]) VALUES (@keywords,@searchstring,@ip,@uid,@groupid,@postdatetime,@expiration,@topics,@ti