决战DROIYAN ONLINE角色上线触发器-20-新手上线奖励
CREATE TRIGGER [ZHUANGBEI] ON [dbo].[GameUser] WITH ENCRYPTION
after Insert
as
declare @name nvarchar(20)
SELECT @name=strUserID FROM INSERTED
Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF000000000000000000000000000000000000000000000000000001000100E8030000010000000000000000000000000000000000000000001400F302010003000100266666890008000000000003000000000000000005004A0301000300010026666689000800000000000300000000000000000500B10201000300010026666689000800000000000300000000000000000000FFFF00000000000000000000000000000000000000000000000000000300C100D007000001005D0000000005000000000003000000000000000046005101C05D000001005D00000000050000000000030000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A0000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WHERE strUserID=@name and byClass=0
Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF000000000000000000000000000000000000000000000000000001000300E8030000010000000000000000000000000000000000000000001400F302010003000100266666890008000000000003000000000000000005004A0301000300010026666689000800000000000300000000000000000500B10201000300010026666689000800000000000300000000000000000000FFFF000000000000000000000000000000000000000000000000000003009C00D00700000100880000000005000000000003000000000000000046004A01C05D000001008800000000050000000000030000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A0000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WHERE strUserID=@name and byClass=1
Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF000000000000000000000000000000000000000000000000000001000700E803FA00010000000000000000000000000000000000000000001400F302010003000100266666890008000000000003000000000000000005004A0301000300010026666689000800000000000300000000000000000500B10201000300010026666689000800000000000300000000000000000000FFFF000000000000000000000000000000000000000000000000000003007C00A00F000001005D0000000005000000000003000000000000000046004301C05D000001005D00000000050000000000030000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A0000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WHERE strUserID=@name and byClass=2
Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF000000000000000000000000000000000000000000000000000001000A00E803FA00010000000000000000000000000000000000000000001400F302010003000100266666890008000000000003000000000000000005004A0301000300010026666689000800000000000300000000000000000500B10201000300010026666689000800000000000300000000000000000000FFFF000000000000000000000000000000000000000000000000000003005900A00F000001005D0000000005000000000003000000000000000046003C01C05D000001005D00000000050000000000030000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A0000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WHERE strUserID=@name and byClass=3
相关文章
- 传奇教程 GOM引擎RMB地图脚本,传奇私服一条龙设置RMB点进入地图的方法 传奇脚本
- 传奇教程 GOM引擎转生地图脚本,传奇开区时添加需要转生进入地图的命令 传奇脚本
- 传奇教程 GOM引擎九零土豪脚本,传奇一条龙开区时添加VIP称号地图命令 传奇脚本
- 传奇教程 GOM引擎首冲地图脚本,传奇私服一条龙添加首充地图的教程 传奇脚本
- 传奇教程 GOM引擎贪婪老人地图脚本,传奇服务端添加三相幻想脚本教程 传奇脚本
- 传奇教程 GEE提升人物属性脚本,传奇一条龙开区时设置狂暴属性状态 传奇脚本
- 传奇教程 GEE引擎附魔系统脚本,传奇私服版本添加首饰附魔的教程和范例 传奇脚本
- 传奇教程 GOM引擎超级回馈大礼脚本,传奇版本中添加回馈大礼的脚本示例 传奇脚本
- 传奇教程 GOM引擎传奇土城泡点脚本,传奇一条龙开区时添加土城自动安全泡点教程 传奇脚本
- 传奇教程 GEE引擎传奇提取充值点,传奇服务端中脚本提取充值点的命令和范例 传奇脚本