Mutate Item Blues

You will need to obtain the character ID for the character whose item blues you want to change. You can use the following query to get the character ID from the database.

SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name'

You will also need to know the target inventory slot of the item you want to modify.

Stored Procedure: _Char_MutateItemBluesAt

Parameters:

• @CharID INT - Target character ID
• @Slot TINYINT - Target slot ID
• @BlueParameters VARCHAR(MAX) - Blue option parameters
• @ID64 BIGINT - Item ID64

@BlueParameters should be written in the following format:

Number1:Number2,Number3:Number4...etc

• Number1 - Magic option ID
• Number2 - Magic option value
• Number3 - Magic option ID
• Number4 - Magic option value
and so on...

Let us first test whether the command works by using the following code, which will change the blues of the item in a specific inventory slot for a specific character.

USE [vPlus]
GO
DECLARE @CharID INT = (SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name')
DECLARE @ID64 BIGINT = (SELECT ItemID FROM SRO_VT_SHARD.._Inventory WHERE CharID = @CharID AND Slot = 13)
EXEC _Char_MutateItemBluesAt @CharID, 13, '77:7,77:6', @ID64;

For real usage, use @CharID directly from your calling procedure.

EXEC _Char_MutateItemBluesAt @CharID, 13, '77:7,77:6', @ID64;