[Release]Lottery Gold

[bestprem]

#Random Gold Scroll By Kiro!!

Download

#*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]

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

Thx to Serag and Sa3id

[MentaL]

[Showtek]

Errors:

Msg 189, Level 15, State 1, Procedure _AddLogItem, Line 52
The round function requires 2 to 3 arguments.
Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 53
Incorrect syntax near '@CharID'.
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 54
Must declare the scalar variable "@random_kiro".

[lewy1000]

After TP i dont get gold :(

 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

[che9299]

Old but ty