DB/Creature: Deathless Watcher

1 files changed, 23 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_04_29_00_world.sql b/sql/updates/world/3.3.5/2019_04_29_00_world.sql
new file mode 100644
index 00000000000..f89796955ae
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_04_29_00_world.sql
@@ -0,0 +1,23 @@
+-- 
+UPDATE `creature` SET `orientation`=2.822289 WHERE `guid`=115151;
+DELETE FROM `creature` WHERE `guid` IN (103664, 103665, 103670, 103671, 103672, 103673, 103708, 103738, 103824, 103827, 103892, 103909, 103911, 103916, 103917);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES 
+(103664, 24013, 571, 0, 0, 1, 1, 17311, 0, 2427.17, -3583.82, 235.574, 3.33358, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103665, 24013, 571, 0, 0, 1, 1, 17311, 0, 2489.82, -3642.58, 230.686, 0.26179, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103670, 24013, 571, 0, 0, 1, 1, 17311, 0, 2686.44, -3459.87, 225.688, 2.33874, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103671, 24013, 571, 0, 0, 1, 1, 17311, 0, 2494.36, -3657.27, 267.185, 6.02835, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103672, 24013, 571, 0, 0, 1, 1, 17311, 0, 2472.38, -3624.29, 230.704, 1.06465, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103673, 24013, 571, 0, 0, 1, 1, 17311, 0, 2654.03, -3729.31, 247.374, 0.50614, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103708, 24013, 571, 0, 0, 1, 1, 17311, 0, 2753.07, -3432.81, 260.421, 4.88692, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103738, 24013, 571, 0, 0, 1, 1, 17311, 0, 2686.1, -3769.21, 248.451, 0.767945, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103824, 24013, 571, 0, 0, 1, 1, 17311, 0, 2738.41, -3427.69, 223.898, 4.32842, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103827, 24013, 571, 0, 0, 1, 1, 17311, 0, 2635.78, -3701.51, 245.945, 5.60251, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103892, 24013, 571, 0, 0, 1, 1, 17311, 0, 2776.44, -3586.02, 254.337, 3.24631, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103909, 24013, 571, 0, 0, 1, 1, 17311, 0, 2776.69, -3621.71, 253.305, 3.59538, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103911, 24013, 571, 0, 0, 1, 1, 17311, 0, 2716.35, -3395.18, 260.169, 2.84984, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103916, 24013, 571, 0, 0, 1, 1, 17311, 0, 2457.49, -3619.88, 267.007, 1.95917, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0),
+(103917, 24013, 571, 0, 0, 1, 1, 17311, 0, 2486.59, -3627.70, 267.017, 0.70742, 300, 0, 0, 8982, 3155, 0, 0, 0, 0, 0);
+
+DELETE FROM `creature_template_movement` WHERE `CreatureId`= 24013;
+INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`) VALUES
+(24013, 1, 1, 2, 0);