Add Silk (Character)

You will need to obtain the character ID for the character that should receive the silks. 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_AddSilkLive

Parameters:

• @CharID INT - Target character ID
• @SilkType TINYINT - Type of silk you want to add

1 = Premium Silks (silk_own)
2 = Gift Silks (silk_gift)
3 = Point Silks (silk_point)

• @SilkAmount INT - Amount of silk you want to add
• @SendNotification BIT - If the value is NULL, the player will not receive a notification after the silk is added. Otherwise, the player will receive a notification.
• @Executor VARCHAR(64) - User who added the silks

Let us first test whether the command works by using the following code, which will add 1000 Premium Silks to a specific character using the character ID.

USE [vPlus]
GO
DECLARE @CharID INT = (SELECT CharID FROM _OnlinePlayers WHERE CharName16 = 'character_name')
EXEC _Char_AddSilkLive @CharID, 1, 1000, '[GM]';

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

EXEC _Char_AddSilkLive @CharID, 1, 1000, '[GM]';