DB: Respawn Arcane Reavers at Dawnstar Spire

Closes #28330

(cherry picked from commit 61144fb47d0b483c0f820d1a7f22342c340171b9)

1 files changed, 116 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_01_11_04_world_2022_10_30_04_world.sql b/sql/updates/world/master/2023_01_11_04_world_2022_10_30_04_world.sql
new file mode 100644
index 00000000000..e59031f3c55
--- /dev/null
+++ b/sql/updates/world/master/2023_01_11_04_world_2022_10_30_04_world.sql
@@ -0,0 +1,116 @@
+-- Respawn Arcane Reavers at Dawnstar Spire using createobject2
+DELETE FROM `creature` WHERE `id`=16339;
+DELETE FROM `creature_addon` WHERE `guid` IN (81857,81858,81859,81860,81861,81863,81864,81865,81867,81869,81937,81938);
+INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnDifficulties`,`phaseId`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`wander_distance`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`ScriptName`,`VerifiedBuild`) VALUES
+(81857, 16339, 530, 0, 0, '0', 0, 0, 0, 7829.5845, -7911.2017, 169.3264, 2.792526721954345703, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0),
+(81858, 16339, 530, 0, 0, '0', 0, 0, 0, 7793.8525, -7904.7544, 166.86871, 3.333578824996948242, 300, 0, 0, 1, 0, 2, 0, 0, 0, '', 0),
+(81859, 16339, 530, 0, 0, '0', 0, 0, 0, 7830.1475, -7888.4844, 169.32259, 0.51941615343093872, 300, 0, 0, 1, 0, 2, 0, 0, 0, '', 0),
+(81860, 16339, 530, 0, 0, '0', 0, 0, 0, 7807.1016, -7828.088, 170.31082, 2.015940666198730468, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0),
+(81861, 16339, 530, 0, 0, '0', 0, 0, 0, 7842.2188, -7876.0615, 167.13791, 1.466076612472534179, 300, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
+(81863, 16339, 530, 0, 0, '0', 0, 0, 0, 7817.933, -7875.994, 167.24031, 1.919862151145935058, 300, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
+(81864, 16339, 530, 0, 0, '0', 0, 0, 0, 7866.79, -7903.742, 167.29266, 6.096136093139648437, 300, 0, 0, 1, 0, 2, 0, 0, 0, '', 0),
+(81865, 16339, 530, 0, 0, '0', 0, 0, 0, 7830.759, -7930.8506, 169.3264, 1.570796370506286621, 300, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
+(81867, 16339, 530, 0, 0, '0', 0, 0, 0, 7866.2603, -7911.634, 180.51527, 0.017314286902546882, 300, 0, 0, 1, 0, 2, 0, 0, 0, '', 0),
+(81869, 16339, 530, 0, 0, '0', 0, 0, 0, 7806.522, -7911.297, 169.32648, 6.2657318115234375, 300, 0, 0, 1, 0, 0, 0, 0, 0, '', 0),
+(81937, 16339, 530, 0, 0, '0', 0, 0, 0, 7837.8115, -7831.0044, 170.4031, 4.597919464111328125, 300, 5, 0, 1, 0, 1, 0, 0, 0, '', 0),
+(81938, 16339, 530, 0, 0, '0', 0, 0, 0, 7851.48, -7902.987, 169.32646, 3.717551231384277343, 300, 0, 0, 1, 0, 0, 0, 0, 0, '', 0);
+
+DELETE FROM `waypoint_data` WHERE `id` IN (81860,81865,81869);
+
+-- Pathing for Arcane Reaver Entry: 16339
+SET @NPC := 81858;
+SET @PATH := @NPC * 10;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`visibilityDistanceType`,`auras`) VALUES (@NPC,@PATH,0,0,1,0,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,7793.723,-7904.971,166.84819,NULL,0,0,0,100,0),
+(@PATH,2,7789.53,-7888.44,167.1335,NULL,0,0,0,100,0),
+(@PATH,3,7785.9644,-7862.049,167.60872,NULL,0,0,0,100,0),
+(@PATH,4,7783.237,-7843.7944,169.02388,NULL,0,0,0,100,0),
+(@PATH,5,7789.2456,-7818.7837,171.01479,NULL,0,0,0,100,0),
+(@PATH,6,7783.237,-7843.7944,169.02388,NULL,0,0,0,100,0),
+(@PATH,7,7785.9644,-7862.049,167.60872,NULL,0,0,0,100,0),
+(@PATH,8,7789.53,-7888.44,167.1335,NULL,0,0,0,100,0);
+
+-- Pathing for Arcane Reaver Entry: 16339
+SET @NPC := 81859;
+SET @PATH := @NPC * 10;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`visibilityDistanceType`,`auras`) VALUES (@NPC,@PATH,0,0,1,0,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,7830.9263,-7888.039,169.23982,NULL,0,0,0,100,0),
+(@PATH,2,7830.7334,-7866.5425,167.54604,NULL,0,0,0,100,0),
+(@PATH,3,7830.3516,-7845.237,169.22816,NULL,0,0,0,100,0),
+(@PATH,4,7835.3516,-7840.085,169.89882,NULL,0,0,0,100,0),
+(@PATH,5,7846.876,-7838.4004,170.29848,NULL,0,0,0,100,0),
+(@PATH,6,7846.483,-7823.547,170.61855,NULL,0,0,0,100,0),
+(@PATH,7,7835.08,-7818.3213,170.47816,NULL,0,0,0,100,0),
+(@PATH,8,7813.5645,-7818.354,170.83528,NULL,0,0,0,100,0),
+(@PATH,9,7799.357,-7819.9844,170.66188,NULL,0,0,0,100,0),
+(@PATH,10,7796.487,-7834.546,169.52571,NULL,0,0,0,100,0),
+(@PATH,11,7808.6626,-7837.914,169.35683,NULL,0,0,0,100,0),
+(@PATH,12,7822.2007,-7832.299,170.07686,NULL,0,0,0,100,0),
+(@PATH,13,7829.9097,-7836.3013,170.05043,NULL,0,0,0,100,0),
+(@PATH,14,7829.91,-7866.301,167.59413,NULL,0,0,0,100,0),
+(@PATH,15,7829.955,-7887.5103,169.23949,NULL,0,0,0,100,0),
+(@PATH,16,7829.923,-7866.3315,167.66835,NULL,0,0,0,100,0),
+(@PATH,17,7829.923,-7836.332,170.09413,NULL,0,0,0,100,0),
+(@PATH,18,7822.2007,-7832.299,170.07686,NULL,0,0,0,100,0),
+(@PATH,19,7808.6626,-7837.914,169.35683,NULL,0,0,0,100,0),
+(@PATH,20,7796.487,-7834.546,169.52571,NULL,0,0,0,100,0),
+(@PATH,21,7799.357,-7819.9844,170.66188,NULL,0,0,0,100,0),
+(@PATH,22,7813.5645,-7818.354,170.83528,NULL,0,0,0,100,0),
+(@PATH,23,7835.08,-7818.3213,170.47816,NULL,0,0,0,100,0),
+(@PATH,24,7846.483,-7823.547,170.61855,NULL,0,0,0,100,0),
+(@PATH,25,7846.876,-7838.4004,170.29848,NULL,0,0,0,100,0),
+(@PATH,26,7835.3516,-7840.085,169.89882,NULL,0,0,0,100,0),
+(@PATH,27,7830.3516,-7845.237,169.22816,NULL,0,0,0,100,0),
+(@PATH,28,7830.7334,-7866.5425,167.54604,NULL,0,0,0,100,0);
+
+-- Pathing for Arcane Reaver Entry: 16339
+SET @NPC := 81864;
+SET @PATH := @NPC * 10;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`visibilityDistanceType`,`auras`) VALUES (@NPC,@PATH,0,0,1,0,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,7867.154,-7903.811,167.38306,NULL,0,0,0,100,0),
+(@PATH,2,7867.242,-7878.6997,169.26465,NULL,0,0,0,100,0),
+(@PATH,3,7865.5635,-7854.1787,170.34413,NULL,0,0,0,100,0),
+(@PATH,4,7857.0254,-7825.577,170.94753,NULL,0,0,0,100,0),
+(@PATH,5,7865.5635,-7854.1787,170.34413,NULL,0,0,0,100,0),
+(@PATH,6,7867.242,-7878.6997,169.26465,NULL,0,0,0,100,0);
+
+-- Pathing for Arcane Reaver Entry: 16339
+SET @NPC := 81867;
+SET @PATH := @NPC * 10;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`visibilityDistanceType`,`auras`) VALUES (@NPC,@PATH,0,0,1,0,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,7856.952,-7911.4897,180.4334,NULL,0,0,0,100,0),
+(@PATH,2,7850.6606,-7911.3657,180.42761,NULL,0,0,0,100,0),
+(@PATH,3,7851.6562,-7919.838,180.42911,NULL,0,0,0,100,0),
+(@PATH,4,7845.596,-7928.678,178.5342,NULL,0,0,0,100,0),
+(@PATH,5,7839.4844,-7933.097,177.14703,NULL,0,0,0,100,0),
+(@PATH,6,7829.6606,-7934.384,175.15036,NULL,0,0,0,100,0),
+(@PATH,7,7821.3896,-7932.7954,173.11923,NULL,0,0,0,100,0),
+(@PATH,8,7812.9688,-7927.4976,170.92276,NULL,0,0,0,100,0),
+(@PATH,9,7808.9365,-7920.1206,169.29443,NULL,0,0,0,100,0),
+(@PATH,10,7817.604,-7910.8906,169.24306,NULL,0,0,0,100,0),
+(@PATH,11,7829.8975,-7910.9272,169.24309,NULL,0,0,0,100,0),
+(@PATH,12,7829.151,-7878.259,169.21193,NULL,0,0,0,100,0),
+(@PATH,13,7829.8975,-7910.9272,169.24309,NULL,0,0,0,100,0),
+(@PATH,14,7817.604,-7910.8906,169.24306,NULL,0,0,0,100,0),
+(@PATH,15,7808.9365,-7920.1206,169.29443,NULL,0,0,0,100,0),
+(@PATH,16,7812.9688,-7927.4976,170.92276,NULL,0,0,0,100,0),
+(@PATH,17,7821.3896,-7932.7954,173.11923,NULL,0,0,0,100,0),
+(@PATH,18,7829.6606,-7934.384,175.15036,NULL,0,0,0,100,0),
+(@PATH,19,7839.4844,-7933.097,177.14703,NULL,0,0,0,100,0),
+(@PATH,20,7845.596,-7928.678,178.5342,NULL,0,0,0,100,0),
+(@PATH,21,7851.6562,-7919.838,180.42911,NULL,0,0,0,100,0),
+(@PATH,22,7850.6606,-7911.3657,180.42761,NULL,0,0,0,100,0),
+(@PATH,23,7856.952,-7911.4897,180.4334,NULL,0,0,0,100,0),
+(@PATH,24,7880.6353,-7911.383,182.8032,NULL,0,0,0,100,0);