Difference between revisions of "Database:Spawns"

Line 22: Line 22:
  
 
== Related tables ==
 
== 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 ===
 +
 +
* 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_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 ===
 
=== merchants ===

Revision as of 09:01, 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

Command Fields

  • 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

  • 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

  • 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_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_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