欢迎来到奇迹MuOnline中文网
1656351178
当前位置:主页 > 新闻资讯 > 技术动态 >

新角色自动三转SQL语句

发布日期:2022-06-16 浏览次数:

CREATE TRIGGER 法师自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=3
UPDATE Character SET Character.Quest=0xEADAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=1
SET NOCOUNT OFF
 
 
CREATE TRIGGER 战士自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=19
UPDATE Character SET Character.Quest=0xAAF6FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=17
SET NOCOUNT OFF
 
 
CREATE TRIGGER 弓箭自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=35
UPDATE Character SET Character.Quest=0xEADAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=33
SET NOCOUNT OFF
 
 
CREATE TRIGGER 魔剑自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=50
UPDATE Character SET Character.Quest=0xFFEAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=48
SET NOCOUNT OFF
 
 
CREATE TRIGGER 圣导自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=66
UPDATE Character SET Character.Quest=0xFFEAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=64
SET NOCOUNT OFF
 
 
CREATE TRIGGER 召唤自动三转触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=83
UPDATE Character SET Character.Quest=0xEAEAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FROM Inserted
Where Inserted.cLevel=400 and Inserted.Class=80
SET NOCOUNT OFF