铁匠汉斯 发表于 2023-11-11 14:57:08

1.03H、S6版本各职业分别送点 执行语句

法师送点CREATE TRIGGER 法师送点 ON Character

AFTER INSERT

AS

SET NOCOUNT ON

UPDATE Character SET Character.LevelUpPoint=500

FROM Inserted

Where Inserted.Class=0

and Character.name=Inserted.name

SET NOCOUNT OFF战士送点CREATE TRIGGER 战士送点 ON Character

AFTER INSERT

AS

SET NOCOUNT ON

UPDATE Character SET Character.LevelUpPoint=300

FROM Inserted

Where Inserted.Class=16

and Character.name=Inserted.name

SET NOCOUNT OFF弓箭手送点CREATE TRIGGER 精灵送点 ON Character

AFTER INSERT

AS

SET NOCOUNT ON

UPDATE Character SET Character.LevelUpPoint=500

FROM Inserted

Where Inserted.Class=32

and Character.name=Inserted.name

SET NOCOUNT OFF魔剑士送点CREATE TRIGGER 魔剑送点 ON Character

AFTER INSERT

AS

SET NOCOUNT ON

UPDATE Character SET Character.LevelUpPoint=700

FROM Inserted

Where Inserted.Class=48

and Character.name=Inserted.name

SET NOCOUNT OFF圣导师送点CREATE TRIGGER 圣导送点 ON Character

AFTER INSERT

AS

SET NOCOUNT ON

UPDATE Character SET Character.LevelUpPoint=300,Character.Leadership=999

FROM Inserted

Where Inserted.Class=64

and Character.name=Inserted.name

SET NOCOUNT OFF召唤送点CREATE TRIGGER 召唤送点 ON Character

AFTER INSERT

AS

SET NOCOUNT ON

UPDATE Character SET Character.LevelUpPoint=500

FROM Inserted

Where Inserted.Class=80

and Character.name=Inserted.name

SET NOCOUNT OFF格斗家送点CREATE TRIGGER 角士送点 ON Character

AFTER INSERT

AS

SET NOCOUNT ON

UPDATE Character SET Character.LevelUpPoint=500

FROM Inserted

Where Inserted.Class=96

and Character.name=Inserted.name

SET NOCOUNT OFF

刚刚还会 发表于 2023-12-5 02:51:24

感谢铁匠汉斯，下载了！

芳芳 发表于 2023-12-5 23:59:16

大神就是大神，这么经典！

小女孩 发表于 2023-12-6 00:00:17

楼主是好人！

心烦勿语 发表于 2023-12-6 02:06:01

感谢老板，我正需要！

单身 发表于 2023-12-17 15:42:12

态度决定一切，不错！

石疯子 发表于 2023-12-17 15:50:14

看了这么多帖子，第一次看到这么高质量内容！
页: [1]
查看完整版本: 1.03H、S6版本各职业分别送点 执行语句