Change Drop

[Mr Z!dane]

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

Thanks

[DevilArrow]

hi bro i have a question 4 you do you know what is the % OF ISRO IN ITEMS RAREs be cause my DB have ite in 14.999, but i think that is so much

[asanoftw]

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!

 
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.

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

And,

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

For EU ITEMS!

Best Regards