当前位置 >> 网站首页 >> 奇迹私服发布网各职业分开送点触发器1.03H S6送点SQL

奇迹私服发布网各职业分开送点触发器1.03H S6送点SQL

更新时间:2019-8-3 文章作者: 1888mu.com 浏览次数:24

圣导送统率:

CREATE TRIGGER [圣导统率] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Leadership=600
From Inserted
Where Inserted.Class=64 and [Character].accountid=inserted.accountid
and [Character].name=inserted.name

CREATE TRIGGER 法师送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=1500
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=1500
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=1500
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=1500
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=1500
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=1500
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=300
FROM Inserted
Where Inserted.Class=96
and Character.name=Inserted.name
SET NOCOUNT OFF

 

 

--自动更新所有圣导师的统率为9999
Update [Character] set [Character].Leadership=9999 Where [Character].Class=64

SET NOCOUNT OFF
End
GO

 


CREATE    TRIGGER 新角色以职业送自由分配点触发器 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET LevelUpPoint=4000 --法师
FROM Inserted
WHERE Inserted.Class=0 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET LevelUpPoint=200 --战士
FROM Inserted
WHERE Inserted.Class=16 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET LevelUpPoint=600 --弓手
FROM Inserted
WHERE Inserted.Class=32 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET LevelUpPoint=400 --魔剑
FROM Inserted
WHERE Inserted.Class=48 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET LevelUpPoint=200,Leadership=600 --圣导
FROM Inserted
WHERE Inserted.Class=64 and Character.accountid=inserted.accountid
and Character.name=inserted.name
UPDATE Character SET LevelUpPoint=400 --召唤
FROM Inserted
WHERE Inserted.Class=80 and Character.accountid=inserted.accountid
and Character.name=inserted.name
SET NOCOUNT OFF

------该资料由 1888mu.com 整理发布!