Common Droplist Rate Modification

November 18, 2008

Some high rate server may have issues with common items since the latest l2j updates. Common items are added to droplist causing a lot of items being droped on high rate servers. How to fix this?

I found a simple SQL query that modifies the drop chance. The usage is simple:
Lets take that server drop rate is x40 and we want common items to drop with x10 rate. Run this SQL query. This query will divide the chances by 10 so x40 would be x4.

Update droplist set chance = chance/10 where (itemId >= 12006 and itemId <= 12361) or (itemId >= 11605 and itemId <= 12308);

Have fun!

Filed under: General |