pool_members
This table holds the contents of pools created in pool_template.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| type | smallint | unsigned | PRI | NO | |||
| spawnId | int | unsigned | PRI | NO | |||
| poolSpawnId | int | unsigned | NO | ||||
| chance | float | NO | |||||
| description | varchar(255) | YES | NULL | ||||
Description of fields
type
- 0: Creature
- 1: GameObject
- 2: Pool
spawnId
- type = 0: creature guid
- type = 1: gameobject guid
- type = 2: pool entry
poolSpawnId
references pool_template.entry
chance
The explicit percentage chance that this entity will be spawned.
If the pool spawns just one entity (max limit = 1 in the respective pool_template), the core selects the entity to be spawned in a two-step process: First, only the explicitly-chanced (chance > 0) entity of the pool are rolled. If this roll does not produce any entity, all the entity without explicit chance (chance = 0) are rolled with equal chance. If the pool spawns more than one entity, 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 entity and all the entity have a nonzero chance, the sum of the chances for all the entity must equal to 100, otherwise the pool won't be spawned.
description
This field usually names the creature/gameobject corresponding to the guid and mentions which spawn point it is. Example:
- Snarlflare (14272) - Spawn 1
- Spawn Point 4 - Tin Vein