diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_12_25_02_world.sql | 87 |
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 +*/ |