DB/Spell: Add effects to all summoning spells from Violet Hold

1 files changed, 87 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_12_25_02_world.sql b/sql/updates/world/3.3.5/2020_12_25_02_world.sql
new file mode 100644
index 00000000000..4714df9153f
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_12_25_02_world.sql
@@ -0,0 +1,87 @@
+--
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 44, `EffectRadiusIndex1` = 15, `EffectMiscValue1` = 30666, `EffectMiscValueB1` = 64 WHERE `Id` = 60048; -- Summon Azure Captain
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 43, `EffectRadiusIndex1` = 15, `EffectMiscValue1` = 30668, `EffectMiscValueB1` = 64 WHERE `Id` = 60049; -- Summon Azure Raider
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 42, `EffectRadiusIndex1` = 15, `EffectMiscValue1` = 30667, `EffectMiscValueB1` = 64 WHERE `Id` = 60050; -- Summon Azure Sorceror
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 41, `EffectRadiusIndex1` = 15, `EffectMiscValue1` = 32191, `EffectMiscValueB1` = 64 WHERE `Id` = 60086; -- Summon Azure Stalker
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 44, `EffectRadiusIndex1` = 15, `EffectMiscValue1` = 30667, `EffectMiscValueB1` = 64 WHERE `Id` = 60093; -- Summon Azure Sorceror
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 44, `EffectRadiusIndex1` = 15, `EffectMiscValue1` = 30668, `EffectMiscValueB1` = 64 WHERE `Id` = 60092; -- Summon Azure Raider
+
+/*
+.go x 1926.5161 763.66156 52.357254 2.251474618911743164
+
+60048 30666 .go x 1923.5326 763.97516 52.440586 2.251474618911743164
+60049 30668 .go x 1926.2025 760.678 52.440586 2.251474618911743164
+60086 32191 .go x 1926.8297 766.64514 52.440586 2.251474618911743164
+
+.go x 1911.2812 800.9722 39.916725 3.019419670104980468
+
+60050 30667 .go x  1913.6453 802.8192 40.000057 3.019419670104980468
+
+.go x 1922.4635 847.0699 48.501614 3.96189737319946289
+
+60093 30667 .go x 1922.5682 844.0717 48.584946 3.96189737319946289
+
+.go x 1911.2812 800.9722 39.916725 3.019419670104980468
+
+60092 30668 .go x  1908.9172 799.12524 40.000057 3.019419670104980468
+*/
+
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30893, `EffectMiscValueB1` = 64 WHERE `Id` = 58031; -- Summon Portal Keeper
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30663, `EffectMiscValueB1` = 64 WHERE `Id` = 58034; -- Summon Azure Binder
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30961, `EffectMiscValueB1` = 64 WHERE `Id` = 58088; -- Summon Azure Invader Alt
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30661, `EffectMiscValueB1` = 64 WHERE `Id` = 58087; -- Summon Azure Invader
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30963, `EffectMiscValueB1` = 64 WHERE `Id` = 58092; -- Summon Azure Mage Slayer Alt
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30918, `EffectMiscValueB1` = 64 WHERE `Id` = 58086; -- Summon Azure Binder
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30660, `EffectMiscValueB1` = 64 WHERE `Id` = 58028; -- Summon Portal Guardian
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30892, `EffectMiscValueB1` = 64 WHERE `Id` = 58029; -- Summon Portal Guardian Alt
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30664, `EffectMiscValueB1` = 64 WHERE `Id` = 58091; -- Summon Azure Mage Slayer
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30662, `EffectMiscValueB1` = 64 WHERE `Id` = 58089; -- Summon Azure Spellbreaker
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30962, `EffectMiscValueB1` = 64 WHERE `Id` = 58090; -- Summon Azure Spellbreaker Alt
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 18, `EffectMiscValue1` = 30695, `EffectMiscValueB1` = 64 WHERE `Id` = 58030; -- Summon Portal Keeper
+
+/*
+.go x 1858.243 770.23785 40.421455 0.907571196556091308
+
+58031 30893 .go x 1858.243 770.23785 40.004787 0.907571196556091308
+58034 30663 .go x 1858.243 770.23785 40.504787 0.907571196556091308
+58088 30961 .go x 1858.243 770.23785 40.504787 0.907571196556091308
+58087 30661 .go x 1858.243 770.23785 40.504787 0.907571196556091308
+
+.go x 1936.0903 803.1875 54.09715 3.054326057434082031
+
+58092 30963 .go x 1936.0903 803.1875 54.18048 3.054326057434082031
+
+.go x 1877.5226 850.17883 45.368217 4.345870018005371093
+
+58086 30918 .go x 1877.5226 850.17883 45.45155 4.345870018005371093
+58028 30660 .go x 1877.5226 850.17883 44.95155 4.345870018005371093
+58029 30892 .go x 1877.5226 850.17883 44.95155 4.345870018005371093
+
+.go x 1907.2882 831.11115 40.220154 3.560471534729003906
+58091 30664 .go x 1907.2882 831.11115 40.303486 3.560471534729003906
+58089 30662 .go x 1907.2882 831.11115 40.303486 3.560471534729003906
+58090 30962 .go x 1907.2882 831.11115 40.303486 3.560471534729003906
+58030 30695 .go x 1907.2882 831.11115 39.803486 3.560471534729003906
+*/
+
+UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectImplicitTargetA1` = 72, `EffectRadiusIndex1` = 7, `EffectMiscValue1` = 30665, `EffectMiscValueB1` = 64 WHERE `Id` = 58093; -- Summon Veteran Mage Hunter
+
+/*
+distance 2
+.go x 1877.5226 850.17883 45.368217 4.345870018005371093
+
+58093 30665 .go x 1878.4926 850.9416 43.41683 4.345870018005371093
+58093 30665 .go x 1876.63 851.2563 43.41683 4.345870018005371093
+58093 30665 .go x 1877.7584 851.0674 43.41683 4.345870018005371093
+58093 30665 .go x 1878.903 849.6679 43.41683 4.345870018005371093
+
+.go x 1858.243 770.23785 40.421455 0.907571196556091308
+
+58093 30665 .go x 1858.0314 769.12573 38.736134 0.907571196556091308
+58093 30665 .go x 1856.6608 769.14087 38.7372 0.907571196556091308
+
+.go x 1858.243 770.23785 40.421455 0.907571196556091308
+
+58093 30665 .go x 1857.44 771.4769 38.78791 0.907571196556091308
+58093 30665 .go x 1858.9102 768.4008 38.735527 0.907571196556091308
+*/