pool_creature
The `pool_creature` table
This table contains a list of creatures that are tied to a specific pool.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | INT | UNSIGNED | PRI | NO | 0 | ||
| pool_entry | MEDIUMINT | UNSIGNED | NO | 0 | |||
| chance | FLOAT | UNSIGNED | NO | 0 | |||
| description | VARCHAR(255) | YES | NULL |
Description of the fields
guid
pool_entry
The pool that this creature is in. Refers to pool_template.entry.
chance
The explicit percentage chance that this creature will be spawned.
If the pool spawns just one creature (max_limit = 1 in the respective pool_template), the core selects the creature to be spawned in a two-step process: First, only the explicitly-chanced (chance > 0) creatures of the pool are rolled. If this roll does not produce any creature, all the creatures without an explicit chance (chance = 0) are rolled with equal chance.
If the pool spawns more than one creature, the chance is ignored and all the creatures in the pool are rolled in one step with equal chance.
In case the pool spawns just one creature and all the creatures have a nonzero chance, the sum of the chances for all the creatures must equal to 100, otherwise the pool won't be spawned.
Value must be >=0. If the value does not meet the condition the SQL will fail on pool_creature_chk_1.
description
This field usually names the creature corresponding to the guid and mentions which spawn point it is. Example: Snarlflare (14272) - Spawn 1