DB/Creature: Lost Soul pooling

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_01_25_05_world_335.sql b/sql/updates/world/3.3.5/2020_01_25_05_world_335.sql
new file mode 100644
index 00000000000..dabd7902be8
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_01_25_05_world_335.sql
@@ -0,0 +1,11 @@
+-- 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, 44863, @POOL, 0, "Lost Soul - Spawn 1"),
+(0, 44864, @POOL, 0, "Lost Soul - Spawn 2");
+
+UPDATE `creature` SET `position_x`=2757.901611, `position_y`=859.967407, `position_z`=113.202911 WHERE `guid` = 44863;