Required Remove Pet Name Scroll / Pet LVl upScroll

[waled951]

Required Procedure itemID
Remove Pet Name Scroll /Pet LVl upScroll

[SuperWizzard]

For The Pet Lvlup scorll, you can use the below procedure and create the scroll for it, am using vplus for debugging in case there's an issue with the scroll to be added back to the player's inventory

 Spoiler

IF @ = '16'

DECLARE @Codename VARCHAR(128) @D INT
SELECT TOP 1 @Codename = ROC.CodeName128 @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 = @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, @Box = 1
EXEC vPlus.._Char_AddItemToChest @CharID @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 @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 = @etID))
UPDATE SRO_VT_SHARD.._CharCOS SET RefCharID = @etID,HP = @HP, Lvl = (SELECT TOP 1 CurLevel FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID) WHERE ID = @D
END

END

For the Pet Name change, it could be a bit tricky, I don't know how to get the active Pet Name yet, but you can figure something yourself, you should find the data in SRO_VT_SHARD -> _CharCOS and on CharName you will find the Pickup Pet/Attack Pet's names there