diff options
| author | Giacomo Pozzoni <giacomopoz@gmail.com> | 2020-07-14 07:34:03 +0000 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-23 15:17:54 +0100 |
| commit | e9cf3828bad44cf193d6c9717b392de7346157a5 (patch) | |
| tree | 82f013fe88a01d23f2a902b28a28140035589b74 /sql | |
| parent | a55801e35ed22fdcecbd656a894a7c8320c28743 (diff) | |
Core/Spells: Implement SPELL_EFFECT_ACTIVATE_OBJECT. (#23) (#24997)
* Core/Spells: Implement SPELL_EFFECT_ACTIVATE_OBJECT. (#23)
Original research by @xvwyh.
* 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>
(cherry picked from commit 203573db83fb1d3f141b5aadbf1d1ca0a637bf94)
Diffstat (limited to 'sql')
3 files changed, 59 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2022_01_23_00_hotfixes.sql b/sql/updates/hotfixes/master/2022_01_23_00_hotfixes.sql new file mode 100644 index 00000000000..35f0607e8e7 --- /dev/null +++ b/sql/updates/hotfixes/master/2022_01_23_00_hotfixes.sql @@ -0,0 +1,16 @@ +-- +-- Table structure for table `gameobject_art_kit` +-- +DROP TABLE IF EXISTS `gameobject_art_kit`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `gameobject_art_kit` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `AttachModelFileID` int(11) NOT NULL DEFAULT '0', + `TextureVariationFileID1` int(11) NOT NULL DEFAULT '0', + `TextureVariationFileID2` int(11) NOT NULL DEFAULT '0', + `TextureVariationFileID3` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/world/master/2022_01_23_00_world_2020_07_14_00_world.sql b/sql/updates/world/master/2022_01_23_00_world_2020_07_14_00_world.sql new file mode 100644 index 00000000000..c9afab0abb7 --- /dev/null +++ b/sql/updates/world/master/2022_01_23_00_world_2020_07_14_00_world.sql @@ -0,0 +1,7 @@ +-- +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`, + ADD COLUMN `artkit4` INT NOT NULL DEFAULT 0 AFTER `artkit3`; diff --git a/sql/updates/world/master/2022_01_23_01_world_2020_07_14_01_world.sql b/sql/updates/world/master/2022_01_23_01_world_2020_07_14_01_world.sql new file mode 100644 index 00000000000..87d719cc286 --- /dev/null +++ b/sql/updates/world/master/2022_01_23_01_world_2020_07_14_01_world.sql @@ -0,0 +1,36 @@ +-- +-- 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"; +DELETE FROM `spell_script_names` WHERE `ScriptName`= "spell_anhuur_activate_beacons"; |