决战DROIYAN ONLINE角色上线触发器-14-七星触发器

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

after Insert 

as 

declare @name nvarchar(20)

SELECT @name=strUserID FROM INSERTED

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

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

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

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