[12440] Add support for condition_id to spell_area table

[newsbot]

Автор: Schmoozerd


<pre>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
</pre>
<pre style='white-space:pre-wrap;width:81ex'>[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</pre>


Подробнее... (https://github.com/cmangos/mangos-wotlk/commit/ef5e75ae25891e602d07277ab4bd22d5720a1eba)