DB/Creature: Add pooling for Ethereum Jailor

Only 5 spawns can be active in the world

1 files changed, 30 insertions, 0 deletions

diff --git a/sql/updates/world/2016_01_17_011_world.sql b/sql/updates/world/2016_01_17_011_world.sql
new file mode 100644
index 00000000000..e4e8ab5e9e2
--- /dev/null
+++ b/sql/updates/world/2016_01_17_011_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');