diff options
| author | Naddley <NaddleyTC@gmail.com> | 2024-09-30 14:24:55 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-09-30 20:10:07 +0200 |
| commit | 2fed819593cb9047143679824f87a23a33be71b3 (patch) | |
| tree | 558817669c18cf632b45b8970e58121281ae17b5 | |
| parent | 659d76d6363394c799dc1cc281371fc71ddb0110 (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>
(cherry picked from commit 7072a88675ae35f4a6a4c7e20073cdd716012e68)
| -rw-r--r-- | sql/updates/world/cata_classic/2024_09_30_00_world_2024_09_30_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_09_30_00_world_2024_09_30_00_world.sql b/sql/updates/world/cata_classic/2024_09_30_00_world_2024_09_30_00_world.sql new file mode 100644 index 00000000000..c412c452734 --- /dev/null +++ b/sql/updates/world/cata_classic/2024_09_30_00_world_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); |