From 27991ff0ba9b673beecf39a72dc0b24f539360d1 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Fri, 19 Jul 2019 01:24:22 +0200
Subject: DB/Pooling: Fix Storm Peaks Ore pool

(cherry picked from commit 28b8c369bb75d0a73c61e3a7e1694f989ca20cb7)
---
 sql/updates/world/master/2021_12_16_14_world_2019_07_19_01_world.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 sql/updates/world/master/2021_12_16_14_world_2019_07_19_01_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2021_12_16_14_world_2019_07_19_01_world.sql b/sql/updates/world/master/2021_12_16_14_world_2019_07_19_01_world.sql
new file mode 100644
index 00000000000..5926ebafc18
--- /dev/null
+++ b/sql/updates/world/master/2021_12_16_14_world_2019_07_19_01_world.sql
@@ -0,0 +1,4 @@
+-- 
+DELETE FROM `pool_template` WHERE `entry`=11389;
+DELETE FROM `pool_members` WHERE `spawnId`=11389 AND `type`=2 AND `poolSpawnId`=9907;
+UPDATE `pool_members` SET `poolSpawnId`=11212 WHERE `spawnId`  IN (162689,162939) AND `poolSpawnId`=11389;
-- 
cgit v1.2.3