Silk Scroll - 1000

[hellspawn800]

up ?

[AceSpace]

Originally Posted by hellspawn800

up ?

Use the latest query in the thread, though it should work even with @ = 41 which is weird.. did u check the @refid?

[hellspawn800]

yes i checked the itemrefid and its the good one

the scroll tp me but no silk given !

here the table _Logeventitem

 Spoiler

 Spoiler

ALTER procedure [dbo]._AddLogItem
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128)
as
declare @len_pos int
declare @len_desc int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial)
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial)
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial)
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial)
end
-- 유료 아이템 구입이면!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if (@Operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end
IF (@Operation = 41 AND @ItemRefID = 41978)
BEGIN
DECLARE @JID int,
@Silk int;

SET @Silk = 1000
SELECT @JID = UserJID from FEAR_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from FEAR_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE FEAR_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO FEAR_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END

here my storedprocess

Fixed. thx

[metma12]

There is any way to spawn it in game using console?

[Over56]

Originally Posted by metma12

There is any way to spawn it in game using console?

sure check your textdata_object scroll name

[samuray3639]

ekledim silk gelmiyor

[Mr Yuni ™]

Works well , thanks for shared and thanks for ZaKuRa <3

[Xoen]

Perfect tY Bro work 100%

[vsro987]

cannot associated iteM data RefObjCommon ID48000 Reftitem ID 26713

any help or link to fix this ??

FIXED

Itgive me SOS no SILK :/