diff options
| author | Giacomo Pozzoni <giacomopoz@gmail.com> | 2020-07-14 07:34:03 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-07-14 09:34:03 +0200 |
| commit | 203573db83fb1d3f141b5aadbf1d1ca0a637bf94 (patch) | |
| tree | fdf29fa005fafdedddab8ec67abc83d26841d7fc /sql | |
| parent | 042b1abfd747160085e5acc24a842a076b20ea01 (diff) | |
Core/Spells: Implement SPELL_EFFECT_ACTIVATE_OBJECT. (#23) (#24997)
* Core/Spells: Implement SPELL_EFFECT_ACTIVATE_OBJECT. (#23)
Original research by @xvwyh.
# Conflicts:
# src/server/game/DataStores/DBCStores.cpp
# src/server/game/DataStores/DBCStructure.h
# src/server/game/DataStores/DBCfmt.h
# src/server/game/Entities/GameObject/GameObject.h
# src/server/game/Entities/GameObject/GameObjectData.h
# src/server/scripts/EasternKingdoms/ZulAman/zulaman.cpp
# src/server/scripts/Kalimdor/HallsOfOrigination/boss_temple_guardian_anhuur.cpp
* Add missing sql update
* Fix some build errors
* Remove unused enum values
* Change artkits from 0-4 to 0-3
* Remove unused code
* Code review feedback
* Fix sql
* Remove artkit4 special case handling
* Default initialize artKits
* Code review feedback
* Split sql into structure and data files
Co-authored-by: Warpten <vertozor@gmail.com>
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2020_99_99_00_world.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/3.3.5/2020_99_99_01.sql | 35 |
2 files changed, 41 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_99_99_00_world.sql b/sql/updates/world/3.3.5/2020_99_99_00_world.sql new file mode 100644 index 00000000000..7cad542b909 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_99_99_00_world.sql @@ -0,0 +1,6 @@ +-- +ALTER TABLE `gameobject_template_addon` + ADD COLUMN `artkit0` INT NOT NULL DEFAULT 0 AFTER `maxgold`, + ADD COLUMN `artkit1` INT NOT NULL DEFAULT 0 AFTER `artkit0`, + ADD COLUMN `artkit2` INT NOT NULL DEFAULT 0 AFTER `artkit1`, + ADD COLUMN `artkit3` INT NOT NULL DEFAULT 0 AFTER `artkit2`; diff --git a/sql/updates/world/3.3.5/2020_99_99_01.sql b/sql/updates/world/3.3.5/2020_99_99_01.sql new file mode 100644 index 00000000000..db20c22ace8 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_99_99_01.sql @@ -0,0 +1,35 @@ +-- +-- Note: All of these should be targetable by spells 46904 and 46903, but conditions are only set for Stormwind (damn Horde fanatics) +UPDATE gameobject_template_addon SET artkit0 = 121, artkit1 = 122 WHERE entry IN ( + 188352, -- Flame of Shattrath + 188129, -- Flame of Silvermoon + 188128, -- Flame of the Exodar + 181567, -- Flame of the Wetlands + 181566, -- Flame of Hillsbrad + 181565, -- Flame of Westfall + 181564, -- Flame of Silverpine + 181563, -- Flame of Darkshore + 181562, -- Flame of Stonetalon + 181561, -- Flame of Ashenvale + 181560, -- Flame of the Barrens + 181349, -- Flame of the Scholomance + 181348, -- Flame of Stratholme + 181347, -- Flame of Blackrock Spire + 181346, -- Flame of Dire Maul + 181345, -- Flame of the Hinterlands + 181344, -- Flame of the Blasted Lands + 181343, -- Flame of Un'Goro + 181342, -- Flame of Azshara + 181341, -- Flame of Searing Gorge + 181340, -- Flame of Winterspring + 181339, -- Flame of Silithus + 181338, -- Flame of the Plaguelands + 181337, -- Flame of Thunder Bluff + 181336, -- Flame of Orgrimmar + 181335, -- Flame of the Undercity + 181334, -- Flame of Darnassus + 181333, -- Flame of Ironforge + 181332 -- Flame of Stormwind +); + +DELETE FROM `spell_script_names` WHERE `ScriptName`= "spell_banging_the_gong"; |