决战DROIYAN上线触发器-2-包含百级
CREATE TRIGGER [FUCKYOU] ON [dbo].[GameUser] WITH ENCRYPTION
after Insert
as
declare @name nvarchar(20)
SELECT @name=strUserID FROM INSERTED
Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF000000000000000000000000000000000000000000000000000005005500000000000A000000000000000000000000000000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A00000000000000000000000000000000000000000001000100E803000001000000000000000000000000000000000000000000460001028467030001009192925D000500000000000300000000000000005A0073030100030001003A000000000000000000000200000000000000005A0078030100030001003A000000000000000000000200000000000000005A0086030100030001003A0000000000000000000002000000000000000064002004204E030001008D8D699A0005000000000003000000000000000064004404983A030001008D8D699A0005000000000003000000000000000064002404007D030001008D8D699A0005000000000003000000000000000064002804007D030001008D8D699A000500000000000300000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,idn=50000 WHERE strUserID=@name and byClass=0
Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF000000000000000000000000000000000000000000000000000005005500000000000A000000000000000000000000000000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A00000000000000000000000000000000000000000001000300E8030300010000000000000000000000000000000000000000004600DE0184670300010088919175000500000000000300000000000000005A008E030100030001000E000000000000000000000200000000000000005A0075030100030001000E000000000000000000000200000000000000005A0085030100030001000E0000000000000000000002000000000000000064002004204E030001008D8D699A0005000000000003000000000000000064004404983A030001008D8D699A0005000000000003000000000000000064002C04007D030001008D8D699A0005000000000003000000000000000064003004007D030001008D8D699A000500000000000300000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,idn=50000 WHERE strUserID=@name and byClass=1
Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF000000000000000000000000000000000000000000000000000005005500000000000A000000000000000000000000000000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A00000000000000000000000000000000000000000001000700E8030300010000000000000000000000000000000000000000004600BC018467030001009192925D000500000000000300000000000000005A0073030100030001003A000000000000000000000200000000000000005A0078030100030001003A000000000000000000000200000000000000005A0086030100030001003A0000000000000000000002000000000000000064002004204E030001008D8D699A0005000000000003000000000000000064004404983A030001008D8D699A0005000000000003000000000000000064003404007D030001008D8D699A0005000000000003000000000000000064003804007D030001008D8D699A000500000000000300000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,idn=50000 WHERE strUserID=@name and byClass=2
Update [GameUser] set strItem=0x0000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF000000000000000000000000000000000000000000000000000005005500000000000A000000000000000000000000000000000000000000010078021E0000000100000000000000000000000000000000000000000001008D03000000000A00000000000000000000000000000000000000000001000A00E803030001000000000000000000000000000000000000000000460099018467030001009192925D000500000000000300000000000000005A0073030100030001003A000000000000000000000200000000000000005A0078030100030001003A000000000000000000000200000000000000005A0086030100030001003A0000000000000000000002000000000000000064002004204E030001008D8D699A0005000000000003000000000000000064004404983A030001008D8D699A0005000000000003000000000000000064003C04007D030001008D8D699A0005000000000003000000000000000064004004007D030001008D8D699A000500000000000300000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,idn=50000 WHERE strUserID=@name and byClass=3
相关文章
- 决战DROIYAN ONLINE角色上线触发器-22-指环王人物触发
- 决战DROIYAN ONLINE角色上线触发器-21-长久4触发器
- 决战DROIYAN ONLINE角色上线触发器-20-新手上线奖励
- 决战DROIYAN ONLINE角色上线触发器-19-新手上线仓库奖励
- 决战DROIYAN ONLINE角色上线触发器-18-武神降临身
- 决战DROIYAN ONLINE角色上线触发器-17-网通绿色身上触发
- 决战DROIYAN ONLINE角色上线触发器-16-送机械的仓库
- 决战DROIYAN ONLINE角色上线触发器-15-七星触发器2
- 决战DROIYAN ONLINE角色上线触发器-14-七星触发器
- 决战DROIYAN ONLINE角色上线触发器-13-七星仓库