diff options
| -rw-r--r-- | sql/updates/world/master/2021_12_17_06_world_2019_07_23_05_world.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_17_06_world_2019_07_23_05_world.sql b/sql/updates/world/master/2021_12_17_06_world_2019_07_23_05_world.sql new file mode 100644 index 00000000000..0dcb6d2a37f --- /dev/null +++ b/sql/updates/world/master/2021_12_17_06_world_2019_07_23_05_world.sql @@ -0,0 +1,35 @@ +-- +UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=24954; +DELETE FROM `creature` WHERE `id`=24954 AND `guid` IN (113209,113224); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(113209, 24954, 571, 0, 0, '0', 0, 0, 0, 4349.93, 4266.78, 98.4817, 5.59187, 300, 0, 0, 0, 0, 2, 0, 0, 0, 0), +(113224, 24954, 571, 0, 0, '0', 0, 0, 0, 4196.80, 4065.43, 92.0476, 5.81195, 300, 0, 0, 0, 0, 2, 0, 0, 0, 0); + +DELETE FROM `waypoint_data` WHERE `id` IN (1132090,1132240); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action_chance`) VALUES +(1132090, 1, 4339.69, 4272.32, 101.39, 2.61521, 0, 0, 100), +(1132090, 2, 4325.61, 4280.77, 105.782, 2.61129, 0, 0, 100), +(1132090, 3, 4320.73, 4283.8, 104.723, 2.59165, 0, 0, 100), +(1132090, 4, 4315.65, 4286.56, 100.907, 2.59558, 0, 0, 100), +(1132090, 5, 4283.06, 4296.48, 92.3875, 2.69375, 20000, 0, 100), +(1132090, 6, 4305.17, 4289.8, 98.9692, 5.96886, 0, 0, 100), +(1132090, 7, 4316.48, 4286.62, 100.95, 5.98064, 0, 0, 100), +(1132090, 8, 4325.3, 4281.27, 105.901, 5.70183, 0, 0, 100), +(1132090, 9, 4336.18, 4274.67, 103.061, 5.71754, 0, 0, 100), +(1132090, 10, 4349.87, 4267.18, 98.4327, 5.70575, 120000, 0, 100), +(1132240, 1, 4123.04, 4106.89, 92.5128, 5.40736, 0, 0, 100), +(1132240, 2, 4185.5, 4070.71, 96.2793, 2.65768, 0, 0, 100), +(1132240, 3, 4174.4, 4077.55, 99.2717, 2.59092, 0, 0, 100), +(1132240, 4, 4167.65, 4081.31, 96.762, 2.56343, 0, 0, 100), +(1132240, 5, 4147.17, 4093.18, 95.2485, 2.63411, 0, 0, 100), +(1132240, 6, 4123.7, 4106.35, 92.481, 2.64197, 20000, 0, 100), +(1132240, 7, 4146.5, 4093.45, 95.0601, 5.72931, 0, 0, 100), +(1132240, 8, 4168.22, 4081.86, 96.7608, 5.76858, 0, 0, 100), +(1132240, 9, 4174.35, 4077.8, 99.322, 5.67434, 0, 0, 100), +(1132240, 10, 4184.38, 4071.35, 96.7752, 5.76465, 0, 0, 100), +(1132240, 11, 4196.83, 4065.39, 91.9598, 5.83926, 120000, 0, 100); + +DELETE FROM `creature_addon` WHERE `guid` IN (113209,113224); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(113209,1132090,0,1,0, "45797"), +(113224,1132240,0,1,0, "45797"); |