aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/1142_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/1142_world.sql b/sql/updates/1142_world.sql
new file mode 100644
index 00000000000..2109d0f8ab7
--- /dev/null
+++ b/sql/updates/1142_world.sql
@@ -0,0 +1,8 @@
+DELETE from `spell_affect` where entry=16999 and effectId=0;
+DELETE from `spell_affect` where entry=16999 and effectId=2;
+INSERT INTO `spell_affect` VALUES (16999, 0, 0x1000001000);
+INSERT INTO `spell_affect` VALUES (16999, 2, 0x1000001000);
+DELETE from `spell_affect` where entry=16998 and effectId=0;
+DELETE from `spell_affect` where entry=16998 and effectId=2;
+INSERT INTO `spell_affect` VALUES (16998, 0, 0x1000001000);
+INSERT INTO `spell_affect` VALUES (16998, 2, 0x1000001000);