how to add gold scroll ?

[devdash]

hello guys, i want to make scroll that give gold after using it
i know how to make scroll lines, i just need the addlogitem thing...
i need it just like silk scroll thing, that bring spcific amount of silk scroll that i picked it

i want to do the same for the gold scroll


thanks in advance.

[ZαKuRα]

maybe it will help you

If (@Operation=41) and (@ItemRefID between 'ItemID' and 'ItemID')
begin


set @Gold = Case
when @ItemRefID= 42084
then 100000000 --1-100M
when @ItemRefID= 42085
then 500000000 --2-500M
When @ItemRefID= 42086
then 1000000000 --3-1B
When @ItemRefID= 42087
then 5000000000 --4-5B
When @ItemRefID= 42088
then 10000000000 --5-10B
When @ItemRefID= 42089
then 20000000000 --6-20B
When @ItemRefID= 42090
then 50000000000 --7-50B
When @ItemRefID= 42091
then 100000000000 --8-100B
When @ItemRefID= 42092
then 500000000000 --9-500B
end
UPDATE [SRO_VT_SHARD].dbo.[_Char] set RemainGold=RemainGold+@Gold where CharID=@CharID
end

[devdash]

Originally Posted by ZαKuRα

maybe it will help you

it will help alot thanks <3
, i will try it now and i will be back with result...

Originally Posted by ZαKuRα

maybe it will help you

not working at all

do you have any other addlogitem for it ?

i need it like Silk Scroll , simple i use the scroll i return to town and i get the amount of the gold that i made it on the addlogitem

[R3D*]

Did you enable the log?

[devdash]

Originally Posted by ZΞDStorm

Did you enable the log?

enable the log ? what do u mean

i already have some other things on it and it work perfectly , like silk scrolls

[Obyx]

If (@Operation=41) and (@ItemRefID = 'ItemID')

BEGIN

UPDATE SRO_VT_SHARD.._Char SET RemainGold = RemainGold + 100000000 WHERE CharID = @d;
end

[guast21]

My [SRO_VT_SHARDLOG] tables are empty and the procedure does nothing...

I already did this do test:

If (@Operation=41)

BEGIN

UPDATE SRO_VT_SHARD.._Char SET RemainGold = RemainGold + 100000000 WHERE CharID = @d;
end

And nothing happens
Do I need to enable the logs somewhere?

[Devsome]

Originally Posted by guast21

My [SRO_VT_SHARDLOG] tables are empty and the procedure does nothing...

I already did this do test:

If (@Operation=41)

BEGIN

UPDATE SRO_VT_SHARD.._Char SET RemainGold = RemainGold + 100000000 WHERE CharID = @d;
end

And nothing happens
Do I need to enable the logs somewhere?

Thread from 2018, better to create a new thread in the right section.

#close