You will need to obtain the account ID for the account whose silk data you want to reload. 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_RefreshSilkData
Parameters:
@UserJID INT- Target account ID
Let us first test whether the command works by using the following code, which will reload the silk data for a specific account after modifying it from the database side.
USE [vPlus] GO DECLARE @UserJID INT = (SELECT JID FROM _OnlinePlayers WHERE CharName16 = 'character_name') EXEC _Account_RefreshSilkData @UserJID;
For real usage, use @UserJID directly from your calling procedure.
EXEC _Account_RefreshSilkData @UserJID;