Random reward scroll

[leo2111]

IF ( @ operation = '41') AND @ itemRefID = '***' -- 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?

[NoIdeaForAName]

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

[DeviasOnline]

or :

[EdwardTeach+-]

Originally Posted by leo2111

IF ( @ operation = '41') AND @ itemRefID = '***' -- 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

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

[leo2111]

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

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

[WickedNite.]

That's the easy approach though...

[D3vil Power]

#_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

[Spidy.]

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