diff options
| author | Killyana <morphone1@gmail.com> | 2016-04-09 20:57:38 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2016-04-09 20:57:38 +0200 |
| commit | c677a82409426150a42cf17a224c7cc17cd48bca (patch) | |
| tree | 2cce62348fa0c13cc2da306c92eec072b9e80e7c | |
| parent | 89cabacbc0bb7d138c199aeed94975ae2c345599 (diff) | |
DB/Creature: Add pooling for Ethereum Jailor
Cherry Picks from https://github.com/TrinityCore/TrinityCore/commit/8a2a129d3597e5410f34ed72c8ead2fd9987f841
| -rw-r--r-- | sql/updates/world/2016_04_09_39_world.sql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/sql/updates/world/2016_04_09_39_world.sql b/sql/updates/world/2016_04_09_39_world.sql new file mode 100644 index 00000000000..cea9ca4f272 --- /dev/null +++ b/sql/updates/world/2016_04_09_39_world.sql @@ -0,0 +1,30 @@ +-- +SET @pool_id=369; +SET @GUID=87572; +DELETE FROM `pool_template` WHERE `entry` = @pool_id; +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(@pool_id, 5, 'Ethereum Jailor'); + +DELETE FROM `pool_creature` WHERE `guid` BETWEEN @GUID AND @GUID+20; +INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES +(@GUID+0, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+1, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+2, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+3, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+4, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+5, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+6, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+7, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+8, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+9, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+10, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+11, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+12, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+13, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+14, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+15, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+16, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+17, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+18, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+19, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+20, @pool_id, 0, 'Ethereum Jailor'); |