diff options
| author | offl <offl@users.noreply.github.com> | 2020-09-18 17:25:05 +0300 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-09-18 17:25:05 +0300 |
| commit | af8f8f2fb5a31ef11897374373ffad3104d96b01 (patch) | |
| tree | 9267ac5bb581d1316118b3a08048bdc330ce41a9 | |
| parent | 9a33c7236b473c5d03ff8c43bb920d9785cde4e5 (diff) | |
DB/Creature: Add correct waypoints for Bimble Longberry
| -rw-r--r-- | sql/updates/world/3.3.5/2020_09_18_03_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_09_18_03_world.sql b/sql/updates/world/3.3.5/2020_09_18_03_world.sql new file mode 100644 index 00000000000..da53a0f9c02 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_09_18_03_world.sql @@ -0,0 +1,19 @@ +-- +UPDATE `creature` SET `position_x` = -4621.53, `position_y` = -981.50415, `position_z` = 501.65564 WHERE `id` = 7978; +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); |
