Celebril
02-23-2004, 07:45 AM
This doesn't fix all of the items (less than 100 or so) that are being sold by merchants for free (using the MWnpcmov db), but I thought I would share this with everyone. This will remove any free items from merchants which can be looted from creatures.
DELETE merchantlist.* FROM items, merchantlist, lootdrop_entries WHERE cost = 0 AND items.id = merchantlist.item AND items.id = lootdrop_entries.item_id;
On that same topic, I'm trying to come up with (somewhat :) ) accurate prices of items (weapons are a priority) to somewhere around where they should be for their power. I was thinking of a formula, maybe something like (20 * (damage/delay))^2 * (damage/delay) * 5000 to get the items price in cp. That seems to work alright for 2H weapons (except for the really weak ones like Rusty, Tarnished, etc). Has anybody done this already/has a better idea? Any input would be appreciated.[/code]
DELETE merchantlist.* FROM items, merchantlist, lootdrop_entries WHERE cost = 0 AND items.id = merchantlist.item AND items.id = lootdrop_entries.item_id;
On that same topic, I'm trying to come up with (somewhat :) ) accurate prices of items (weapons are a priority) to somewhere around where they should be for their power. I was thinking of a formula, maybe something like (20 * (damage/delay))^2 * (damage/delay) * 5000 to get the items price in cp. That seems to work alright for 2H weapons (except for the really weak ones like Rusty, Tarnished, etc). Has anybody done this already/has a better idea? Any input would be appreciated.[/code]