Cleaning up the merchantlist table

[eq4me]

As most of you are aware there is lots of stuff on the merchants that is not supposed to be there. Mostly it is newby area crap stuff but there are quite a few good or rare items people had sold on EQLive when the zones merchant lists where grabbed.
With the low population of most Emu servers this is mostly not a bad thing to have some hard to forage/camp tradeskill items like spiderling silk and basic equipment like cloth/chain/bronze armor on the merchants but is is not ideal to have that scattered around like it is now. So I propose that we strip the merchants down to their original items and add basic but hard to come by items in an more controlled fashion.

To start the ball rolling I punched up a small script that reads out all available itemids on the merchantlist table(but not the temp table) and do some statistics on em. For now I checked what name in the items table the id matches. How many merchants have this item, how many mobs drop it and how many tradeskill recipes exist to create such an item. Please be aware that there is no checking if the mob, recipe or merchant actually exists or spawns

The list is based on the last PEQ release but should be mostly the same as peq-luclin-rc1 and Angelox's DB.

http://80.237.220.68/files/items_lis...hantlist_table

There are quite some entries and my first step would be to bulk strip all obviously not for sale items bevore going into details. On first glance there are some strange things like a recipe for Evil Eye Eyestalks. =)

Any help and comments would be appreciated.

EDIT: I am not 100% sure if the tradeskill recipes part of the statistic is right. I'll check this after work.