aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorRothend <67004168+Rothend@users.noreply.github.com>2020-06-24 21:26:01 +0200
committerShauren <shauren.trinity@gmail.com>2022-01-18 00:06:59 +0100
commitf5967b8a8745bc8ccd512c876bf821968a4ba1b2 (patch)
tree15875fa2379d80eed5240615835e5090acee5f9d /sql
parentd8efda4ff335ce6252f32e1736b1f99d443bce7b (diff)
Script/Spell: fix Midsummer's Juggling Torch (#24885)
* Script/Spell: fix Midsummer's Juggling Torch. Closes #17446 * Remove unneeded GetPosition() call, thanks jackpoz for noticing! * Rename 9999_99_99_99_world_midsummer_torch_juggling.sql to 2020_06_24_01_world.sql Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com> (cherry picked from commit 5f35bf9e795ab0c8343d693062d3643dae2b7d8c)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_01_17_02_world_2020_06_24_01_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_17_02_world_2020_06_24_01_world.sql b/sql/updates/world/master/2022_01_17_02_world_2020_06_24_01_world.sql
new file mode 100644
index 00000000000..e4b6613a706
--- /dev/null
+++ b/sql/updates/world/master/2022_01_17_02_world_2020_06_24_01_world.sql
@@ -0,0 +1,6 @@
+-- UPDATE `achievement_criteria_data` SET `type`=6, `value1`=4395 WHERE `criteria_id`=6937;
+
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ("spell_midsummer_juggle_torch", "spell_midsummer_torch_catch");
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(45819, "spell_midsummer_juggle_torch"),
+(45644, "spell_midsummer_torch_catch");