diff options
| author | Wyreth <Wyreth@users.noreply.github.com> | 2017-09-22 17:38:23 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2020-09-08 22:35:36 +0200 |
| commit | d37e75ec7d4c6a155b918c549a8aa7d6bd829e8f (patch) | |
| tree | 95646c199f671a74eaf5dd4dce6652ea519f54c9 | |
| parent | bcb19b7d52437c561a64187225b478bc4ac0ff2c (diff) | |
DB/Tele: Add some teleport locations in Borean Tundra and Dragonblight
Closes #20385
Before pushing this to other branch you must change the ID range
(cherry picked from commit df348cb8ebd8feff5c5d79f43cb8c425cccd9899)
| -rw-r--r-- | sql/updates/world/master/2020_09_08_03_world_2017_09_22_05_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_09_08_03_world_2017_09_22_05_world.sql b/sql/updates/world/master/2020_09_08_03_world_2017_09_22_05_world.sql new file mode 100644 index 00000000000..9d6eebc3a05 --- /dev/null +++ b/sql/updates/world/master/2020_09_08_03_world_2017_09_22_05_world.sql @@ -0,0 +1,12 @@ +-- +SET @ID := 1429; +DELETE FROM `game_tele` WHERE (`id` BETWEEN @ID AND @ID+3) OR (`id` BETWEEN 1679 AND 1682); +INSERT INTO `game_tele` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, `name`) VALUES +(@ID , 3670.24, 6784.35, 170.181, 1.4044, 571, "Coldarra"), +(@ID+1, 3606.76, 5944.54, 136.216, 2.84247, 571, "AmberLedge"), +(@ID+2, 2967.29, 6788.09, 7.05211, 5.86967, 571, "Garrosh'sLanding"), +(@ID+3, 3543.21, 271.834, 342.721, 3.15239, 571, "WyrmrestTemple"), +(1679, -3265.45, -2754.5, 12.6062, 0.280862, 0, 'GreenwardensGrove'), +(1680, -4121.85, -2762.32, 17.9311, 4.48274, 0, 'SlabchiselsSurvey'), +(1681, -3209, -4997.95, 119.817, 1.53891, 0, 'Thundermar'), +(1682, -2808.37, -5380.95, 173.717, 0.34903, 0, 'Kirthaven'); |