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