diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_10_02_world_misc.sql | 31 |
2 files changed, 35 insertions, 2 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index bcb6f02dc02..84776a121b2 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -2210,8 +2210,10 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 62274, 'spell_shield_of_runes'), ( 63018, 'spell_xt002_searing_light_spawn_life_spark'), ( 65121, 'spell_xt002_searing_light_spawn_life_spark'), -( 64234, 'spell_xt002_gravity_bomb_spawn_void_zone'), -( 63024, 'spell_xt002_gravity_bomb_spawn_void_zone'), +( 64234, 'spell_xt002_gravity_bomb_aura'), +( 63024, 'spell_xt002_gravity_bomb_aura'), +( 64233, 'spell_xt002_gravity_bomb_damage'), +( 63025, 'spell_xt002_gravity_bomb_damage'), ( 62791, 'spell_xt002_heart_overload_periodic'), ( 62775, 'spell_xt002_tympanic_tantrum'), ( 37751, 'spell_xt002_submerged'), diff --git a/sql/updates/world/2011_06_10_02_world_misc.sql b/sql/updates/world/2011_06_10_02_world_misc.sql new file mode 100644 index 00000000000..af07fab967a --- /dev/null +++ b/sql/updates/world/2011_06_10_02_world_misc.sql @@ -0,0 +1,31 @@ +-- Delete disabled achievements +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry` IN(10074,10075,10220,10221,10077,10079); + +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN(10074,10075,10220,10221,10077,10079); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`ScriptName`) VALUES +-- Nerf Engineering 10m +(10074,11,0,'achievement_nerf_engineering'), +(10074,12,0,''), +-- Nerf Engineering 25m +(10075,11,0,'achievement_nerf_engineering'), +(10075,12,1,''), +-- Heartbreaker 10m +(10221,11,0,'achievement_heartbreaker'), +(10221,12,0,''), +-- Heartbreaker 25m +(10220,11,0,'achievement_heartbreaker'), +(10220,12,1,''), +-- Nerf Gravity Bombs 10m +(10077,11,0,'achievement_nerf_gravity_bombs'), +(10077,12,0,''), +-- Nerf Gravity Bombs 25m +(10079,11,0,'achievement_nerf_gravity_bombs'), +(10079,12,1,''); + +DELETE FROM `spell_script_names` WHERE `spell_id` IN(64233,63025); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(64233,'spell_xt002_gravity_bomb_damage'), +(63025,'spell_xt002_gravity_bomb_damage'); + +-- Better naming for changed script with new functionality +UPDATE `spell_script_names` SET `ScriptName`='spell_xt002_gravity_bomb_aura' WHERE `spell_id` IN(64234,63024)
\ No newline at end of file |