aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWinchester1987 <Winchester1987@users.noreply.github.com>2018-09-01 15:29:02 +0200
committerKillyana <morphone1@gmail.com>2018-09-01 15:29:02 +0200
commit9ace4093d8cf67ba54912038f93fa42d3aa14b9c (patch)
treef2d5c6b5fcbdce5e5efcb47a7442e551514f7512
parentca7ee982db4d25c464acf6daadc150d58dafa016 (diff)
DB/Creature: Fix Sindragosa movements
Closes #22358
-rw-r--r--sql/updates/world/3.3.5/2018_09_01_01_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_09_01_01_world.sql b/sql/updates/world/3.3.5/2018_09_01_01_world.sql
new file mode 100644
index 00000000000..ca957cf0703
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_09_01_01_world.sql
@@ -0,0 +1,7 @@
+--
+DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (36853, 38265, 38266, 38267);
+INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES
+(36853, 1, 0, 2, 0),
+(38265, 1, 0, 2, 0),
+(38266, 1, 0, 2, 0),
+(38267, 1, 0, 2, 0);