How to add silk to play by char name

09/08/2013 03:17 MaDenGo*#1
How to add silk to play by char name

Any query to do it ?
09/08/2013 10:27 Anonymous-6723#2
Code:
USE SRO_VT_SHARD-- Use SHARD database
DECLARE @CharName16 varchar(64)
DECLARE @UserID INT
DECLARE @silk int
SET @silk = '9999' --Silk Here
SET @CharName16 = 'Zed*' --CharName here
SET @UserID = (select UserJID from _User where CharID = (SELECT CharID FROM _Char where CharName16 = @CharName16))
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @silk where JID = @UserID