diff options
| -rw-r--r-- | sql/updates/world/master/2023_01_12_03_world_2022_10_30_07_world.sql | 125 |
1 files changed, 125 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_01_12_03_world_2022_10_30_07_world.sql b/sql/updates/world/master/2023_01_12_03_world_2022_10_30_07_world.sql new file mode 100644 index 00000000000..c00e79dea91 --- /dev/null +++ b/sql/updates/world/master/2023_01_12_03_world_2022_10_30_07_world.sql @@ -0,0 +1,125 @@ +-- Missing Silvermoon Guardian spawns +DELETE FROM `creature` WHERE `guid` IN (12470,12494); +DELETE FROM `creature_addon` WHERE `guid` IN (12470,12494); +INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnDifficulties`,`phaseId`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`wander_distance`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`ScriptName`,`VerifiedBuild`) VALUES +(12470, 16221, 530, 0, 0, '0', 0, 0, 9266.465,-6550.5283,33.899437, 2.897246599197387695, 300, 0, 0, 1, 0, 0, 0, 0, 0, '', 0), +(12494, 16221, 530, 0, 0, '0', 0, 0, 9265.465,-6550.5283,33.899437, 0.087266460061073303, 300, 0, 0, 1, 0, 0, 0, 0, 0, '', 0); + +-- Pathing for missing Silvermoon Guardian Entry: 16221 +SET @NPC := 12470; +UPDATE `creature` SET `wander_distance`=0,`MovementType`=2 WHERE `guid`=@NPC; +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,9266.465,-6550.5283,33.899437,0,0,0,0,100,0), +(@PATH,2,9293.746,-6554.2383,34.66549,0,0,0,0,100,0), +(@PATH,3,9304.031,-6546.539,34.710205,0,0,0,0,100,0), +(@PATH,4,9293.746,-6554.2383,34.66549,0,0,0,0,100,0), +(@PATH,5,9266.465,-6550.5283,33.899437,0,0,0,0,100,0), +(@PATH,6,9250.883,-6548.068,32.404564,0,0,0,0,100,0), +(@PATH,7,9224.099,-6560.443,31.990011,0,0,0,0,100,0), +(@PATH,8,9193.114,-6584.202,32.66605,0,0,0,0,100,0), +(@PATH,9,9167.324,-6612.1104,31.284536,0,0,0,0,100,0), +(@PATH,10,9133.162,-6619.7676,28.557425,0,0,0,0,100,0), +(@PATH,11,9114.433,-6633.276,25.546194,0,0,0,0,100,0), +(@PATH,12,9097.9,-6655.489,22.157452,0,0,0,0,100,0), +(@PATH,13,9105.405,-6682.3037,21.1005,0,0,0,0,100,0), +(@PATH,14,9067.467,-6683.3013,17.133951,0,0,0,0,100,0), +(@PATH,15,9099.714,-6683.9517,20.850382,0,0,0,0,100,0), +(@PATH,16,9133.104,-6695.377,23.682104,0,0,0,0,100,0), +(@PATH,17,9167.279,-6711.8447,25.629526,0,0,0,0,100,0), +(@PATH,18,9199.781,-6718.539,25.85908,0,0,0,0,100,0), +(@PATH,19,9210.716,-6723.7095,25.60611,0,0,0,0,100,0), +(@PATH,20,9233.276,-6753.362,25.13524,0,0,0,0,100,0), +(@PATH,21,9245.07,-6795.2314,23.175833,0,0,0,0,100,0), +(@PATH,22,9243.104,-6833.158,17.046247,0,0,0,0,100,0), +(@PATH,23,9222.052,-6864.4595,11.268669,0,0,0,0,100,0), +(@PATH,24,9243.097,-6833.186,16.985456,0,0,0,0,100,0), +(@PATH,25,9245.063,-6795.26,23.050833,0,0,0,0,100,0), +(@PATH,26,9233.276,-6753.362,25.13524,0,0,0,0,100,0), +(@PATH,27,9210.716,-6723.7095,25.60611,0,0,0,0,100,0), +(@PATH,28,9199.781,-6718.539,25.85908,0,0,0,0,100,0), +(@PATH,29,9167.279,-6711.8447,25.629526,0,0,0,0,100,0), +(@PATH,30,9133.104,-6695.377,23.682104,0,0,0,0,100,0), +(@PATH,31,9099.714,-6683.9517,20.850382,0,0,0,0,100,0), +(@PATH,32,9067.467,-6683.3013,17.133951,0,0,0,0,100,0), +(@PATH,33,9105.405,-6682.3037,21.1005,0,0,0,0,100,0), +(@PATH,34,9097.9,-6655.489,22.157452,0,0,0,0,100,0), +(@PATH,35,9114.433,-6633.276,25.546194,0,0,0,0,100,0), +(@PATH,36,9133.075,-6619.799,28.557425,0,0,0,0,100,0), +(@PATH,37,9167.324,-6612.1104,31.284536,0,0,0,0,100,0), +(@PATH,38,9193.114,-6584.202,32.66605,0,0,0,0,100,0), +(@PATH,39,9224.099,-6560.443,31.990011,0,0,0,0,100,0), +(@PATH,40,9250.883,-6548.068,32.404564,0,0,0,0,100,0); +-- Formation +DELETE FROM `creature_formations` WHERE `leaderGUID`=12470; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(12470,12494,3,0,515,0,0), +(12470,12470,0,0,2,0,0); + +-- Missing Pathing for Silvermoon Guardian Entry: 16221 +SET @NPC := 56888; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `wander_distance`=0,`MovementType`=2,`position_x`=8715.267,`position_y`=-6672.605,`position_z`=70.42766 WHERE `guid`=@NPC; +UPDATE `creature` SET `wander_distance`=0,`MovementType`=0,`position_x`=8713.267,`position_y`=-6674.605,`position_z`=70.42766 WHERE `guid`=56887; +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,8715.267,-6672.605,70.42766,0,1000,0,0,100,0), +(@PATH,2,8737.004,-6677.9756,69.692726,0,0,0,0,100,0), +(@PATH,3,8766.34,-6649.9844,65.844604,0,0,0,0,100,0), +(@PATH,4,8800.046,-6648.526,58.3881,0,0,0,0,100,0), +(@PATH,5,8833.269,-6643.5005,50.18699,0,0,0,0,100,0), +(@PATH,6,8849.173,-6651.176,47.035736,0,0,0,0,100,0), +(@PATH,7,8866.991,-6675.4517,41.270267,0,0,0,0,100,0), +(@PATH,8,8899.804,-6689.4243,34.136967,0,0,0,0,100,0), +(@PATH,9,8916.354,-6683.544,30.945305,0,0,0,0,100,0), +(@PATH,10,8932.791,-6675.3047,27.625359,0,0,0,0,100,0), +(@PATH,11,8966.553,-6677.99,19.577826,0,0,0,0,100,0), +(@PATH,12,8993.152,-6682.3535,12.287277,0,0,0,0,100,0), +(@PATH,13,8954.701,-6678.256,22.425604,0,0,0,0,100,0), +(@PATH,14,8920.981,-6691.671,30.165886,0,0,0,0,100,0), +(@PATH,15,8900.156,-6691.5723,34.207634,0,0,0,0,100,0), +(@PATH,16,8874.535,-6684.9375,38.95142,0,0,0,0,100,0), +(@PATH,17,8840.451,-6660.2134,47.16092,0,0,0,0,100,0), +(@PATH,18,8826.833,-6652.768,50.834267,0,0,0,0,100,0), +(@PATH,19,8788.527,-6658.085,61.695183,0,0,0,0,100,0), +(@PATH,20,8766.815,-6659.2095,65.99828,0,0,0,0,100,0), +(@PATH,21,8754.134,-6666.499,67.703735,0,0,0,0,100,0), +(@PATH,22,8731.106,-6700.3823,72.841774,0,0,0,0,100,0), +(@PATH,23,8716.5205,-6733.499,80.80049,0,0,0,0,100,0), +(@PATH,24,8716.629,-6767.98,88.37359,0,0,0,0,100,0), +(@PATH,25,8711.674,-6779.87,89.74212,0,0,0,0,100,0), +(@PATH,26,8703.4795,-6790.086,91.71819,0,1000,0,0,100,0), +(@PATH,27,8711.617,-6779.955,89.72039,0,0,0,0,100,0), +(@PATH,28,8716.629,-6767.98,88.37359,0,0,0,0,100,0), +(@PATH,29,8716.5205,-6733.499,80.80049,0,0,0,0,100,0), +(@PATH,30,8731.04,-6700.5215,72.90366,0,0,0,0,100,0), +(@PATH,31,8754.134,-6666.499,67.703735,0,0,0,0,100,0), +(@PATH,32,8766.815,-6659.2095,65.99828,0,0,0,0,100,0), +(@PATH,33,8788.527,-6658.085,61.695183,0,0,0,0,100,0), +(@PATH,34,8826.833,-6652.768,50.834267,0,0,0,0,100,0), +(@PATH,35,8840.451,-6660.2134,47.16092,0,0,0,0,100,0), +(@PATH,36,8874.453,-6684.9043,38.96497,0,0,0,0,100,0), +(@PATH,37,8900.156,-6691.5723,34.207634,0,0,0,0,100,0), +(@PATH,38,8920.981,-6691.671,30.165886,0,0,0,0,100,0), +(@PATH,39,8954.594,-6678.215,22.448065,0,0,0,0,100,0), +(@PATH,40,8993.152,-6682.3535,12.287277,0,0,0,0,100,0), +(@PATH,41,8966.553,-6677.99,19.577826,0,0,0,0,100,0), +(@PATH,42,8932.791,-6675.3047,27.625359,0,0,0,0,100,0), +(@PATH,43,8916.354,-6683.544,30.945305,0,0,0,0,100,0), +(@PATH,44,8899.804,-6689.4243,34.136967,0,0,0,0,100,0), +(@PATH,45,8866.991,-6675.4517,41.270267,0,0,0,0,100,0), +(@PATH,46,8849.173,-6651.176,47.035736,0,0,0,0,100,0), +(@PATH,47,8833.269,-6643.5005,50.18699,0,0,0,0,100,0), +(@PATH,48,8800.046,-6648.526,58.3881,0,0,0,0,100,0), +(@PATH,49,8766.34,-6649.9844,65.844604,0,0,0,0,100,0), +(@PATH,50,8737.004,-6677.9756,69.692726,0,0,0,0,100,0); +-- Formation +DELETE FROM `creature_formations` WHERE `leaderGUID`=56888; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(56888,56887,2,90,515,0,0), +(56888,56888,0,0,2,0,0); |