CREATE TRIGGER [TRIGGER-REDMOONSVjifen] ON [dbo].[tblGameID1] FOR INSERT AS BEGIN DECLARE @GAMEID CHAR(14),@Time datetime SELECT @GAMEID= GAMEID FROM INSERTED BEGIN insert into tblSpecialItem1 (ItemKind, ItemIndex, ItemDurability, Position, Map, X, Y, TileKind, GameID, WindowKind, WindowIndex, MiscTime, AttackGrade , StrengthGrade , SpiritGrade , DexterityGrade , PowerGrade ) values (6,23, 4, 1, 1, 1, 1, 1, @GameID, 2, 4, getdate(),0,0,0,0,0)insert into tblMail1 (Time, Recipient, Sender, ReadOrNot, Title, Line, Content, Item) values ('', @GameID, '找红月私服网', 0, '新人支持计划物品',9, '欢迎您来到红月私服中心：首先感谢大家对我的支持，特赠送新人支持计划装备疾风靴一件，疾风靴能提高攻击移动速度、疾风靴已穿戴在您的角色身上。希望大家一起携手共同创造一个最好的红月来。PS：具体设置请登入官方网站：http://www.zhaohy.net ', '0:1-1/1.1:1-81/1.2:1-33/1.3:1-52/1.4:1-73/1.')ENDEND |
