diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 12 | ||||
| -rw-r--r-- | sql/updates/9058_world_spell_script_names.sql | 11 |
2 files changed, 22 insertions, 1 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index c50bcdafb73..1a5b035f611 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1650,7 +1650,17 @@ update creature_template set scriptname="boss_flame_leviathan_safety_container" DELETE FROM spell_script_names WHERE spell_id=19958 AND ScriptName='spell_mage_cold_snap'; DELETE FROM spell_script_names WHERE spell_id=32826 AND ScriptName='spell_mage_polymorph_visual'; DELETE FROM spell_script_names WHERE spell_id=31687 AND ScriptName='spell_mage_summon_water_elemental'; +DELETE FROM spell_script_names WHERE spell_id=-47540 AND ScriptName='spell_pri_penance'; +DELETE FROM spell_script_names WHERE spell_id=31231 AND ScriptName='spell_rog_cheat_death'; +DELETE FROM spell_script_names WHERE spell_id=51662 AND ScriptName='spell_rog_hunger_for_blood'; +DELETE FROM spell_script_names WHERE spell_id=14185 AND ScriptName='spell_rog_preparation'; +DELETE FROM spell_script_names WHERE spell_id=5938 AND ScriptName='spell_rog_shiv'; INSERT INTO spell_script_names (spell_id, ScriptName) VALUES (11958,'spell_mage_cold_snap'), (32826,'spell_mage_polymorph_visual'), -(31687,'spell_mage_summon_water_elemental'); +(31687,'spell_mage_summon_water_elemental'), +(-47540, 'spell_pri_penance'), +(31231,'spell_rog_cheat_death'), +(51662,'spell_rog_hunger_for_blood'), +(14185,'spell_rog_preparation'), +(5938,'spell_rog_shiv'); diff --git a/sql/updates/9058_world_spell_script_names.sql b/sql/updates/9058_world_spell_script_names.sql new file mode 100644 index 00000000000..1b2d54c967e --- /dev/null +++ b/sql/updates/9058_world_spell_script_names.sql @@ -0,0 +1,11 @@ +DELETE FROM spell_script_names WHERE spell_id=-47540 AND ScriptName='spell_pri_penance'; +DELETE FROM spell_script_names WHERE spell_id=31231 AND ScriptName='spell_rog_cheat_death'; +DELETE FROM spell_script_names WHERE spell_id=51662 AND ScriptName='spell_rog_hunger_for_blood'; +DELETE FROM spell_script_names WHERE spell_id=14185 AND ScriptName='spell_rog_preparation'; +DELETE FROM spell_script_names WHERE spell_id=5938 AND ScriptName='spell_rog_shiv'; +INSERT INTO spell_script_names (spell_id, ScriptName) VALUES +(-47540,'spell_pri_penance'), +(31231,'spell_rog_cheat_death'), +(51662,'spell_rog_hunger_for_blood'), +(14185,'spell_rog_preparation'), +(5938,'spell_rog_shiv'); |