Required Remove Pet Name Scroll / Pet LVl upScroll

IF @[Only registered and activated users can see links. Click Here To Register...] = '16'

DECLARE @Codename VARCHAR(128) @[Only registered and activated users can see links. Click Here To Register...]D INT
SELECT TOP 1 @Codename = ROC.CodeName128 @[Only registered and activated users can see links. Click Here To Register...]D = CC.ID FROM SRO_VT_SHARD.._Inventory inv WITH(NOLOCK)
JOIN SRO_VT_SHARD.._Items I ON I.ID64 = Inv.ItemID
JOIN SRO_VT_SHARD.._Char C ON C.CharID = Inv.CharID
JOIN SRO_VT_SHARD.._CharCOS CC ON CC.ID = I.Data
JOIN SRO_VT_SHARD.._RefObjCommon ROC WITH(NOLOCK) ON ROC.ID = CC.RefCharID
JOIN SRO_VT_SHARD.._RefObjCommon ROC2 WITH(NOLOCK) ON ROC2.ID = I.RefItemID
WHERE ROC.CodeName128 LIKE 'COS_P%' AND C.CharID = @CharID AND CC.State = 3 AND Inv.Slot >= 13
AND Inv.ItemID != 0 AND Inv.ItemID IS NOT NULL AND ROC.TypeID4 = 3 AND ROC.Service = 1 AND ROC2.TypeID1 = 3 AND ROC2.TypeID2= 2 AND ROC2.TypeID3 = 1 AND ROC2.TypeID4 = 1
IF(SELECT Lvl FROM SRO_VT_SHARD.._CharCOS WHERE ID = @[Only registered and activated users can see links. Click Here To Register...]D)=(SELECT TOP 1 CurLEvel FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID)
BEGIN
EXEC vPlus.dbo._Char_SendTextNotification @CharID, 'Pet level is same as your level, you have received the scroll back in your Item Chest.', @AlertType = 4, @ChatBoxType = 2, @[Only registered and activated users can see links. Click Here To Register...]Box = 1
EXEC vPlus.._Char_AddItemToChest @CharID @[Only registered and activated users can see links. Click Here To Register...]RefID,1,0,'Pet Level Up'
END
ELSE
BEGIN
IF @Codename IS NOT NULL
BEGIN
DECLARE @CharLvl VARCHAR(3) = CASE WHEN (SELECT LEN(CAST(CurLevel AS VARCHAR)) FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID) = 1 THEN '0'+(SELECT CAST(CurLevel AS VARCHAR) FROM SRO_VT_SHARD.._Char WITH(NOLOCK) WHERE CharID = @CharID)
WHEN (SELECT LEN(CAST(CurLevel AS VARCHAR)) FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID) = 2 THEN '0'+(SELECT CAST(CurLevel AS VARCHAR) FROM SRO_VT_SHARD.._Char WITH(NOLOCK) WHERE CharID = @CharID)
ELSE (SELECT CAST(CurLevel AS VARCHAR) FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID) END
DECLARE @[Only registered and activated users can see links. Click Here To Register...]etID INT =(SELECT TOP 1 ID FROM SRO_VT_SHARD.._RefObjCommon WITH(NOLOCK) WHERE CodeName128 =(SELECT LEFT(@Codename, LEN(@Codename)-3))+@CharLvl)
DECLARE @HP INT = (SELECT MaxHP FROM SRO_VT_SHARD.._RefObjChar WITH(NOLOCK) WHERE ID IN (SELECT Link FROM SRO_VT_SHARD.._RefObjCommon WITH(NOLOCK) WHERE ID = @[Only registered and activated users can see links. Click Here To Register...]etID))
UPDATE SRO_VT_SHARD.._CharCOS SET RefCharID = @[Only registered and activated users can see links. Click Here To Register...]etID,HP = @HP, Lvl = (SELECT TOP 1 CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID) WHERE ID = @[Only registered and activated users can see links. Click Here To Register...]D
END

END