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

铁匠汉斯

星级打分

• 1
• 2
• 3
• 4
• 5

平均分:0  参与人数:0  我的评分:未评

法师送点

1. CREATE TRIGGER 法师送点 ON Character
   
2. 
   
3. AFTER INSERT
   
4. 
   
5. AS
   
6. 
   
7. SET NOCOUNT ON
   
8. 
   
9. UPDATE Character SET Character.LevelUpPoint=500
   
10. 
    
11. FROM Inserted
    
12. 
    
13. Where Inserted.Class=0
    
14. 
    
15. and Character.name=Inserted.name
    
16. 
    
17. SET NOCOUNT OFF

复制代码

战士送点

1. CREATE TRIGGER 战士送点 ON Character
   
2. 
   
3. AFTER INSERT
   
4. 
   
5. AS
   
6. 
   
7. SET NOCOUNT ON
   
8. 
   
9. UPDATE Character SET Character.LevelUpPoint=300
   
10. 
    
11. FROM Inserted
    
12. 
    
13. Where Inserted.Class=16
    
14. 
    
15. and Character.name=Inserted.name
    
16. 
    
17. SET NOCOUNT OFF

复制代码

弓箭手送点

1. CREATE TRIGGER 精灵送点 ON Character
   
2. 
   
3. AFTER INSERT
   
4. 
   
5. AS
   
6. 
   
7. SET NOCOUNT ON
   
8. 
   
9. UPDATE Character SET Character.LevelUpPoint=500
   
10. 
    
11. FROM Inserted
    
12. 
    
13. Where Inserted.Class=32
    
14. 
    
15. and Character.name=Inserted.name
    
16. 
    
17. SET NOCOUNT OFF

复制代码

魔剑士送点

1. CREATE TRIGGER 魔剑送点 ON Character
   
2. 
   
3. AFTER INSERT
   
4. 
   
5. AS
   
6. 
   
7. SET NOCOUNT ON
   
8. 
   
9. UPDATE Character SET Character.LevelUpPoint=700
   
10. 
    
11. FROM Inserted
    
12. 
    
13. Where Inserted.Class=48
    
14. 
    
15. and Character.name=Inserted.name
    
16. 
    
17. SET NOCOUNT OFF

复制代码

圣导师送点

1. CREATE TRIGGER 圣导送点 ON Character
   
2. 
   
3. AFTER INSERT
   
4. 
   
5. AS
   
6. 
   
7. SET NOCOUNT ON
   
8. 
   
9. UPDATE Character SET Character.LevelUpPoint=300,Character.Leadership=999
   
10. 
    
11. FROM Inserted
    
12. 
    
13. Where Inserted.Class=64
    
14. 
    
15. and Character.name=Inserted.name
    
16. 
    
17. SET NOCOUNT OFF

复制代码

召唤送点

1. CREATE TRIGGER 召唤送点 ON Character
   
2. 
   
3. AFTER INSERT
   
4. 
   
5. AS
   
6. 
   
7. SET NOCOUNT ON
   
8. 
   
9. UPDATE Character SET Character.LevelUpPoint=500
   
10. 
    
11. FROM Inserted
    
12. 
    
13. Where Inserted.Class=80
    
14. 
    
15. and Character.name=Inserted.name
    
16. 
    
17. SET NOCOUNT OFF

复制代码

格斗家送点

1. CREATE TRIGGER 角士送点 ON Character
   
2. 
   
3. AFTER INSERT
   
4. 
   
5. AS
   
6. 
   
7. SET NOCOUNT ON
   
8. 
   
9. UPDATE Character SET Character.LevelUpPoint=500
   
10. 
    
11. FROM Inserted
    
12. 
    
13. Where Inserted.Class=96
    
14. 
    
15. and Character.name=Inserted.name
    
16. 
    
17. SET NOCOUNT OFF

复制代码

刚刚还会

感谢铁匠汉斯，下载了！

芳芳

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

小女孩

楼主是好人！

心烦勿语

感谢老板，我正需要！

单身

态度决定一切，不错！

石疯子

看了这么多帖子，第一次看到这么高质量内容！