[Release] Random Gold

[bestprem]

Random Gold Lottery!!

#*Media Section*

#itemdata_50000.txt

1	180295	ITEM_KIRO_RANDOM_GOLD	???? ???? ??? (???)	xxx	SN_ITEM_KIRO_RANDOM_GOLD	SN_ITEM_KIRO_RANDOM_GOLD_TT_DESC	1	0	3	3	3	1	180000	3	2	0	1	0	3	0	1	0	0	129	0	0	0	0	0	0	0	1	1	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	comatose\uniq_point_scroll.ddj	xxx	xxx	1	2	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1500	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

#textdata_object.txt

1	SN_ITEM_KIRO_RANDOM_GOLD								Gold Lottery(Kiro)
1	SN_ITEM_KIRO_RANDOM_GOLD_TT_DESC								Gold Lottery(Kiro)

#*Database Section*

#Tables
#_RefObjCommon

1	180295	ITEM_KIRO_RANDOM_GOLD	???? ???? ??? (???)	xxx	SN_ITEM_KIRO_RANDOM_GOLD	SN_ITEM_KIRO_RANDOM_GOLD_TT_DESC	1	0	3	3	3	1	180000	3	2	0	1	0	3	0	1	0	0	129	0	0	0	0	0	0	0	1	1	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	comatose\uniq_point_scroll.ddj	xxx	xxx 99999

#_RefObjItem

99999	1	2	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1500	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

#Procedures
SRO_VT_SHARDLOG >>>> [_AddLogItem]

Notice:add that query at addlogitem

IF (@Operation = 41) -- If item used!
BEGIN
    IF (@ItemRefID = 180295) -- RefObjCommon ID (Scroll) (By Kiro)
    BEGIN
    declare @Charname varchar(128)
declare @upper_kiro int = '100000000' declare @lower_kiro int = '10000000'
 declare @random_kiro int = ROUND(((@upper_kiro - @lower_kiro -1) * RAND() + @lower_kiro), 0)
 set @charname = (select CharName16  from sro_vt_shard.dbo._Char where CharID=@CharID)
Update SRO_VT_SHARD.dbo._Char set RemainGold = RemainGold + @random_kiro  where CharName16 = @charname      
end
end

[PortalDark]

#Approved

[Crue*]

thanks !

[menamoners]

N!Ce keep going

[Scheffi]

Old but thank you

[Wolf Internet Attacker]

Nice :3

[asanoftw]

ok nice =D

[Justin1337*]

Thanks, btw fix your sig :P

[nourayman]

Too easy + Too old

anyway thank's .

[bestprem]

i know it it's easy
for beginners :3

[lewy1000]

I try it but after TP gold not added :O

 IF (@ItemRefID = 180295) -- RefObjCommon ID (Scroll) (By Kiro)
BEGIN
declare @Charname varchar(128)
declare @upper_kiro int 
SET @upper_kiro = '100000000' 
declare @lower_kiro int 
SET @lower_kiro = '1000000'
declare @random_kiro int 
SET @random_kiro = ROUND(((@upper_kiro - @lower_kiro -1) * RAND() + @lower_kiro), 0)
set @charname = (select CharName16  from sro_vt_shard_init.dbo._Char where CharID = @CharID)
Update SRO_VT_SHARD_INIT.dbo._Char set RemainGold = RemainGold + @random_kiro  where CharName16 = @charname      
end

No errors in server modules.

[bestprem]

Originally Posted by lewy1000

I try it but after TP gold not added :O

 IF (@ItemRefID = 180295) -- RefObjCommon ID (Scroll) (By Kiro)
BEGIN
declare @Charname varchar(128)
declare @upper_kiro int 
SET @upper_kiro = '100000000' 
declare @lower_kiro int 
SET @lower_kiro = '1000000'
declare @random_kiro int 
SET @random_kiro = ROUND(((@upper_kiro - @lower_kiro -1) * RAND() + @lower_kiro), 0)
set @charname = (select CharName16  from sro_vt_shard_init.dbo._Char where CharID = @CharID)
Update SRO_VT_SHARD_INIT.dbo._Char set RemainGold = RemainGold + @random_kiro  where CharName16 = @charname      
end

No errors in server modules.

Skype:Kerolosmoner

[silkflo]

Maybe late to answer you , but i've got the same problem. So for other who might have no gold added, change the @operation number, i changed for 16 and works