[Release]Lottery Scroll for items .

Page 1 of 2

07/24/2017 08:01 Emperix#1

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 :
[Only registered and activated users can see links. Click Here To Register...]

07/24/2017 18:06 [-.MoneyTalks-.]#2

thx for share <3

07/24/2017 22:57 Emperix#3

Quote:

Originally Posted by [-.MoneyTalks-.]

thx for share <3

You're welome , hope you liked it .

07/25/2017 04:23 SwaGy.#4

Thanks alot, but what about rates !

07/25/2017 08:18 Emperix#5

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 .

07/25/2017 10:08 elmagico321#6

good job

07/25/2017 13:17 R3D*#7

It will help a lot of beginners.

07/25/2017 14:29 MarC*#8

good job

07/25/2017 19:26 SwaGy.#9

Quote:

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

07/25/2017 20:43 Worshiper#10

good job thanks for it

07/25/2017 22:03 Emperix#11

Quote:

Originally Posted by [GM]Dejo

good job thanks for it

Thanks :)

Quote:

Originally Posted by SwaGy.

Great, thanks

Thanks :)

Quote:

Originally Posted by MarC*

good job

Thanks :)

Quote:

Originally Posted by Acs'

It will help a lot of beginners.

Yeah :) for sure .

Quote:

Originally Posted by elmagico321

good job

Thanks :)

07/26/2017 03:47 EdwardTeach+-#12

nice for beginning.

01/22/2018 12:02 TheBold#13

have Problem

Quote:

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

Quote:

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".

02/05/2018 13:50 WRONG WAY#14

Quote:

Originally Posted by TheBold

have Problem

Code:

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

06/08/2019 19:17 cikho12#15

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

Page 1 of 2