////在线送点
CREATE TRIGGER [Restrict_songdian] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].LevelUpPoint =132000 From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name
//在线送级
CREATE TRIGGER [Restrict_songji] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].cLevel =400 From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name
圣导送9999统率:
CREATE TRIGGER [Leadership] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Leadership=9999
From Inserted
Where Inserted.Class=64 and [Character].accountid=inserted.accountid
and [Character].name=inserted.name
CREATE TRIGGER [大师满级满点] ON [dbo].[T_MasterLevelSystem]
FOR INSERT, UPDATE, DELETE
AS
update [T_MasterLevelSystem]
set [T_MasterLevelSystem].MASTER_LEVEL = 200
WHERE MASTER_LEVEL = 0 and ML_POINT = 0
update [T_MasterLevelSystem]
SET [T_MasterLevelSystem].ML_POINT = 200
WHERE MASTER_LEVEL = 200 and ML_POINT = 0
update [T_MasterLevelSystem]
SET [T_MasterLevelSystem].ML_EXP = 35507050
WHERE MASTER_LEVEL = 200 and ML_POINT = 200