Update Character Name Color

A good understanding of How to select a color value?

You will need to obtain the character ID for the character whose name color you want to update. You can use the following query to get the character ID from the database.

SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name'

Stored Procedure: _Char_UpdateNameColor

Parameters:

• @CharID INT - Target character ID
• @Color INT - Color value

Let us first test whether the command works by using the following code, which will change the name color of a specific character to red.

USE [vPlus]
GO
DECLARE @CharID INT = (SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name')
EXEC _Char_UpdateNameColor @CharID, 16715792;

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

EXEC _Char_UpdateNameColor @CharID, 16715792;