DB/Durotar: Some updates to Senjin Village

1 files changed, 75 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_03_23_01_world.sql b/sql/updates/world/master/2025_03_23_01_world.sql
new file mode 100644
index 00000000000..2eec0d036ed
--- /dev/null
+++ b/sql/updates/world/master/2025_03_23_01_world.sql
@@ -0,0 +1,75 @@
+SET @CGUID := 4000757;
+SET @OGUID := 4000240;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` = @CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 71333, 1, 14, 367, '0', 0, 0, 0, 0, -775.2725830078125, -4872.11962890625, 20.11041831970214843, 1.069466352462768554, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 59679); -- Ki'ta Arrowtusk (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+
+-- Update positions
+UPDATE `creature` SET `position_x`= -814.84552001953125, `position_y`= -4915.751953125, `position_z`= 19.27795982360839843, `orientation`= 2.94960641860961914 WHERE `guid` = 309576;
+
+-- GameObject
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+13;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 202835, 1, 14, 367, '0', 0, 0, -827.076416015625, -4875.15966796875, 19.57098388671875, 4.857946395874023437, -0.00895977020263671, 0.001100540161132812, -0.65382003784179687, 0.756596267223358154, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+1, 202839, 1, 14, 367, '0', 0, 0, -830.51739501953125, -4875.75537109375, 19.85191535949707031, 5.045515060424804687, 0, 0, -0.58008670806884765, 0.814554750919342041, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence Post (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+2, 202839, 1, 14, 367, '0', 0, 0, -753.98956298828125, -4837.376953125, 20.29513931274414062, 3.856971025466918945, 0.007650375366210937, -0.02623176574707031, -0.93633937835693359, 0.350031346082687377, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence Post (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+3, 202835, 1, 14, 367, '0', 0, 0, -814.63714599609375, -4875.31787109375, 19.06008529663085937, 4.427181243896484375, -0.03291273117065429, -0.00387477874755859, -0.80027008056640625, 0.598723292350769042, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+4, 202839, 1, 14, 367, '0', 0, 0, -848.98089599609375, -4873.205078125, 19.50335121154785156, 4.49179840087890625, 0.019816875457763671, -0.02727699279785156, -0.78016567230224609, 0.624663710594177246, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence Post (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+5, 202835, 1, 14, 367, '0', 0, 0, -846.0711669921875, -4874.91845703125, 19.97179794311523437, 4.133981704711914062, 0.00207376480102539, -0.04065704345703125, -0.87836456298828125, 0.476254522800445556, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+6, 202835, 1, 14, 367, '0', 0, 0, -765.17535400390625, -4827.18212890625, 19.35793685913085937, 4.138099193572998046, -0.04360723495483398, 0.060954093933105468, -0.87627506256103515, 0.475946485996246337, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+7, 202835, 1, 14, 367, '0', 0, 0, -859.37152099609375, -4871.89404296875, 20.22395896911621093, 4.946660995483398437, 0.037186145782470703, -0.0265045166015625, -0.61905670166015625, 0.784017562866210937, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+8, 202839, 1, 14, 367, '0', 0, 0, -789.9149169921875, -4877.69970703125, 19.33333396911621093, 5.021447658538818359, 0, 0, -0.58984661102294921, 0.807515323162078857, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence Post (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+9, 202835, 1, 14, 367, '0', 0, 0, -752.56597900390625, -4840.47412109375, 20.68576431274414062, 3.521735191345214843, 0.010813713073730468, -0.04436683654785156, -0.98098564147949218, 0.188631460070610046, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+10, 202839, 1, 14, 367, '0', 0, 0, -862.640625, -4872.859375, 19.65110588073730468, 5.103348731994628906, 0.021522045135498046, -0.01683616638183593, -0.55603981018066406, 0.830706357955932617, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence Post (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+11, 202835, 1, 14, 367, '0', 0, 0, -820.576416015625, -4874.4130859375, 19.3814239501953125, 4.676824092864990234, -0.00750541687011718, 0.011237144470214843, -0.71948051452636718, 0.694381117820739746, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+12, 202839, 1, 14, 367, '0', 0, 0, -768.27081298828125, -4825.74462890625, 19.93432998657226562, 4.75557708740234375, -0.10455513000488281, 0.035693168640136718, -0.69082069396972656, 0.714535534381866455, 120, 255, 1, 59679), -- Sen'jin Bat Roost Fence Post (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+(@OGUID+13, 202835, 1, 14, 367, '0', 0, 0, -786.6788330078125, -4876.6474609375, 19.16666603088378906, 5.012210845947265625, 0.009224414825439453, -0.00744533538818359, -0.59352302551269531, 0.804729700088500976, 120, 255, 1, 59679); -- Sen'jin Bat Roost Fence (Area: Sen'jin Village - Difficulty: 0) CreateObject1
+
+-- Path for Senjin Watcher
+SET @MOVERGUID := 309588;
+SET @ENTRY := 3297;
+SET @PATHOFFSET := 0;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, NULL, 'Senjin Watcher - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -824.90857, -4892.6685, 19.597498, NULL, 0),
+(@PATH, 1, -816.6692, -4892.9277, 19.218502, NULL, 0),
+(@PATH, 2, -812.3421, -4895.744, 19.194778, NULL, 0),
+(@PATH, 3, -808.31476, -4901.0137, 19.264536, NULL, 0),
+(@PATH, 4, -802.738, -4903.9688, 19.438566, NULL, 0),
+(@PATH, 5, -796.58484, -4901.432, 19.502586, NULL, 0),
+(@PATH, 6, -792.05475, -4901.635, 19.539076, NULL, 0),
+(@PATH, 7, -790.29865, -4904.7344, 19.589085, NULL, 0),
+(@PATH, 8, -791.69617, -4908.349, 19.586267, NULL, 0),
+(@PATH, 9, -794.60767, -4910.097, 19.55, NULL, 0),
+(@PATH, 10, -797.2483, -4910.158, 19.515501, NULL, 0),
+(@PATH, 11, -800.6594, -4908.754, 19.39083, NULL, 0),
+(@PATH, 12, -804.4012, -4909.3267, 19.377724, NULL, 0),
+(@PATH, 13, -807.60364, -4911.9336, 19.222582, NULL, 0),
+(@PATH, 14, -810.26587, -4916.7783, 19.373941, NULL, 0),
+(@PATH, 15, -813.6268, -4921.2446, 19.393717, NULL, 0),
+(@PATH, 16, -818.33453, -4925.0103, 19.629108, NULL, 0),
+(@PATH, 17, -821.9809, -4928.2344, 19.927263, NULL, 0),
+(@PATH, 18, -826.3594, -4929.8423, 20.276354, NULL, 0),
+(@PATH, 19, -830.6059, -4929.1807, 20.572798, NULL, 0),
+(@PATH, 20, -833.8768, -4927.4272, 20.702688, NULL, 0),
+(@PATH, 21, -837.32465, -4923.4116, 20.541348, NULL, 0),
+(@PATH, 22, -842.1667, -4919.221, 20.552881, NULL, 0),
+(@PATH, 23, -842.5417, -4915.5786, 20.393187, NULL, 0),
+(@PATH, 24, -841.57404, -4912.1304, 20.21583, NULL, 0),
+(@PATH, 25, -839.4575, -4908.5576, 20.048054, NULL, 0),
+(@PATH, 26, -835.59125, -4905.8, 19.83872, NULL, 0),
+(@PATH, 27, -832.1348, -4903.397, 19.808771, NULL, 0),
+(@PATH, 28, -829.2576, -4899.274, 19.867643, NULL, 0),
+(@PATH, 29, -829.2539, -4894.9517, 19.91815, NULL, 0);
+
+UPDATE `creature` SET `position_x`=-824.90857, `position_y`=-4892.6685, `position_z`=19.597498, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);