From 66fcd52106bb14961498afb9d3f0344e21d0890b Mon Sep 17 00:00:00 2001 From: azazel Date: Wed, 18 Aug 2010 00:20:23 +0600 Subject: Add more methods to SpellScript. Spells cleanup: move spells from the core to scripts. * Shaman spells: 39610 Mana Tide Totem, 1535 Fire Nova (and ranks) * Death Knight spells: 55090 Scourge Strike (and ranks), 49158 Corpse Explosion (and ranks), 50524 Runic Power Feed * Druid spells: 54846 Glyph of Starfire * Warlock spells: 6201 Create Healthstone (and ranks), 47422 Everlasting Affliction, 47193 Demonic Empowerment, 63521 Guarded by The Light * Hunter spells: 37506 Scatter Shot, 53412 Invigoration, 53209 Chimera Shot * Quest spells: 45449 Arcane Prisoner Rescue (quest 11587), 46023 The Ultrasonic Screwdriver (quest 11730). Closes issue #3068 Clean old code for hunter's Heart of the Phoenix, move script effect of hunter's Master's Call to corresponding script. Move DK's Hungering Cold to spell_scripts table (needs DB support) --HG-- branch : trunk --- sql/base/world_database.sql | 20 ++++++++- sql/updates/9436_world_spell_script_names.sql | 65 +++++++++++++++++++++++++++ 2 files changed, 83 insertions(+), 2 deletions(-) create mode 100644 sql/updates/9436_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 6099d56ce93..d44b6641b06 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -14740,6 +14740,9 @@ LOCK TABLES `spell_script_names` WRITE; INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -- generic ( 58601, 'spell_gen_remove_flight_auras'), +-- quest +( 45449, 'spell_q11587_arcane_prisoner_rescue'), +( 46023, 'spell_q11730_ultrasonic_screwdriver'), -- warrior ( 12975,'spell_warr_last_stand'), -- paladin @@ -14747,9 +14750,12 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (-20473, 'spell_pal_holy_shock'), ( 37877, 'spell_pal_blessing_of_faith'), -- hunter -( 23989, 'spell_hun_readiness'), +( 53209, 'spell_hun_chimera_shot'), +( 53412, 'spell_hun_invigoration'), ( 53271, 'spell_hun_masters_call'), ( 53478, 'spell_hun_last_stand_pet'), +( 23989, 'spell_hun_readiness'), +( 37506, 'spell_hun_scatter_shot'), ( 55709, 'spell_hun_pet_heart_of_the_phoenix'), ( 54044, 'spell_hun_pet_carrion_feeder'), -- rogue @@ -14761,13 +14767,23 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 47948, 'spell_pri_pain_and_suffering_proc'), (-47540, 'spell_pri_penance'), -- death knight +(-49158,'spell_dk_corpse_explosion'), +( 50524,'spell_dk_runic_power_feed'), +(-55090,'spell_dk_scourge_strike'), -- shaman +( 39610, 'spell_sha_mana_tide_totem'), +( -1535, 'spell_sha_fire_nova'), -- mage ( 11958, 'spell_mage_cold_snap'), ( 31687, 'spell_mage_summon_water_elemental'), -( 32826, 'spell_mage_polymorph_visual'); +( 32826, 'spell_mage_polymorph_visual'), -- warlock +( -6201, 'spell_warl_create_healthstone'), +( 47193, 'spell_warl_demonic_empowerment'), +( 47422, 'spell_warl_everlasting_affliction'), +( 63521, 'spell_warl_guarded_by_the_light'), -- druid +( 54846, 'spell_dru_glyph_of_starfire'); /*!40000 ALTER TABLE `spell_script_names` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/9436_world_spell_script_names.sql b/sql/updates/9436_world_spell_script_names.sql new file mode 100644 index 00000000000..5b70ef3e0fe --- /dev/null +++ b/sql/updates/9436_world_spell_script_names.sql @@ -0,0 +1,65 @@ +-- QUEST SPELLS +-- 45449 Arcane Prisoner Rescue +DELETE FROM `spell_script_names` WHERE `spell_id`=45449 AND `ScriptName`='spell_q11587_arcane_prisoner_rescue'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (45449,'spell_q11587_arcane_prisoner_rescue'); + +-- 46023 The Ultrasonic Screwdriver +DELETE FROM `spell_script_names` WHERE `spell_id`=46023 AND `ScriptName`='spell_q11730_ultrasonic_screwdriver'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (46023,'spell_q11730_ultrasonic_screwdriver'); + +-- SHAMAN SPELLS +-- 1535 Fire Nova (and ranks) +DELETE FROM `spell_script_names` WHERE `spell_id`=-1535 AND `ScriptName`='spell_sha_fire_nova'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (-1535,'spell_sha_fire_nova'); + +-- 39610 Mana Tide Totem +DELETE FROM `spell_script_names` WHERE `spell_id`=39610 AND `ScriptName`='spell_sha_mana_tide_totem'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (39610,'spell_sha_mana_tide_totem'); + +-- DEATH KNIGHT SPELLS +-- 49158 Corpse Explosion (and ranks) +DELETE FROM `spell_script_names` WHERE `spell_id`=-49158 AND `ScriptName`='spell_dk_corpse_explosion'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (-49158,'spell_dk_corpse_explosion'); + +-- 50524 Runic Power Feed +DELETE FROM `spell_script_names` WHERE `spell_id`=50524 AND `ScriptName`='spell_dk_runic_power_feed'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (50524,'spell_dk_runic_power_feed'); + +-- 55090 Scourge Strike (and ranks) +DELETE FROM `spell_script_names` WHERE `spell_id`=-55090 AND `ScriptName`='spell_dk_scourge_strike'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (-55090,'spell_dk_scourge_strike'); + +-- DRUID SPELLS +-- 54846 Glyph of Starfire +DELETE FROM `spell_script_names` WHERE `spell_id`=54846 AND `ScriptName`='spell_dru_glyph_of_starfire'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (54846,'spell_dru_glyph_of_starfire'); + +-- WARLOCK SPELLS +-- 6201 Create Healthstone (and ranks) +DELETE FROM `spell_script_names` WHERE `spell_id`=-6201 AND `ScriptName`='spell_warl_create_healthstone'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (-6201,'spell_warl_create_healthstone'); + +-- 47193 Demonic Empowerment +DELETE FROM `spell_script_names` WHERE `spell_id`=47193 AND `ScriptName`='spell_warl_demonic_empowerment'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (47193,'spell_warl_demonic_empowerment'); + +-- 47422 Everlasting Affliction +DELETE FROM `spell_script_names` WHERE `spell_id`=47422 AND `ScriptName`='spell_warl_everlasting_affliction'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (47422,'spell_warl_everlasting_affliction'); + +-- 63521 Guarded by The Light +DELETE FROM `spell_script_names` WHERE `spell_id`=63521 AND `ScriptName`='spell_warl_guarded_by_the_light'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (63521,'spell_warl_guarded_by_the_light'); + +-- HUNTER SPELLS +-- 53209 Chimera Shot +DELETE FROM `spell_script_names` WHERE `spell_id`=53209 AND `ScriptName`='spell_hun_chimera_shot'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (53209,'spell_hun_chimera_shot'); + +-- 53412 Invigoration +DELETE FROM `spell_script_names` WHERE `spell_id`=53412 AND `ScriptName`='spell_hun_invigoration'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (53412,'spell_hun_invigoration'); + +-- 37506 Scatter Shot +DELETE FROM `spell_script_names` WHERE `spell_id`=37506 AND `ScriptName`='spell_hun_scatter_shot'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (37506,'spell_hun_scatter_shot'); -- cgit v1.2.3