How to Add Item Drops to Mobs & Uniques (vSRO Server Files SQL Guide)

Drop Add Query

USE SRO_VT_SHARD
GO

DECLARE @MonsterID INT
DECLARE @ItemID INT
DECLARE @DropRatio REAL

SET @MonsterID = 3810 -- Mob / Unique ID
SET @ItemID = 24165 -- Item ID to drop
SET @DropRatio = 1 -- 1 = 100%, 0.3 = 30%

INSERT INTO _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'
)

Genişletmek için tıkla ...

Find Item ID (RefObjCommon)

Find Monster ID (RefObjCommon)

Notes

• DropRatio: 1 = 100% drop chance
• Mob and item IDs must be correct from _RefObjCommon
• Works for uniques and normal mobs
• Make sure server is stopped or reload drop tables after insert