Skill Reset

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

SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name'

Stored Procedure: _Function_ResetSkills

Parameters:

• @CharID INT - Target character ID

Let us test the command by resetting all skills for a specific character.

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

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

EXEC _Function_ResetSkills @CharID;