diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_09_03_world_spell_script_names.sql | 5 |
2 files changed, 7 insertions, 0 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index ef916b5e4ef..bcb6f02dc02 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -2214,6 +2214,8 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 63024, 'spell_xt002_gravity_bomb_spawn_void_zone'), ( 62791, 'spell_xt002_heart_overload_periodic'), ( 62775, 'spell_xt002_tympanic_tantrum'), +( 37751, 'spell_xt002_submerged'), +( 37752, 'spell_xt002_stand'), -- Eye Of Eternity ( 56105, 'spell_malygos_vortex_dummy'), ( 55873, 'spell_malygos_vortex_visual'), diff --git a/sql/updates/world/2011_06_09_03_world_spell_script_names.sql b/sql/updates/world/2011_06_09_03_world_spell_script_names.sql new file mode 100644 index 00000000000..1ce1d7a9fb2 --- /dev/null +++ b/sql/updates/world/2011_06_09_03_world_spell_script_names.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_scripts` WHERE `id` IN(37751,37752); -- Remove redundant data from spell_scripts +DELETE FROM `spell_script_names` WHERE `spell_id` IN(37751,37752); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(37751,'spell_xt002_submerged'), +(37752,'spell_xt002_stand'); |