From 8ca575ed52fb4ee8149302ecf33b4bb0c33e5eb5 Mon Sep 17 00:00:00 2001 From: offl Date: Sun, 27 Dec 2020 03:06:31 +0200 Subject: DB/Spell: Add effects to more spells from Violet Hold Turned out almost all spells from BM were copied to create Violet Hold. Not only serverside spells and not only their effects but also attributes and icons. The scripts were also copied, possibly unchanged --- sql/updates/world/3.3.5/2020_12_27_04_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_12_27_04_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_12_27_04_world.sql b/sql/updates/world/3.3.5/2020_12_27_04_world.sql new file mode 100644 index 00000000000..63db06700a2 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_12_27_04_world.sql @@ -0,0 +1,7 @@ +-- +UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 77, `EffectImplicitTargetA1` = 1, `DmgMultiplier1` = 1 WHERE `Id` BETWEEN 57995 AND 57999; -- Portal 1-5 Ready +UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 77, `EffectImplicitTargetA1` = 22, `EffectImplicitTargetB1` = 7, `EffectRadiusIndex1` = 28, `DmgMultiplier1` = 1 WHERE `Id` = 58019; -- Portal Ready Primer +UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 77, `EffectImplicitTargetA1` = 1, `DmgMultiplier1` = 1 WHERE `Id` = 58011; -- Portal Channel Trigger +UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 77, `EffectImplicitTargetA1` = 1, `DmgMultiplier1` = 1 WHERE `Id` = 58014; -- Close Portal Trigger +UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 77, `EffectImplicitTargetA1` = 25, `DmgMultiplier1` = 1 WHERE `Id` = 58018; -- Close Portal Effect +UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 3, `EffectImplicitTargetA1` = 1, `EffectRadiusIndex1` = 36, `DmgMultiplier1` = 1 WHERE `Id` = 58002; -- Summon Portal -- cgit v1.2.3