Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `pool_creature` table''' This table contains a list of creatur..."

2012-07-07T21:18:17Z

Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} <big>'''The `pool_creature` table'''</big> This table contains a list of creatur..."

New page

{| align="right"
| __TOC__
|}
[[Category: SkyFire World database tables]]
{{Back-to:World}}

<big>'''The `pool_creature` table'''</big>

This table contains a list of creatures that are tied to a specific pool.

<big>'''Structure'''</big>
{| border="1" cellspacing="1" cellpadding="3"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#guid|guid]]
|int(10)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#pool_entry|pool_entry]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#chance|chance]]
|float
|unsigned
|
|NO
|0
|
|
|-
|[[#description|description]]
|varchar(255)
|signed
|
|YES
|NULL
|
|
|}

<big>'''Description of the fields'''</big>
====guid====
Creature's [[creature_SF#guid|guid]].

====pool_entry====
The [[pool_template_SF#entry|pool]] that this creature is in. Refers to [[pool_template_SF#pool_template|pool_template]] [[pool_template_SF#entry|entry]].

====chance====
The explicit percentage chance that this creature will be spawned.

If the pool spawns just one creature ([[pool_template_SF#max_limit|max_limit]] = 1 in the respective [[pool_template_SF#pool_template|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 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.

====description====
This field usually names the creature corresponding to the [[pool_creature_SF#guid|guid]] and mentions which spawn point it is. Example: Snarlflare (14272) - Spawn 1

Pool creature SF - Revision history

Cheapgamer: Created page with "{| align="right" | __TOC__ |} Category: SkyFire World database tables {{Back-to:World}} '''The `pool_creature` table''' This table contains a list of creatur..."

Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `pool_creature` table''' This table contains a list of creatur..."