From a368606a969cd6b9f7a6e7d61d1cf0bbedda4bc7 Mon Sep 17 00:00:00 2001 From: jackpoz Date: Tue, 14 Jul 2020 09:35:57 +0200 Subject: Core/Misc: Rename sql files --- sql/updates/world/3.3.5/2020_07_14_00_world.sql | 6 +++++ sql/updates/world/3.3.5/2020_07_14_01_world.sql | 35 +++++++++++++++++++++++++ sql/updates/world/3.3.5/2020_99_99_00_world.sql | 6 ----- sql/updates/world/3.3.5/2020_99_99_01.sql | 35 ------------------------- 4 files changed, 41 insertions(+), 41 deletions(-) create mode 100644 sql/updates/world/3.3.5/2020_07_14_00_world.sql create mode 100644 sql/updates/world/3.3.5/2020_07_14_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2020_99_99_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2020_99_99_01.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2020_07_14_00_world.sql b/sql/updates/world/3.3.5/2020_07_14_00_world.sql new file mode 100644 index 00000000000..7cad542b909 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_14_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_07_14_01_world.sql b/sql/updates/world/3.3.5/2020_07_14_01_world.sql new file mode 100644 index 00000000000..db20c22ace8 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_14_01_world.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"; 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 deleted file mode 100644 index 7cad542b909..00000000000 --- a/sql/updates/world/3.3.5/2020_99_99_00_world.sql +++ /dev/null @@ -1,6 +0,0 @@ --- -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 deleted file mode 100644 index db20c22ace8..00000000000 --- a/sql/updates/world/3.3.5/2020_99_99_01.sql +++ /dev/null @@ -1,35 +0,0 @@ --- --- 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"; -- cgit v1.2.3