Achievement Update

By completing this guide, you should be able to update achievement quest progress for the specified character.

You will have to obtain the character ID you want to update the achievement quest progress for. 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 quest ID you want to update. You may use the following query to obtain the quest ID from the database.

SELECT ID
FROM _RefAchievementQuests
WHERE CodeName = 'Quest_CodeName';

Stored Procedure: _Char_AchievementUpdate
Parameters:

@CharID INT - Target character ID
@QuestID INT - Achievement quest ID
@ProgressAdd INT - Quest progress amount to add

Let's test if the command works by using the following code, which will add 100,000 gold progress for the [SPEND_GOLD_01] quest for a specific character.

USE [vPlus]
GO

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

EXEC _Char_AchievementUpdate @CharID, 4, 100000;

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

EXEC _Char_AchievementUpdate @CharID, 4, 100000;

Cookies

Achievement Update