NPC item lists

[shadowmeir]

yo all
my server is running with everything i just want to know if i could add to what certain merchants sell.
like the spell merchants dont have all the spells for the characters.
any imformation that you please respond

[Zengez]

Only thing i can think of is do a #finditem (spellname) to find what the item id of every spell you want on teh merchant, then go through and make a custom merchantid and import all your items onto a 'custom' merchant, thereby being able to customize the merchant to sell all the spells instead of just teh some...

If you can find a merchantid table somewhere (i haven't, but then again, i haven't looked heh) you could find out which merchantid numbers have the current spell list, then just edit them to include the spells that are missing... but personally it seems easier to me to build a custom merchant, even with all that hand editing... /shrug i've put up over a dozen merchants each selling 30+ items by type (all blacksmithingmade weapons on these 2 merchants, all blacksmithing chain on this merchant etc etc) in the last 3 days and it's not so bad.... although the more i look at the sheer quantity of player crafted gear (which i'm trying to put all of onto merchants) the more it makes me wanna cry :)

Anyways, hope that helps, if you need more info on how to actually make custom merchants pm me, or just do a search, i'm sure theres a half dozen threads on it (too lazy to go find one right now tho ;)

[Muuss]

#npcstats show
will give you the id of the npc (in game)

In the npc_types table, you'll find a field named merchant_id for that npc. Once you have it, obtain all the records matching the merchant_id of your npc. Add the items you need to merchantlist. don't forget to increase the value of 'slot' for each item.

If you don't know how to do this, read a tutorial on how to use mysql, you CAN'T run a server without knowing the basics of sql.

[Zengez]

If you do want to go with the custom merchants (Muuss's idea probably easier for you /shrug) i just finished a (hopefully) comprehensive step by step guide to making a custom merchant with custom item costs...

http://www.eqemulator.net/forums/viewtopic.php?t=18730

Dunno if that'd help you, but it's there if you want it /shrug