法师自动三转触发器
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
以上是角色上线后自动完成三转任务,例如战士新角色上线就是神骑士。下面语句是角色送转生的设置
新角色自动送转触发器
CREATE TRIGGER 新角色自动送转触发器 ON Character AFTER INSERT AS SET NOCOUNT ON UPDATE Character SET 保存转身次数表项名称=需要送的转数 FROM Inserted WHERE Inserted.保存转身次数表项名称=0 and Character.accountid=inserted.accountid and Character.name=inserted.nameSET NOCOUNT OFF
评论0