From a39d0db9ec64f6bf38716abaade5b7835f2db338 Mon Sep 17 00:00:00 2001 From: Shauren Date: Wed, 1 May 2024 22:26:53 +0200 Subject: Core/Spells: Implemented evoker empower spell mechanic --- .../hotfixes/master/2024_05_01_00_hotfixes.sql | 24 ++++++++++++++++++++++ sql/updates/world/master/2024_05_01_00_world.sql | 6 ++++++ 2 files changed, 30 insertions(+) create mode 100644 sql/updates/hotfixes/master/2024_05_01_00_hotfixes.sql create mode 100644 sql/updates/world/master/2024_05_01_00_world.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2024_05_01_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_05_01_00_hotfixes.sql new file mode 100644 index 00000000000..10b253c4fcb --- /dev/null +++ b/sql/updates/hotfixes/master/2024_05_01_00_hotfixes.sql @@ -0,0 +1,24 @@ +-- +-- Table structure for table `spell_empower` +-- +DROP TABLE IF EXISTS `spell_empower`; +CREATE TABLE `spell_empower` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `SpellID` int NOT NULL DEFAULT '0', + `Unused1000` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `spell_empower_stage` +-- +DROP TABLE IF EXISTS `spell_empower_stage`; +CREATE TABLE `spell_empower_stage` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Stage` int NOT NULL DEFAULT '0', + `DurationMs` int NOT NULL DEFAULT '0', + `SpellEmpowerID` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/sql/updates/world/master/2024_05_01_00_world.sql b/sql/updates/world/master/2024_05_01_00_world.sql new file mode 100644 index 00000000000..b1e4744f4de --- /dev/null +++ b/sql/updates/world/master/2024_05_01_00_world.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_evo_fire_breath','spell_evo_fire_breath_damage','spell_evo_scouring_flame'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(357208,'spell_evo_fire_breath'), +(382266,'spell_evo_fire_breath'), +(357209,'spell_evo_fire_breath_damage'), +(357209,'spell_evo_scouring_flame'); -- cgit v1.2.3