diff options
| author | megamage <none@none> | 2009-02-19 18:46:19 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-02-19 18:46:19 -0600 |
| commit | 83adfb5692e3daa4d09d233f193f23b746e5e4c4 (patch) | |
| tree | c32d3119fbea09fe9fbbf40f0df6e4f8d3425399 /sql | |
| parent | e21b2c9baa506a265fddd50f65a69d2bb297cc96 (diff) | |
Added support for pools in pools
Pools inside another pool cannot have a number of spawned objects <> 1 (maxlimit value)
Note: pools in a pool in a pool in a pool... is possible and working,
but circulare inclusion is not detected and will cause a core infinit loop
Author: Neo2003
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/7299_01_mangos_pools.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/7299_01_mangos_pools.sql b/sql/updates/7299_01_mangos_pools.sql index 0b212fd7378..afc3c88cb26 100644 --- a/sql/updates/7299_01_mangos_pools.sql +++ b/sql/updates/7299_01_mangos_pools.sql @@ -12,6 +12,13 @@ CREATE TABLE `pool_gameobject` ( PRIMARY KEY (`guid`,`pool_entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; +CREATE TABLE `pool_pool` ( + `pool_id` mediumint(8) unsigned NOT NULL default '0', + `mother_pool` mediumint(8) unsigned NOT NULL default '0', + `chance` float NOT NULL default '0', + PRIMARY KEY (`pool_id`,`mother_pool`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + CREATE TABLE `pool_template` ( `entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Pool entry', `max_limit` int(10) unsigned NOT NULL default '0' COMMENT 'Max number of objects (0) is no limit', |