奇迹MU角色职业自动转职触发器

Published: May 11, 2024   Comment: No Comments

游戏数据库 如果觉得对你有帮助，并想支持我，可以适当打赏以作勉励，点击打赏

奇迹MU角色职业自动转职触发器

CREATE TRIGGER 角色职业自动转职触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Class=3
FROM Inserted
WHERE Inserted.Class=0 and Character.accountid=inserted.accountid
and Character.name=inserted.name

UPDATE Character SET Class=19
FROM Inserted
WHERE Inserted.Class=16 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET Class=35
FROM Inserted
WHERE Inserted.Class=32 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET Class=50
FROM Inserted
WHERE Inserted.Class=48 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET Class=66
FROM Inserted
WHERE Inserted.Class=64 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET Class=83
FROM Inserted
WHERE Inserted.Class=80 and Character.accountid=inserted.accountid
and Character.name=inserted.name
SET NOCOUNT OFF