You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Database:Spawns"
| Line 8: | Line 8: | ||
=== Generic Spawn Fields === | === Generic Spawn Fields === | ||
| + | |||
| + | Generic information like name, race, etc | ||
* name = The name of the spawn | * name = The name of the spawn | ||
| − | === Command Fields === | + | === Entity Command Fields === |
| + | |||
| + | This allows you to tag an npc as a banker, a merchant and so forth. Run the query SELECT * FROM entity_commands to see commands set up on your server. | ||
* command_primary = The primary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank | * command_primary = The primary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank | ||
| Line 17: | Line 21: | ||
=== Merchant Fields === | === Merchant Fields === | ||
| + | |||
| + | This allows you to configure the NPC as a merchant, note you should tag the entity command ie: frommerchant (see your entity_command table) or bank etc. | ||
* merchant_id = The merchant list id | * merchant_id = The merchant list id | ||
| Line 31: | Line 37: | ||
=== loottable === | === loottable === | ||
| + | |||
| + | A list of loot tables, which acts as a parent to lootdrops | ||
* name = descriptive name of the loottable | * name = descriptive name of the loottable | ||
| Line 40: | Line 48: | ||
=== lootdrop === | === lootdrop === | ||
| + | |||
| + | Loot drops are members of loot tables and list items that drop | ||
* loot_table_id = id of the lootttable (see above) | * loot_table_id = id of the lootttable (see above) | ||
| Line 48: | Line 58: | ||
=== merchants === | === merchants === | ||
| + | |||
| + | Merchant lists list a selection of inventories that a merchant list will sell | ||
* merchant_id = the merchant_id for your table | * merchant_id = the merchant_id for your table | ||
| Line 54: | Line 66: | ||
=== merchant_inventory === | === merchant_inventory === | ||
| + | |||
| + | Merchant inventories allow you to configure the items for sale in a merchant list | ||
* inventory_id = the inventory_id to place the item in (see merchants/inventory_id) | * 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 09:54, 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
Generic Spawn Fields
Generic information like name, race, etc
- name = The name of the spawn
Entity Command Fields
This allows you to tag an npc as a banker, a merchant and so forth. Run the query SELECT * FROM entity_commands to see commands set up on your server.
- command_primary = The primary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank
- command_secondary = The secondary entity command of the NPC, see the entity_commands table for more information. EG: 9 may = bank
Merchant Fields
This allows you to configure the NPC as a merchant, note you should tag the entity command ie: frommerchant (see your entity_command table) or bank etc.
- merchant_id = The merchant list id
- merchant_type = (1 - no buy), (2 - no buy back), (3 - spells), (4 - crafting)
Related tables
spawn_loot
Provides a list of loot tables that a spawn id should drop
- spawn_id = id of the spawn
- loottable_id = id of the loot table
loottable
A list of loot tables, which acts as a parent to lootdrops
- name = descriptive name of the loottable
- mincoin = minimum amount of coin
- maxcoin = maximum amount of coin
- maxlootitems = maximum amount of items that should drop
- lootdrop_probability = probability of the lootdrop occuring
- coin_probability = probability of the coin occuring
lootdrop
Loot drops are members of loot tables and list items that drop
- loot_table_id = id of the lootttable (see above)
- item_id = the id of one of the items to appear in the lootdrop list
- item_charges = number of charges on this item
- equip_item = should the npc equip this item
- probability = probability of this item dropping
merchants
Merchant lists list a selection of inventories that a merchant list will sell
- 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 inventories allow you to configure the items for sale in a merchant list
- 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