hello, i used the mass drop editor to do my drops and now i have a pr oblem of some items not dropping at all. its like anything after item order 5 or 6 that wont drop for some reason if anyone can help would appreciate pls
UPDATE PS_GameDefs.dbo.MobItems SET DropRate=DropRate*10000 WHERE ItemOrder IN (7,8,9) AND DropRate < 101 AND DropRate > 0
thank you so much!Quote:
Quick fix to run after you have set base % desired between 1 and 100.
Explained :Code:UPDATE PS_GameDefs.dbo.MobItems SET DropRate=DropRate*10000 WHERE ItemOrder IN (7,8,9) AND DropRate < 101 AND DropRate > 0
Adjust drop rates
SET DropRate=DropRate*10000
Choose which to effect
WHERE ItemOrder IN (7,8,9)
Insure you only effect standard percent drop rates
AND DropRate < 101 AND DropRate > 0