From 08f205722a90fc1c57b5209743fcac4a05c7d27d Mon Sep 17 00:00:00 2001 From: azazel Date: Fri, 10 Dec 2010 12:01:57 +0600 Subject: Scripts/Quest: implement dummy effects for spells 43882, 50133 and aura 43874 for quests 11396/11399 Bring Down Those Shields (based on code by NoFantasy) --HG-- branch : trunk --- sql/base/world_database.sql | 3 +++ sql/updates/10619_world_spell_script_names.sql | 7 +++++++ 2 files changed, 10 insertions(+) create mode 100644 sql/updates/10619_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 9b2d94ddfec..fe2102b5ba6 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -26870,6 +26870,9 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 17271, 'spell_q5206_test_fetid_skull'), ( 19512, 'spell_q6124_6129_apply_salve'), ( 34665, 'spell_q10255_administer_antidote'), +( 43874, 'spell_q11396_11399_force_shield_arcane_purple_x3'), +( 43882, 'spell_q11396_11399_scourging_crystal_controller_dummy'), +( 50133, 'spell_q11396_11399_scourging_crystal_controller'), ( 44936, 'spell_q11515_fel_siphon_dummy'), ( 45449, 'spell_q11587_arcane_prisoner_rescue'), ( 46023, 'spell_q11730_ultrasonic_screwdriver'), diff --git a/sql/updates/10619_world_spell_script_names.sql b/sql/updates/10619_world_spell_script_names.sql new file mode 100644 index 00000000000..23f06a72125 --- /dev/null +++ b/sql/updates/10619_world_spell_script_names.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=43874 AND `ScriptName`='spell_q11396_11399_force_shield_arcane_purple_x3'; +DELETE FROM `spell_script_names` WHERE `spell_id`=50133 AND `ScriptName`='spell_q11396_11399_scourging_crystal_controller'; +DELETE FROM `spell_script_names` WHERE `spell_id`=43882 AND `ScriptName`='spell_q11396_11399_scourging_crystal_controller_dummy'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(43874, 'spell_q11396_11399_force_shield_arcane_purple_x3'), +(43882, 'spell_q11396_11399_scourging_crystal_controller_dummy'), +(50133, 'spell_q11396_11399_scourging_crystal_controller'); -- cgit v1.2.3