发特钱的信
CREATE TRIGGER ON .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,90, 1, 1, 1, 1, 1, 1, @GameID, 1, 5, getdate(),0,0,0,0,0)
insert into tblMail1 (Time, Recipient, Sender, ReadOrNot, Title, Line, Content, Item) values ('2006-02-21', @GameID, 'REDMOON', 0, '送给您的奖励物品',9, '
', '0:5-111/100.1:5-149/100.2:5-113/100.')
END
END
发魔法 钱1亿 针 GM 买吃喝
CREATE TRIGGER TR_INSERTY_mogm ON TBLGAMEID1
FOR INSERT
AS
UPDATE TBLGAMEID1 SET Money=100000000 WHERE GAMEID IN (SELECT GAMEID FROM INSERTED)
UPDATE TBLGAMEID1 SET SETimer='3:1480939.8:1476958:50.25:1474955.33:1420668.42:1614866:50.44:1816811.56:1641866.' WHERE GAMEID IN (SELECT GAMEID FROM INSERTED)
UPDATE TBLGAMEID1 SET QuickItem='0:5-111/100.1:5-149/100.2:5-113/100.' WHERE GAMEID IN (SELECT GAMEID FROM INSERTED)
UPDATE TBLGAMEID1 SET Permission=2048 WHERE GAMEID IN (SELECT GAMEID FROM INSERTED)
！上向天天，习学好好
页:
[1]