Partial fix for 0 cost items at merchants

[Celebril]

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]

[badk0re]

Wonderful work =)

[samandhi]

Code:
DELETE merchantlist.* FROM items, merchantlist, lootdrop_entries WHERE cost = 0 AND items.id = merchantlist.item AND items.id = lootdrop_entries.item_id;

Hmm what about those same items that the NPC's will not pay YOU anything for? In other words, if you buy it from them (which will now cost pp, will they buy it back for pp?) I have noticed that they will give you 0 pp for an item that they sell for 0pp, even if you dont get it from them, but from a loot drop.. Follow me?

[wize_one]

i believe by defualt merchants will not buy no drop no rent items..that fix was to allow selling of no drop items on merchants

[Celebril]

I just discovered the updated dumpeditems.sql script from this site last night... I was using the version from sourceforge before that (dated from December). I guess there's not much point updating the item prices with new releases of that coming out all the time That was just a "bandaid" fix anyway.
The best way to fix the problem would be to have all those items that merchants normally don't sell be put into the proper loot tables, then to remove them from merchants' inventories. This would negate the need to "balance" their prices altogether. Unfortunately, I don't have an eqlive account anymore, so I cannot contribute to getting those loot drops accurate :(
Does anybody know of a site which might have such data easily available (which creatures drop which items, I mean)?