how to add gold scroll ?

07/30/2018 16:13 devdash#1
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.
07/30/2018 16:22 ZαKuRα#2
maybe it will help you

Quote:
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
07/30/2018 17:30 devdash#3
Quote:
Originally Posted by ZαKuRα View Post
maybe it will help you
it will help alot thanks <3
, i will try it now and i will be back with result...

Quote:
Originally Posted by ZαKuRα View Post
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
08/01/2018 11:40 R3D*#4
Did you enable the log?
08/01/2018 17:48 devdash#5
Quote:
Originally Posted by ZΞDStorm View Post
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
08/16/2018 00:24 Obyx#6
If (@Operation=41) and (@ItemRefID = 'ItemID')

BEGIN

UPDATE SRO_VT_SHARD.._Char SET RemainGold = RemainGold + 100000000 WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]d;
end
01/30/2021 21:07 guast21#7
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 = @[Only registered and activated users can see links. Click Here To Register...]d;
end

And nothing happens
Do I need to enable the logs somewhere?
01/31/2021 17:14 Devsome#8
Quote:
Originally Posted by guast21 View Post
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 = @[Only registered and activated users can see links. Click Here To Register...]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