Register for your free account! | Forgot your password?

You last visited: Today at 19:48

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Release]Lottery Scroll for items .

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2017
Posts: 33
Received Thanks: 5
Talking [Release]Lottery Scroll for items .

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 :



Emperix is offline  
Thanks
3 Users
Old   #2
 
elite*gold: 0
Join Date: Dec 2013
Posts: 69
Received Thanks: 40
thx for share <3


[-.MoneyTalks-.] is offline  
Old   #3
 
elite*gold: 0
Join Date: Jul 2017
Posts: 33
Received Thanks: 5
Quote:
Originally Posted by [-.MoneyTalks-.] View Post
thx for share <3
You're welome , hope you liked it .
Emperix is offline  
Old   #4
 
elite*gold: 0
Join Date: Dec 2016
Posts: 64
Received Thanks: 17
Thanks alot, but what about rates !


SwaGy. is offline  
Old   #5
 
elite*gold: 0
Join Date: Jul 2017
Posts: 33
Received Thanks: 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 .
Emperix is offline  
Old   #6
 
elite*gold: 0
Join Date: Oct 2013
Posts: 533
Received Thanks: 163
good job
elmagico321 is offline  
Thanks
1 User
Old   #7


 
elite*gold: 0
Join Date: May 2011
Posts: 980
Received Thanks: 529
It will help a lot of beginners.
ZΞDStorm is offline  
Old   #8
 
elite*gold: 0
Join Date: Jul 2017
Posts: 5
Received Thanks: 2
good job
MarC* is offline  
Thanks
1 User
Old   #9
 
elite*gold: 0
Join Date: Dec 2016
Posts: 64
Received Thanks: 17
Quote:
Originally Posted by Emperix View Post
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
SwaGy. is offline  
Thanks
1 User
Old   #10
 
elite*gold: 0
Join Date: May 2017
Posts: 444
Received Thanks: 59
good job thanks for it
[GM]Dejo is offline  
Thanks
1 User
Old   #11
 
elite*gold: 0
Join Date: Jul 2017
Posts: 33
Received Thanks: 5
Quote:
Originally Posted by [GM]Dejo View Post
good job thanks for it
Thanks

Quote:
Originally Posted by SwaGy. View Post
Great, thanks
Thanks

Quote:
Originally Posted by MarC* View Post
good job
Thanks

Quote:
Originally Posted by Acs' View Post
It will help a lot of beginners.
Yeah for sure .

Quote:
Originally Posted by elmagico321 View Post
good job
Thanks
Emperix is offline  
Old   #12
 
elite*gold: 0
Join Date: Feb 2016
Posts: 652
Received Thanks: 318
nice for beginning.
EdwardTeach+- is offline  
Thanks
1 User
Old   #13
 
elite*gold: 0
Join Date: Dec 2016
Posts: 26
Received Thanks: 3
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() * (@[email protected]+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".
TheBold is offline  
Old   #14
 
elite*gold: 0
Join Date: Feb 2011
Posts: 338
Received Thanks: 53
Quote:
Originally Posted by TheBold View Post
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() * (@[email protected]+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


3ashek El7ozn is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Release Lottery Silk Scroll
am beginner SQL :D 1....
1 Replies - SRO PServer Guides & Releases
Vsro silk scroll and gift scroll doesn't work
solved topic can delete
1 Replies - SRO PServer - Discussions / Questions
(ALB) WTS Effect Scroll - Megadolon Drop Scroll
Im looking for plats just serious offers please
1 Replies - Trading
WTT 3X Scroll for Shuta( Come with ur Scroll)(Evengarda)
İ want to change 4x Scroll for shuta ... u need to come with ur scroll
1 Replies - Archlord Trading



All times are GMT +2. The time now is 19:48.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.