Add Silk By Char name

Fixed

Yeah yeah... And i want isro offical files but hey it's not possible. So what do you want exactly? You want to add silk to account by char name?

if yes

Execute this query only for once

Code:

---

USE [SRO_VT_ACCOUNT]
 GO
Create Procedure [dbo].[SilkByCharName]
@name varchar(64),
@count int
as
declare @ID int
select @ID = UserJID from SR_ShardCharNames where CharName = @name
if not @ID = null
begin
insert into SK_silk (JID, silk_own, silk_gift, silk_point)values(@ID,@count,0,0)
end
go

---

Then you can use this query code to give silk to account via char name

Code:

---

exec SilkByCharName 'CharName', 'silkcount'

---