103各职业分开送点,453mu私服自助发布网,453mu私服自助发布网,奇迹私发网,新开奇迹SF

CREATE TRIGGER [冲值送VIP] ON [dbo].[MEMB_INFO]
after Insert
as
UPDATE MEMB_INFO SET myCash = myCash+myCashVIP,member=1,myCashVIP = 0
FROM Inserted
Where Inserted.myCashVIP >= 100

删除指定分区的帐号
DELETE FROM memb_info WHERE servercode =1

CREATE TRIGGER [清空新人装备栏] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Inventory=0 From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name

圣导送统率：

CREATE TRIGGER [圣导统率] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Leadership=3000
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=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=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=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=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
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