You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Database:Spawns"
m (New page: == 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 = T...) |
m |
||
| Line 11: | Line 11: | ||
* merchant_id = The merchant list id | * merchant_id = The merchant list id | ||
* merchant_type = (1 - no buy), (2 - no buy back), (3 - spells), (4 - crafting) | * 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 === | ||
| + | |||
| + | merchant_id = the merchant_id to place the item in (see merchants) | ||
| + | item_id = the id of the item to sell | ||
| + | quantity = the amount of item to sell | ||
Revision as of 08:13, 24 September 2009
Contents
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
merchant_id = the merchant_id to place the item in (see merchants) item_id = the id of the item to sell quantity = the amount of item to sell