Backup/Discuz.Web/upgrade/sqlscript/sqlserver/upgradeprocedure_2005.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,