pool_members

The ‘pool_members’ table

The ‘pool_members’ table

This table holds the contents of pools created in pool_template.

Structure

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

 

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.