المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : استفسار بخصوص add item drop


Spicoo
14-10-2017, 01:00 AM
عاوز اعمل دروب للموبس بتاع تمبل جوبتر
بس عاوز اعملو ايتم d 12 عشوائي
وكل مثلا 5 وحوش يرمو 1x item

Scrox
14-10-2017, 01:59 AM
اتفضيل كيورى دى

USE SRO_VT_SHARD_INIT
GO

DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real



SET @MonsterID = 24082 -- You can find Monster ID's at RefObjCommon
SET @DropRatio = 0.00004 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course
SET @ItemID = 3851 -- You can find Item ID's at RefObjCommon


INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')

_Legend_R_
14-10-2017, 12:55 PM
اتفضيل كيورى دى

USE SRO_VT_SHARD_INIT
GO

DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real



SET @MonsterID = 24082 -- You can find Monster ID's at RefObjCommon
SET @DropRatio = 0.00004 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course
SET @ItemID = 3851 -- You can find Item ID's at RefObjCommon


INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')

ده بتاعه اضافه درب هو اصلا d12 بينزل درب من جيبتر عادي