From 60362cd11a7f918b88739c13bdfc1fec58fad714 Mon Sep 17 00:00:00 2001 From: ariel- Date: Sat, 10 Mar 2018 20:02:33 -0300 Subject: DB/Creature: root training dummies Closes #21513 --- sql/updates/world/3.3.5/2018_03_10_03_world.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/3.3.5/2018_03_10_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2018_03_10_03_world.sql b/sql/updates/world/3.3.5/2018_03_10_03_world.sql new file mode 100644 index 00000000000..0b5153ed76a --- /dev/null +++ b/sql/updates/world/3.3.5/2018_03_10_03_world.sql @@ -0,0 +1,19 @@ +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (2673, 2674, 17578, 16111, 24792, 32543, 32546, 32547, 32542, 32545, 30527, 31143, 31144, 31146, 32541, 32666, 32667); +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES +(2673, 1, 0, 0, 1), +(2674, 1, 0, 0, 1), +(17578, 1, 0, 0, 1), +(16111, 1, 0, 0, 1), +(24792, 1, 0, 0, 1), +(32543, 1, 0, 0, 1), +(32546, 1, 0, 0, 1), +(32547, 1, 0, 0, 1), +(32542, 1, 0, 0, 1), +(32545, 1, 0, 0, 1), +(30527, 1, 0, 0, 1), +(31143, 1, 0, 0, 1), +(31144, 1, 0, 0, 1), +(31146, 1, 0, 0, 1), +(32541, 1, 0, 0, 1), +(32666, 1, 0, 0, 1), +(32667, 1, 0, 0, 1); -- cgit v1.2.3