diff options
| author | Wyreth <Wyreth@users.noreply.github.com> | 2017-09-22 17:38:23 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-09-22 17:38:23 +0200 |
| commit | df348cb8ebd8feff5c5d79f43cb8c425cccd9899 (patch) | |
| tree | 425f8f54f8d2bafdacaae1324e6ac62d4766f390 | |
| parent | 2e5f4c41d882b12047be93ade30059e311645a88 (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
| -rw-r--r-- | sql/updates/world/3.3.5/2017_09_22_05_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_09_22_05_world.sql b/sql/updates/world/3.3.5/2017_09_22_05_world.sql new file mode 100644 index 00000000000..fd0097027f7 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_09_22_05_world.sql @@ -0,0 +1,8 @@ +-- +SET @ID := 1429; -- Need 4 change it for 4.3.4 and master +DELETE FROM `game_tele` WHERE `id` BETWEEN @ID AND @ID+3; +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"); |