[Release]Lottery Scroll for items .

[Emperix]

Hello,

before you comment any bad comment about how old it is , I know its old but no one released it , or maybe someone did but not working fine , today i came with this scroll that works 100% without any single problem.

Basically this scroll when you use it , it will give you a random item that you inserted in the Table [ you will know what i mean when u download it ] completely randomly , what you have to do ? download the text file put the lines and procedure in his place and you will be fine , how to insert codes ?
Make the table query then open the table and you how to do like this exactly :
1 ITEM_SILK_SCROLL_5
2 ITEM_SILK_SCROLL_10
you know what i mean , Enjoy .

Here ya go :

[[-.MoneyTalks-.]]

thx for share <3

[Emperix]

Originally Posted by [-.MoneyTalks-.]

thx for share <3

You're welome , hope you liked it .

[SwaGy.]

Thanks alot, but what about rates !

[Emperix]

rates are balanced , if you put 2 items the rates are 50% for the 1st item and 50% for the second , and if put 4 or more , every item has the same rate as the all the items .

[elmagico321]

good job

[R3D*]

It will help a lot of beginners.

[MarC*]

good job

[SwaGy.]

Originally Posted by Emperix

rates are balanced , if you put 2 items the rates are 50% for the 1st item and 50% for the second , and if put 4 or more , every item has the same rate as the all the items .

Great, thanks

[Worshiper]

good job thanks for it

[Emperix]

Originally Posted by [GM]Dejo

good job thanks for it

Thanks

Originally Posted by SwaGy.

Great, thanks

Thanks

Originally Posted by MarC*

good job

Thanks

Originally Posted by Acs'

It will help a lot of beginners.

Yeah for sure .

Originally Posted by elmagico321

good job

Thanks

[EdwardTeach+-]

nice for beginning.

[TheBold]

have Problem

if (@ItemRefID = 49084 and @Operation = 16)
begin--Usage:--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @cname1 varchar(64)
select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
declare @sayi int
declare @adet int
declare @maxa int
declare @mina int
select @maxa = MAX(ID) FROM SRO_VT_SHARD .dbo._LotteryTABLE
select @mina = Min(ID) FROM SRO_VT_SHARD .dbo._LotteryTABLE
declare @itemname varchar(64)
etik:
SELECT @sayi = (CONVERT(INT, RAND() * (@maxa-@mina+1))+(@mina))
select @itemname = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @sayi
select @itemname = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @sayi
print @sayi
print @itemname
if(PATINDEX('%ITEM%',@itemname)>0)
begin
print 'not present'
end
else begin
print 'not present'
goto etik
end
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @cname,@itemname,1,0
end

Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 32
Must declare the scalar variable "@cname".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 54
Must declare the scalar variable "@cname".

[WRONG WAY]

Originally Posted by TheBold

have Problem

if (@ItemRefID = 49084 and @Operation = 41)
	begin--Usage:--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
	declare @cname varchar(64)
	select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
		declare @sayi int
		declare @adet int
		declare @maxa int
		declare @mina int
		select @maxa =  MAX(ID)  FROM SRO_VT_SHARD .dbo._LotteryTABLE
		select @mina =  Min(ID)  FROM SRO_VT_SHARD .dbo._LotteryTABLE
		declare @itemname varchar(64)
		etik:	
SELECT  @sayi =  (CONVERT(INT, RAND() * (@maxa-@mina+1))+(@mina))
select @itemname = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @sayi
		select @itemname = CodeName128 from SRO_VT_SHARD.dbo._LotteryTABLE where ID = @sayi
		print @sayi 
		print @itemname
		if(PATINDEX('%ITEM%',@itemname)>0)
		begin	
		print 'not present' 
		end
		else begin
		print 'not present' 
		goto etik 
		end
		exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @cname,@itemname,1,0 
end

[cikho12]

Hi. Can i copy procedure like acc,weapon,etc... ?