---To remove the Item from every Mob
Select * from __RefMonster_AssignedItemDrop WHERE RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'ITEM_.....%')
--DELETE FROM _RefMonster_AssignedItemDrop WHERE RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'ITEM_.....%')
---To remove all Drop from single monsters only... Examle is using Remove all drops from MOB_SD_SETH
Select * from __RefMonster_AssignedItemDrop WHERE RefMonsterID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'MOB_SD_SETH')
--DELETE FROM _RefMonster_AssignedItemDrop WHERE RefMonsterID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'MOB_SD_SETH%')
Cheching Monster + Items Drops or Remove one Item from one Monster...
Select * FROM _RefMonster_AssignedItemDrop where RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like '%TOKEN%') and RefMonsterID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'MOB_%')
--DELETE FROM _RefMonster_AssignedItemDrop where RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like '%TOKEN%') and RefMonsterID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'MOB_%')
Select Direct CodeName128 from Item Drops
what mob drops 'ITEMCODENAME' item..
Select CodeName128 from _RefObjCommon where ID IN (Select RefMonsterID FROM _RefMonster_AssignedItemDrop where RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like '%TOKEN%'))
What Items are getting droped by ...'MOBCODENAME'
Select CodeName128 from _RefObjCommon where ID IN (Select RefItemID FROM _RefMonster_AssignedItemDrop where RefMonsterID in (Select ID from _RefObjCommon where CodeName128 like '%LAUNA%'))