USE [SRO_VT_SHARD]
GO

SELECT
Monster.ID AS MonsterID,
Monster.CodeName128 AS MonsterName,
Item.ID AS ItemID,
Item.CodeName128 AS ItemName
FROM _RefMonster_AssignedItemDrop AS Drops
INNER JOIN _RefObjCommon AS Monster
ON Drops.RefMonsterID = Monster.ID
INNER JOIN _RefObjCommon AS Item
ON Drops.RefItemID = Item.ID
ORDER BY Monster.ID ASC

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

• _RefMonster_AssignedItemDrop → drop mapping table
• MonsterID → mob ID
• ItemID → drop item ID
• _RefObjCommon → mob + item reference data
• Join structure → monster → item drop relation

• Drop table analysis
• Server balancing
• Rare item farming control
• Event drop configuration
• Debugging broken drops

WHERE Monster.CodeName128 = 'MOB_CH_TIGERWOMAN'

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

WHERE Item.CodeName128 LIKE 'ITEM_ETC_%'

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