diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2022_11_15_02_world.sql | 115 |
1 files changed, 115 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2022_11_15_02_world.sql b/sql/updates/world/3.3.5/2022_11_15_02_world.sql new file mode 100644 index 00000000000..1dbf1bb27d1 --- /dev/null +++ b/sql/updates/world/3.3.5/2022_11_15_02_world.sql @@ -0,0 +1,115 @@ +-- Update few wrong (positive) spells cooldown values +UPDATE `spell_proc` SET `Cooldown`=6000 WHERE `SpellId`=7434; -- Fate Rune of Unsurpassed Vigor +UPDATE `spell_proc` SET `Cooldown`=20000 WHERE `SpellId`=13163; -- Aspect of the Monkey +UPDATE `spell_proc` SET `Cooldown`=5000 WHERE `SpellId`=15088; -- Flurry +UPDATE `spell_proc` SET `Cooldown`=2000 WHERE `SpellId`=15600; -- Hand of Justice (this will fix a possible item exploit) +UPDATE `spell_proc` SET `Cooldown`=500 WHERE `SpellId`=16164; -- Elemental Focus +UPDATE `spell_proc` SET `Cooldown`=1000 WHERE `SpellId`=22618; -- Force Reactive Disk +UPDATE `spell_proc` SET `Cooldown`=120000 WHERE `SpellId`=22648; -- Call of Eskhandar +UPDATE `spell_proc` SET `Cooldown`=3500 WHERE `SpellId`=23552; -- Lightning Shield +UPDATE `spell_proc` SET `Cooldown`=1000 WHERE `SpellId`=23572; -- Mana Surge +UPDATE `spell_proc` SET `Cooldown`=3500 WHERE `SpellId`=32734; -- Earth Shield +UPDATE `spell_proc` SET `Cooldown`=35000 WHERE `SpellId`=32837; -- Spell Focus Trigger +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=33648; -- Reflection of Torment +UPDATE `spell_proc` SET `Cooldown`=3500 WHERE `SpellId`=34355; -- Poison Shield +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=34584; -- Love Struck +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=34598; -- Karazhan Caster Robe +UPDATE `spell_proc` SET `Cooldown`=4000 WHERE `SpellId`=34827; -- Water Shield +UPDATE `spell_proc` SET `Cooldown`=60000 WHERE `SpellId`=35077; -- Band of the Eternal Defender +UPDATE `spell_proc` SET `Cooldown`=60000 WHERE `SpellId`=35080; -- Band of the Eternal Champion +UPDATE `spell_proc` SET `Cooldown`=60000 WHERE `SpellId`=35083; -- Band of the Eternal Sage +UPDATE `spell_proc` SET `Cooldown`=60000 WHERE `SpellId`=35086; -- Band of the Eternal Restorer +UPDATE `spell_proc` SET `Cooldown`=30000 WHERE `SpellId`=37173; -- Armor Penetration +UPDATE `spell_proc` SET `Cooldown`=40000 WHERE `SpellId`=37247; -- Regain Mana +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=37655; -- Bonus Mana Regen +UPDATE `spell_proc` SET `Cooldown`=120000 WHERE `SpellId`=38164; -- Unyielding Knights +UPDATE `spell_proc` SET `Cooldown`=15000 WHERE `SpellId`=38299; -- HoTs on Heals +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=38334; -- Proc Mana Regen +UPDATE `spell_proc` SET `Cooldown`=45000 WHERE `SpellId`=38350; -- Crit Proc Heal (possible Paladin exploit) +UPDATE `spell_proc` SET `Cooldown`=3500 WHERE `SpellId`=39027; -- Poison Shield +UPDATE `spell_proc` SET `Cooldown`=8000 WHERE `SpellId`=40899; -- Felfire Proc +UPDATE `spell_proc` SET `Cooldown`=15000 WHERE `SpellId`=41393; -- Riposte (possible Rogue exploit) +UPDATE `spell_proc` SET `Cooldown`=10000 WHERE `SpellId`=43748; -- Elemental Strength +UPDATE `spell_proc` SET `Cooldown`=30000 WHERE `SpellId`=43750; -- Energized +UPDATE `spell_proc` SET `Cooldown`=25000 WHERE `SpellId`=46662; -- Deathfrost +UPDATE `spell_proc` SET `Cooldown`=15000 WHERE `SpellId`=46832; -- Moonkin Starfire Bonus +UPDATE `spell_proc` SET `Cooldown`=10000 WHERE `SpellId`=48833; -- Primal Instinct +UPDATE `spell_proc` SET `Cooldown`=10000 WHERE `SpellId`=48837; -- Elemental Tenacity +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=49622; -- Bonus Mana Regen +UPDATE `spell_proc` SET `Cooldown`=4000 WHERE `SpellId`=50908; -- Seal of Onslaught +UPDATE `spell_proc` SET `Cooldown`=1000 WHERE `SpellId`=51698; -- Honor Among Thieves +UPDATE `spell_proc` SET `Cooldown`=1000 WHERE `SpellId`=51700; -- Honor Among Thieves +UPDATE `spell_proc` SET `Cooldown`=1000 WHERE `SpellId`=51701; -- Honor Among Thieves +UPDATE `spell_proc` SET `Cooldown`=10000 WHERE `SpellId`=52020; -- Snap and Snarl +UPDATE `spell_proc` SET `Cooldown`=45000 WHERE `SpellId`=52423; -- Retaliation +UPDATE `spell_proc` SET `Cooldown`=6000 WHERE `SpellId`=52898; -- Spell Damping +UPDATE `spell_proc` SET `Cooldown`=5000 WHERE `SpellId`=53646; -- Demonic Pact +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=54707; -- Sonic Awareness (DND) +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=54808; -- Sonic Shield +UPDATE `spell_proc` SET `Cooldown`=60000 WHERE `SpellId`=55640; -- Lightweave Embroidery +UPDATE `spell_proc` SET `Cooldown`=55000 WHERE `SpellId`=55776; -- Swordguard Embroidery +UPDATE `spell_proc` SET `Cooldown`=6000 WHERE `SpellId`=56218; -- Glyph of Corruption +UPDATE `spell_proc` SET `Cooldown`=3500 WHERE `SpellId`=56451; -- Earth Shield +UPDATE `spell_proc` SET `Cooldown`=500 WHERE `SpellId`=56821; -- Glyph of Sinister Strike +UPDATE `spell_proc` SET `Cooldown`=45000 WHERE `SpellId`=57907; -- Increased Spirit +UPDATE `spell_proc` SET `Cooldown`=30000 WHERE `SpellId`=58442; -- Airy Pale Ale +UPDATE `spell_proc` SET `Cooldown`=30000 WHERE `SpellId`=58501; -- Iron Boot Flask +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=58901; -- Tears of Anguish +UPDATE `spell_proc` SET `Cooldown`=6000 WHERE `SpellId`=59176; -- Spell Damping +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=60066; -- Rage of the Unraveller +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=60221; -- Essence of Gossamer +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=60519; -- Spark of Life +UPDATE `spell_proc` SET `Cooldown`=30000 WHERE `SpellId`=60770; -- Totem of the Elemental Plane +UPDATE `spell_proc` SET `Cooldown`=45000 WHERE `SpellId`=60826; -- Sigil of Haunted Dreams +UPDATE `spell_proc` SET `Cooldown`=45000 WHERE `SpellId`=61356; -- Invigorating Earthsiege Diamond Passive +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=62114; -- Flow of Knowledge +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=62115; -- Strength of the Titans +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=63251; -- Glory of the Jouster +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=64738; -- Show of Faith +UPDATE `spell_proc` SET `Cooldown`=15000 WHERE `SpellId`=64752; -- Item - Druid T8 Feral 2P Bonus +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=64792; -- Blood of the Old God +UPDATE `spell_proc` SET `Cooldown`=45000 WHERE `SpellId`=64860; -- Item - Hunter T8 4P Bonus +UPDATE `spell_proc` SET `Cooldown`=45000 WHERE `SpellId`=64867; -- Item - Mage T8 2P Bonus +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=65002; -- Bonus Mana Regen +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=65013; -- Pyrite Infusion +UPDATE `spell_proc` SET `Cooldown`=15000 WHERE `SpellId`=67209; -- Item - Rogue T9 2P Bonus (Rupture) +UPDATE `spell_proc` SET `Cooldown`=8000 WHERE `SpellId`=67353; -- Item - Druid T9 Feral Relic (Lacerate, Swipe, Mangle, and Shred) +UPDATE `spell_proc` SET `Cooldown`=5000 WHERE `SpellId`=67356; -- Item - Druid T9 Restoration Relic (Rejuvenation) +UPDATE `spell_proc` SET `Cooldown`=6000 WHERE `SpellId`=67361; -- Item - Druid T9 Balance Relic (Moonfire) +UPDATE `spell_proc` SET `Cooldown`=8000 WHERE `SpellId`=67363; -- Item - Paladin T9 Holy Relic (Judgement) +UPDATE `spell_proc` SET `Cooldown`=8000 WHERE `SpellId`=67365; -- Item - Paladin T9 Retribution Relic (Seal of Vengeance) +UPDATE `spell_proc` SET `Cooldown`=9000 WHERE `SpellId`=67379; -- Item - Paladin T9 Protection Relic (Hammer of The Righteous) +UPDATE `spell_proc` SET `Cooldown`=9000 WHERE `SpellId`=67392; -- Item - Shaman T9 Enhancement Relic (Lava Lash) +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=67672; -- Coliseum 5 Melee Trinket +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=69739; -- Shiny Shard of the Scale - Equip Effect +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=69755; -- Purified Shard of the Scale - Equip Effect +UPDATE `spell_proc` SET `Cooldown`=100 WHERE `SpellId`=69762; -- Unchained Magic +UPDATE `spell_proc` SET `Cooldown`=3000 WHERE `SpellId`=70188; -- Cloak of Darkness +UPDATE `spell_proc` SET `Cooldown`=1000 WHERE `SpellId`=70904; -- Corruption +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=71404; -- Item - Icecrown Dungeon Melee Trinket +UPDATE `spell_proc` SET `Cooldown`=250 WHERE `SpellId`=71567; -- Item - Icecrown Dungeon Healer Trinket +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=71585; -- Item - Icecrown 25 Emblem Healer Trinket +UPDATE `spell_proc` SET `Cooldown`=3000 WHERE `SpellId`=71770; -- Ooze Spell Tank Protection +UPDATE `spell_proc` SET `Cooldown`=3000 WHERE `SpellId`=71993; -- Frozen Mallet +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=75465; -- Item - Chamber of Aspects 25 Nuker Trinket +UPDATE `spell_proc` SET `Cooldown`=50000 WHERE `SpellId`=75474; -- Item - Chamber of Aspects 25 Heroic Nuker Trinket +-- Update few wrong (negative) spells cooldown values +UPDATE `spell_proc` SET `Cooldown`=3500 WHERE `SpellId`=-324; -- Lightning Shield +UPDATE `spell_proc` SET `Cooldown`=3500 WHERE `SpellId`=-974; -- Earth Shield +UPDATE `spell_proc` SET `Cooldown`=8 WHERE `SpellId`=-10400; -- Flametongue Weapon (Passive) +UPDATE `spell_proc` SET `Cooldown`=500 WHERE `SpellId`=-14186; -- Seal Fate +UPDATE `spell_proc` SET `Cooldown`=500 WHERE `SpellId`=-16257; -- Flurry +UPDATE `spell_proc` SET `Cooldown`=6000 WHERE `SpellId`=-18094; -- Nightfall +UPDATE `spell_proc` SET `Cooldown`=8 WHERE `SpellId`=-29074; -- Master of Elements +UPDATE `spell_proc` SET `Cooldown`=500 WHERE `SpellId`=-30160; -- Elemental Devastation +UPDATE `spell_proc` SET `Cooldown`=6000 WHERE `SpellId`=-33150; -- Surge of Light +UPDATE `spell_proc` SET `Cooldown`=1 WHERE `SpellId`=-34753; -- Holy Concentration +UPDATE `spell_proc` SET `Cooldown`=8 WHERE `SpellId`=-44449; -- Burnout +UPDATE `spell_proc` SET `Cooldown`=6000 WHERE `SpellId`=-44557; -- Enduring Winter +UPDATE `spell_proc` SET `Cooldown`=100 WHERE `SpellId`=-49208; -- Reaping +UPDATE `spell_proc` SET `Cooldown`=500 WHERE `SpellId`=-49217; -- Wandering Plague +UPDATE `spell_proc` SET `Cooldown`=3500 WHERE `SpellId`=-52127; -- Water Shield +UPDATE `spell_proc` SET `Cooldown`=100 WHERE `SpellId`=-54639; -- Blood of the North +UPDATE `spell_proc` SET `Cooldown`=22000 WHERE `SpellId`=-56342; -- Lock and Load +UPDATE `spell_proc` SET `Cooldown`=5800 WHERE `SpellId`=-56636; -- Taste for Blood +UPDATE `spell_proc` SET `Cooldown`=100 WHERE `SpellId`=-63730; -- Serendipity |