Add Silk (Account)

You will need to obtain the account ID for the account that should receive the silks. You can use the following query to get the account ID from the database.

SELECT JID FROM _OnlinePlayers WHERE CharName16 = 'character_name'

Stored Procedure: _Account_AddSilkLive

Parameters:

• @UserJID INT - Target account 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 account using the account ID.

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

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

EXEC _Account_AddSilkLive @UserJID, 1, 1000, '[GM]';