vSRO Çözüldü Model Switcher

IF @RefItemID= 52163 -- 8 Dg Model Switcher (xx)
Begin

Declare @refItemID1 int;
Declare @ItemCode1 varchar(64);
Declare @NewItemID1 varchar(64);
SET @refItemID1 = (SELECT RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = ( Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0 ));
SET @ItemCode1 = (SELECT NameStrID128 From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where ID = @refItemID);
SET @NewItemID1 = (SELECT ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where NameStrID128 = @ItemCode1 AND CodeName128 like 'LEGENDARY08' );
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewItemID1 Where ID64 = ( Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0 );
END

Genişletmek için tıkla ...