Random reward scroll

12/03/2016 19:24 leo2111#1

Code:

IF ( @ operation = '41') AND @ itemRefID = 'xxx' -- scroll id
Begin 

select @ charname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @ ChariD
exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @ charname,'ITEM_MALL_DAMAGE_INC_ABS_10P_SCROLL',1, 1
exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @ charname,'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE',1,1 
end

How to make this scroll to give a random reward?

12/03/2016 22:00 NoIdeaForAName#2

By realizing that your signature is the most cringiest thing ever.

[Only registered and activated users can see links. Click Here To Register...]

12/04/2016 01:44 DeviasOnline#3

or : [Only registered and activated users can see links. Click Here To Register...]

12/04/2016 02:50 EdwardTeach+-#4

Quote:

Originally Posted by leo2111

Code:

IF ( @ operation = '41') AND @ itemRefID = 'xxx' -- scroll id
Begin 

select @ charname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @ ChariD
exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @ charname,'ITEM_MALL_DAMAGE_INC_ABS_10P_SCROLL',1, 1
exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @ charname,'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE',1,1 
end

How to make this scroll to give a random reward?

Hi, that totally wrong,
To make a scroll give a random Reward,
-1st you'll have to create a table with like "20 Codename or less that you need that scroll when someone use it gave him random reward from these 20 codename u choice in this table"
and then you'll make a producer

Code:

BEGIN
declare @ CharName varchar(25) = (select CharName16 from SRO_VT_SHARD.._Char where CharID=@ CharID)
declare @ itemCodeName varchar(MAX) = (Select  1 CodeName from _YourTableName order by RAND()))
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @ charname @ itemCodeName,1,0
end

that make it exec on AddLogItem

12/04/2016 14:26 leo2111#5

Quote:
Originally Posted by EdwardTeach+-
Hi, that totally wrong,
To make a scroll give a random Reward,
-1st you'll have to create a table with like "20 Codename or less that you need that scroll when someone use it gave him random reward from these 20 codename u choice in this table"
and then you'll make a producer
Code:
BEGIN
declare @ CharName varchar(25) = (select CharName16 from SRO_VT_SHARD.._Char where CharID=@ CharID)
declare @ itemCodeName varchar(MAX) = (Select  1 CodeName from _YourTableName order by RAND()))
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @ charname @ itemCodeName,1,0
end
that make it exec on AddLogItem

Thank you! This is what I actually wanted to know.
Best regards!

The procedure as it is right now is wrong , but I modified it and everything works fine, thank you :)

12/05/2016 14:45 WickedNite.#6

That's the easy approach though...

12/05/2016 15:29 D3vil Power#7

#_TimedJob

PHP Code:


			
if(@JobID= 'xxx') -- scroll id
        begin 
            EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk]  [MENTION=4225629]orderi[/MENTION]D = NULL,  [MENTION=831308]userid[/MENTION] = [MENTION=339306]newuser[/MENTION]ID,  [MENTION=1417196]pkg[/MENTION]ID = NULL,  [MENTION=2856536]numsi[/MENTION]lk = 50,  [MENTION=865581]PRICE[/MENTION] = NULL 
            set [MENTION=351728]new[/MENTION]JobID = @@identity 
            return [MENTION=351728]new[/MENTION]JobID 
        end

Try this ..
that's Scroll gift coin form ItemMall

12/07/2016 02:32 Spidy.#8

Quote:

Originally Posted by leo2111

Thank you! This is what I actually wanted to know.
Best regards!

The procedure as it is right now is wrong , but I modified it and everything works fine, thank you :)

^
#Closed