Change Drop

Quote:

Originally Posted by srmaster2

in my game have drop from Mob +101 Sox D10 How Can change it to D11 Nova

Thanks

Hey, firstly you have to use this query to delete sox dg10 drops!

Code:

 
delete dbo._RefMonster_AssignedItemDrop
FROM _RefDropItemAssign Drops
LEFT JOIN _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID) 
WHERE CodeName128 like '%ITEM_CH_%_10_RARE_%'
WHERE CodeName128 like '%ITEM_EU_%_10_RARE_%'

Secondly, you have to use this query to add Dg11 nova as you want.

Code:

 
INSERT into dbo._RefMonster_AssignedItemDrop
FROM _RefDropItemAssign Drops
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like '%ITEM_CH_%_11_RARE_%'))

And,

Code:

INSERT into dbo._RefMonster_AssignedItemDrop
FROM _RefDropItemAssign Drops
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like '%ITEM_EU_%_11_RARE_%'))

For EU ITEMS!

Best Regards