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


Published:   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
Last Modified:2024-05-11 18:39:50

我有话说