aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2015-04-26 14:03:40 +0200
committerAokromes <Aokromes@users.noreply.github.com>2015-04-26 14:03:40 +0200
commitf62b0391c1763b840b004493f18f0ac3c1d99844 (patch)
treefcfe7ffebe678f9989180d4ab0dabb8250ff607a
parentabdb21130448be410b38f3753aa0a32ae08b5630 (diff)
DB/Creature: Fix Kalecgos event
By sirikfoll, closes #11276
-rw-r--r--sql/updates/world/2015_04_26_01_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2015_04_26_01_world.sql b/sql/updates/world/2015_04_26_01_world.sql
new file mode 100644
index 00000000000..b7c45c1f987
--- /dev/null
+++ b/sql/updates/world/2015_04_26_01_world.sql
@@ -0,0 +1,6 @@
+--
+UPDATE `spell_linked_spell` SET `type`=0 WHERE `spell_trigger`=44869 AND `spell_effect`=44866 AND `type`=1;
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=46021 AND `spell_effect`=44852;
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+(46021,44852,0,'Transported to the spectral realm turn Sathrovarr Hostile');