无度站

禁止玩家[GM][DEV][DEKARON][OPR]
GM权限SQL语句！
CREATE TRIGGER ATest
ON character.dbo.user_character
FOR INSERT, UPDATE
AS
declare @tmp varchar(40)
select @tmp=I.character_name from inserted I
if patindex('%GM%',@tmp)>0
begin
ROLLBACK TRANSACTION
END
if patindex('%DEV%',@tmp)>0
begin
ROLLBACK TRANSACTION
END5
if patindex('%DEKARON%',@tmp)>0
begin
ROLLBACK TRANSACTION
END
if patindex('%OPR%',@tmp)>0
begin
ROLLBACK TRANSACTION
END