استفسار بخصوص add item drop

[Spicoo]

عاوز اعمل دروب للموبس بتاع تمبل جوبتر
بس عاوز اعملو ايتم d 12 عشوائي
وكل مثلا 5 وحوش يرمو 1x item

[Scrox]

اتفضيل كيورى دى

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

المشاركة الأصلية كتبت بواسطة Erixon

اتفضيل كيورى دى

     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 بينزل درب من جيبتر عادي