diff options
| author | Naddley <NaddleyTC@gmail.com> | 2024-09-30 14:24:55 +0200 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-09-30 14:24:55 +0200 |
| commit | 7072a88675ae35f4a6a4c7e20073cdd716012e68 (patch) | |
| tree | e9f36714877620c2dc87053278d7e37193eb70a9 | |
| parent | db75f34239e86fc42a901200d24669f7d2550692 (diff) | |
DB/Gilneas: Added spell_area data for chapter 1
https://github.com/The-Cataclysm-Preservation-Project/TrinityCore/commit/bc2d669a54a342e749b7f1779e3cae6247f98b66
https://github.com/The-Cataclysm-Preservation-Project/TrinityCore/commit/a11513051b5478b3671a65e99ef03fd27538d9e3
Closes #25824
Closes #30090
Co-authored-by: Ovahlord <dreadkiller@gmx.de>
| -rw-r--r-- | sql/updates/world/master/2024_09_30_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_09_30_00_world.sql b/sql/updates/world/master/2024_09_30_00_world.sql new file mode 100644 index 00000000000..c412c452734 --- /dev/null +++ b/sql/updates/world/master/2024_09_30_00_world.sql @@ -0,0 +1,9 @@ +-- SpellArea +DELETE FROM `spell_area` WHERE (`spell` = 59073 AND `area` IN (4756, 4755, 4757, 4714)) OR (`spell` = 49416 AND `area` = 4756) OR (`spell` = 68630 AND `area` = 4786); +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES +(59073, 4756, 14078, 14159, 0, 0, 2, 3, 64, 1|2|8|32), +(59073, 4755, 14099, 14159, 0, 0, 2, 3, 2|64, 1|2|8|32), +(59073, 4757, 14099, 14159, 0, 0, 2, 3, 2|64, 1|2|8|32), +(59073, 4714, 14099, 14159, 0, 0, 2, 3, 2|64, 1|2|8|32), +(49416, 4756, 14078, 14099, 0, 0, 2, 3, 64, 1|8|32), +(68630, 4786, 0, 14375, 0, 0, 2, 3, 0, 1|2|8|32); |