aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaribon <Daribon@users.noreply.github.com>2018-03-23 16:39:16 +0100
committerKillyana <morphone1@gmail.com>2018-03-23 16:39:16 +0100
commit74365e14e63a2b63bcdafaa39a5f2c3e5e06d367 (patch)
treeba1038b4126180d23fb55a5a0caaef4de4566b7f
parent3420b8d5c4dd21b66502ace7cd6ee210d6e6e8e1 (diff)
DB: Fix Initial starting position for undeads and night elves
Closes #21679 For 3.3.5 only
-rw-r--r--sql/updates/world/3.3.5/2018_03_23_00_world_335.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_03_23_00_world_335.sql b/sql/updates/world/3.3.5/2018_03_23_00_world_335.sql
new file mode 100644
index 00000000000..dd5e993c600
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_03_23_00_world_335.sql
@@ -0,0 +1,4 @@
+-- Fix spawn location for undead
+UPDATE `playercreateinfo` SET `position_x` = 1676.349976, `position_y` = 1677.449951, `position_z` = 121.669998, `orientation` = 2.705260 WHERE `race` = 5 AND `zone`=85;
+-- Fix spawn location for night elf
+UPDATE `playercreateinfo` SET `position_x` = 10311.299805, `position_y` = 831.463013, `position_z` = 1326.410034, `orientation` = 5.480334 WHERE `race` = 4 AND `zone`=141;