aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-12-27 03:06:31 +0200
committeroffl <offl@users.noreply.github.com>2020-12-27 03:06:31 +0200
commit8ca575ed52fb4ee8149302ecf33b4bb0c33e5eb5 (patch)
treeab1d825acdd83e8ae48aefa3aba5481b8183eafd /sql/updates
parent9f7df813c56f9ec4cd2a0e533d1396c211b29584 (diff)
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
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.3.5/2020_12_27_04_world.sql7
1 files changed, 7 insertions, 0 deletions
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