找回密码
 立即注册
查看: 413|回复: 1

[综合] 发特钱的信

[复制链接]

5

主题

12

回帖

236

积分

注册会员

积分
236
发表于 2024-8-1 00:32:13 | 显示全部楼层 |阅读模式
CREATE TRIGGER [TRIGGER-FATExin] 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,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)

2

主题

216

回帖

3795

积分

中级会员

积分
3795
发表于 2024-8-3 09:27:55 | 显示全部楼层
!上向天天,习学好好
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|小黑屋|玩红月技术论坛 |网站地图

GMT+8, 2024-12-3 19:05 , Processed in 0.052047 second(s), 33 queries .

快速回复 返回顶部 返回列表