Scroll Random item

08/11/2017 16:45 revldo1#1
i Want Make scroll after click take reward random item

UP
08/12/2017 16:07 EdwardTeach+-#2
Hi
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:
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
08/12/2017 17:09 Valtyr#3
Quote:
Originally Posted by revldo1 View Post
i Want Make scroll after click take reward random item

UP
Scroll

RefObjCommon
PHP Code:
1    50077    ITEM_VALYTR_SPECIAL    ?????    xxx    SN_ITEM_VALYTR_SPECIAL    SN_ITEM_VALYTR_SPECIAL_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    100    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\silk_scroll.ddj    xxx    xxx    61607 
RefObjItem
PHP Code:
61607    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    1000    COOLTIME:0x00000000    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0 
SHARDLOG

AddLogItem

Code:
 IF ( [MENTION=1059401]operation[/MENTION] = '41') AND [MENTION=1134588]item[/MENTION]RefID = '50077' -- scroll id
   BEGIN
declare [MENTION=3898309]charname[/MENTION]6 varchar(64) 
Select [MENTION=3898309]charname[/MENTION]6=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = [MENTION=395373]Chari[/MENTION]D 
declare [MENTION=1994693]lottery[/MENTION]Avatar varchar(129)
set [MENTION=1994693]lottery[/MENTION]Avatar = (SELECT TOP 1 GiftItems FROM SRO_VT_SHARDLOG.dbo._Random_YSRO_ITEM ORDER BY NEWID())
    exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION]6 [MENTION=1994693]lottery[/MENTION]Avatar,1,0
   end
SHARDLOG Table

PHP Code:
USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_Random_VALTYR_ITEM]    Script Date: 12.08.2017 15:07:48 ******/
DROP TABLE [dbo].[_Random_VALTYR_ITEM]
GO

/****** Object:  Table [dbo].[_Random_VALTYR_ITEM]    Script Date: 12.08.2017 15:07:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_Random_VALTYR_ITEM](
    [GiftItems] [varchar](129) NULL,
    [SpecialItems] [varchar](129) NULL,
    [PremItems] [varchar](129) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO