I've done some research on generation a new merchantlist from scratch this weekend and I have discovered that this will take quite some time. Unfortunately far more time I can spare in the the next few weeks.
So as an interim solution I am going back to trimming down the exisiting merchantlist table.
Provided you have both the peq-luclin-release file load_system.sql and my allowed_vendor_items.txt file in one directory on an Linux Box all you need to do is:
Code:
grep "merchantlist " load_system.sql > merchantlist.orig
for i in `cat allowed_vendor_items.txt| cut -d"," -f1` ; do grep ",$i)" merchantlist.orig ; done > merchantlist.new
The above will weed out any item id not listed in allowed_vendor_items.txt and write a new merchantlist table. Be aware that there is no change to the slot id.
Edit: Please be aware that the merchants in cshome and all customized adventure merchants and such will loose most to all of their inventory.