Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2004, 11:52 AM
shadowmeir
Fire Beetle
 
Join Date: Nov 2004
Posts: 2
Default NPC item lists

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
Reply With Quote
  #2  
Old 11-29-2004, 02:47 PM
Zengez
Hill Giant
 
Join Date: Nov 2004
Posts: 160
Default

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
Reply With Quote
  #3  
Old 11-29-2004, 08:06 PM
Muuss
Dragon
 
Join Date: May 2003
Posts: 539
Default

#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.
__________________
Muuss - [PEQGC] Dobl, the ogre that counts for 2 !
http://www.vilvert.fr/page.php?id=10
Reply With Quote
  #4  
Old 11-30-2004, 01:02 AM
Zengez
Hill Giant
 
Join Date: Nov 2004
Posts: 160
Default

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
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 05:13 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3