diff options
| -rw-r--r-- | sql/updates/world/master/2022_02_28_11_world_2020_10_04_00_world.sql | 140 |
1 files changed, 140 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_28_11_world_2020_10_04_00_world.sql b/sql/updates/world/master/2022_02_28_11_world_2020_10_04_00_world.sql new file mode 100644 index 00000000000..6853cb540c5 --- /dev/null +++ b/sql/updates/world/master/2022_02_28_11_world_2020_10_04_00_world.sql @@ -0,0 +1,140 @@ +-- Remove empty addon data & fix sheath +DELETE FROM `creature_addon` WHERE `guid` IN (83391,83406,83385,83378); +UPDATE `creature_addon` SET `bytes2` = 1 WHERE `guid` IN (83388,104186,104200,104340,104343,104369,104500); +UPDATE `creature_template_addon` SET `bytes2` = 1 WHERE `entry` IN (18497,18778,18726,18506,20299,20316,20307,20304); + +-- Waypoints & formations +UPDATE `creature` SET `position_x` = 237.949, `position_y` = 32.5140, `position_z` = 26.6320 WHERE `guid` = 83386 AND `id` = 18493; +UPDATE `creature` SET `position_x` = 237.949, `position_y` = 32.5140, `position_z` = 26.6320 WHERE `guid` = 83406 AND `id` = 18497; + +DELETE FROM `waypoint_data` WHERE `id` IN (833860); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(833860,1,237.949,32.514015,26.632038,0,0,0,0,100,0), +(833860,2,217.88676,33.820267,26.621796,0,0,0,0,100,0), +(833860,3,211.06705,32.123497,26.631569,0,0,0,0,100,0), +(833860,4,209.0718,26.146828,26.627604,0,0,0,0,100,0), +(833860,5,215.35312,3.553464,28.625826,0,0,0,0,100,0), +(833860,6,211.31487,-9.173203,27.079954,0,0,0,0,100,0), +(833860,7,210.42763,-25.172428,26.591162,0,0,0,0,100,0), +(833860,8,212.88191,-30.137917,26.591192,0,0,0,0,100,0), +(833860,9,216.55647,-32.453876,26.591314,0,0,0,0,100,0), +(833860,10,226.7893,-32.321796,27.100355,0,0,0,0,100,0), +(833860,11,239.0565,-32.50906,26.598682,0,0,0,0,100,0), +(833860,12,226.7893,-32.321796,27.100355,0,0,0,0,100,0), +(833860,13,216.55647,-32.453876,26.591314,0,0,0,0,100,0), +(833860,14,212.88191,-30.137917,26.591192,0,0,0,0,100,0), +(833860,15,210.42763,-25.172428,26.591162,0,0,0,0,100,0), +(833860,16,211.31487,-9.173203,27.079954,0,0,0,0,100,0), +(833860,17,215.35312,3.553464,28.625826,0,0,0,0,100,0), +(833860,18,209.0718,26.146828,26.627604,0,0,0,0,100,0), +(833860,19,211.06705,32.123497,26.631569,0,0,0,0,100,0), +(833860,20,217.88676,33.820267,26.621796,0,0,0,0,100,0), +(833860,21,237.949,32.514015,26.632038,0,0,0,0,100,0), +(833860,22,257.8986,33.67169,13.394913,0,0,0,0,100,0), +(833860,23,266.3649,32.88496,13.436618,0,0,0,0,100,0), +(833860,24,268.90814,29.680952,13.439169,0,0,0,0,100,0), +(833860,25,269.36295,21.878204,13.413179,0,0,0,0,100,0), +(833860,26,268.32703,-3.305813,-0.0678567,0,0,0,0,100,0), +(833860,27,269.36295,21.878204,13.413179,0,0,0,0,100,0), +(833860,28,268.90814,29.680952,13.439169,0,0,0,0,100,0), +(833860,29,266.3649,32.88496,13.436618,0,0,0,0,100,0), +(833860,30,257.8986,33.67169,13.394913,0,0,0,0,100,0); + +-- Waypoints still should be updated from sniffs +DELETE FROM `creature_formations` WHERE `leaderGUID` = 83374; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(83374,83374,0,0,515,0,0), +(83374,83405,3,270,515,0,0); + +UPDATE `creature` SET `MovementType` = 0 WHERE `guid` = 83405 AND `id` = 18493; +DELETE FROM `creature_addon` WHERE `guid` = 83405; +DELETE FROM `waypoint_data` WHERE `id` = 834050; + +/* +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (83393,83402,83400,83426,83436,83415,83416,88280,83427); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(83393,83393,0,0,3,0,0), +(83393,83410,0,0,3,0,0), +(83393,83403,0,0,3,0,0), +(83393,83401,0,0,3,0,0), +(83402,83402,0,0,3,0,0), +(83402,83398,0,0,3,0,0), +(83402,83397,0,0,3,0,0), +(83402,83396,0,0,3,0,0), +(83402,83399,0,0,3,0,0), +(83400,83400,0,0,3,0,0), +(83400,83413,0,0,3,0,0), +(83400,83414,0,0,3,0,0), +(83400,83411,0,0,3,0,0), +(83400,83412,0,0,3,0,0), +(83426,83426,0,0,3,0,0), +(83426,83433,0,0,3,0,0), +(83426,83420,0,0,3,0,0), +(83426,83424,0,0,3,0,0), +(83426,83425,0,0,3,0,0), +(83426,83421,0,0,3,0,0), +(83426,83422,0,0,3,0,0), +(83426,83417,0,0,3,0,0), +(83426,83418,0,0,3,0,0), +(83436,83436,0,0,3,0,0), +(83436,83438,0,0,3,0,0), +(83436,83432,0,0,3,0,0), +(83436,83434,0,0,3,0,0), +(83436,83435,0,0,3,0,0), +(83436,83437,0,0,3,0,0), +(83436,83428,0,0,3,0,0), +(83436,83429,0,0,3,0,0), +(83436,83431,0,0,3,0,0), +(83436,83430,0,0,3,0,0), +(83415,83415,0,0,3,0,0), +(83415,88278,0,0,3,0,0), +(83415,83450,0,0,3,0,0), +(83415,83451,0,0,3,0,0), +(83415,83448,0,0,3,0,0), +(83415,83443,0,0,3,0,0), +(83415,83440,0,0,3,0,0), +(83415,83445,0,0,3,0,0), +(83415,83441,0,0,3,0,0), +(83416,83416,0,0,3,0,0), +(83416,88277,0,0,3,0,0), +(83416,83447,0,0,3,0,0), +(83416,83446,0,0,3,0,0), +(83416,83442,0,0,3,0,0), +(83416,88279,0,0,3,0,0), +(83416,83452,0,0,3,0,0), +(83416,83444,0,0,3,0,0), +(83416,83449,0,0,3,0,0), +(83416,83439,0,0,3,0,0), +(83416,83419,0,0,3,0,0), +(88280,88280,0,0,3,0,0), +(88280,88281,0,0,3,0,0), +(88280,130981,0,0,3,0,0), +(88280,88283,0,0,3,0,0), +(88280,88290,0,0,3,0,0), +(88280,130980,0,0,3,0,0), +(88280,130978,0,0,3,0,0), +(88280,130979,0,0,3,0,0), +(88280,130982,0,0,3,0,0), +(88280,88291,0,0,3,0,0), +(83427,83427,0,0,3,0,0), +(83427,130992,0,0,3,0,0), +(83427,88288,0,0,3,0,0), +(83427,88284,0,0,3,0,0), +(83427,88289,0,0,3,0,0), +(83427,88285,0,0,3,0,0), +(83427,130993,0,0,3,0,0), +(83427,88286,0,0,3,0,0), +(83427,88287,0,0,3,0,0), +(83427,131000,0,0,3,0,0), +(83427,130994,0,0,3,0,0); +*/ + +-- Remove laugh emote from pathing phasing creatures, they don't laugh +-- Add correct spell to their waypoint script and move it to end of waypoints, they just becomes invisible for unk time after reaching last waypoint +-- Their waypoints should be redone +UPDATE `waypoint_data` SET `action` = 0 WHERE `action` = 495 AND `point` = 1 AND `id` IN (1046380,1047050,1047060,1047620,1047630,1047640,1047710,1047740,1047750,1047790,1047800,1047820,1047830,1047840,1047850,1045010,1045030,1045260,1045340,1045350); +UPDATE `waypoint_data` SET `action` = 495 WHERE `action` = 1 AND `id` IN (1046380,1047050,1047060,1047620,1047630,1047640,1047710,1047740,1047750,1047790,1047800,1047820,1047830,1047840,1047850,1045010,1045030,1045260,1045340,1045350); +DELETE FROM `waypoint_scripts` WHERE `id` = 495; +INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `guid`, `Comment`) VALUES +(495,0,15,32754,1,0,0,0,0,0,518,"Phasing Soldier - On Script - Cast 'Invisibility'"), +(495,30,14,32754,1,0,0,0,0,0,519,"Phasing Soldier - On Script - Remove Aura 'Invisibility'"); |