aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-05-31 17:18:19 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-01-11 23:03:57 +0100
commitf9ff8388a19b7193a3ecad810a010e5fec60d007 (patch)
tree258c33426d7e5ad1b88bb2a3b57f9f0bec109fcb
parent37e632968ab7572e974a18e57d04d24279982966 (diff)
DB/Creature: Remove and fix some wrong spawns in Eversong Woods
Closes #17230 By SnapperRy and lyn1337 (cherry picked from commit dec66e3174a7cd4352ebb5d43ba678e477c09ceb)
-rw-r--r--sql/updates/world/master/2017_01_11_10_world_2016_05_31_06_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_11_10_world_2016_05_31_06_world.sql b/sql/updates/world/master/2017_01_11_10_world_2016_05_31_06_world.sql
new file mode 100644
index 00000000000..46d8b875c82
--- /dev/null
+++ b/sql/updates/world/master/2017_01_11_10_world_2016_05_31_06_world.sql
@@ -0,0 +1,10 @@
+--
+-- remove mis-spawned Mistbat (entry: 16353)
+DELETE FROM `creature` WHERE `guid`=57016;
+
+-- remove one too many spawned Elder Springpaw (entry: 15651)
+DELETE FROM `creature` WHERE `guid`=55946;
+
+-- set random movement and spawn distance to the common value for that creature
+UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `guid`=55942;
+UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `guid`=55945;