决战DROIYAN ONLINE角色上线触发器-3-暴风身上

CREATE TRIGGER [ZHUANGBEI] ON [dbo].[GameUser] WITH ENCRYPTION 

after Insert 

as 

declare @name nvarchar(20)

SELECT @name=strUserID FROM INSERTED

Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF0000000000000000000000000000000000000000000000000000010078021E000000010000000000000000000000000000000000000000005A0073030100030001003A000000000000000000000200000000000000005A0078030100030001003A000000000000000000000200000000000000005A0086030100030001003A000000000000000000000200000000000000005A00DB030100030001003B0000000000000000000002000000000000000001000100E80300000100000000000000000000000000000000000000000064002804007D030001009F8D8B87A10A00000000000C000000000000000064001D04204E030001009F8D8B87A10A00000000000C000000000000000064002404007D030001009F8D8B87A10A00000000000C000000000000000064004404983A030001009F8D8B87A10A00000000000C000000000000000007003B00B80B030001005D920000000F00000000000300000000000000001400F30201000300010089000000000000000000000200000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF000000000000000000000000000000000000000000000000000001000100E80303000100A1A19E000005000000000003000000000000000001008D03000000000A0000000000000000000000000000000000000000004600020284670300010091715B5B000A00000000000300000000000000001400F30201000300010089000000000000000000000200000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,idn=10000 WHERE strUserID=@name and byClass=0

Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF0000000000000000000000000000000000000000000000000000010078021E0000000100000000000000000000000000000000000000000064003004007D030001009F8D8B87A30A00000000000C000000000000000064002C04007D030001009F8D8B87A30A00000000000C000000000000000064001D04204E030001009F8D8B87A30A00000000000C000000000000000064004404983A030001009F8D8B87A30A00000000000C000000000000000001008D03000000000A0000000000000000000000000000000000000000001400F30201000300010089000000000000000000000200000000000000001600F30201000300010089000000000000000000000200000000000000001D00B90028230300010091880000000F00000000000300000000000000000000FFFF000000000000000000000000000000000000000000000000000001000300E80303000100A1A19E00000500000000000300000000000000005A0075030100030001000E000000000000000000000200000000000000005A0088030100030001000E000000000000000000000200000000000000005A00DB030100030001003B000000000000000000000200000000000000005A008E030100030001000E0000000000000000000002000000000000000001000300E8030000010000000000000000000000000000000000000000004600DF0184670300010091756A6A000A00000000000300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,idn=10000  WHERE strUserID=@name and byClass=1

Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000001400F3020100030001008900000000000000000000020000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A0000000000000000000000000000000000000000004600BC0184670300010091785B5B000A000000000003000000000000000010004D008813030001005D920000000F00000000000300000000000000000000FFFF00000000000000000000000000000000000000000000000000001400F302010003000100890000000000000000000002000000000000000064001D04204E030001009F8D8B87A10A00000000000C000000000000000064004404983A030001009F8D8B87A10A00000000000C000000000000000064003404007D030001009F8D8B87A10A00000000000C000000000000000064003804007D030001009F8D8B87A10A00000000000C000000000000000001000700E80303000100A1A19E00000500000000000300000000000000005A0073030100030001003A000000000000000000000200000000000000005A0078030100030001003A000000000000000000000200000000000000005A0086030100030001003A000000000000000000000200000000000000005A00DB030100030001003B0000000000000000000002000000000000000001000700E803FA00010000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,idn=10000  WHERE strUserID=@name and byClass=2

Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000001400F3020100030001008900000000000000000000020000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A00000000000000000000000000000000000000000046009901846703000100917D5B5B000A000000000003000000000000000001000A00E803FA00010000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000005A0073030100030001003A000000000000000000000200000000000000005A0078030100030001003A000000000000000000000200000000000000005A0086030100030001003A000000000000000000000200000000000000005A00DB030100030001003B000000000000000000000200000000000000001400F30201000300010089000000000000000000000200000000000000000000FFFF000000000000000000000000000000000000000000000000000064003C04007D030001009F8D8B879D0A00000000000C000000000000000064004004007D030001009F8D8B879D0A00000000000C000000000000000064004404983A030001009F8D8B879D0A00000000000C000000000000000064001D04204E030001009F8D8B879D0A00000000000C000000000000000016006A00401F030001005D920000000F000000000003000000000000000001000A00E80303000100A1A19E00000500000000000300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,idn=10000  WHERE strUserID=@name and byClass=3