diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2021-10-02 17:15:53 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-02 17:15:53 +0200 |
| commit | 72ccd582fff2aef5ae943ff829980c998f6c3775 (patch) | |
| tree | db578757dc458c0010796f1d1a32456f567c2d53 | |
| parent | 546ebfa62ba32b9fa9ea9eae1a397c56990534b1 (diff) | |
DB/PlayerCreateInfo: Fix Coords/Orientation (Not Allied Race)
closes #26989 by xXBentRealityXx
| -rw-r--r-- | sql/updates/world/master/2021_10_02_01_world.sql | 17 |
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; |