Database:Spawns

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