Add Buff Skill

You will need to obtain the character ID for the character you want to add buffs to. 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_AddBuffLive

Parameters:

@CharID INT - Target character ID
@Basic_Code VARCHAR(128) - Desired buff code

Let us first test whether the command works by using the following code, which will add a 100% speed buff to a specific character.

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

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

EXEC _Char_AddBuffLive @CharID, 'SKILL_MALL_MOVE_SPEED_UP_100_01';

Another example using a timeless skill such as the Honor Buff Crown:

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

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

EXEC _Char_AddBuffLive @CharID, 'SKILL_TC_CROWN_BUFF_01';

Cookies