diff options
| author | offl <offl@users.noreply.github.com> | 2020-09-18 17:25:05 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-02-27 20:08:40 +0100 |
| commit | f0b4fdd307bda309c0a73818cc60d59c7ec8488d (patch) | |
| tree | 51e610434f87236b43302958b2e031096439ff7e | |
| parent | 831d282eaff21513473d9a31d5b322b7423bb065 (diff) | |
DB/Creature: Add correct waypoints for Bimble Longberry
(cherry picked from commit af8f8f2fb5a31ef11897374373ffad3104d96b01)
| -rw-r--r-- | sql/updates/world/master/2022_02_27_00_world_2020_09_18_03_world.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_27_00_world_2020_09_18_03_world.sql b/sql/updates/world/master/2022_02_27_00_world_2020_09_18_03_world.sql new file mode 100644 index 00000000000..f0baec77428 --- /dev/null +++ b/sql/updates/world/master/2022_02_27_00_world_2020_09_18_03_world.sql @@ -0,0 +1,21 @@ +-- +UPDATE `creature` SET `guid` = 1768, `position_x` = -4621.53, `position_y` = -981.50415, `position_z` = 501.65564 WHERE `id` = 7978; +UPDATE `creature_addon` SET `guid` = 1768, `path_id` = 17680 WHERE `guid` = 307714; +DELETE FROM `waypoint_data` WHERE `id` = 3077140; +DELETE FROM `waypoint_data` WHERE `id` = 17680; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES +(17680,1,-4617.623,-1000.40375,501.6549), +(17680,2,-4626.8384,-1012.12024,501.65195), +(17680,3,-4641.676,-1014.93176,501.6477), +(17680,4,-4657.6543,-997.70056,501.64493), +(17680,5,-4667.463,-983.35,501.64008), +(17680,6,-4681.7456,-969.36365,501.6129), +(17680,7,-4689.5044,-949.4025,501.6603), +(17680,8,-4699.369,-937.9784,501.67114), +(17680,9,-4711.0723,-923.4748,501.67294), +(17680,10,-4707.8447,-907.0121,501.6636), +(17680,11,-4688.0977,-902.98816,501.6528), +(17680,12,-4671.5874,-914.5615,501.64935), +(17680,13,-4655.9478,-931.1493,501.65768), +(17680,14,-4636.642,-954.9942,501.65884), +(17680,15,-4621.53,-981.50415,501.65564); |