Pool creature SF

From Project Skyfire
Revision as of 16:18, 7 July 2012 by Cheapgamer (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Back to world database list of tables.


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(10) unsigned PRI NO 0
pool_entry mediumint(8) unsigned NO 0
chance float unsigned NO 0
description varchar(255) signed YES NULL


Description of the fields

guid

Creature's 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 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 guid and mentions which spawn point it is. Example: Snarlflare (14272) - Spawn 1