From 885b6fa6979fb6766eeeaaf110304fc3cc4a9c62 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Sat, 25 Jan 2020 22:08:26 +0100
Subject: DB/Creature: Lost Soul pooling

(cherry picked from commit 14517326668ee97f1017ea24e9b56fbcde7557b7)
---
 .../world/master/2021_12_20_29_world_2020_01_25_05_world.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 sql/updates/world/master/2021_12_20_29_world_2020_01_25_05_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2021_12_20_29_world_2020_01_25_05_world.sql b/sql/updates/world/master/2021_12_20_29_world_2020_01_25_05_world.sql
new file mode 100644
index 00000000000..d253a8651a5
--- /dev/null
+++ b/sql/updates/world/master/2021_12_20_29_world_2020_01_25_05_world.sql
@@ -0,0 +1,12 @@
+-- Lost Soul
+SET @POOL := 351;
+DELETE FROM `pool_template` WHERE `entry` = @POOL;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES 
+(@POOL, 1, 'Lost Soul');
+DELETE FROM `pool_members` WHERE `poolSpawnId` = @POOL;
+INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES
+(0, 325765, @POOL, 0, "Lost Soul - Spawn 1"),
+(0, 325966, @POOL, 0, "Lost Soul - Spawn 2"),
+(0, 325970, @POOL, 0, "Lost Soul - Spawn 3");
+
+-- UPDATE `creature` SET `position_x`=2757.901611, `position_y`=859.967407, `position_z`=113.202911 WHERE `guid` = 44863;
-- 
cgit v1.2.3