游戏心得

奇迹1.03H数据库语句新人送点送级大师满级

////在线送点
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