Thread: Mysql question
View Single Post
  #2  
Old 12-09-2006, 05:50 PM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

In table: npc_types, run:

Code:
SELECT * FROM npc_types WHERE merchant_id > 0
That should show all NPCs that are set up as merchants in the game (my PEQ database shows 1753, which seems like a lot).

Table merchantlists is nothing but a list of what items the merchant has in what slot by merchant_id (set in table npc_types).

The item "price" seems to be set in table items, price field. I haven't verified this in code, but this is my understanding of merchants.
Reply With Quote