IF ((@Operation = 41 ) AND (@ItemRefID = 41887)) BEGIN IF (@ItemRefID = Scroll ID FROM _RefObjCommon) BEGIN declare @RefCharID int DECLARE @OldItemCodeName varchar(128) DECLARE @SS varchar(128) DECLARE @OldItemPlus int DECLARE @NewItemCodeName varchar(128) Declare @RefMail INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=@CharID AND Slot ='13') Declare @RefMailID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @RefMail) select @OldItemCodeName = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @RefMailID if(@OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_YELLOW') begin set @NewItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE' end if(@OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_YELLOW') begin set @NewItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_UNIQUE' end declare @CharName16 varchar(64) set @OldItemPlus =OLD Devil Plus set @NewItemPlus = 0 DECLARE @ReplaceID int SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @OldItemCodeName and itm.OptLevel >= @OldItemPlus) if (@ReplaceID > 0) begin Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID select @CharName16 =CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus end end END