Difference between revisions of "Database:Spawns"

m
Line 16: Line 16:
 
=== merchants ===
 
=== merchants ===
  
merchant_id = the merchant_id for your table
+
* merchant_id = the merchant_id for your table
inventory_id = the inventory the merchant list will show (see merchant_inventory)
+
* inventory_id = the inventory the merchant list will show (see merchant_inventory)
description = the description of the merchant list
+
* description = the description of the merchant list
  
 
=== merchant_inventory ===
 
=== merchant_inventory ===
  
merchant_id = the merchant_id to place the item in (see merchants)
+
* inventory_id = the inventory_id to place the item in (see merchants/inventory_id)
item_id = the id of the item to sell
+
* item_id = the id of the item to sell
quantity = the amount of item to sell
+
* quantity = the amount of item to sell

Revision as of 08:15, 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

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