aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2020_01_25_02_world_335.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_01_25_02_world_335.sql b/sql/updates/world/3.3.5/2020_01_25_02_world_335.sql
new file mode 100644
index 00000000000..9c24940d88d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_01_25_02_world_335.sql
@@ -0,0 +1,9 @@
+-- Mist Howler
+SET @POOL := 348;
+DELETE FROM `pool_template` WHERE `entry` = @POOL;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
+(@POOL, 1, 'Mist Howler');
+DELETE FROM `pool_members` WHERE `poolSpawnId` = 348;
+INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES
+(0, 32884, 348, 0, "Mist Howler - Spawn 1"),
+(0, 51885, 348, 0, "Mist Howler - Spawn 2");