Discuz.Web/upgrade/sqlscript/sqlserver/upgradeprocedure_2000.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

IF OBJECT_ID('dnt_checkemailandsecques','P') IS NOT NULL
DROP PROC dnt_checkemailandsecques
GO

CREATE PROCEDURE dnt_checkemailandsecques
@username nchar(20),
@email char(50),
@secques char(8)
AS
SELECT TOP 1 [uid] FROM [dnt_users] WHERE [username]=@username AND [email]=@email AND [secques]=@secques
GO

IF OBJECT_ID('dnt_checkpasswordandsecques','P') IS NOT NULL
DROP PROC dnt_checkpasswordandsecques
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

IF OBJECT_ID('dnt_checkpasswordbyuid','P') IS NOT NULL
DROP PROC dnt_checkpasswordbyuid
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

IF OBJECT_ID('dnt_checkpasswordbyusername','P') IS NOT NULL
DROP PROC dnt_checkpasswordbyusername
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

IF OBJECT_ID('dnt_createadmingroup','P') IS NOT NULL
DROP PROC dnt_createadmingroup
GO

CREATE PROCEDURE dnt_createadmingroup
	@admingid smallint,
	@alloweditpost tinyint,
	@alloweditpoll tinyint,
	@allowstickthread tinyint,
	@allowmodpost tinyint,
	@allowdelpost tinyint,
	@allowmassprune tinyint,
	@allowrefund tinyint,
	@allowcensorword tinyint,