From d8cc656ff404217819d618e601cc502b0af08c56 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 20 May 2016 19:28:26 +0200 Subject: Fix sql name --- .../world/3.3.5/2016_05_19_00_world_PROCS.sql | 37 ---------------------- sql/updates/world/3.3.5/2016_05_20_00_world.sql | 37 ++++++++++++++++++++++ 2 files changed, 37 insertions(+), 37 deletions(-) delete mode 100644 sql/updates/world/3.3.5/2016_05_19_00_world_PROCS.sql create mode 100644 sql/updates/world/3.3.5/2016_05_20_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_05_19_00_world_PROCS.sql b/sql/updates/world/3.3.5/2016_05_19_00_world_PROCS.sql deleted file mode 100644 index 67fc3e7a5d7..00000000000 --- a/sql/updates/world/3.3.5/2016_05_19_00_world_PROCS.sql +++ /dev/null @@ -1,37 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `ScriptName` IN -('spell_mage_blazing_speed','spell_pri_blessed_recovery','spell_dru_forms_trinket','spell_dru_t9_feral_relic', -'spell_sha_nature_guardian','spell_warl_nether_protection','spell_hun_piercing_shots','spell_hun_t9_4p_bonus', -'spell_sha_lightning_shield','spell_dk_acclimation','spell_dk_advantage_t10_4p','spell_dk_improved_blood_presence_triggered', -'spell_rog_t10_2p_bonus','spell_pal_illumination','spell_item_soul_preserver','spell_item_death_choice', -'spell_item_lightning_capacitor','spell_item_thunder_capacitor','spell_item_toc25_normal_caster_trinket','spell_item_toc25_heroic_caster_trinket', -'spell_igb_battle_experience_check','spell_gen_blood_reserve','spell_item_darkmoon_card_greatness', -'spell_item_charm_witch_doctor','spell_item_mana_drain'); - -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(-49200, 'spell_dk_acclimation'), -- DK Acclimation -(70656, 'spell_dk_advantage_t10_4p'), -- DK Advantage t10 4p melee -(63611, 'spell_dk_improved_blood_presence_triggered'), -- DK Improved blood Presence Triggered -(37336, 'spell_dru_forms_trinket'), -- Druid Forms Trinket -(67353, 'spell_dru_t9_feral_relic'), -- Druid T9 Feral Relic (Idol of Mutilation) -(64568, 'spell_gen_blood_reserve'), -- Blood Reserve (weapon enchant proc) -(-53234, 'spell_hun_piercing_shots'), -- Hunter Piercing Shots -(-67151, 'spell_hun_t9_4p_bonus'), -- Hunter T9 Bonus -(71201, 'spell_igb_battle_experience_check'), -- Battle Experience (Gunship - ICC) -(60510, 'spell_item_soul_preserver'), -- Soul Preserver -(67702, 'spell_item_death_choice'), -- Death Choice Trinket -(67771, 'spell_item_death_choice'), -- Death Choice Trinket -(37657, 'spell_item_lightning_capacitor'), -- Lightning Capcitor -(54841, 'spell_item_thunder_capacitor'), -- Thunder Capacitor -(67712, 'spell_item_toc25_normal_caster_trinket'), -- Item - Coliseum 25 Normal Caster Trinket -(67758, 'spell_item_toc25_heroic_caster_trinket'), -- Item - Coliseum 25 Heroic Caster Trinket -(57345, 'spell_item_darkmoon_card_greatness'), -- Darkmoon Card: Greatness -(43820, 'spell_item_charm_witch_doctor'), -- Charm of the Witch Doctor -(27522, 'spell_item_mana_drain'), -- Mana Drain -(40336, 'spell_item_mana_drain'), -- Mana Drain -(-31641, 'spell_mage_blazing_speed'), -- Mage Blazing Speed -(-20210, 'spell_pal_illumination'), -- Paladin Illumination (for Holy Shock) -(-27811, 'spell_pri_blessed_recovery'), -- Priest Blessed Recovery -(70805, 'spell_rog_t10_2p_bonus'), -- Rogue T10 2P bonus -(-30881, 'spell_sha_nature_guardian'), -- Shaman Nature's Guardian -(-324, 'spell_sha_lightning_shield'), -- Shaman Lightning Shield -(-30299, 'spell_warl_nether_protection'); -- Warlock Nether protection diff --git a/sql/updates/world/3.3.5/2016_05_20_00_world.sql b/sql/updates/world/3.3.5/2016_05_20_00_world.sql new file mode 100644 index 00000000000..67fc3e7a5d7 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_05_20_00_world.sql @@ -0,0 +1,37 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN +('spell_mage_blazing_speed','spell_pri_blessed_recovery','spell_dru_forms_trinket','spell_dru_t9_feral_relic', +'spell_sha_nature_guardian','spell_warl_nether_protection','spell_hun_piercing_shots','spell_hun_t9_4p_bonus', +'spell_sha_lightning_shield','spell_dk_acclimation','spell_dk_advantage_t10_4p','spell_dk_improved_blood_presence_triggered', +'spell_rog_t10_2p_bonus','spell_pal_illumination','spell_item_soul_preserver','spell_item_death_choice', +'spell_item_lightning_capacitor','spell_item_thunder_capacitor','spell_item_toc25_normal_caster_trinket','spell_item_toc25_heroic_caster_trinket', +'spell_igb_battle_experience_check','spell_gen_blood_reserve','spell_item_darkmoon_card_greatness', +'spell_item_charm_witch_doctor','spell_item_mana_drain'); + +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(-49200, 'spell_dk_acclimation'), -- DK Acclimation +(70656, 'spell_dk_advantage_t10_4p'), -- DK Advantage t10 4p melee +(63611, 'spell_dk_improved_blood_presence_triggered'), -- DK Improved blood Presence Triggered +(37336, 'spell_dru_forms_trinket'), -- Druid Forms Trinket +(67353, 'spell_dru_t9_feral_relic'), -- Druid T9 Feral Relic (Idol of Mutilation) +(64568, 'spell_gen_blood_reserve'), -- Blood Reserve (weapon enchant proc) +(-53234, 'spell_hun_piercing_shots'), -- Hunter Piercing Shots +(-67151, 'spell_hun_t9_4p_bonus'), -- Hunter T9 Bonus +(71201, 'spell_igb_battle_experience_check'), -- Battle Experience (Gunship - ICC) +(60510, 'spell_item_soul_preserver'), -- Soul Preserver +(67702, 'spell_item_death_choice'), -- Death Choice Trinket +(67771, 'spell_item_death_choice'), -- Death Choice Trinket +(37657, 'spell_item_lightning_capacitor'), -- Lightning Capcitor +(54841, 'spell_item_thunder_capacitor'), -- Thunder Capacitor +(67712, 'spell_item_toc25_normal_caster_trinket'), -- Item - Coliseum 25 Normal Caster Trinket +(67758, 'spell_item_toc25_heroic_caster_trinket'), -- Item - Coliseum 25 Heroic Caster Trinket +(57345, 'spell_item_darkmoon_card_greatness'), -- Darkmoon Card: Greatness +(43820, 'spell_item_charm_witch_doctor'), -- Charm of the Witch Doctor +(27522, 'spell_item_mana_drain'), -- Mana Drain +(40336, 'spell_item_mana_drain'), -- Mana Drain +(-31641, 'spell_mage_blazing_speed'), -- Mage Blazing Speed +(-20210, 'spell_pal_illumination'), -- Paladin Illumination (for Holy Shock) +(-27811, 'spell_pri_blessed_recovery'), -- Priest Blessed Recovery +(70805, 'spell_rog_t10_2p_bonus'), -- Rogue T10 2P bonus +(-30881, 'spell_sha_nature_guardian'), -- Shaman Nature's Guardian +(-324, 'spell_sha_lightning_shield'), -- Shaman Lightning Shield +(-30299, 'spell_warl_nether_protection'); -- Warlock Nether protection -- cgit v1.2.3