[12440] Add support for condition_id to spell_area table

[newsbot]

Автор: Schmoozerd

m sql/mangos.sql

+ sql/updates/12440_01_mangos_spell_area.sql

m src/game/ObjectMgr.cpp

m src/game/ObjectMgr.h

m src/game/Player.cpp

m src/game/SpellAuras.cpp

m src/game/SpellMgr.cpp

m src/game/SpellMgr.h

m src/shared/revision_nr.h

m src/shared/revision_sql.h

[12440] Add support for condition_id to spell_area table



Add a new column `condition_id` to table `spell_area`

This column is intended to replace the columns

- quest_start

- quest_start_active

- quest_end

- racemask

- gender



Attention DB-Devs: A tool for convertion will be linked in the comments :)

Final removal of these no more required columns will be done after some time, so that you can adapt and provide UPDATE support for this change :)



Also simplify and gernalize the apply/remove code for these spell-area auras

SQL-Changes for spell_area.condition_id



Add first step of spell_area.conditionId



Add second step of spell_area.conditionId



This removes caching by quest_id

This will be slightly slower, but only expected in case of quest-accept/remove cases.



Some improvements and generalisations

Подробнее...