Achievement Title Add

By completing this guide, you should be able to add an achievement title for the specified character.

You will have to obtain the character ID you want to add the title to. You may use the following query to obtain the character ID from the database.

SELECT CharID
FROM _OnlinePlayers
WHERE CharName16 = 'Character_Name';

You will have to obtain the title ID you want to add. You may use the following query to obtain the title ID from the database.

SELECT ID
FROM _RefAchievementTitles
WHERE CodeName = 'Achievement_CodeName';

Stored Procedure: _Char_AchievementTitleAdd
Parameters:

@CharID INT - Target character ID
@TitleID INT - Title ID
@ForceUpdate BIT - Force update the title

1 - Update the title instantly
0 - Do not force an instant title update

Let's test if the command works by using the following code, which will add the [BIG_SPENDER] title for a specific character.

USE [vPlus]
GO

DECLARE @CharID INT = (
    SELECT CharID
    FROM _OnlinePlayers
    WHERE CharName16 = 'character_name'
);

EXEC _Char_AchievementTitleAdd @CharID, 3, 1;

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

EXEC _Char_AchievementTitleAdd @CharID, 3, 1;

Cookies

Achievement Title Add