diff options
Diffstat (limited to 'sql/updates/world')
| -rw-r--r-- | sql/updates/world/2011_06_10_02_world_misc.sql | 31 |
1 files changed, 31 insertions, 0 deletions
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 |