Scripts/Spells: Convert code from Spell::EffectDummy to spell scripts.

2 files changed, 72 insertions, 0 deletions

diff --git a/sql/updates/world/2012_02_16_00_world_spell_script_names.sql b/sql/updates/world/2012_02_16_00_world_spell_script_names.sql
new file mode 100644
index 00000000000..993fe3a2f38
--- /dev/null
+++ b/sql/updates/world/2012_02_16_00_world_spell_script_names.sql
@@ -0,0 +1,69 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` in (-100,-12162,13567,17251,23019,23448,23453,25860,28089,29200,29858,30458,30507,31225,35745,37674,39090,39093,39096,42784,43723,44875,47170,49357,50243,51582,51961,52759,52845,53808,54171,54577,55004,64385,-1464,-5308,12809,23881,-1454,-50286,8171,52041,52046,52047,52048,52049,52050,52059,52060,52061,52031,52033,52034,52035,52036,58778,58779,58780,60103,-49998,-66188,-47541,52375,59134,-62900,49560,62324,31890);
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES 
+(-100,'spell_warr_charge'),
+(-12162,'spell_warr_deep_wounds'),
+(13567,'spell_gen_dummy_trigger'),
+(17251,'spell_gen_spirit_healer_res'),
+(23019,'spell_item_crystal_prison_dummy_dnd'),
+(23448,'spell_gen_gadgetzan_transporter_backfire'),
+(23453,'spell_gen_gnomish_transporter'),
+(25860,'spell_item_reindeer_transformation'),
+(28089,'spell_thaddius_polarity_shift'),
+(29200,'spell_item_purify_helboar_meat'),
+(29858,'spell_warl_soulshatter'),
+(30458,'spell_item_nigh_invulnerability'),
+(30507,'spell_item_poultryizer'),
+(31225,'spell_item_shimmering_vessel'),
+(35745,'spell_item_socrethars_stone'),
+(37674,'spell_gen_chaos_blast'),
+(39090,'spell_capacitus_polarity_charge'),
+(39093,'spell_capacitus_polarity_charge'),
+(39096,'spell_capacitus_polarity_shift'),
+(42784,'spell_astromancer_wrath_of_the_astromancer'),
+(43723,'spell_item_demon_broiled_surprise'),
+(44875,'spell_item_complete_raptor_capture'),
+(47170,'spell_item_impale_leviroth'),
+(49357,'spell_item_brewfest_mount_transformation'),
+(50243,'spell_item_teach_language'),
+(51582,'spell_item_rocket_boots'),
+(51961,'spell_item_chicken_cover'),
+(52759,'spell_sha_ancestral_awakening_proc'),
+(52845,'spell_item_brewfest_mount_transformation'),
+(53808,'spell_item_pygmy_oil'),
+(54577,'spell_item_uded'),
+(54171,'spell_pal_divine_storm_dummy'),
+(55004,'spell_item_nitro_boots'),
+(64385,'spell_item_unusual_compass'),
+(-1464,'spell_warr_slam'),
+(-5308,'spell_warr_execute'),
+(12809,'spell_warr_concussion_blow'),
+(23881,'spell_warr_bloodthirst'),
+(-1454,'spell_warl_life_tap'),
+(-50286,'spell_dru_starfall_dummy'),
+(8171,'spell_sha_cleansing_totem_pulse'),
+(52041,'spell_sha_healing_stream_totem'),
+(52046,'spell_sha_healing_stream_totem'),
+(52047,'spell_sha_healing_stream_totem'),
+(52048,'spell_sha_healing_stream_totem'),
+(52049,'spell_sha_healing_stream_totem'),
+(52050,'spell_sha_healing_stream_totem'),
+(52059,'spell_sha_healing_stream_totem'),
+(52060,'spell_sha_healing_stream_totem'),
+(52061,'spell_sha_healing_stream_totem'),
+(52031,'spell_sha_mana_spring_totem'),
+(52033,'spell_sha_mana_spring_totem'),
+(52034,'spell_sha_mana_spring_totem'),
+(52035,'spell_sha_mana_spring_totem'),
+(52036,'spell_sha_mana_spring_totem'),
+(58778,'spell_sha_mana_spring_totem'),
+(58779,'spell_sha_mana_spring_totem'),
+(58780,'spell_sha_mana_spring_totem'),
+(60103,'spell_sha_lava_lash'),
+(-49998,'spell_dk_death_strike'),
+(-66188,'spell_dk_death_strike'),
+(-47541,'spell_dk_death_coil'),
+(52375,'spell_dk_death_coil'),
+(59134,'spell_dk_death_coil'),
+(-62900,'spell_dk_death_coil'),
+(49560,'spell_dk_death_grip'),
+(62324,'spell_vehicle_throw_passenger');
diff --git a/sql/updates/world/2012_02_16_01_world_spell_dbc.sql b/sql/updates/world/2012_02_16_01_world_spell_dbc.sql
new file mode 100644
index 00000000000..b343399d7f2
--- /dev/null
+++ b/sql/updates/world/2012_02_16_01_world_spell_dbc.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_dbc` WHERE `id`=31980;
+INSERT INTO `spell_dbc` (`Id`,`Dispel`,`Mechanic`,`Attributes`,`AttributesEx`,`AttributesEx2`,`AttributesEx3`,`AttributesEx4`,`AttributesEx5`,`AttributesEx6`,`AttributesEx7`,`Stances`,`StancesNot`,`Targets`,`CastingTimeIndex`,`AuraInterruptFlags`,`ProcFlags`,`ProcChance`,`ProcCharges`,`MaxLevel`,`BaseLevel`,`SpellLevel`,`DurationIndex`,`RangeIndex`,`StackAmount`,`EquippedItemClass`,`EquippedItemSubClassMask`,`EquippedItemInventoryTypeMask`,`Effect1`,`Effect2`,`Effect3`,`EffectDieSides1`,`EffectDieSides2`,`EffectDieSides3`,`EffectRealPointsPerLevel1`,`EffectRealPointsPerLevel2`,`EffectRealPointsPerLevel3`,`EffectBasePoints1`,`EffectBasePoints2`,`EffectBasePoints3`,`EffectMechanic1`,`EffectMechanic2`,`EffectMechanic3`,`EffectImplicitTargetA1`,`EffectImplicitTargetA2`,`EffectImplicitTargetA3`,`EffectImplicitTargetB1`,`EffectImplicitTargetB2`,`EffectImplicitTargetB3`,`EffectRadiusIndex1`,`EffectRadiusIndex2`,`EffectRadiusIndex3`,`EffectApplyAuraName1`,`EffectApplyAuraName2`,`EffectApplyAuraName3`,`EffectAmplitude1`,`EffectAmplitude2`,`EffectAmplitude3`,`EffectMultipleValue1`,`EffectMultipleValue2`,`EffectMultipleValue3`,`EffectMiscValue1`,`EffectMiscValue2`,`EffectMiscValue3`,`EffectMiscValueB1`,`EffectMiscValueB2`,`EffectMiscValueB3`,`EffectTriggerSpell1`,`EffectTriggerSpell2`,`EffectTriggerSpell3`,`EffectSpellClassMaskA1`,`EffectSpellClassMaskA2`,`EffectSpellClassMaskA3`,`EffectSpellClassMaskB1`,`EffectSpellClassMaskB2`,`EffectSpellClassMaskB3`,`EffectSpellClassMaskC1`,`EffectSpellClassMaskC2`,`EffectSpellClassMaskC3`,`MaxTargetLevel`,`SpellFamilyName`,`SpellFamilyFlags1`,`SpellFamilyFlags2`,`SpellFamilyFlags3`,`MaxAffectedTargets`,`DmgClass`,`PreventionType`,`DmgMultiplier1`,`DmgMultiplier2`,`DmgMultiplier3`,`AreaGroupId`,`SchoolMask`,`Comment`) VALUES	
+(31980,0,0,328064,1024,4,268894208,0,0,0,0,0,0,0,1,0,0,101,0,0,14,14,0,13,0,-1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,22,0,0,15,0,0,12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,0,4,0,0,0,0,1,0,0,0,1,"Righteous Defense Trigger Spell");