Difference between revisions of "Database:Spawns"

Line 6: Line 6:
  
 
The following lists how fields function in the database
 
The following lists how fields function in the database
 +
 +
=== Generic Spawn Fields ===
 +
 +
* name = The name of the spawn
  
 
=== Merchant Fields ===
 
=== Merchant Fields ===

Revision as of 08:16, 24 September 2009

About

Please fill more information in here as you find it

Table Breakdown

The following lists how fields function in the database

Generic Spawn Fields

  • name = The name of the spawn

Merchant Fields

  • merchant_id = The merchant list id
  • merchant_type = (1 - no buy), (2 - no buy back), (3 - spells), (4 - crafting)

Related tables

merchants

  • merchant_id = the merchant_id for your table
  • inventory_id = the inventory the merchant list will show (see merchant_inventory)
  • description = the description of the merchant list

merchant_inventory

  • inventory_id = the inventory_id to place the item in (see merchants/inventory_id)
  • item_id = the id of the item to sell
  • quantity = the amount of item to sell