From 8a2a129d3597e5410f34ed72c8ead2fd9987f841 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Sun, 17 Jan 2016 17:22:08 +0100
Subject: DB/Creature: Add pooling for Ethereum Jailor

Only 5 spawns can be active in the world
---
 sql/updates/world/2016_01_17_011_world.sql | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)
 create mode 100644 sql/updates/world/2016_01_17_011_world.sql

(limited to 'sql/updates')

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');
-- 
cgit v1.2.3