diff options
Diffstat (limited to 'sql/updates')
| -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"; |