-- ---------------------------------------------------------------------- -- SPELL PROC EVENT -- ---------------------------------------------------------------------- -- Fix Cooldowns -- UPDATE spell_proc_event SET cooldown = cooldown*1000 WHERE cooldown < 1000; -- [Paladin] Infusion of Light REPLACE INTO spell_proc_event VALUES (-53569, 0, 10, 2097152, 65536, 0, 0, 2, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (53601, 0, 0, 0, 0, 0, 688808, 0, 0, 0, 6000); -- Sacred Shield -- [Paladin] Heart of the Crusader REPLACE INTO spell_proc_event VALUES (-20335, 0, 10, 8388608, 0, 0, 16, 0, 0, 100, 0); -- [Paladin] Seal of Righteousness REPLACE INTO spell_proc_event VALUES (21084, 1+2, 0, 0, 0, 0, 0, 1+2+1024, 0, 0, 0); -- [Paladin] Seal of Corruption REPLACE INTO spell_proc_event VALUES (53736, 0, 0, 0, 0, 0, 0, 1+2+1024, 0, 0, 0); -- [Paladin] Seal of Vengeance REPLACE INTO spell_proc_event VALUES (31801, 0, 0, 0, 0, 0, 0, 1+2+1024, 0, 0, 0); -- [Paladin] Guarded by the light REPLACE INTO spell_proc_event VALUES (53583, 0, 0, 0, 0, 0, 0, 1+2+1024, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (53585, 0, 0, 0, 0, 0, 0, 1+2+1024, 0, 0, 0); -- [Paladin] Reckoning DELETE FROM spell_proc_event WHERE entry IN(-20177, 20177, 20179, 20180, 20181); REPLACE INTO spell_proc_event VALUES (20182, 0, 0, 0, 0, 0, 0, 1+2+64+262144, 0, 0, 0); -- [Hunter] Misdirection REPLACE INTO spell_proc_event VALUES (34477, 0, 9, 0, 0, 0, 4+16+64+256+1024+4096+16384+65536+262144, 0, 0, 100, 0); -- [Hunter] Culling the Herd REPLACE INTO spell_proc_event VALUES (-61680, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0); -- [Hunter] Entrapment REPLACE INTO spell_proc_event VALUES (-19184, 0, 9, 16, 8192, 262144, 0, 0, 0, 0, 0); -- [Hunter] Lock and Load REPLACE INTO spell_proc_event VALUES (-56342, 0, 9, 24, 134217728, 409600, 0, 0, 0, 0, 22000); -- [Hunter] Pet - Dust Cloud REPLACE INTO spell_proc_event VALUES (54404, 0, 0, 0, 0, 0, 0, 4, 0, 100, 0); -- [Hunter] Pet - Savage Rend REPLACE INTO spell_proc_event VALUES (50871, 0, 9, 0, 1342177280, 0, 0, 2, 0, 100, 0); -- [Hunter] Pet - Intimidation REPLACE INTO spell_proc_event VALUES (19577, 0, 0, 0, 0, 0, 0, 1+2+1024, 0, 0, 0); -- [Warlock] Improved Spirit Tap REPLACE INTO spell_proc_event VALUES (-15337, 0, 6, 8192+8388608, 2, 0, 65536+262144, 2, 0, 100, 0); -- [Warlock] Essence of Life REPLACE INTO spell_proc_event VALUES (33953, 0, 0, 0, 0, 0, 278528, 3, 0, 0, 45000); -- [Warlock] Siphon Life REPLACE INTO spell_proc_event VALUES (63108, 0, 5, 2, 0, 0, 0, 262144, 0, 0, 0); -- [Warlock] Demonic Immolation Passive REPLACE INTO spell_proc_event VALUES (4524, 0, 0, 0, 0, 0, 1048576, 262144, 0, 0, 0); -- [Warlock] Shadowfiend passive aura REPLACE INTO spell_proc_event VALUES (28305, 0, 0, 0, 0, 0, 4, 1+2, 0, 100, 0); -- [Warlock] Demonic Pact, pet trigger REPLACE INTO spell_proc_event VALUES (53646, 0, 0, 0, 0, 0, 0, 2, 0, 0, 20000); REPLACE INTO spell_proc_event VALUES (54909, 0, 0, 0, 0, 0, 0, 2, 0, 0, 20000); -- [Warlock] Glyph of Shadowflame REPLACE INTO spell_proc_event VALUES (63310, 0, 5, 0, 65536, 0, 65536, 1+2+1024, 0, 0, 0); -- [Warlock] Nightfall REPLACE INTO spell_proc_event VALUES (-18094, 0, 5, 10, 0, 0, 262144, 262144, 0, 0, 0); -- [Warlock] Decimation REPLACE INTO spell_proc_event VALUES (-63156, 126, 5, 1, 192, 0, 65536, 0, 0, 0, 0); -- [Rogue] Overkill and Master of Subtlety with Vanish REPLACE INTO spell_proc_event VALUES (31221, 0, 8, 4194304+2048, 0, 0, 1024, 0, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (31222, 0, 8, 4194304+2048, 0, 0, 1024, 0, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (31223, 0, 8, 4194304+2048, 0, 0, 1024, 0, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (58426, 0, 8, 4194304+2048, 0, 0, 1024, 0, 0, 0, 0); -- [Rogue] Stealth REPLACE INTO spell_proc_event VALUES (1784, 0, 0, 0, 0, 0, 0, 262144, 0, 0, 0); -- [Rogue] Hemorrhage REPLACE INTO spell_proc_event VALUES (-16511, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0); -- [Death Knight] Desolation REPLACE INTO spell_proc_event VALUES (-66799, 0, 15, 4194304, 0, 0, 16, 0, 0, 0, 0); -- [Death Knight] Cinderglacier REPLACE INTO spell_proc_event VALUES (53386, 48, 15, 8192+1+2, 4+2, 128, 349456, 0, 0, 0, 0); -- [Death Knight] Taste for Blood REPLACE INTO spell_proc_event VALUES (60503, 1, 4, 4, 0, 0, 16, 65536, 0, 0, 0); -- [Death Knight] Scent of Blood REPLACE INTO spell_proc_event VALUES (50421, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000); -- [Death Knight] Necrosis REPLACE INTO spell_proc_event VALUES (-51459, 0, 15, 0, 536870912, 0, 20, 0, 0, 0, 0); -- [Death Knight] Blood-Caked Blade REPLACE INTO spell_proc_event VALUES (-49219, 0, 15, 0, 536870912, 0, 20, 0, 0, 0, 0); -- [Death Knight] Enduring Winter REPLACE INTO spell_proc_event VALUES (-44557, 0, 3, 32, 0, 0, 0, 0, 0, 0, 6000); -- [Death Knight] Wandering Plague REPLACE INTO spell_proc_event VALUES (-49217, 0, 15, 0, 0, 2, 0, 0, 0, 0, 500); -- [Mage] Improved Mana Gems REPLACE INTO spell_proc_event VALUES (37447, 0, 3, 0, 256, 0, 1024+16384, 0, 0, 100, 15000); REPLACE INTO spell_proc_event VALUES (61062, 0, 3, 0, 256, 0, 1024+16384, 0, 0, 100, 15000); -- [Mage] Arcane Potency DELETE FROM spell_proc_event WHERE entry IN(31571, 31572); -- [Mage] Deep Freeze DELETE FROM spell_proc_event WHERE entry=71761; DELETE FROM playercreateinfo_spell WHERE spell=71761; DELETE FROM spell_script_names WHERE spell_id=44572; INSERT INTO spell_script_names VALUES (44572, 'spell_mage_deep_freeze'); DELETE FROM spell_linked_spell WHERE spell_trigger=44572; -- [Mage] Master of Elements UPDATE spell_proc_event SET SchoolMask=0 WHERE entry IN(29074, 29075, 29076); -- [Mage] Combustion REPLACE INTO spell_proc_event VALUES (11129, 4, 3, 12582935, 200768, 0, 0, 0, 0, 0, 0); -- [Mage] Fingers of Frost REPLACE INTO spell_proc_event VALUES (74396, 84, 3, 685904631, 1151040, 0, 65536, 3, 0, 0, 0); -- [Mage] Brain Freeze - adding small internal cooldown (the rest is unchanged) REPLACE INTO spell_proc_event VALUES (44546, 0, 3, 1049120, 4096, 0, 69632, 0, 0, 5, 3000); REPLACE INTO spell_proc_event VALUES (44548, 0, 3, 1049120, 4096, 0, 69632, 0, 0, 10, 3000); REPLACE INTO spell_proc_event VALUES (44549, 0, 3, 1049120, 4096, 0, 69632, 0, 0, 15, 3000); DELETE FROM spell_script_names WHERE spell_id IN(-44546, 44546, 44548, 44549); INSERT INTO spell_script_names VALUES (-44546, 'spell_mage_brain_freeze'); -- [Mage] Magic Absorption REPLACE INTO spell_proc_event VALUES (-29441, 0, 0, 0, 0, 0, 0, 12, 0, 0, 0); -- [Shaman] Windfury Weapon REPLACE INTO spell_proc_event VALUES (33757, 0, 0, 0, 0, 0, 0, 0, 0, 20, 3000); -- [Shaman] Elemental Focus REPLACE INTO spell_proc_event VALUES (16164, 0, 11, 2416967875, 4096+262144, 0, 0, 2, 0, 0, 0); -- [Shaman] Improved Stormstrike REPLACE INTO spell_proc_event VALUES (-51521, 0, 11, 0, 16, 0, 0, 0, 0, 0, 1); -- [Priest] Inner Fire REPLACE INTO spell_proc_event VALUES (-588, 0, 0, 0, 0, 0, 0, 262144, 0, 0, 0); -- [Priest] Shadow Weaving REPLACE INTO spell_proc_event VALUES (15257, 32, 6, 0, 0, 0, 65536, 0, 0, 33, 0); REPLACE INTO spell_proc_event VALUES (15331, 32, 6, 0, 0, 0, 65536, 0, 0, 66, 0); REPLACE INTO spell_proc_event VALUES (15332, 32, 6, 0, 0, 0, 65536, 0, 0, 100, 0); -- [Priest] Renewed Hope REPLACE INTO spell_proc_event VALUES (-57470, 0, 6, 1, 0, 0, 0, 0, 0, 0, 15000); -- [Priest] Borrowed Time REPLACE INTO spell_proc_event VALUES (59887, 0, 0, 0, 0, 0, 87040, 3, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (59888, 0, 0, 0, 0, 0, 87040, 3, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (59889, 0, 0, 0, 0, 0, 87040, 3, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (59890, 0, 0, 0, 0, 0, 87040, 3, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (59891, 0, 0, 0, 0, 0, 87040, 3, 0, 0, 0); -- [Priest] Misery DELETE FROM spell_proc_event WHERE entry IN(-33191, 33191, 33192, 33193); INSERT INTO spell_proc_event VALUES (-33191, 0, 6, 8388608+32768, 1024, 0, 0, 0, 0, 0, 0); -- [Warrior] Recklessness REPLACE INTO spell_proc_event VALUES (1719, 0, 4, 778044484, 4212549, 0, 0, 2, 0, 0, 0); -- [Warrior] Furious Attacks REPLACE INTO spell_proc_event VALUES (46910, 0, 4, 64, 0, 0, 20, 0, 5.5, 0, 0); REPLACE INTO spell_proc_event VALUES (46911, 0, 4, 64, 0, 0, 20, 0, 7.5, 0, 0); -- [Druid] Idol of the Crying Moon REPLACE INTO spell_proc_event VALUES (71174, 0, 7, 4096, 256, 0, 262144, 0, 0, 0, 0); -- [Item] Glyph of Freezing trap REPLACE INTO spell_proc_event VALUES (56845, 0, 9, 8, 0, 0, 2097152, 0, 0, 0, 0); -- [Item] Warrior T8 Protection 4P Bonus REPLACE INTO spell_proc_event VALUES (64936, 0, 4, 4096, 0, 0, 4096+65536, 0, 0, 100, 0); -- [Item] Goblin Gumbo REPLACE INTO spell_proc_event VALUES (42760, 0, 0, 0, 0, 0, 2+4+8+64+128+16384+32768+65536+131072, 0, 0, 20, 0); -- [Item] Lightweave Embroidery REPLACE INTO spell_proc_event VALUES (55640, 0, 0, 0, 0, 0, 0, 1+2, 0, 0, 45000); -- [Item] Val'anyr REPLACE INTO spell_proc_event VALUES (64411, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (64415, 0, 0, 0, 0, 0, 0, 524288, 0, 0, 45000); -- [Item] Coment's Trial REPLACE INTO spell_proc_event VALUES (64786, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45000); -- [Item] Berserker! REPLACE INTO spell_proc_event VALUES (57351, 0, 0, 0, 0, 0, 1782780, 0, 0, 0, 0); -- [Item] - Rogue T10 2P Bonus REPLACE INTO spell_proc_event VALUES (70805, 0, 8, 0, 131072, 0, 0, 0, 0, 0, 1000); -- [Item] Coliseum 25 Normal Melee Trinket REPLACE INTO spell_proc_event VALUES (67702, 1, 0, 0, 0, 0, 332116, 3+262144, 0, 35, 45000); -- [Item] Coliseum 25 Heroic Melee Trinket REPLACE INTO spell_proc_event VALUES (67771, 1, 0, 0, 0, 0, 332116, 3+262144, 0, 35, 45000); -- [Item] Mage T8 2P Bonus REPLACE INTO spell_proc_event VALUES (64867, 0, 3, 536870945, 4096, 0, 0, 0, 0, 0, 45000); -- [Item] Rouge T9 Clearcasting REPLACE INTO spell_proc_event VALUES (67210, 0, 8, 4294967295, 4294967295, 4294967295, 0, 0, 0, 0, 0); -- [Item] Glyph of Shadow Word: Pain REPLACE INTO spell_proc_event VALUES (55681, 0, 6, 32768, 0, 0, 262144, 0, 0, 0, 0); -- [Item] Glyph of Blocking REPLACE INTO spell_proc_event VALUES (58375, 0, 4, 0, 512, 0, 16+65536, 0, 0, 100, 0); -- [Item] Eye of the Broodmother DELETE FROM spell_proc_event WHERE entry=65007; -- [Item] Alchemist Stone REPLACE INTO spell_proc_event VALUES (17619, 0, 13, 0, 0, 0, 32768+2048, 3, 0, 0, 0); -- [Item] Ephemeral Snowflake REPLACE INTO spell_proc_event VALUES (71567, 0, 0, 0, 0, 0, 0, 1+2, 0, 0, 400); -- [Item] Meteorite Crystal REPLACE INTO spell_proc_event VALUES (64999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); -- [Item] Shadowmourne REPLACE INTO spell_proc_event VALUES (71903, 0, 0, 0, 0, 0, 0, 1+2+1024+1048576, 0, 75, 0); -- [Item] DK 4P bonus REPLACE INTO spell_proc_event VALUES (61257, 0, 0, 0, 0, 0, 0, 1+2, 0, 0, 0); -- [Item] Dislodged Foreign Object REPLACE INTO spell_proc_event VALUES (71602, 0, 0, 0, 0, 0, 65536, 1+2, 0, 0, 45000); REPLACE INTO spell_proc_event VALUES (71645, 0, 0, 0, 0, 0, 65536, 1+2, 0, 0, 45000); -- [Item] Item - Shaman T10 Elemental Relic REPLACE INTO spell_proc_event VALUES (71198, 0, 11, 268435456, 0, 0, 0, 0, 0, 0, 0); -- [Item] Sundial of the Exiled -- [Item] Mithril Pocketwatch REPLACE INTO spell_proc_event VALUES (60063, 0, 0, 0, 0, 0, 65536, 0, 0, 0, 45000); -- ---------------------------------------------------------------------- -- SPELL SCRIPTS -- ---------------------------------------------------------------------- -- Model Visibility DELETE FROM spell_script_names WHERE spell_id=24401; INSERT INTO spell_script_names VALUES (24401, 'spell_gen_model_visible'); -- One per cast procs DELETE FROM spell_script_names WHERE ScriptName='spell_gen_proc_once_per_cast'; INSERT INTO spell_script_names VALUES (71845, 'spell_gen_proc_once_per_cast'); INSERT INTO spell_script_names VALUES (75474, 'spell_gen_proc_once_per_cast'); INSERT INTO spell_script_names VALUES (75465, 'spell_gen_proc_once_per_cast'); INSERT INTO spell_script_names VALUES (71645, 'spell_gen_proc_once_per_cast'); INSERT INTO spell_script_names VALUES (71846, 'spell_gen_proc_once_per_cast'); INSERT INTO spell_script_names VALUES (71602, 'spell_gen_proc_once_per_cast'); INSERT INTO spell_script_names VALUES (72419, 'spell_gen_proc_once_per_cast'); -- [Item] SOTA Seaforium Charge DELETE FROM spell_script_names WHERE spell_id=52417; INSERT INTO spell_script_names VALUES (52417, 'spell_item_massive_seaforium_charge'); -- [Item] Titanium Seal of Dalaran DELETE FROM spell_script_names WHERE spell_id=60476; INSERT INTO spell_script_names VALUES (60476, 'spell_item_titanium_seal_of_dalaran'); -- [Item] Mind Amplification Dish DELETE FROM spell_script_names WHERE spell_id IN(67799, 13180); INSERT INTO spell_script_names VALUES (67799, 'spell_item_mind_amplify_dish'); INSERT INTO spell_script_names VALUES (13180, 'spell_item_mind_amplify_dish'); -- [Item] Mithril Spurs (7969) DELETE FROM spell_script_names WHERE spell_id IN(7215); INSERT INTO spell_script_names VALUES (7215, 'spell_item_mithril_spurs'); -- [Item] Magic Dust (2091) DELETE FROM spell_script_names WHERE spell_id IN(1090); INSERT INTO spell_script_names VALUES (1090, 'spell_item_magic_dust'); -- [Item] Crazy Alchemist's Potion (40077) DELETE FROM spell_script_names WHERE spell_id IN(53750); INSERT INTO spell_script_names VALUES (53750, 'spell_item_crazy_alchemists_potion'); -- [Item] Skull of Impending Doom (4984) DELETE FROM spell_script_names WHERE spell_id IN(5024); INSERT INTO spell_script_names VALUES (5024, 'spell_item_skull_of_impeding_doom'); -- [Item] Carrot on a Stick DELETE FROM spell_script_names WHERE spell_id IN(48777); INSERT INTO spell_script_names VALUES (48777, 'spell_item_carrot_on_a_stick'); -- [Item] Runescroll of Fortitude DELETE FROM spell_linked_spell WHERE spell_trigger=69377; DELETE FROM spell_script_names WHERE spell_id IN(69377); INSERT INTO spell_script_names VALUES (69377, 'spell_item_runescroll_of_fortitude'); -- [Item] Brann's Communicator DELETE FROM spell_linked_spell WHERE spell_trigger IN(61122); DELETE FROM spell_script_names WHERE spell_id IN(61122); INSERT INTO spell_script_names VALUES (61122, 'spell_item_branns_communicator'); -- [Item] Essence of Life (33953), triggered by Ancient Pickled Egg and The Egg of Mortal Essence DELETE FROM spell_script_names WHERE spell_id IN(33953); INSERT INTO spell_script_names VALUES (33953, 'spell_item_essence_of_life'); -- [Item] Fish Feast (57426) DELETE FROM spell_script_names WHERE spell_id IN(57426); INSERT INTO spell_script_names VALUES (57426, 'spell_item_fish_feast'); -- [Item] Strong Anti-Venom (7933) DELETE FROM spell_script_names WHERE spell_id IN(7933); INSERT INTO spell_script_names VALUES (7933, 'spell_item_strong_anti_venom'); -- [Item] Gnomish Shrink Ray DELETE FROM spell_script_names WHERE spell_id IN(13006); INSERT INTO spell_script_names VALUES (13006, 'spell_item_gnomish_shrink_ray'); -- [Item] Goblin Weather Machine DELETE FROM spell_script_names WHERE spell_id IN(46203, 46736, 46738, 46739, 46740); INSERT INTO spell_script_names VALUES (46203, 'spell_item_goblin_weather_machine'); INSERT INTO spell_script_names VALUES (46736, 'spell_item_goblin_weather_machine'); INSERT INTO spell_script_names VALUES (46738, 'spell_item_goblin_weather_machine'); INSERT INTO spell_script_names VALUES (46739, 'spell_item_goblin_weather_machine'); INSERT INTO spell_script_names VALUES (46740, 'spell_item_goblin_weather_machine'); -- [Item] Big Blizzard Bear DELETE FROM spell_script_names WHERE spell_id IN(58983); INSERT INTO spell_script_names VALUES (58983, 'spell_big_blizzard_bear'); -- [Item] Oracle Talisman of Ablution DELETE FROM spell_script_names WHERE spell_id IN(59789); INSERT INTO spell_script_names VALUES (59789, 'spell_item_oracle_ablutions'); -- [Item] Trauma REPLACE INTO spell_proc_event VALUES (71865, 0, 0, 0, 0, 0, 0, 1+2, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (71868, 0, 0, 0, 0, 0, 0, 1+2, 0, 0, 0); -- HC DELETE FROM spell_script_names WHERE spell_id IN(71865, 71868); INSERT INTO spell_script_names VALUES (71865, 'spell_item_trauma'); INSERT INTO spell_script_names VALUES (71868, 'spell_item_trauma'); -- [Item] Furbolg Medicine Pouch DELETE FROM spell_script_names WHERE spell_id IN(20631); INSERT INTO spell_script_names VALUES (20631, 'spell_gen_use_spell_base_level_check'); -- [Item] Deadman's Hand DELETE FROM spell_script_names WHERE spell_id IN(27867); INSERT INTO spell_script_names VALUES (27867, 'spell_gen_disabled_above_70'); -- [Item] Lightweave Embroidery DELETE FROM spell_script_names WHERE spell_id IN(55640); INSERT INTO spell_script_names VALUES (55640, 'spell_gen_allow_proc_from_spells_with_cost'); -- [Item] Hand of Justice REPLACE INTO spell_proc_event VALUES (15600, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0); DELETE FROM spell_script_names WHERE spell_id IN(15600); INSERT INTO spell_script_names VALUES (15600, 'spell_gen_proc_reduced_above_60'); -- [Enchant] Icy Chill (20005) -- [Enchant] Lifestealing (20004) -- [Enchant] Crusader (20007) REPLACE INTO spell_enchant_proc_data VALUES (1894, 0, 1.7, 0); DELETE FROM spell_script_names WHERE spell_id IN(20004, 20005, 20007); INSERT INTO spell_script_names VALUES (20004, 'spell_gen_reduced_above_60'); INSERT INTO spell_script_names VALUES (20005, 'spell_gen_reduced_above_60'); INSERT INTO spell_script_names VALUES (20007, 'spell_gen_reduced_above_60'); -- [Enchant] Deathfrost (46629) DELETE FROM spell_script_names WHERE spell_id IN(46629); INSERT INTO spell_script_names VALUES (46629, 'spell_gen_disabled_above_73'); -- [Enchant] Enchant Gloves - Riding Skill (13927) DELETE FROM spell_script_names WHERE spell_id IN(59917); INSERT INTO spell_script_names VALUES (59917, 'spell_gen_disabled_above_70'); DELETE FROM spell_linked_spell WHERE spell_trigger IN(13927, -13927); INSERT INTO spell_linked_spell VALUES (13927, 59917, 1, 'Enchant Gloves - Riding Skill Speed add'); INSERT INTO spell_linked_spell VALUES (-13927, -59917, 0, 'Enchant Gloves - Riding Skill Speed remove'); -- [Enchant] Black Magic (59630) REPLACE INTO spell_proc_event VALUES (59630, 0, 0, 0, 0, 0, 65536+16+4096, 0, 0, 0, 35000); DELETE FROM spell_script_names WHERE spell_id IN(59630); INSERT INTO spell_script_names VALUES (59630, 'spell_gen_black_magic_enchant'); -- [Enchant] Blade Ward (64440) DELETE FROM spell_script_names WHERE spell_id IN(64440); INSERT INTO spell_script_names VALUES (64440, 'spell_item_blade_ward_enchant'); INSERT INTO spell_script_names VALUES (64440, 'spell_gen_proc_above_75'); -- [Enchant] Blood Draining (64568) DELETE FROM spell_script_names WHERE spell_id IN(64568); INSERT INTO spell_script_names VALUES (64568, 'spell_item_blood_draining_enchant'); INSERT INTO spell_script_names VALUES (64568, 'spell_gen_proc_above_75'); -- [Misc] Luck of the Draw DELETE FROM spell_script_names WHERE spell_id=72221; -- [Misc] Grow Flower Patch (Lifeblood trigger) DELETE FROM spell_script_names WHERE spell_id IN(55475); INSERT INTO spell_script_names VALUES (55475, 'spell_gen_grow_flower_patch'); -- [Misc] Preparation / Arena Preparation DELETE FROM spell_script_names WHERE spell_id IN(32727, 44521); INSERT INTO spell_script_names VALUES (32727, 'spell_gen_bg_preparation'); INSERT INTO spell_script_names VALUES (44521, 'spell_gen_bg_preparation'); -- [Misc] Eject All Passengers DELETE FROM spell_script_names WHERE spell_id IN(50630); INSERT INTO spell_script_names VALUES (50630, 'spell_gen_eject_all_passengers'); -- [Misc] Fixate DELETE FROM spell_script_names WHERE spell_id IN(40414, 40892, 49026); INSERT INTO spell_script_names VALUES (40414, 'spell_gen_fixate'); INSERT INTO spell_script_names VALUES (40892, 'spell_gen_fixate'); INSERT INTO spell_script_names VALUES (49026, 'spell_gen_fixate'); -- [Misc] Periodic Knock Away DELETE FROM spell_script_names WHERE spell_id IN(21737); INSERT INTO spell_script_names VALUES (21737, 'spell_gen_periodic_knock_away'); -- [Misc] Knock Away DELETE FROM spell_script_names WHERE spell_id IN(10101, 18670, 18813, 18945, 19633, 20686, 25778, 31389, 32959); INSERT INTO spell_script_names VALUES (10101, "spell_gen_knock_away"); INSERT INTO spell_script_names VALUES (18670, "spell_gen_knock_away"); INSERT INTO spell_script_names VALUES (18813, "spell_gen_knock_away"); INSERT INTO spell_script_names VALUES (18945, "spell_gen_knock_away"); INSERT INTO spell_script_names VALUES (19633, "spell_gen_knock_away"); INSERT INTO spell_script_names VALUES (20686, "spell_gen_knock_away"); INSERT INTO spell_script_names VALUES (25778, "spell_gen_knock_away"); INSERT INTO spell_script_names VALUES (31389, "spell_gen_knock_away"); INSERT INTO spell_script_names VALUES (32959, "spell_gen_knock_away"); -- [Misc] Hate to Zero (9204), spell_dbc DELETE FROM spell_script_names WHERE spell_id IN(9204); INSERT INTO spell_script_names VALUES (9204, 'spell_gen_hate_to_zero'); -- [Death Knight] Wandering Plague target selector DELETE FROM spell_script_names WHERE spell_id IN(50526); INSERT INTO spell_script_names VALUES (50526, 'spell_dk_wandering_plague'); -- [Death Knight] Army of the Dead UPDATE creature_template SET unit_class=4, AIName='', ScriptName='npc_pet_dk_army_of_the_dead', spell1=47468, spell2=47482 WHERE entry=24207; REPLACE INTO creature_template_addon VALUES (24207, 0, 0, 0, 1, 0, '43264'); -- periodic taunt DELETE FROM spell_script_names WHERE spell_id IN(43263); INSERT INTO spell_script_names VALUES (43263, 'spell_dk_aotd_taunt'); -- [Death Knight] Raise Ally DELETE FROM spell_script_names WHERE spell_id IN(61999); INSERT INTO spell_script_names VALUES (61999, 'spell_dk_raise_ally'); DELETE FROM spell_script_names WHERE spell_id IN(46619); INSERT INTO spell_script_names VALUES (46619, 'spell_dk_raise_ally_trigger'); -- [Death Knight] Master of Ghouls DELETE FROM spell_script_names WHERE spell_id IN(52143); INSERT INTO spell_script_names VALUES (52143, 'spell_dk_master_of_ghouls'); -- [Death Knight] Death Grip DELETE FROM spell_script_names WHERE spell_id IN(49576, 49560); INSERT INTO spell_script_names VALUES (49576, 'spell_dk_death_grip'); INSERT INTO spell_script_names VALUES (49560, 'spell_dk_death_grip'); DELETE FROM spell_linked_spell WHERE spell_trigger=49576; -- [Death Knight] Chains of Ice DELETE FROM spell_script_names WHERE spell_id IN(45524); INSERT INTO spell_script_names VALUES (45524, 'spell_dk_chains_of_ice'); DELETE FROM spell_linked_spell WHERE spell_trigger=45524; -- [Death Knight] Scent of Blood DELETE FROM spell_script_names WHERE spell_id IN(-49004, 49004, 49508, 49509); INSERT INTO spell_script_names VALUES (-49004, 'spell_gen_proc_from_direct_damage'); INSERT INTO spell_script_names VALUES (-49004, 'spell_dk_scent_of_blood_trigger'); -- [Death Knight] Rime DELETE FROM spell_script_names WHERE spell_id IN(-49188, 49188, 56822, 59057); INSERT INTO spell_script_names VALUES (-49188, 'spell_gen_no_offhand_proc'); -- [Death Knight] Killing Machine DELETE FROM spell_script_names WHERE spell_id IN(-51123, 51123, 51127, 51128, 51129, 51130); INSERT INTO spell_script_names VALUES (-51123, 'spell_gen_no_offhand_proc'); -- [Death Knight] Bloodworms DELETE FROM spell_script_names WHERE spell_id IN(50452); INSERT INTO spell_script_names VALUES (50452, 'spell_dk_bloodworms'); -- [Death Knight] Summon Gargoyle DELETE FROM spell_script_names WHERE spell_id IN(49206); INSERT INTO spell_script_names VALUES (49206, 'spell_dk_summon_gargoyle'); -- [Death Knight] Improved Blood Presence DELETE FROM spell_script_names WHERE spell_id IN(63611); INSERT INTO spell_script_names VALUES (63611, 'spell_dk_improved_blood_presence_proc'); -- [Death Knight] Wandering Plague DELETE FROM spell_script_names WHERE spell_id IN(-49217, 49217, 49654, 49655); INSERT INTO spell_script_names VALUES (-49217, 'spell_dk_wandering_plague_aura'); -- [Death Knight] Bone Shield DELETE FROM spell_script_names WHERE spell_id IN(49222); INSERT INTO spell_script_names VALUES (49222, 'spell_dk_bone_shield'); -- [Death Knight] Hungering Cold DELETE FROM spell_script_names WHERE spell_id IN(51209); INSERT INTO spell_script_names VALUES (51209, 'spell_dk_hungering_cold'); -- [Death Knight] Hungering Cold DELETE FROM spell_script_names WHERE spell_id IN(-49219, 49219, 49627, 49628); INSERT INTO spell_script_names VALUES (-49219, 'spell_dk_blood_caked_blade'); -- [Hunter] Call of the Wild, Furious Howl target only master / pet, done in spellmgr.cpp DELETE FROM spell_script_names WHERE ScriptName='spell_hun_target_only_pet_and_owner'; -- [Hunter] Mend Pet DELETE FROM spell_script_names WHERE spell_id IN(-136, 136, 3111, 3661, 3662, 13542, 13543, 13544, 27046, 33976, 48989, 48990); INSERT INTO spell_script_names VALUES (-136, 'spell_hun_check_pet_los'); -- [Hunter] Aspect of the Beast DELETE FROM spell_script_names WHERE spell_id IN(13161, 61669); INSERT INTO spell_script_names VALUES (13161, 'spell_hun_aspect_of_the_beast'); INSERT INTO spell_script_names VALUES (61669, 'spell_hun_aspect_of_the_beast'); -- [Hunter] Pet's Cover DELETE FROM spell_script_names WHERE spell_id IN(1742); INSERT INTO spell_script_names VALUES (1742, 'spell_hun_cower'); -- [Hunter] Wyvern Sting DELETE FROM spell_script_names WHERE spell_id IN(-19386, 19386, 24132, 24133, 27068, 49011, 49012); INSERT INTO spell_script_names VALUES (-19386, 'spell_hun_wyvern_sting'); -- [Hunter] Animal Handler DELETE FROM spell_pet_auras WHERE spell IN(34453, 34454); INSERT INTO spell_pet_auras VALUES (34453, 1, 0, 68361); INSERT INTO spell_pet_auras VALUES (34454, 1, 0, 68361); DELETE FROM spell_script_names WHERE spell_id IN(68361); INSERT INTO spell_script_names VALUES (68361, 'spell_hun_animal_handler'); -- [Rogue] Killing Spree DELETE FROM spell_linked_spell WHERE spell_trigger IN(51690); INSERT INTO spell_linked_spell VALUES (51690, 61851, 2, 'Rogue - Killing Spree'); DELETE FROM spell_script_names WHERE spell_id IN(51690); INSERT INTO spell_script_names VALUES (51690, 'spell_rog_killing_spree'); -- [Rogue] Savage Combat REPLACE INTO spell_proc_event VALUES (51682, 0, 8, 0, 524288, 0, 0, 0, 0, 0, 0); REPLACE INTO spell_proc_event VALUES (58413, 0, 8, 0, 524288, 0, 0, 0, 0, 0, 0); DELETE FROM spell_script_names WHERE spell_id IN(-58683, -58684, 58683, 58684); INSERT INTO spell_script_names VALUES (58683, 'spell_rog_savage_combat'); INSERT INTO spell_script_names VALUES (58684, 'spell_rog_savage_combat'); -- [Rogue] Combat Potency DELETE FROM spell_script_names WHERE spell_id IN(-35541, 35541); INSERT INTO spell_script_names VALUES (-35541, 'spell_rog_combat_potency'); -- [Rogue] Item - Rogue T10 2P Bonus DELETE FROM spell_script_names WHERE spell_id IN(70805); INSERT INTO spell_script_names VALUES (70805, 'spell_gen_proc_on_self'); -- [Rogue] Item - Rogue T10 4P Bonus DELETE FROM spell_script_names WHERE spell_id IN(70803); INSERT INTO spell_script_names VALUES (70803, 'spell_gen_proc_not_self'); -- [Rogue] Cheat Death DELETE FROM spell_scripts WHERE id=31231; -- [Warrior] Mocking Blow DELETE FROM spell_script_names WHERE spell_id IN(21008, 694); INSERT INTO spell_script_names VALUES (694, 'spell_warr_mocking_blow'); -- [Warrior] Enrage talent DELETE FROM spell_script_names WHERE spell_id IN(-12317, 12317, 13045, 13046, 13047, 13048); INSERT INTO spell_script_names VALUES (-12317, 'spell_gen_proc_from_direct_damage'); -- [Warrior] Intervene DELETE FROM spell_script_names WHERE spell_id IN(3411); INSERT INTO spell_script_names VALUES (3411, 'spell_warr_intervene'); -- [Warrior] Intervene DELETE FROM spell_script_names WHERE spell_id IN(-59725, 59725, 23920, -59088, 59088, 59089); INSERT INTO spell_script_names VALUES (59088, 'spell_warr_improved_spell_reflection'); INSERT INTO spell_script_names VALUES (59089, 'spell_warr_improved_spell_reflection'); INSERT INTO spell_script_names VALUES (59725, 'spell_warr_improved_spell_reflection_trigger'); -- [Shaman] Glyph of Totem of Wrath DELETE FROM spell_proc_event WHERE entry=63280; DELETE FROM spell_script_names WHERE spell_id IN(-30706, 30706, 57720, 57721, 57722); INSERT INTO spell_script_names VALUES (-30706, 'spell_sha_totem_of_wrath'); DELETE FROM spell_linked_spell WHERE spell_trigger IN(-57658, -57660, -57662, -57663); -- [Shaman] Earthen Power DELETE FROM spell_script_names WHERE spell_id IN(59566); INSERT INTO spell_script_names VALUES (59566, 'spell_sha_earthen_power'); -- [Shaman] Spirit Walk (Feral Spirits) DELETE FROM spell_script_names WHERE spell_id IN(58875); INSERT INTO spell_script_names VALUES (58875, 'spell_sha_spirit_walk'); DELETE FROM disables WHERE entry IN(58875) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 58875, 64, '', '', 'Disable LOS for Spirit Walk'); -- [Shaman] Item - Shaman T10 Restoration 4P Bonus REPLACE INTO spell_proc_event VALUES (70808, 0, 11, 256, 0, 0, 0, 2, 0, 0, 0); DELETE FROM spell_script_names WHERE spell_id IN(70808); INSERT INTO spell_script_names VALUES (70808, 'spell_sha_t10_restoration_4p_bonus'); -- [Shaman] Water Shield DELETE FROM spell_script_names WHERE spell_id IN(-52127, 52127, 52129, 52131, 52134, 52136, 52138, 24398, 33736, 57960); -- [Shaman] Item - Shaman T6 Totemic Mastery 2P Bonus DELETE FROM spell_script_names WHERE spell_id IN(38443); INSERT INTO spell_script_names VALUES (38443, 'spell_sha_totemic_mastery'); -- [Mage] Arcane Blast DELETE FROM spell_script_names WHERE spell_id IN(-30451, 30451, 42894, 42896, 42897); INSERT INTO spell_script_names VALUES (-30451, 'spell_mage_arcane_blast'); -- [Mage] Burning Determination DELETE FROM spell_script_names WHERE spell_id IN(54747, 54749); INSERT INTO spell_script_names VALUES (54747, 'spell_mage_burning_determination'); INSERT INTO spell_script_names VALUES (54749, 'spell_mage_burning_determination'); -- [Mage] Molten Shields (Molten Armor) DELETE FROM spell_script_names WHERE spell_id IN(-30482, 30482, 43045, 43046); INSERT INTO spell_script_names VALUES (-30482, 'spell_mage_molten_armor'); -- [Mage] Burnout DELETE FROM spell_script_names WHERE spell_id IN(-44450, 44450, -44449, 44449, 44469, 44470, 44471, 44472); INSERT INTO spell_script_names VALUES (-44449, 'spell_mage_burnout'); INSERT INTO spell_script_names VALUES (-44450, 'spell_mage_burnout_trigger'); -- [Warlock] Glyph of Seduction DELETE FROM spell_script_names WHERE spell_id IN(6358); INSERT INTO spell_script_names VALUES (6358, 'spell_warl_seduction'); -- [Warlock] Eye of Kilrogg DELETE FROM spell_script_names WHERE spell_id IN(126); INSERT INTO spell_script_names VALUES (126, 'spell_warl_eye_of_kilrogg'); -- [Warlock] Shadowflame DELETE FROM spell_linked_spell WHERE spell_trigger IN(47897, 61290); DELETE FROM spell_script_names WHERE spell_id IN(-47897); INSERT INTO spell_script_names VALUES (-47897, 'spell_warl_shadowflame'); -- [Warlock] Health Funnel DELETE FROM spell_script_names WHERE spell_id IN(-755); INSERT INTO spell_script_names VALUES (-755, 'spell_hun_check_pet_los'); -- script name correct (spell_hun_*) INSERT INTO spell_script_names VALUES (-755, 'spell_warl_health_funnel'); -- [Warlock] Improved Demonic Tactics DELETE FROM spell_script_names WHERE spell_id IN(-54347, 54347, 54348, 54349); INSERT INTO spell_script_names VALUES (-54347, 'spell_warl_improved_demonic_tactics'); -- [Warlock] Ritual of Summoning DELETE FROM spell_script_names WHERE spell_id IN(698); INSERT INTO spell_script_names VALUES (698, 'spell_warl_ritual_of_summoning'); -- [Warlock] Demonic Aegis DELETE FROM spell_script_names WHERE spell_id IN(-30143, 30143, 30144, 30145); INSERT INTO spell_script_names VALUES (-30143, 'spell_warl_demonic_aegis'); -- [Warlock] Demonic Aegis DELETE FROM spell_script_names WHERE spell_id IN(-35696, 35696); INSERT INTO spell_script_names VALUES (-35696, 'spell_warl_demonic_knowledge'); -- [Paladin] Seal of Command (20375) REPLACE INTO spell_proc_event VALUES (20375, 1+2, 0, 0, 0, 0, 0, 0, 0, 0, 0); DELETE FROM spell_script_names WHERE spell_id IN(20375, 20424); INSERT INTO spell_script_names VALUES (20375, 'spell_pal_seal_of_command'); INSERT INTO spell_script_names VALUES (20424, 'spell_pal_seal_of_command'); -- [Paladin] Divine Intervention (19753), trigger of (19752) DELETE FROM spell_script_names WHERE spell_id IN(19753); INSERT INTO spell_script_names VALUES (19753, 'spell_pal_divine_intervention'); -- [Paladin] Seal of Light REPLACE INTO spell_proc_event VALUES (20165, 0, 0, 0, 0, 0, 0, 1+2+1024, 10, 0, 0); DELETE FROM spell_script_names WHERE spell_id IN(20165); INSERT INTO spell_script_names VALUES (20165, 'spell_pal_seal_of_light'); -- [Paladin] Seal of Wisdom REPLACE INTO spell_proc_event VALUES (20166, 0, 0, 0, 0, 0, 0, 1+2+1024, 12, 0, 0); DELETE FROM spell_script_names WHERE spell_id IN(20166); INSERT INTO spell_script_names VALUES (20166, 'spell_pal_seal_of_light'); -- same script, no mistake -- [Paladin] Sacred Shield DELETE FROM spell_script_names WHERE spell_id IN(58597, 53601); INSERT INTO spell_script_names VALUES (53601, 'spell_pal_sacred_shield_base'); -- [Druid] Item - Druid T10 Balance 4P Bonus, Languish REPLACE INTO spell_proc_event VALUES (70723, 0, 7, 5, 0, 0, 65536, 2, 0, 100, 0); DELETE FROM spell_script_names WHERE spell_id IN(70723); INSERT INTO spell_script_names VALUES (70723, 'spell_dru_t10_balance_4p_bonus'); -- [Druid] Nurturing Instinct DELETE FROM spell_script_names WHERE spell_id IN(-33872, 33872, 33873); INSERT INTO spell_script_names VALUES (-33872, 'spell_dru_nurturing_instinct'); -- [Druid] Feral Swiftness, add to bear form DELETE FROM spell_script_names WHERE spell_id IN(-17002, 17002, 24866); DELETE FROM spell_script_names WHERE ScriptName='spell_dru_feral_swiftness'; INSERT INTO spell_script_names VALUES (-17002, 'spell_dru_feral_swiftness'); INSERT INTO spell_script_names VALUES (5487, 'spell_dru_feral_swiftness'); INSERT INTO spell_script_names VALUES (9634, 'spell_dru_feral_swiftness'); -- [Druid] Omen of Clarity REPLACE INTO spell_proc_event VALUES (16864, 0, 0, 0, 0, 0, 0, 65536, 3.5, 0, 0); DELETE FROM spell_script_names WHERE spell_id IN(16864); INSERT INTO spell_script_names VALUES (16864, 'spell_dru_omen_of_clarity'); -- [Druid] Barkskin DELETE FROM spell_script_names WHERE spell_id IN(-22812, 22812); INSERT INTO spell_script_names VALUES (22812, 'spell_dru_barkskin'); -- [Druid] Owlkin Frenzy DELETE FROM spell_script_names WHERE spell_id IN(-48389, 48389, 48392, 48393); -- ---------------------------------------------------------------------- -- SPELL LINKED SPELL -- ---------------------------------------------------------------------- -- [Item] Nevermelting Ice Crystal DELETE FROM spell_linked_spell WHERE spell_trigger=-71563; REPLACE INTO spell_linked_spell VALUES (-71563, -71564, 0, 'Nevermelting Ice Crystal - Remove working trigger'); -- [Item] Electromagnetic Gigaflux Reactivator DELETE FROM spell_linked_spell WHERE spell_trigger=-11826; REPLACE INTO spell_linked_spell VALUES (-11826, 11828, 0, 'Electromagnetic Gigaflux Reactivator - Cast Forked Lightning'); -- [Warlock] Immolation Aura DELETE FROM spell_linked_spell WHERE spell_trigger=-47241; REPLACE INTO spell_linked_spell VALUES (-47241, -50589, 0, 'Metamorphosis - Remove Immolation Aura'); -- [Warlock] Glyph of Life Tap DELETE FROM spell_linked_spell WHERE spell_trigger=-63320; REPLACE INTO spell_linked_spell VALUES (-63320, -63321, 0, 'Glyph of Life Tap - Remove working trigger'); -- [Hunter] Wyvern Sting DELETE FROM spell_linked_spell WHERE comment='Wyvern Sting'; DELETE FROM spell_linked_spell WHERE spell_effect=60089; -- [Rogue] Tricks of Trade - remove parent aura DELETE FROM spell_linked_spell WHERE spell_trigger=59628; REPLACE INTO spell_linked_spell VALUES (59628, -57934, 0, 'Tricks of Trade - remove at trigger'); -- [Paladin] Repeatance DELETE FROM spell_linked_spell WHERE spell_trigger=20066; INSERT INTO spell_linked_spell VALUES (20066, -61840, 1, 'Repentance'); -- [Paladin] Sacred Shield DELETE FROM spell_linked_spell WHERE spell_trigger=-53601; INSERT INTO spell_linked_spell VALUES (-53601, -58597, 0, 'Sacred Shield remove'); -- [Death Knight] On a Pale Horse DELETE FROM spell_linked_spell WHERE spell_trigger IN(51983, 51986, -51983, -51986); -- [Paladin] Pursuit of Justice DELETE FROM spell_linked_spell WHERE spell_trigger IN(26022, 26023, -26022, -26023); INSERT INTO spell_linked_spell VALUES (26022, 61417, 2, 'Pursuit of Justice add'); INSERT INTO spell_linked_spell VALUES (26023, 61418, 2, 'Pursuit of Justice add'); INSERT INTO spell_linked_spell VALUES (-26022, -61417, 0, 'Pursuit of Justice remove'); INSERT INTO spell_linked_spell VALUES (-26023, -61418, 0, 'Pursuit of Justice remove'); -- Passive Threat for tanks DELETE FROM spell_linked_spell WHERE spell_effect IN(57339, 57340, -57339, -57340); INSERT INTO spell_linked_spell VALUES (7376, 57339, 2, 'Defensive Stance Passive - Tank Class Passive Threat'); INSERT INTO spell_linked_spell VALUES (21178, 57339, 2, 'Bear Form (Passive2) - Tank Class Passive Threat'); INSERT INTO spell_linked_spell VALUES (25780, 57340, 2, 'Righteous Fury - Tank Class Passive Threat'); INSERT INTO spell_linked_spell VALUES (48263, 57340, 2, 'Frost Presence - Tank Class Passive Threat'); INSERT INTO spell_linked_spell VALUES (-7376, -57339, 0, 'Defensive Stance Passive - Tank Class Passive Threat Remove'); INSERT INTO spell_linked_spell VALUES (-21178, -57339, 0, 'Bear Form (Passive2) - Tank Class Passive Threat Remove'); INSERT INTO spell_linked_spell VALUES (-25780, -57340, 0, 'Righteous Fury - Tank Class Passive Threat Remove'); INSERT INTO spell_linked_spell VALUES (-48263, -57340, 0, 'Frost Presence - Tank Class Passive Threat Remove'); -- ---------------------------------------------------------------------- -- LoS Fixes -- ---------------------------------------------------------------------- -- [Warlock] Nightmare, Improved Fear DELETE FROM disables WHERE entry IN(60946, 60947) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 60946, 64, '', '', 'Disable LOS for Nightmare'); INSERT INTO disables VALUES (0, 60947, 64, '', '', 'Disable LOS for Nightmare'); -- [Druid] Revitalize DELETE FROM disables WHERE entry IN(48540, 48541, 48542, 48543) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 48540, 64, '', '', 'Disable LOS for Revitalize'); INSERT INTO disables VALUES (0, 48541, 64, '', '', 'Disable LOS for Revitalize'); INSERT INTO disables VALUES (0, 48542, 64, '', '', 'Disable LOS for Revitalize'); INSERT INTO disables VALUES (0, 48543, 64, '', '', 'Disable LOS for Revitalize'); -- [Hunter] Roar of Recovery -- [Hunter] Bestial Wrath -- [Hunter] Heart of the Phoenix DELETE FROM disables WHERE entry IN(53517, 19574, 54114) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 53517, 64, '', '', 'Disable LOS for Roar of Recovery'); INSERT INTO disables VALUES (0, 19574, 64, '', '', 'Disable LOS for Bestial Wrath'); INSERT INTO disables VALUES (0, 54114, 64, '', '', 'Disable LOS for Heart of the Phoenix'); -- [Death Knight] Frost Fever DELETE FROM disables WHERE entry IN(55095) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 55095, 64, '', '', 'Disable LOS for Frost Fever'); -- [Death Knight] Raise Dead DELETE FROM disables WHERE entry IN(46585, 52150) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 46585, 64, '', '', 'Disable LOS for Raise Dead Guardian'); INSERT INTO disables VALUES (0, 52150, 64, '', '', 'Disable LOS for Raise Dead Pet'); -- [Shaman] Tremor Totem effect DELETE FROM disables WHERE entry IN(8146) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 8146, 64, '', '', 'Disable LOS for Tremor Totem effect'); -- [Priest] Shadow Fiend - Mana Leech proc DELETE FROM disables WHERE entry IN(34650) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 34650, 64, '', '', 'Disable LOS for Shadow Fiend - Mana Leech proc'); -- [Priest] Improved Devouring Plague DELETE FROM disables WHERE entry IN(63675) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 63675, 64, '', '', 'Disable LOS for Improved Devouring Plague'); -- [General] Ritual of Summoning DELETE FROM disables WHERE entry IN(7720) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 7720, 64, '', '', 'Disable LOS for Ritual of Summoning'); -- [General] Temporary LoS fix EoE (for phase 3, some spells have this attribute added below) DELETE FROM disables WHERE entry IN(56091, 56092, 57090, 57108, 57092) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 56091, 64, '', '', 'Disable LOS for EoE'); INSERT INTO disables VALUES (0, 56092, 64, '', '', 'Disable LOS for EoE'); INSERT INTO disables VALUES (0, 57090, 64, '', '', 'Disable LOS for EoE'); INSERT INTO disables VALUES (0, 57108, 64, '', '', 'Disable LOS for EoE'); INSERT INTO disables VALUES (0, 57092, 64, '', '', 'Disable LOS for EoE'); -- [General] Thorim, Charged Obr damage DELETE FROM disables WHERE entry IN(62017) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 62017, 64, '', '', 'Disable LOS for Thorim'); DELETE FROM disables WHERE entry IN(64098) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 64098, 64, '', '', 'Disable LOS for Thorim'); -- [General] Quest Little Morsels (9440) DELETE FROM disables WHERE entry IN(29916, 29917) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 29916, 64, '', '', 'Disable LOS for Quest Little Morsels (9440)'); INSERT INTO disables VALUES (0, 29917, 64, '', '', 'Disable LOS for Quest Little Morsels (9440)'); -- [General] Dark Energy, Sunken Temple (18948) -- [General] Flame of Hakkar, Sunken Temple (12354) -- [General] Atal'ai Poison, Sunken Temple (18949) DELETE FROM disables WHERE entry IN(18948, 12354, 18949) AND sourceType=0 AND flags=64; INSERT INTO disables VALUES (0, 18948, 64, '', '', 'Disable LOS for Dark Energy, Sunken Temple'); INSERT INTO disables VALUES (0, 12354, 64, '', '', 'Disable LOS for Flame of Hakkar, Sunken Temple'); INSERT INTO disables VALUES (0, 18949, 64, '', '', 'Disable LOS for Atal''ai Poison, Sunken Temple'); -- ---------------------------------------------------------------------- -- THREAT & RANK FIXES -- ---------------------------------------------------------------------- -- Totem of Wrath spell bonus, fix ranks REPLACE INTO spell_ranks VALUES (57658, 57658, 1),(57658, 57660, 2),(57658, 57662, 3),(57658, 57663, 4); -- Ferocious Inspiration trigger, fix ranks REPLACE INTO spell_ranks VALUES (75593, 75593, 1),(75593, 75446, 2),(75593, 75447, 3); -- Crypt Fever - fix ranks REPLACE INTO spell_ranks VALUES (50508, 50508, 1),(50508, 50509, 2),(50508, 50510, 3); -- Ebon Plague - fix ranks REPLACE INTO spell_ranks VALUES (51726, 51726, 1),(51726, 51734, 2),(51726, 51735, 3); -- Earth and Moon - fix ranks REPLACE INTO spell_ranks VALUES (60431, 60431, 1),(60431, 60432, 2),(60431, 60433, 3); -- Wrecking Crew - Enrage REPLACE INTO spell_ranks VALUES (57518, 57518, 1),(57518, 57519, 2),(57518, 57520, 3), (57518, 57521, 4),(57518, 57522, 5); -- Enrage - Enrage REPLACE INTO spell_ranks VALUES (12880, 12880, 1),(12880, 14201, 2),(12880, 14202, 3), (12880, 14203, 4),(12880, 14204, 5); -- [Shaman] Magma totem generates no threat REPLACE INTO spell_threat VALUES (8187, 0, 0, 0); -- [Death Knight] Icy touch threat generated DELETE FROM spell_threat WHERE entry=45477; -- [Death Knight] Death and Decay DELETE FROM spell_threat WHERE entry IN(52212, 43265, 49936, 49937, 49938); INSERT INTO spell_threat VALUES (52212, 0, 1.9, 0); -- ---------------------------------------------------------------------- -- MIXOLOGY -- ---------------------------------------------------------------------- DROP TABLE IF EXISTS `spell_mixology`; CREATE TABLE `spell_mixology` ( `entry` mediumint(8) unsigned NOT NULL, `pctMod` float NOT NULL DEFAULT '30' COMMENT 'bonus multiplier', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; INSERT INTO `spell_mixology` VALUES ('53752', '80'); INSERT INTO `spell_mixology` VALUES ('54212', '44.4'); INSERT INTO `spell_mixology` VALUES ('53760', '44.4'); INSERT INTO `spell_mixology` VALUES ('53758', '50'); INSERT INTO `spell_mixology` VALUES ('53755', '37.6'); INSERT INTO `spell_mixology` VALUES ('62380', '80'); INSERT INTO `spell_mixology` VALUES ('53764', '33.3'); INSERT INTO `spell_mixology` VALUES ('53751', '57'); INSERT INTO `spell_mixology` VALUES ('53748', '40'); INSERT INTO `spell_mixology` VALUES ('33721', '40'); INSERT INTO `spell_mixology` VALUES ('53749', '40'); INSERT INTO `spell_mixology` VALUES ('53763', '35'); INSERT INTO `spell_mixology` VALUES ('53746', '44.4'); INSERT INTO `spell_mixology` VALUES ('60340', '44.4'); INSERT INTO `spell_mixology` VALUES ('60347', '44.4'); INSERT INTO `spell_mixology` VALUES ('60345', '44.4'); INSERT INTO `spell_mixology` VALUES ('60344', '44.4'); INSERT INTO `spell_mixology` VALUES ('60341', '44.4'); INSERT INTO `spell_mixology` VALUES ('60343', '44.4'); INSERT INTO `spell_mixology` VALUES ('60346', '44.4'); INSERT INTO `spell_mixology` VALUES ('28497', '44.4'); -- ---------------------------------------------------------------------- -- MISC -- ---------------------------------------------------------------------- -- Pet Scaling -- [Shared] Hit / Expertise scalling DELETE FROM spell_linked_spell WHERE spell_trigger IN(61013, 61017, -61013, -61017) OR spell_effect IN(61013, 61017, -61013, -61017); DELETE FROM spell_scripts WHERE id IN(61013, 61017, -61013, -61017); DELETE FROM spell_script_names WHERE spell_id IN(61013, 61017, -61013, -61017); INSERT INTO spell_script_names VALUES (61013, 'spell_pet_hit_expertise_scalling'); INSERT INTO spell_script_names VALUES (61017, 'spell_pet_hit_expertise_scalling'); -- [Hunter] Generic DELETE FROM spell_linked_spell WHERE spell_trigger IN(34902, 34903, 34904, -34902, -34903, -34904) OR spell_effect IN(34902, 34903, 34904, -34902, -34903, -34904); DELETE FROM spell_scripts WHERE id IN(34902, 34903, 34904, -34902, -34903, -34904); DELETE FROM spell_script_names WHERE spell_id IN(34902, 34903, 34904, -34902, -34903, -34904); INSERT INTO spell_script_names VALUES (34902, 'spell_hun_generic_scaling'); INSERT INTO spell_script_names VALUES (34903, 'spell_hun_generic_scaling'); INSERT INTO spell_script_names VALUES (34904, 'spell_hun_generic_scaling'); -- [Warlock] Generic DELETE FROM spell_linked_spell WHERE spell_trigger IN(34947, 34956, 34957, 34958, -34947, -34956, -34957, -34958) OR spell_effect IN(34947, 34956, 34957, 34958, -34947, -34956, -34957, -34958); DELETE FROM spell_scripts WHERE id IN(34947, 34956, 34957, 34958, -34947, -34956, -34957, -34958); DELETE FROM spell_script_names WHERE spell_id IN(34947, 34956, 34957, 34958, -34947, -34956, -34957, -34958); INSERT INTO spell_script_names VALUES (34947, 'spell_warl_generic_scaling'); INSERT INTO spell_script_names VALUES (34956, 'spell_warl_generic_scaling'); INSERT INTO spell_script_names VALUES (34957, 'spell_warl_generic_scaling'); INSERT INTO spell_script_names VALUES (34958, 'spell_warl_generic_scaling'); -- [Warlock] Infernal DELETE FROM spell_linked_spell WHERE spell_trigger IN(36186, 36188, 36189, 36190, -36186, -36188, -36189, -36190) OR spell_effect IN(36186, 36188, 36189, 36190, -36186, -36188, -36189, -36190); DELETE FROM spell_scripts WHERE id IN(36186, 36188, 36189, 36190, -36186, -36188, -36189, -36190); DELETE FROM spell_script_names WHERE spell_id IN(36186, 36188, 36189, 36190, -36186, -36188, -36189, -36190); INSERT INTO spell_script_names VALUES (36186, 'spell_warl_infernal_scaling'); INSERT INTO spell_script_names VALUES (36188, 'spell_warl_infernal_scaling'); INSERT INTO spell_script_names VALUES (36189, 'spell_warl_infernal_scaling'); INSERT INTO spell_script_names VALUES (36190, 'spell_warl_infernal_scaling'); -- [Shaman] Feral Spirit DELETE FROM spell_linked_spell WHERE spell_trigger IN(35674, 35675, 35676, 61783, -35674, -35675, -35676, -61783) OR spell_effect IN(35674, 35675, 35676, 61783, -35674, -35675, -35676, -61783); DELETE FROM spell_scripts WHERE id IN(35674, 35675, 35676, 61783, -35674, -35675, -35676, -61783); DELETE FROM spell_script_names WHERE spell_id IN(35674, 35675, 35676, 61783, -35674, -35675, -35676, -61783); INSERT INTO spell_script_names VALUES (35674, 'spell_sha_feral_spirit_scaling'); INSERT INTO spell_script_names VALUES (35675, 'spell_sha_feral_spirit_scaling'); INSERT INTO spell_script_names VALUES (35676, 'spell_sha_feral_spirit_scaling'); INSERT INTO spell_script_names VALUES (61783, 'spell_sha_feral_spirit_scaling'); -- [Shaman] Fire Elemental Totem DELETE FROM spell_linked_spell WHERE spell_trigger IN(35665, 35666, 35667, 35668, -35665, -35666, -35667, -35668) OR spell_effect IN(35665, 35666, 35667, 35668, -35665, -35666, -35667, -35668); DELETE FROM spell_scripts WHERE id IN(35665, 35666, 35667, 35668, -35665, -35666, -35667, -35668); DELETE FROM spell_script_names WHERE spell_id IN(35665, 35666, 35667, 35668, -35665, -35666, -35667, -35668); INSERT INTO spell_script_names VALUES (35665, 'spell_sha_fire_elemental_scaling'); INSERT INTO spell_script_names VALUES (35666, 'spell_sha_fire_elemental_scaling'); INSERT INTO spell_script_names VALUES (35667, 'spell_sha_fire_elemental_scaling'); INSERT INTO spell_script_names VALUES (35668, 'spell_sha_fire_elemental_scaling'); -- [Shaman] Earth Elemental Totem DELETE FROM spell_linked_spell WHERE spell_trigger IN(65225, 65226, 65227, 65228, -65225, -65226, -65227, -65228) OR spell_effect IN(65225, 65226, 65227, 65228, -65225, -65226, -65227, -65228); DELETE FROM spell_scripts WHERE id IN(65225, 65226, 65227, 65228, -65225, -65226, -65227, -65228); DELETE FROM spell_script_names WHERE spell_id IN(65225, 65226, 65227, 65228, -65225, -65226, -65227, -65228); INSERT INTO spell_script_names VALUES (65225, 'spell_sha_fire_elemental_scaling'); -- can be the same INSERT INTO spell_script_names VALUES (65226, 'spell_sha_fire_elemental_scaling'); -- can be the same INSERT INTO spell_script_names VALUES (65227, 'spell_sha_fire_elemental_scaling'); -- can be the same INSERT INTO spell_script_names VALUES (65228, 'spell_sha_fire_elemental_scaling'); -- can be the same -- [Priest] Shadowfiend DELETE FROM spell_linked_spell WHERE spell_trigger IN(35661, 35662, 35663, 35664, -35661, -35662, -35663, -35664) OR spell_effect IN(35661, 35662, 35663, 35664, -35661, -35662, -35663, -35664); DELETE FROM spell_scripts WHERE id IN(35661, 35662, 35663, 35664, -35661, -35662, -35663, -35664); DELETE FROM spell_script_names WHERE spell_id IN(35661, 35662, 35663, 35664, -35661, -35662, -35663, -35664); INSERT INTO spell_script_names VALUES (35661, 'spell_pri_shadowfiend_scaling'); INSERT INTO spell_script_names VALUES (35662, 'spell_pri_shadowfiend_scaling'); INSERT INTO spell_script_names VALUES (35663, 'spell_pri_shadowfiend_scaling'); INSERT INTO spell_script_names VALUES (35664, 'spell_pri_shadowfiend_scaling'); -- [Druid] Force of Nature (Treants) DELETE FROM spell_linked_spell WHERE spell_trigger IN(35669, 35670, 35671, 35672, -35669, -35670, -35671, -35672) OR spell_effect IN(35669, 35670, 35671, 35672, -35669, -35670, -35671, -35672); DELETE FROM spell_scripts WHERE id IN(35669, 35670, 35671, 35672, -35669, -35670, -35671, -35672); DELETE FROM spell_script_names WHERE spell_id IN(35669, 35670, 35671, 35672, -35669, -35670, -35671, -35672); INSERT INTO spell_script_names VALUES (35669, 'spell_dru_treant_scaling'); INSERT INTO spell_script_names VALUES (35670, 'spell_dru_treant_scaling'); INSERT INTO spell_script_names VALUES (35671, 'spell_dru_treant_scaling'); INSERT INTO spell_script_names VALUES (35672, 'spell_dru_treant_scaling'); -- [Mage] Mirror Image / Water Elemental DELETE FROM spell_linked_spell WHERE spell_trigger IN(35657, 35658, 35659, 35660, -35657, -35658, -35659, -35660) OR spell_effect IN(35657, 35658, 35659, 35660, -35657, -35658, -35659, -35660); DELETE FROM spell_scripts WHERE id IN(35657, 35658, 35659, 35660, -35657, -35658, -35659, -35660); DELETE FROM spell_script_names WHERE spell_id IN(35657, 35658, 35659, 35660, -35657, -35658, -35659, -35660); INSERT INTO spell_script_names VALUES (35657, 'spell_mage_pet_scaling'); INSERT INTO spell_script_names VALUES (35658, 'spell_mage_pet_scaling'); INSERT INTO spell_script_names VALUES (35659, 'spell_mage_pet_scaling'); INSERT INTO spell_script_names VALUES (35660, 'spell_mage_pet_scaling'); -- [Death Knight] Ghoul / Ebon Gargoyle / Army of the Dead DELETE FROM spell_linked_spell WHERE spell_trigger IN(51996, 54566, 61697, -51996, -54566, -61697) OR spell_effect IN(51996, 54566, 61697, -51996, -54566, -61697); DELETE FROM spell_scripts WHERE id IN(51996, 54566, 61697, -51996, -54566, -61697); DELETE FROM spell_script_names WHERE spell_id IN(51996, 54566, 61697, -51996, -54566, -61697); INSERT INTO spell_script_names VALUES (51996, 'spell_dk_pet_scaling'); INSERT INTO spell_script_names VALUES (54566, 'spell_dk_pet_scaling'); INSERT INTO spell_script_names VALUES (61697, 'spell_dk_pet_scaling'); -- [Druid] Force of Nature REPLACE INTO creature_template_addon VALUES (1964, 0, 0, 0, 4097, 0, '50419'); DELETE FROM spell_script_names WHERE spell_id IN(50419); INSERT INTO spell_script_names VALUES (50419, 'spell_dru_brambles_treant'); -- [Priest] Shadowfiend UPDATE creature_template SET resistance1=0, resistance2=0, resistance3=0, resistance4=0, resistance5=0, resistance6=0 WHERE entry=19668; -- [Hunter] Snake Trap UPDATE creature_template SET mindmg = 38, maxdmg = 53 WHERE entry = 19921; UPDATE creature_template SET mindmg = 16, maxdmg = 24 WHERE entry = 19833; -- [Death Knight] Remove Ghouls at despawn (cooldown disabled while active...) REPLACE INTO creature_template_addon VALUES (26125, 0, 0, 0, 0, 0, ''); REPLACE INTO creature_template_addon VALUES (30230, 0, 0, 0, 0, 0, ''); UPDATE creature_template SET mindmg=87, maxdmg=87, unit_class=4, spell1=47468, spell2=47484, spell3=47481, spell4=47482, ScriptName='npc_pet_dk_ghoul' WHERE entry=26125; UPDATE creature_template SET mindmg=87, maxdmg=87, unit_class=4, spell1=47468, spell2=47484, spell3=47481, spell4=47482, spell5=51874, ScriptName='' WHERE entry=30230; -- [Death Knight] Dancing Rune Weapon REPLACE INTO spell_proc_event VALUES (49028, 0, 0, 0, 0, 0, 0, 65536, 0, 0, 0); REPLACE INTO creature_template_addon VALUES (27893, 0, 0, 0, 0, 0, '53160'); UPDATE creature_template SET unit_flags=33554434, flags_extra=128, AIName='', ScriptName='npc_pet_dk_dancing_rune_weapon' WHERE entry=27893; DELETE FROM spell_script_names WHERE spell_id IN(49028, 53160); INSERT INTO spell_script_names VALUES (49028, 'spell_dk_dancing_rune_weapon'); INSERT INTO spell_script_names VALUES (53160, 'spell_dk_dancing_rune_weapon_visual'); -- [Death Knight] Bloodworms REPLACE INTO creature_template_addon VALUES (28017, 0, 0, 0, 4097, 0, '50453 65221'); -- [Death Knight] Ebon Gargoyle REPLACE INTO creature_template_addon VALUES (27829, 0, 0, 0, 0, 0, '65221 62137'); -- [Death Knight] Rune Strike proc REPLACE INTO spell_proc_event VALUES (56817, 0, 15, 0, 536870912, 0, 0, 0, 0, 0, 0); UPDATE spell_dbc SET EffectSpellClassMaskA2=536870912 WHERE Id=56817; -- [Death Knight] Death and Decay DELETE FROM spell_script_names WHERE spell_id IN(-43265, 52212); INSERT INTO spell_script_names VALUES (-43265, 'spell_dk_death_and_decay'); INSERT INTO spell_script_names VALUES (52212, 'spell_dk_death_and_decay'); -- [Death Knight] DELETE FROM playercreateinfo_spell WHERE spell=3275; -- [Warlock] Eye of Kilrogg UPDATE creature_template SET unit_flags=unit_flags|131072, mindmg=0, maxdmg=0, attackpower=0, Health_mod=0.1 WHERE entry=4277; -- [Warlock] Infernal REPLACE INTO creature_template_addon VALUES (89, 0, 0, 0, 4097, 0, '7942 4525 19483'); UPDATE creature_template SET exp=2, speed_walk=1, speed_run=1.14286 WHERE entry=89; -- [Rogue] Master Poisoner - crit chance REPLACE INTO spell_proc_event VALUES (58410, 0, 0, 0, 0, 0, 0, 1+2+65536, 0, 0, 0); -- [Mage] Summon Water Elemental (perm) UPDATE creature_template SET faction=35, exp=0, unit_class=8, unit_flags=0, spell1=31707, spell2=33395, MovementType=1 WHERE entry=510; UPDATE creature_template SET faction=35, exp=0, unit_class=8, unit_flags=0, spell1=72898, spell2=0, MovementType=1 WHERE entry=37994; -- [Mage] Mirror Image UPDATE creature_template SET Health_mod=0.4, unit_class=8 WHERE entry=31216; DELETE FROM spell_script_names WHERE spell_id IN(55342); INSERT INTO spell_script_names VALUES (55342, 'spell_mage_mirror_image'); DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry=58836; INSERT INTO conditions VALUES (13, 1, 58836, 0, 0, 31, 0, 3, 31216, 0, 0, 0, 0, '', 'Target Mirror Images'); INSERT INTO conditions VALUES (13, 1, 58836, 0, 0, 33, 0, 1, 3, 0, 0, 0, 0, '', 'Owned by caster'); -- [Optimization] Wintergarde Invisibility DELETE FROM spell_linked_spell WHERE spell_effect IN(48357, -48357); DELETE FROM spell_area WHERE spell=48358; -- [Generic] Argent Pony Bridle UPDATE creature_template SET npcflag=1+128, ScriptName='npc_pet_gen_argent_pony_bridle' WHERE entry IN(33238, 33239); -- [Generic] Freeze Fix DELETE FROM spell_linked_spell WHERE spell_trigger IN(53355, 53371); INSERT INTO spell_linked_spell VALUES (53355, -53371, 1, 'Freeze fix'); INSERT INTO spell_linked_spell VALUES (53371, -53355, 1, 'Freeze fix'); -- [Generic] Nitro Boosts DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry=55004; INSERT INTO conditions VALUES (17, 0, 55004, 0, 0, 7, 0, 202, 405, 0, 0, 0, 0, '', 'Nitro Boosts requires 405 Engineering skill'); -- [Generic] Magnificent Flying Carpet DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry=61309; INSERT INTO conditions VALUES (17, 0, 61309, 0, 0, 7, 0, 197, 425, 0, 0, 0, 0, '', 'Magnificent Flying Carpet requires 425 Tailoring skill'); -- [Generic] Hand-Mounted Pyro Rocket DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry=54757; INSERT INTO conditions VALUES (17, 0, 54757, 0, 0, 7, 0, 202, 400, 0, 0, 0, 0, '', 'Pyro Rocket requires 400 Engineering skill'); -- [Generic] Frag Belt DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry=67890; INSERT INTO conditions VALUES (17, 0, 67890, 0, 0, 7, 0, 202, 380, 0, 0, 0, 0, '', 'Frag Belt (Cobalt Frag Bomb) requires 380 Engineering skill'); -- [Generic] Flexweave Underlay DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry=55001; INSERT INTO conditions VALUES (17, 0, 55001, 0, 0, 7, 0, 202, 350, 0, 0, 0, 0, '', 'Flexweave Underlay (Parachute) requires 350 Engineering skill'); -- [Generic] Summoning UPDATE gameobject_template SET data2=32783, data3=0 WHERE entry IN(36727, 179944); -- pussywizard: encounter credit spells -- pussywizard: remove spellscript spell_gen_dungeon_credit (done in spell::finish) DELETE FROM spell_script_names WHERE ScriptName='spell_gen_dungeon_credit'; -- ensure all entries in spell_dbc / conditions have proper data UPDATE spell_dbc SET Attributes=Attributes|(0x00800180), AttributesEx2=AttributesEx2|(0x5), AttributesEx3=AttributesEx3|(0x40100), AttributesEx6=AttributesEx6|(0x1000000), Targets=0, CastingTimeIndex=1, Effect1=3, Effect2=0, Effect3=0, EffectImplicitTargetA1=22, EffectImplicitTargetB1=7, EffectRadiusIndex1=28, MaxAffectedTargets=0 WHERE Id IN(58630, 59046, 59450, 61863, 64899, 64985, 65074, 65184, 65195, 68184, 68572, 68574, 68575, 68663, 72706, 72830, 72959); UPDATE spell_dbc SET `comment`='Mal\'ganis - credit marker' WHERE Id=58630; UPDATE spell_dbc SET `comment`='Tribunal of Ages - credit marker' WHERE Id=59046; UPDATE spell_dbc SET `comment`='The Four Horsemen - credit marker' WHERE Id=59450; UPDATE spell_dbc SET `comment`='The Prophet Tharon\'ja - credit marker' WHERE Id=61863; UPDATE spell_dbc SET `comment`='Hodir - credit marker' WHERE Id=64899; UPDATE spell_dbc SET `comment`='Thorim - credit marker' WHERE Id=64985; UPDATE spell_dbc SET `comment`='Freya - credit marker' WHERE Id=65074; UPDATE spell_dbc SET `comment`='Algalon the Observer - credit marker' WHERE Id=65184; UPDATE spell_dbc SET `comment`='The Iron Council - credit marker' WHERE Id=65195; UPDATE spell_dbc SET `comment`='Faction Champions - credit marker' WHERE Id=68184; UPDATE spell_dbc SET `comment`='Grand Champions - credit marker' WHERE Id=68572; UPDATE spell_dbc SET `comment`='Argent Champion - credit marker' WHERE Id=68574; UPDATE spell_dbc SET `comment`='Argent Champion - credit marker' WHERE Id=68575; UPDATE spell_dbc SET `comment`='The Black Knight - credit marker' WHERE Id=68663; UPDATE spell_dbc SET `comment`='Valithria Dreamwalker - credit marker' WHERE Id=72706; UPDATE spell_dbc SET `comment`='Escaped from Arthas - credit marker' WHERE Id=72830; UPDATE spell_dbc SET `comment`='Icecrown Gunship Battle - credit marker' WHERE Id=72959; DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry IN(58630, 59046, 59450, 61863, 64899, 64985, 65074, 65184, 65195, 68184, 68572, 68574, 68575, 68663, 72706, 72830, 72959); INSERT INTO conditions VALUES (13, 1, 58630, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Mal\'ganis - credit marker'), (13, 1, 59046, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Tribunal of Ages - credit marker'), (13, 1, 59450, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'The Four Horsemen - credit marker'), (13, 1, 61863, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'The Prophet Tharon\'ja - credit marker'), (13, 1, 64899, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Hodir - credit marker'), (13, 1, 64985, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Thorim - credit marker'), (13, 1, 65074, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Freya - credit marker'), (13, 1, 65184, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Algalon the Observer - credit marker'), (13, 1, 65195, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'The Iron Council - credit marker'), (13, 1, 68184, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Faction Champions - credit marker'), (13, 1, 68572, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Grand Champions - credit marker'), (13, 1, 68574, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Argent Champion - credit marker'), (13, 1, 68575, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Argent Champion - credit marker'), (13, 1, 68663, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'The Black Knight - credit marker'), (13, 1, 72706, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Valithria Dreamwalker - credit marker'), (13, 1, 72830, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Escaped from Arthas - credit marker'), (13, 1, 72959, 0, 0, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Icecrown Gunship Battle - credit marker'); -- [Item] Bryntroll (50415) (50709) UPDATE item_template SET spellppmRate_1=2, spellcooldown_1=500 WHERE entry IN(50415, 50709); -- 500ms cooldown just in case -- [Item] Nibelung (49992) (50648) DELETE FROM smart_scripts WHERE entryorguid IN(38391, 38392) AND source_type=0; UPDATE creature_template SET spell1=71841, AIName='', InhabitType=5, ScriptName='npc_pet_gen_valkyr_guardian' WHERE entry=38391; UPDATE creature_template SET spell1=71842, AIName='', InhabitType=5, ScriptName='npc_pet_gen_valkyr_guardian' WHERE entry=38392; DELETE FROM spell_script_names WHERE spell_id IN(71841, 71842); INSERT INTO spell_script_names VALUES (71841, 'spell_pet_gen_valkyr_guardian_smite'); INSERT INTO spell_script_names VALUES (71842, 'spell_pet_gen_valkyr_guardian_smite'); -- [Item] The Flag of Ownership DELETE FROM spell_linked_spell WHERE spell_trigger IN(51640,-51640,51702,-51702,52605,-52605,51657,-51657) OR spell_effect IN(51640,-51640,51702,-51702,52605,-52605,51657,-51657); DELETE FROM spell_script_names WHERE spell_id IN(51640,-51640,51702,-51702,52605,-52605,51657,-51657); DELETE FROM spell_scripts WHERE id IN(51640,-51640,51702,-51702,52605,-52605,51657,-51657); INSERT INTO spell_script_names VALUES (51640, 'spell_the_flag_of_ownership'); -- [Item] Mooncloth Tailoring DELETE FROM skill_extra_item_template WHERE requiredSpecialization=26798; INSERT INTO skill_extra_item_template VALUES (18560, 26798, 100, 1),(26751, 26798, 100, 1),(56001, 26798, 100, 1); -- [Item] Teleport Underground (wormhole) DELETE FROM spell_target_position WHERE id=68081; INSERT INTO spell_target_position VALUES (68081, 0, 571, 5860.42, 517.54, 599.82, 3.45); -- [Item] Solace of the Fallen (47271) (47432) -- [Item] Solace of the Defeated (47041) (47059) DELETE FROM spell_script_names WHERE spell_id IN(67698, 67752); INSERT INTO spell_script_names VALUES (67698, 'spell_gen_allow_proc_from_spells_with_cost'); INSERT INTO spell_script_names VALUES (67752, 'spell_gen_allow_proc_from_spells_with_cost'); REPLACE INTO spell_proc_event VALUES (67698, 0, 0, 0, 0, 0, 87040, 3, 0, 0, 0); -- hit + crit, anything different than 0 REPLACE INTO spell_proc_event VALUES (67752, 0, 0, 0, 0, 0, 87040, 3, 0, 0, 0); -- hit + crit, anything different than 0 -- [Enchant] Rune of the Fallen Crusader (53344) UPDATE spell_enchant_proc_data SET PPMChance=2 WHERE entry=3368; DELETE FROM spell_script_names WHERE spell_id IN(-53365, 53365); INSERT INTO spell_script_names VALUES (53365, 'spell_dk_rune_of_the_fallen_crusader'); -- [Night elf] Elusiveness DELETE FROM playercreateinfo_spell WHERE spell=21009; INSERT INTO playercreateinfo_spell VALUES (8, 1085, 21009, 'Elusiveness');