Title Add or Update

A good understanding of How to select a color value?

You will need to obtain the character ID for the character whose title you want to add or 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_AddOrUpdateHwan

Parameters:

• @CharID INT - Target character ID
• @HwanLevel TINYINT - Hwan level
• @Color INT - Hwan color
• @ForceUpdate BIT - Force update
  If this value is set to 1, the title will be forcibly updated on the character.
• @IsTemporary BIT - Is temporary
  If this value is set to 1, the title will not be added to the Title Manager and will disappear after teleporting.

Let us first test whether the command works by using the following code, which will add the title [Senior General] to a specific character.

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

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

EXEC _Char_AddOrUpdateHwan @CharID, 3;