aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSorikoff <Sorikoff@users.noreply.github.com>2020-02-27 14:17:59 +0100
committerKillyana <morphone1@gmail.com>2020-02-27 14:17:59 +0100
commit2b59159f6af636742dc5f418ac2a5aa25507a840 (patch)
tree15c31cbe16d0c94c0f62e1768a59807549700caf
parent3b0a89a2ea76157156c03262bc86f024a1d4ca57 (diff)
DB/Creature: Remove wrong auras from Unworthy Initiate
Closes #24204
-rw-r--r--sql/updates/world/3.3.5/2020_02_27_00_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_02_27_00_world.sql b/sql/updates/world/3.3.5/2020_02_27_00_world.sql
new file mode 100644
index 00000000000..e439563ad6b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_02_27_00_world.sql
@@ -0,0 +1,3 @@
+--
+UPDATE `creature_template_addon` SET `auras`='' WHERE `entry` IN (29519, 29520, 29565, 29566, 29567);
+DELETE FROM `creature_addon` WHERE `guid` IN (128740);