aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2021_10_02_01_world.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_02_01_world.sql b/sql/updates/world/master/2021_10_02_01_world.sql
new file mode 100644
index 00000000000..abe6da2c24c
--- /dev/null
+++ b/sql/updates/world/master/2021_10_02_01_world.sql
@@ -0,0 +1,17 @@
+-- Human
+UPDATE `playercreateinfo` SET `orientation` = 5.1044426 WHERE `race` = 1 AND `class` != 6;
+
+-- Dwarf
+UPDATE `playercreateinfo` SET `zone` = 132, `orientation` = 0.501087 WHERE `race` = 3 AND `class` != 6;
+
+-- Night Elf
+UPDATE `playercreateinfo` SET `zone` = 188, `orientation` = 5.48033 WHERE `race` = 4 AND `class` NOT IN (6, 12);
+
+-- Orc
+UPDATE `playercreateinfo` SET `zone` = 363, `orientation` = 0 WHERE `race` = 2 AND `class` != 6;
+
+-- Pandaren
+UPDATE `playercreateinfo` SET `orientation` = 2.879619 WHERE `race` = 24 AND `class` != 6;
+
+-- Death Knight
+UPDATE `playercreateinfo` SET `orientation` = 3.659973 WHERE `class` = 6 AND `race` != 24;