Fixed
Printable View
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
Then you can use this query code to give silk to account via char nameCode: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
Code:exec SilkByCharName 'CharName', 'silkcount'