pool_members
- Fabian Hergt
The ‘pool_members’ table |
|---|
This table holds the contents of pools created in pool_template.
Structure |
|---|
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|
|---|---|---|---|---|---|---|---|---|
type | smallint |
| PRI | NO | 0 |
|
|
|
spawnId | int |
| PRI | NO | 0 |
|
|
|
poolSpawnId | int |
|
| NO | 0 |
|
|
|
chance | double |
|
| NO | 0 |
|
|
|
description | varchar(255) |
|
| YES | NULL |
|
|
|
Description of the fields
type
0 = Creature
1 = GameObject
2 = Pool
spawnId
Defined by type, either creature spawn guid, gameobject spawn guid or pool entry from pool_template.
poolSpawnId
Refers to 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.